4. Database Configuration
In Jiffy, DB nodes can be configured with various flavours of Databases like (Postgress, Oracle and Mysql) Please find the below DB configuration url and Driver Class file details.
POSTGRESS:
During task creations in Jiffy using DB node, configuration parameters for DB node to be keyed in with DB url, JDBC driver class file name and DB credentials.
Refer the below sample screenshot for POSTGRESS database DB node configuration.
Database URL Format: jdbc:cognos:dbapi@<HOST>:<PORT>?domain= <DOMAIN> &dataSource=’<DATABASE_NAME>
Normally this is the only JDBC client connection used to establish client-server connections to Virtual View Manager, where cognos is the default
NOTE: DB URL, DB Name specified in the URL, Username and Password may vary depends on the client-side configuration/setup.
ORACLE:
During task creations in Jiffy using DB node, configuration parameters for DB node to be keyed in with DB url , JDBC driver class file name and DB credentials .
Refer the below sample screenshot for ORACLE database DB node configuration.
Database URL Format: jdbc:cognos:dbapi@<HOST>:<PORT>?domain= <DOMAIN>&dataSource=<DATABASE_NAME>
Normally this is the only JDBC client connection used to establish client-server connections to Virtual View Manager, where cognos is the default
NOTE: DB URL, DB Name specified in the URL, Username and Password may vary depends on the client-side configuration/setup.
MYSQL:
During task creations in Jiffy using DB node, configuration parameters for DB node to be keyed in with DB url , JDBC driver class file name and DB credentials .
Refer the below sample screenshot for MYSQL database DB node configuration.
Database URL Format: jdbc:cognos:dbapi@<HOST>:<PORT>?domain= <DOMAIN>&dataSource=<DATABASE_NAME>
Normally this is the only JDBC client connection used to establish client-server connections to Virtual View Manager, where cognos is the default
NOTE: DB URL, DB Name specified in the URL, Username and Password may vary depends on the client-side configuration/setup.