Should JDBC driver be deployed for MS Dynamics (Receiver)

[former_member188885]

Hi All,

I have a requirement which is a File to JDBC scenario. The data from the file has to update a ERP system called MS Dynamics. So what are the pre- requisites to be done in order to create a JDBC receiver for this. This is the first time i am using a JDBC receiver. Should any driver be deployed? If yes how should it be done.

Please help.

[former_member209575 · Accepted solution]

Hi ,

You have to deploy JDBC driver in your PI system.

Please find below answer from JDBC FAQ

How do I deploy the JDBC Driver JARs required to connect the JDBC Adapter to my DBMS?

o A: The JDBC driver deployment is performed using a special SDA file

named aii_af_jmsproviderlib.sda (releases 3.0/7.0) or

com.sap.aii.adapter.lib.sda (releases 7.1) which is shipped as an

empty stub with your XI installation. For Type 4 drivers,

information how to add your JDBC drivers to this SDA is available

in section 11.1 of the SAP XI 3.0 Configuration Guide, which is

available on the SAP Service Marketplace under the URL:

http://service.sap.com/instguidesNW04.

For Type 2 drivers, additional configuration steps are required,

which are documented in note 850116

Also please look below note

SAP Note 850116 - XI 3.0 / PI 7.0 JDBC Adapter: Type 2JDBC Driver Deployment

if it is PI 7.1 System follow below link

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4b60

Regards

Pradeep P N