1. How is the Outbound interface using Message Type through Old Agent Control Board for JDBC Adapter (SQLServer)?

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

1. 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

1. 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

1. 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

1. Do mapping

1. Push data

• Go to Agent Control Board -> integration tab -> Choose the interface that you want to process -> Click on PROCESS button

1. Check result

• The result on Message board

• Result in SQL Server