Using alias

You can set DB connection using alias instead of entering server IP address and port number using Add Database Connection Information dialog. First, Set DB connections information for each database in db.properties file. Next, open Add Database Connection Information dialog and check "Alias" option and set alias file path and alias name. If use alias connection, you don't need to edit ODI file every time when connection information of the database server has changed.

db.properties file example on MS-SQL database connection:

Sample.vendor=mssql

Sample.serverAddress=127.0.0.1

Sample.portNo=1433

Sample.dbName=Foodmart

Sample.user=user1

Sample.password=user1password

Sample.maxconns=20

Sample.initconns=5

Sample.timeout=5

Check the "Alias" in the Add Database Connection Information dialog. Then enter the alias name set in db.properties file and set the path of db.properties file.

Note

Database connection information in db.properties file depends on database vendor such as ODBC, MS-SQL, DB2, Oracle, etc.

Sample db.properties file that including needed options for each vendor can be found under /conf/sample relative to OZ installation path. For detailed options, refer to OZ Server Administrator's Guide.