Hi Team,

Created a flow in which Oracle Database insertion is required. In App connect Enterprise Toolkit, created a policy for JDBC Providers and called that policy file in Java Compute node in creating DB connection command.
* Connection conn = getJDBCType4Connection("{policy}:db", JDBC_TransactionType.MB_TRANSACTION_AUTO);

Trying to do the same in CP4I, what is the way of connecting Oracle DB with app connect flow.
Found a way of creating of ODBC.ini file in Configuration Type, is that only way to connect DB.

If so, Please share some reference for creating ODBC.ini file and how to call/refer this configuration file in my App connect Message flow to create connection for Inserting values.

------------------------------
Preethi B V
------------------------------

Hi Preethi,
The same approach will work just fine in CP4I.  You can use your current JDBC approach or switch to ODBC, whichever you fancy.  To get JDBC to work, you need to include the JDBC provider JARs into the BAR, or otherwise make them available to the container.  You will also need to include the policy project in the BAR.  This way all the resources for JDBC are available in the runtime.

------------------------------
MATTHEW SEGALL
------------------------------

Original Message:
Sent: Sun February 13, 2022 01:06 PM
From: Preethi B V
Subject: Oracle Database connection from App connect flow in CP4I.

Hi Team,

Created a flow in which Oracle Database insertion is required. In App connect Enterprise Toolkit, created a policy for JDBC Providers and called that policy file in Java Compute node in creating DB connection command.
* Connection conn = getJDBCType4Connection("{policy}:db", JDBC_TransactionType.MB_TRANSACTION_AUTO);

Trying to do the same in CP4I, what is the way of connecting Oracle DB with app connect flow.
Found a way of creating of ODBC.ini file in Configuration Type, is that only way to connect DB.

If so, Please share some reference for creating ODBC.ini file and how to call/refer this configuration file in my App connect Message flow to create connection for Inserting values.

------------------------------
Preethi B V
------------------------------