Kbase 63565: SQL Database Access
| Autor |
Tatiane Koslinsky - CAT |
| Acesso |
Público |
| Publicação |
9/21/2017 |
|
Menu: Environment > SQL Database Access
The databases that have only SQL access are registered in this screen. These databases are used by JBoss and are not connected by PF file (Progress environment). You can identify the connection parameters for these databases through the database load script (-ServerType SQL).
1. Progress Environment:
Click 'New' to register the database, then select the company, enter the logical name below and click 'Save'.
Back to the 'SQL Access Database' screen, enter:
a. Server host;
b. SQL connection port (-ServerType SQL);
c. User and password.
Note:
The user entered must have DBA permission in the database. For this reason, we recommend you check pub user permissions:
After accessing the Proenv application, type:
sqlexp -db database -H server -S XXXXX -user sysprogress -password password
Execute command:
grant dba to pub;
grant resource to pub;
commit;
To each parameter entered, click 'Save' or press ENTER. Execute this procedure for all databases with SQL access from the progress-ds.xml file.
2. Oracle environment:
For environments with Oracle databases, use option "SQL Database Access" to register the Oracle database connection information. When you import connection parameters on the "4GL Database Access" screen, the Oracle database connection data are automatically registered.
Enter parameter 'SQL Plus Directory' with the directory where the SQL Plus executable is found in the computer running the update console. To register this parameter for all databases, select one of the databases registered, enter the parameter value and select button "Save information for all databases". Thus, the parameter selected is copied to all configured databases.
3. SQL Server Environment:
For environments with SQL Server databases, use option "SQL Database Access" to register the SQL Server database connection information. When you import connection parameters on the "4GL Database Access" screen, the SQL Server database connection data are automatically registered.
If parameter 'Sqlcmd Directory' is blank, enter the directory where the 'sqlcmd.exe' executable is found in the computer running the update console. To register this parameter for all databases, select one of the databases registered, enter the parameter value and select button "Save information for all databases". Thus, the parameter selected is copied to all configured databases.
Important: The conversion log displays the SQL access database connection information. To protect the connection information (as user and password, for example), configure the console directory security so only authorized users can access the log.