EPM Integration Agent Custom Database Connections

In this update, the EPM Integration Agent now enables customers to implement a custom database connection function using the agent interface library. Customers can use whatever method they desire to get the JDBC connection and then set the connection for use in the agent SQL processing.

This feature can be used to implement authentication for sources like MSAD authentication against Azure Active Directory, Oracle, SQL Server, MySql, DB2 and so on. The Agent uses this connection to execute. The conn object must be a type 4 JDBC connection and an implementation of the java.sql.Connection interface.

This feature is only applicable in the befExtract and befExport scripts. See sample scripts BefExtract.py and the java CustomEventSample and CustomWribackEvent for more details on usage.

Business Benefit: This feature enables customers to pass a connection object from a BefExtract custom script whose creation and release can be managed by the customer's API. For example, if a customer wishes to use an Azure active directory to authenticate users for an Azure data source, this new feature provides the ability to write custom code to authenticate and connect to this service prior to performing the extract query. Prior to this update, database connections were only initialized using basic authentication with the user and password provided in the source application definition.  Now, customers can implement enhanced authentication and incorporate directly into the agent extract process.

Key Resources