B1if, From SQL to Oracle

[Former Member]

Hi Experts,

I have doubt on B1iF integration from SQL database to Oracle database.

I want to know it's possible or not. if possible means please tel me the solution.

Thanks in advance. I am waiting your valuable reply.

[Former Member]

Its urgent, if any one know please help me out.

[Former Member]

Is it possible using JDBC connection?

http://wiki.scn.sap.com/wiki/display/EP/JDBC+Connection+Setup

[bastian_schaefer]

Hi,

yes, of course.

Only a JDBC driver of this database engine is needed to be installed.

It should be enough to place the jdbc driver's jar file under <installation path of Integration Framework>\Tomcat\webapps\B1iXcellerator\WEB-INF\lib

Please create a new entry of type "J.AnySystem" in B1i's SLD and enter the parameters.

Afterwards this new JDBC SLD entry can be used for DBINBOUND, DBOUTBOUND and for JDBC call atoms.

Best regards

Bastian