Skip to Content
Author's profile photo Former Member

Data Connection Details for Data server Configuration

Few days ago when I was working for some system configuration, I have faced a big issue to collect the db connection details for a DB2 server. So by facing so I planned to share my knowledge regarding data connection details I gained from various system configuration. Hope it will help all in future.

Here I will give the details of most used databases where developers need to connect using data server for fetching the data from those DB. I am giving the details for Oracle, MSSQL, DB2, Sybase etc.

Data Server Configuration : Before starting the data connection details let me explain about a bit of data server configurations. While configuring a data server few parameters which directly depends upon the database connection details, they are as follows,

  • JDBC Driver
  • Server URL
  • Validation Query

JDBC Driver is a fixed driver class which is different for each kind of database. Using server URL it basically connects to the database but every databases have a fixed format for the URL and Validation Query used to check the ping to that server based on that MII determines the server is up or not.

Apart from that developers required another thing that is JDBC Driver (.jar file). So those are the main part developers required to collect data before configuring the data server in MII.

Data Connection Details :

  • 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
  • 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

There are lots of other db with IDBC connector which developers can connect in SAP MII Data server but the above mentioned are commonly in use.

Hope it will help a bit to the developer while configuring the data server.

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Now I don't have to Google every time. đŸ™‚

      Nice Information

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks !!!

      Author's profile photo Former Member
      Former Member

      Really Good and nice thought for keeping all together.

      Author's profile photo Anant Rai
      Anant Rai

      Helpful and handy blog

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks all.. đŸ™‚

      Author's profile photo Former Member
      Former Member

      Useful info for all.. thanks for putting it up!

      Author's profile photo Jurgen de Jong
      Jurgen de Jong

      Recently we needed to add a MaxDB database to SAP MII. We used the following data:

       

      MaxDB

      • JDBC Driver: com.sap.dbtech.jdbc.DriverSapDB
      • Server URL Format: jdbc:sapdb://<host>:<prot>/<db name>
      • Validation Query : select getdate()
      • SELECT NOW() FROM DUAL