Design

Back Next

Creating a Data Access Service Connector

You can create a data access service connector on a Secure Agent to access data directly from a database.

You can use a data access service connector to connect to the following databases:

Databricks

IBM DB2

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

Use a personal access token (PAT) to connect to the Databricks database. For more information about the various limitations in connecting to Databricks, see Rules and guidelines for Databricks.

You can create a data access service connector by defining the properties and specifying variables to interact directly with the database. You can also define the actions associated with a data access service connector.

Before you create a data access service connector, you must copy the required JDBC JAR files to the following directory and restart the Secure Agent:

<Secure Agent installation directory>/apps/process-engine/ext

Download the following JDBC JAR files based on the database that you use:

Database name	JAR files
Databricks	DatabricksJDBC42.jar
IBM DB2	db2jcc4.jar
MySQL	mysql-connector-java-5.1.40-bin.jar
Oracle	ojdbc8.jar
SQL Server	sqljdbc41.jar

The JAR files must be compatible with the database version that you use.

To create a data access service connector, perform the following steps:

Application Integration

, click

New

Service Connectors

In the

New Asset

dialog box, click

Data Access Service Connector using Form

, and then click

Create

The image shows the New Asset dialog box.

Designing Service Connectors

Defining Properties

Specifying Variables

Defining Actions

Creating Process Objects

Testing the data access service connector

Rules and guidelines for Databricks

Download Guide

Watch

Comments

Cloud Application Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Dave Hofer - September 07, 2023

Can you please clarify... "Before you create a data access service connector, you must copy the required JDBC JAR files to the following location and restart the Secure Agent". Please be more specific on exactly which JDBC JAR files are needed or provide a link to a more detailed explanation.

Informatica Documentation Team - September 08, 2023

Hi Dave Hofer,

We’re working to address your comments and will get back to you.

Thanks,

Informatica Documentation team

Informatica Documentation Team - January 25, 2024

Hi Dave Hofer,

We're glad to let you know that we addressed your feedback on this page. We’ve added information about the jar files that need to be downloaded.

Thanks,

Informatica Documentation team

Trung Lương - November 01, 2023

Please be more specific on exactly which JDBC JAR files are needed for MySQL

Informatica Documentation Team - November 02, 2023

Hi Trung Lương,

We’re working to address your comments and will get back to you.

Thanks,

Informatica Documentation team

Informatica Documentation Team - January 25, 2024

Hi Trung Lương,

We're glad to let you know that we addressed your feedback on this page. We’ve added information about the jar file that needs to be downloaded for MySQL.

Thanks,

Informatica Documentation team

Suman Kodeboyina - February 20, 2024

Hi,

There is a typo in the section:

Download the following JDBC JAR files based on the database that you use:

The following info is incorrect as they had both Oracle and SQL Server jar assigned to Oracle .

Oracle ojdbc8.jarsqljdbc41.jar

Thanks

Suman K.

Informatica Documentation Team - February 21, 2024

Hi Suman Kodeboyina,

We're glad to let you know that we've addressed your feedback on this page. We've corrected the jar file name for Oracle.

Thanks,

Informatica Documentation team

Rename Saved Search

Table of Contents

Design

Design

Creating a Data Access Service Connector

Creating a Data Access Service Connector