27.1 How to use JDBC adapter

This tutorial explains what JDBC adapter is and why do we need it. It describes how to create and use them.

1 What is JDBC adapter?

JDBC Adapter is used as a connector to transfer data from Database to Salesforce and from Salesforce to Database. Agent supports five-database type include Oracle, SQLServer, MySQL, MsAcess and PostgreSQL.

2 Prerequisite

Before creating adapter, you have to have Integration and interface and these two things must create in Salesforce. To create, edit, and delete you need to do in Salesforce not Agent. Please perform both integration and interface development in Salesforce first. Then run AgentUI and create adapter there. 2.1 Creating of JDBC adapter The following sample is about SQLServer configuration. Run Agent UI > Integration Wizard > Choose Integration > Choose existing interface.

Adapter Section: Choose Adapter Type (JDBC) > Name Adapter
Adapter Properties:
Database type: Choose SQLServer. The type of database to which the adapter

connects. Select between SQLServer and other.

Username: sa
Password: * (The default password to use when making the connection to the database).
Hostname: 192.168.1.141 (Ip address)
Port: 1433 (default) - Database Name:
Server Instance: (Local)
Click “Test Source Connection” to test the connection to the specified folder and file.
Click Save.

Note: For Oracle, MySQL, MsAcess and PostgreSQL database, you can just do the same as SQLServer. However, just you need to change the database types, adapter and its properties accordingly.

3. To test Integration

There are three ways to test yours integrate. 3.1 Button Test Integration When you click test integrate the 50 records among many data will process. The maximum is 50. By clicking this button you will know if your configure is correct or not. This button is located in Integration Setup Wizard-Integration Detail.

3.3 Schedule Click Integration Scheduling>Property File Selection>Integration Name>Interface Name>Integration Mode>On>Run at/Run every>Save 4 To check result Go to SF > Message Monitoring Board