Table of Contents
Introduction #
This tutorial explains how is the Outbound interface using flat data with a Message Type that has support with the JDBC Adapter in The Old Agent.
What is the JDBC Adapter in Old Agent? #
JDBC Adapter is used as a connector to transfer data from Database to Salesforce and from Salesforce to Database. The Agent supports five-database types include Oracle, MySQL, SQLServer, MsAccess, and PostgreSQL.
Pre-request to process Outbound interface using Message Type #
Firstly, you need to have some required step before you can do the Outbound interface with flat data using Message Type:
-
- Configuration on Agent Control Board
- Create Adapter on Agent Control Board
- Create Message Type
- Create integration and outbound interface
- Do mapping
Configuration #
1. Configuration on Agent Control Board
- Agent Server Credential
- Salesforce credential
2. Create adapter on Agent Control Board
- Go to Adapter tab on Agent Control Board -> Click on New button
- Adapter Section: Choose Adapter Type(JDBC) -> Name Adapter
- Adapter Properties:
- Database Type: Choose SQL Server. The type of database to which the adapter connects. Select between SQL Server or other.
- Username: sa
- Password: *** (The default password to use when making the connection to the database)
- Hostname: 192.168.123.65(Ip address)
- Port: 1433(default)
- Database name:
- Server Instance: (local)
- Connection Destination: Agent property file
- Save
3. Create message type
- You need to create MetaData Provider
- Create repository
- Click on Open Database(Old) button
- AGENT Property File: OldAgent_AWS.properties
- Adapter Type: JDBC
- Adapter Name: Outbound_adapter_SQL
- Click on Retrieve Database
- Table/Stored Procedure Name: Choose table name in Database
- Save
- Message Type
4. Create integration and interface
- Metadata Provider: SreymayMeta
- Repository: Repo
- Source/Target Message Type: tbl_account
- Go to interface Detail
- Put the table name in a database on Source/Target Name field
5. Do mapping
6. Push data
- Go to Agent Control Board -> integration tab -> Choose the interface that you want to process -> Click on PROCESS button
7. Check result
- The result on Message board
- Result in SQL Server