Managing database type profiles

Database type profiles configuration is the easiest way to manage the database types that Appeon Deployment Wizard supports for application deployments. You can configure database type profiles in the DB Type Profiles tab, and apply a database type profile for an application deployment by selecting the profile in the PowerServer Toolkit Configuration Wizard or in the DB Settings tab of the application profile settings.

Database type profiles in PowerServer Toolkit are different from database profiles in PowerBuilder:

  • You only need to configure one database type profile for a given database type. For example, if application A connects to SAP SQL Anywhere database d1 and application B connects to SAP SQL Anywhere database d2, you can use the database type profile SAP SA | UltraLite for both applications, although the connection information in the profile SAP SA | UltraLite sets up connection to SAP SQL Anywhere database d1.

  • Database type profiles are not used for setting up connections with application databases. Instead, they are mainly used by Appeon Deployment Wizard to call the relevant database driver for converting PowerBuilder SQL statements.

To modify a database type profile, take the following steps:

Step 1: Click the Configure button on the PowerServer Toolkit, and select the DB Type Profiles tab on the Application Profile Configuration page as shown in the following figure.

The Database Type column lists all the database types that are supported by Appeon; and the Configured column indicates whether a database type profile has been configured.

Figure 35. DB Type Profiles

DB Type Profiles

Step 2: Select a database type profile (for example, SAP SA | UltraLite), and click the Configure button to configure the database type profile, as shown in the following figure.

Figure 36. Database Type configuration

Database Type configuration

Step 3: Specify the information needed for setting up the database type profile.

Outer Join Syntax: Specify how Appeon format the SQL syntax for outer joins, you can select corresponding format from the drop-down list in the Database Settings frame. Regardless of the settings in PowerBuilder, it is recommended to use ANSI as the outer join syntax format in Appeon.

ODBC Interface: Select this option if you use an ODBC interface. Specify the ODBC data source, User ID, and Password.

Table 11. ODBC interface settings

Setting

Instructions

Data Source

All the data sources configured in Windows ODBC Administrator are listed. Select a proper data source of the configured database type from the dropdown list. It is not necessary to specify the actual databases that the application uses.

Click ODBC Administrator to configure an ODBC data source if it is not available.

User ID

Type in a recognized (set) user name to login to the database. If no user name has been set, leave this field blank.

Password

Type in the password used to log in to the database. If no password has been set, leave this field blank.


Native Interface: Select this option if you use a native database interface. Specify the server name/IP, User ID, Password, and the database name.

Note: Not all of the listed database types are supported by Appeon for the native database interface. If SAP IQ, SAP SA | UltraLite or IBM DB2 is your database type, the Native Interface option is disabled.

Table 12. Native database interface settings

Setting

Instructions

Server

Enter the machine name or IP address of the server where the target database resides.

User ID

Type in a recognized (set) user name to login to the database. If no user name has been set, leave this field blank.

Password

Type in the password used to login to the database. If no password has been set, leave this field blank.

Database

Specify the name of the database that will be used by the application.

Release

(ASE only) Specify the version number of ASE database.


Step 4: Specify the "Enclose table and column names in double quotes" option. It determines whether PowerServer Toolkit encloses the names of tables, columns, indexes, and constraints in double quotes when it generates the database syntax during deployment.

Notes:

1) When this option is selected, verify that the quoted_identifier setting is set to ON in the database server.

2) Clear the check box of this option when the updated table name of DataWindow contains the owner name.

Step 5: Click Test Connection to test the connection to the database.