[SAP EAI] SAP EAI - Database Connection Setting

Integration Builder에서의 Channel을 구성 중 DB2 서버에 대한 db 연결 세부 정보에 대한 내용입니다.

데이터 연결 세부 정보:

 

Oracle

JDBC Driver Class : oracle.jdbc.driver.OracleDriver

Server URL Format : jdbc:oracle:thin:@<host>:<port>:SID

Validation Query : select sysdate from dual

Driver : JDBC/UCP Download Page

 

MSSQL

JDBC Driver Class : com.microsoft.sqlserver.jdbc.SQLServerDriver / com.microsoft.sqlserver.jdbc.SQLServerDriver

Server URL Format : jdbc:microsoft:sqlserver://<host>:<port>;DatabaseName=<db>;

Validation Query : SELECT GETDATE()

Driver : Download Microsoft JDBC Driver 4.0 for SQL Server from Official Microsoft Download Center

참고 사이트: Microsoft Ignite

 

DB2

JDBC Driver Class : com.ibm.db2.jcc.DB2Driver

Server URL Format : jdbc:db2://<host>:<port>/<db> (for JDBC4); jdbc:db2:<db> (for JDBC2)

Validation Query : Select Current Date from SYSIBM.SYSDUMMY1

Driver : IBM DB2 JDBC Driver Versions – United States

 

Sybase:

JDBC Driver Class : com.sybase.jdbc.SybDriver (for jConnect 4.2 and earlier); com.sybase.jdbc2.jdbc.SybDriver (for jConnect 5.2); com.sybase.jdbc4.jdbc.SybDriver

Server URL Format : jdbc:sybase:Tds:<host>:<port>/<db name>

Validation Query : select getdate()

Driver : jConnect for JDBC Software Application Development Tools – Software Developer Kit – Sybase Inc

 

 

 

참고 사이트
https://blogs.sap.com/2014/02/24/data-connection-details-for-data-server-configuration/

Data Connection Details for Data server Configuration | SAP Blogs