1. Home
  2. Docs
  3. Single Sign On with Transparent Logon Guide
  4. Settings
  5. Database

Database

TL Database Settings
TL Database Settings

The Database Tab of the Transparent Logon Settings contains the following settings:

Mapping Database Dialect

Use the dropdown to select the database to be used for your cross reference database: H2 (Built in), Oracle or SQL Server. The latter would be selected when you maintain the mapping database in another datasource.

Mapping Database URL

Enter the correct URL for your mappping database, using the dialect selected above.
Samples for the correct syntax:
Oracle: jdbc:oracle:thin:@172.35.42.151:1521:JD Edwards
SQL: jdbc:sqlserver://127.0.0.1:1433;databaseName=JDETEST

For clustered Oracle database, use the following syntax:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604))
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604)))
(CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))

Mapping Database Username

Enter the userID of the user to access the database to maintain the cross reference database.

Mapping Database User Password

Enter the password for the above userID.

Was this article helpful to you? Yes 2 No

How can we help?