App Connect

 View Only
  • 1.  Policy in ACE

    Posted Mon December 06, 2021 12:51 AM
    Hi Team,

    I would like to know how we can create the ODBC policy at ACE server level and where I can get the jar files.

    ------------------------------
    Prince Khanna
    ------------------------------


  • 2.  RE: Policy in ACE

    Posted Thu December 23, 2021 10:00 AM
    ODBC does not use policies nor are there any JARs.  ODBC is C based, not Java.  You add the details to the odbc.ini file and the common drivers are already provided.  For other databases, you will need to contact the database support group to locate the ODBC driver if you cannot locate it online.

    If you mean JDBC, then the policy is created in the toolkit.  First create a policy project then add a policy to it.  Use the drop down menu on the policy editor to select JDBCProviders template then select the closest database type from the second drop down.  You will then need to fill out the remaining details.  The JAR files are all provided by the database provider.  You will need to reach out to them to locate the driver.

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