Skip to Content
Author's profile photo David Pugh

SAP Data Services and JDBC

SAP Data Services and JDBC

SAP Data Services, as of 4.2 SP2, now supports the use of JDBC drivers as a data source. This capability has been implemented through a new adapter type, JDBC.

To add a JDBC adapter you use the Data Services Administration Console, browse to adapter instances, choose your job server and then select Adapter Configuration.

Adapter List.png

Select JDBCAdapter. I’m using SAP ASE as a source so I have added the JDBC library files for ASE (<install Directory>jConnect-7_0\classes\jconn4.jar) to the classpath.


Then you add the class name, driver URL, username and password. Class name and URL should be contained in the documentation from the JDBC driver provider. The URL for ASE includes servername, port and database name.


The next section is used to configure what Data Services pushes down to the database. This will vary by database type and JDBC driver provider.


Once you have applied the configuration settings you can start the adapter. This is now ready for use in Data Services Designer.


In Designer create a new datastore and change the type to Adapter. Select the adapter you have created in the management console and select OK.


You can now browse the metadata as you would in any other datastore type and import the tables you require.


In this example I’ve imported 2 tables and joined them together in a data flow. Within the query transform I’ve also applied functions to 3 of the fields to test what gets pushed down. You can see from the Optimised SQL that the Upper, Year and Month functions have been pushed down.


There are a few limitations with the JDBC Adapter, which include no View Data, Stored Procedures, Lookup and Table Comparisons. Hopefully, as the use of this adapter grows, these will be addressed in future releases.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Arun Sasi
      Arun Sasi

      Hi David,

      Excellent Article!!

      David Pugh

      I tried to follow your steps to create a JDBCAdapter to connect to SQL Server 2008 database but it gives an error

      Adapter 'JDBCAdapter' is not started - cannot obtain statistics."

      Our job server is on unix and we are currently on setting up our dev server on DS 4.2 SP5.

      I have added the sqljdbc4.jar under the classpath section (/appl/sap/BODS4/dataservices/ext/lib)

      JDBC Driver Class Name:

      JDBC Driver URL: jdbc:sqlserver://servername:1433;databaseName=db_name

      Please help!!


      Arun Sasi

      Author's profile photo Former Member
      Former Member

      Very instructive blog David,

      Thank you!

      Author's profile photo Former Member
      Former Member

      Hi, is this JDBC adapter still for source and NOT target? Thanks!


      Author's profile photo Mahantesh Hiremath
      Mahantesh Hiremath

      Did you find any solution use as a target.?

      Author's profile photo Mahantesh Hiremath
      Mahantesh Hiremath

      We are trying to load from HANA to Snowflake with a snowflake ODBC driver. Which is taking a lot of time (2 simple records) more than 6 min. No clues about what happening !!!!