System DataSource

System DataSource defines a shared data access point. It is defined in '/www/MbtSvr/config/config.properties' as follows:

DATASOURCE.TestDB.CONNSTRING=jdbc connection string
DATASOURCE.TestDB.DRIVERCLASS=jdbc driver class path
DATASOURCE.TestDB.PASSWORD=myDbUserID
DATASOURCE.TestDB.USERNAME=myPassword

where TestDB is the name of the data source to be used in the model.

Typically you will use the following format to specify URI:

sql:datasource=TestDB;sql=SELECT * FROM EMPLOYEE
Print/export
QR Code
QR Code system_datasource (generated for current page)