Integrate Sybase Data in Your Informatica Cloud Instance

Informatica Cloud allows you to perform extract, transform, and load (ETL) tasks in the cloud. With the Cloud Secure Agent and the CData JDBC Driver for Sybase, you get live access to Sybase data, directly within Informatica Cloud. In this article, we will walk through downloading and registering the Cloud Secure Agent, connecting to Sybase through the JDBC Driver and generating a mapping that can be used in any Informatica Cloud process.

Informatica Cloud Secure Agent

To work with the Sybase data through the JDBC Driver, install the Cloud Secure Agent.

1. Navigate to the Administrator page in Informatica Cloud
2. Select the Runtime Environments tab
3. Click "Download Secure Agent"
4. Make note of the Install Token
5. Run the installer on the client machine and register the Cloud Secure Agent with your username and install token

NOTE: It may take some time for all of the Cloud Secure Agent services to get up and running.

Connecting to the Sybase JDBC Driver

With the Cloud Secure Agent installed and running, you are ready to connect to Sybase through the JDBC Driver.

Adding the JDBC Driver to the Secure Agent Machine

1. Navigate to the following directory on the Secure Agent machine:
   %Secure Agent installation directory%/ext/connectors/thirdparty/
2. Create a folder and add the driver JAR file (cdata.jdbc.sybase.jar) based on the type of mapping that you want to configure.

   For mappings, create the following folder and add the driver JAR file:

   informatica.jdbc_v2/common

   For mappings in advanced mode, also create the following folder and add the driver JAR file:

   informatica.jdbc_v2/spark
3. Restart the Secure Agent.

Connecting to Sybase in Informatica Cloud

After installing the driver JAR file, you are ready to configure your connection to Sybase in Informatica Cloud. Start by clicking the Connections tab and clicking New Connection. Fill in the following properties for the connection:

• Connection Name: Name your connection (i.e.: CData Sybase Connection)
• Type: Select "JDBC_V2"
• Runtime Environment: Select the runtime environment where you installed the Secure Agent
• JDBC Driver Class Name: The name of the JDBC driver class: cdata.jdbc.sybase.SybaseDriver
• JDBC Connection URL: Set this to the JDBC URL for Sybase. Your URL will look similar to the following:
  
  jdbc:sybase:User=myuser;Password=mypassword;Server=localhost;Database=mydatabase;Charset=iso_1;

  To connect to Sybase, specify the following connection properties:

  • Server: Set this to the name or network address of the Sybase database instance.
  • Database: Set this to the name of the Sybase database running on the specified Server.

  Optionally, you can also secure your connections with TLS/SSL by setting UseSSL to true.

  Sybase supports several methods for authentication including Password and Kerberos.

  Connect Using Password Authentication

  Set the AuthScheme to Password and set the following connection properties to use Sybase authentication.

  • User: Set this to the username of the authenticating Sybase user.
  • Password: Set this to the username of the authenticating Sybase user.

  Connect using LDAP Authentication

  To connect with LDAP authentication, you will need to configure Sybase server-side to use the LDAP authentication mechanism.

  After configuring Sybase for LDAP, you can connect using the same credentials as Password authentication.

  Connect Using Kerberos Authentication

  To leverage Kerberos authentication, begin by enabling it setting AuthScheme to Kerberos.

See the Using Kerberos section in the Help documentation for more information on using Kerberos authentication.

You can find an example connection string below: Server=MyServer;Port=MyPort;User=SampleUser;Password=SamplePassword;Database=MyDB;Kerberos=true;KerberosKDC=MyKDC;KerberosRealm=MYREALM.COM;KerberosSPN=server-name

Built-In Connection String Designer

For assistance in constructing the JDBC URL, use the connection string designer built into the Sybase JDBC Driver. Either double-click the .jar file or execute the .jar file from the command-line.

java -jar cdata.jdbc.sybase.jar

Fill in the connection properties and copy the connection string to the clipboard.

Username: Set this to the username for Sybase

Password: Set this to the password for Sybase

Create a Mapping for Sybase Data

With the connection to Sybase configured, we can now access Sybase data in any Informatica process. The steps below walk through creating a mapping for Sybase to another data target.

1. Navigate to the Data Integration page
2. Click New.. and select Mapping from the Mappings tab
3. Click the Source Object and in the Source tab, select the Connection and set the Source Type
4. Click "Select" to choose the table to map
5. In the Fields tab, select the fields from the Sybase table to map
6. Click the Target object and configure the Target source, table and fields. In the Field Mapping tab, map the source fields to the target fields.

With the mapping configured, you are ready to start integrating live Sybase data with any of the supported connections in Informatica Cloud. Download a free, 30-day trial of the CData JDBC Driver for Sybase and start working with your live Sybase data in Informatica Cloud today.