Database Connection
Database connection is based on java JDBC database connection. Application supports commercial relational databases with JDBC datasource. And also support various data connection for ERP and salesforce datasource synchronization.
Supported database systems
|
Category |
Database connection |
Description |
|
Relational JDBC Connector |
Oracle Thin Driver |
ojdbc8.jar included |
|
|
MySQL Driver |
8.0.11 included |
|
|
IBM DB2 Driver |
|
|
|
IBM AS400 DB2 Driver |
jt400.jar |
|
|
Microsoft MSSQL Server |
7.2.2.jre11 included |
|
|
PostgreSQL |
postgresql-42.2.2.jre7.jar |
|
|
Sybase IQ |
sqljdbc4.jar |
|
|
Sybase ASE |
sqljdbc4.jar |
|
|
Exasol Inmemory Database |
Not included on package |
|
|
JDBC ODBC Bridge |
Not included on package |
|
Cloud Connector |
Salesforce Connector |
force-wsc 45.0.0 |
|
|
LDAP Datasource |
|
|
|
Amplix metadata readonly |
Connector included |
|
ERP BI Connector |
Oracle EBS application |
|
|
|
SAP BW Data |
sapjco3.jar included |
|
|
Oracle Hyperion Essbase |
ess_japi included |
|
|
Oracle JD Edwards ERP |
Connector included |
|
Bigdata Connector |
Hive2 |
Not included on package |
|
|
MongoDB NoSQL DB |
Not included on package |
|
Embedded Datasource |
Apache Derby Embedded |
10.15.1.3 |
Adding database connection
|
Entering database connection manager |
|
|
|
|
|
1 |
Click Analysis from left main menu. |
|
2 |
From Analysis menu, select Database Instance item. |
Adding datasource
|
Adding new datasource |
|
|
|
|
|
1 |
Click on Add Data Instance button on top toolbar |
|
2 |
From datasource registration wizard, select data type and set configuration. |
Editing datasource
|
Data source editing |
|
|
|
|
|
1 |
Input database name to register into system. |
|
2 |
Select database type or change if necessary. Click on Apply Template button, to get typical JDBC driver and JDBC URL information |
|
3 |
Click Set button to fill system value on JDBC URL template value. |
|
4 |
Input Username and Password and click Test button to verify connection. (Verification results will be shown on popup message) |
|
5 |
Set advanced options and click confirm button to save on meta data. |
Database Instance advanced options
|
Name |
Description |
Notes |
|
DB Value |
Database validation query |
SELECT 1 SELECT 1 FROM DUAL |
|
Max Pool Size |
Database max connection pool |
Default 20 |
|
Query Timeout(S) |
Query timeout |
Default 120 seconds |
|
Query Timeout(Scheduler) |
Query timeout for scheduled item |
Default 1200 seconds |
|
DB CharSet |
For non UTF8 db |
|
|
Output CharSet |
For non UTF8 db |
|
|
Limit count |
Max row count limit |
|
|
Use Cache |
|
|
|
Cache Rule |
Every minutes Every hour Every day on hour |
|
|
Cache Period |
|
|
|
DB Monitoring |
|
|
|
Local File Cube |
For execl uploaded writable database |
|
|
Pre Execution Statement |
SQL before running report |
|
|
Post Execution Statement |
SQL after running report |
|