Tutorials

  1. Home
  2. Dokumente
  3. Tutorials
  4. 86. How is the Outbound interface using Message Type through Agent Control Board for JDBC Adapter (SQLServer)?

86. How is the Outbound interface using Message Type through 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:

    1. Configuration on Agent Control Board
    2. Create Adapter on Agent Control Board
    3. Create Message Type
    4. Create integration and outbound interface
    5. 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

Fandest du diesen Artikel hilfreich? Ja Nein

Wie können wir helfen?