Choose Database Connection Console Action

InstallAnywhere 2024 R2

The Choose Database Connection console action enables end users to specify information for connecting to a MySQL, Microsoft SQL Server, IBM DB2, or PostgreSQL database. The variables that are used to store the values that end users specify can be used with the Run SQL Script action to run a SQL script.

Important:SQL databases limit remote administration by users unless otherwise configured. Therefore, for connections to remote SQL database servers, the user name and the password that the end user specifies must be for a user who is running the installer from an appropriate IP address and has been granted adequate privileges that are required to run your SQL script.

The Choose Database Connection customizer includes the following settings:

Choose Database Connection Customizer Settings
Setting	Description
Title	Enter the text that you want to use in the title bar of the console. The default value is: Choose Database Connection
Instructions	Enter the text that you want to display on the Choose Database Connection console. The default value is: Provide database configuration details and authentication
Database Name	Specify the name of the database on which the installer is running the SQL script. By default, the entry in this setting is the user-defined variable $DB_NAME_VARIABLE$. You can specify a different variable if needed.
Server Host	Specify the server host to which your installer is connecting. By default, the entry in this setting is the user-defined variable $DB_SERVERHOST_VARIABLE$. You can specify a different variable if needed.
Server Port	Specify the port that should be used for the server connection. By default, the entry in this setting is the user-defined variable $DB_SERVERPORT_VARIABLE$. You can specify a different variable if needed.
User Name	Specify the user name for the account that should be used to connect to the server through server authentication. By default, the entry in this setting is the user-defined variable $DB_USERNAME_VARIABLE$. You can specify a different variable if needed.
Password	Specify the password that corresponds with the specified user name for the account that should be used to connect to the server through server authentication. By default, the entry in this setting is the user-defined variable $DB_PASSWORD_VARIABLE$. You can specify a different variable if needed.
Enable test connection when moving to next action	If you want to test the connection information that end users entered before moving from the Choose Database Connection console action to the next action, select this check box.
Test Connection Type	Select the type of database to which your installer is connecting.