If you're using the CData ODBC Driver for SAP ERP on Windows, use the RFC APIs to connect to the SAP system.

For Mac or Linux, follow the JCo JAR file instructions below.

Connect Using the Classic RFC SDK

To use the Classic RFC SDK without Unicode support provided with the library librfc32.dll, set ConnectionType to Classic. Place the assembly in a location where it is accessible at run time, such as system32 or the bin folder in your installation directory or your path.

Connect Using the Classic RFC SDK with Unicode Support

To use the Classic RFC SDK with Unicode support, set ConnectionType to Classic_Unicode.

Place the following assemblies in a location where they are accessible at run time, such as system32 or the bin folder in your installation directory.

• librfc32u.dll
• icudt34.dll
• icuin34.dll
• icuuc34.dll

Connect Using the NetWeaver RFC SDK

Prior to connecting, you must have a valid S-User Id and be able to access the SAP software downloading site. You also must be able to download the SAP content from the SAP portal. To download the necessary SDK, follow these steps:

1. Navigate to https://me.sap.com/softwarecenter.
2. On the "Downloads" page, search for sap nw rfc.
3. Click SAP NW FRC SDK 7.50.
4. Select the platform you use and then download.

To use the NetWeaver RFC SDK, set ConnectionType to NetWeaver.

Place the following assemblies in a location where they are accessible at run time, such as system32 or the bin folder in your installation directory.

• sapnwrfc.dll
• icudt34.dll
• icuin34.dll
• icuuc34.dll
• libicudecnumber.dll
• libsapucum.dll

Connect Using SOAP Interface and RFC URL

To connect using the SOAP interface, set the following:

• ConnectionType: Set this to Soap.
• RFCUrl: Set this to the SOAP URL of your SAP system.

The SOAP service must be enabled in your SAP system for this type of connection to work properly.

Connect Using the JCo JAR File

The CData ODBC Driver for SAP ERP relies on the SAP RFC to execute queries and retrieve data from SAP. The RFC depends on the JCo (Java Connector) JAR file.

To access the RFC SDK used to communicate with SAP, you can use the SAP JCo (Java Connector). You need to include the sapjco3.jar in your CLASS_PATH specified in the INI file and ensure that the native library location for the JAR is set to the folder containing the sapjco3 library.

You must also ensure that the bitness (32-bit or 64-bit) of the libraries matches the bitness of the Java Virtual Machine (JVM) on which your application is running. A mismatch between these can lead to errors where the JVM cannot load the native library, resulting in a failure to establish a connection to the SAP system. Before downloading, check your system's architecture and download the corresponding version of the library.

• On Linux, place the libsapjco3.so file in the same directory as the sapjco3.jar.
• On Mac OS X, place the libsapjco3.jnilib file in the same directory as the sapjco3.jar.

Follow these steps to download the relevant jar file:

1. Open the SAP Java Connector.
2. Select the Jco version that matches your platform.
3. Click the download link. This opens the login page.
4. Login to the SAP site with a valid S-User ID.
5. Download the package.