amplix manual

데이터베이스 접속

JDBC 자바를 이용하여 데이터베이스 시스템에 접속한다. JDBC 데이터소스를 지원하는 모든 상용 관계형 데이터베이스를 지원한다. 또한 ERP 및 Salesforce 데이터 동기화 하는 커넥터를 제공한다.

데이터베이스 접속 관리자

1	Click Analysis from left main menu.
2	From Analysis menu, select Database Instance item.

Adding new datasource

1	Click on Add Data Instance button on top toolbar
2	From datasource registration wizard, select data type and set configuration.

	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.

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