Preface
Introduction to Synchronize Dynamics 365 Accounts or Contacts with Salesforce Accounts or Contacts recipe
- Prerequisites
Recipe contents
- Synchronize Dynamics 365 Accounts or Contacts with Salesforce Accounts or Contacts recipe assets
Using the Synchronize Dynamics 365 Accounts or Contacts with Salesforce Accounts or Contacts recipe

Synchronize Dynamics 365 Accounts or Contacts with Salesforce Accounts or Contacts

Back Next

Configuring and publishing the MySQLConnectionCustomer connection

Before configuring the MySQLConnectionCustomer connection, perform the following steps:

Create a database to store the result.

The following snippet is an example for creating a database in MySQL:

CREATE DATABASE `customer`;
CREATE TABLE `customer_onboard` (
  `dynamics_id` varchar(255) DEFAULT NULL,
  `salesforces_id` varchar(255) DEFAULT NULL,
  `name_entity` varchar(255) DEFAULT NULL,
  `process_id` varchar(255) DEFAULT NULL,
  `result_status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

To use a MySQL database, you can download the

mysql-connector-j-8.0.33.jar

JDBC driver from https://dev.mysql.com/downloads/connector/j/.

To configure and publish the MySQLConnectionCustomer connection, perform the following steps:

Open the

MySQLConnectionCustomer

connection.

From the

Type

list, select

JDBC Generic Cloud Adapter

From the Runtime Environment
list, select the Secure Agent.

In the

Connection Properties

section, enter values for the following properties:

Property	Description
JDBC Connection URL	The URL schema for the database. Use the following schema for the MySQL database: jdbc:mysql://<Host>:<Port>/<Database> For example: jdbc:mysql://<Host>:<Port>/customer
JDBC Jar Directory	The path to the JDBC driver .jar file. For example, you can enter the following directory: C:/jdbc If you do not specify a directory path, the Secure Agent gets the .jar file from the process-engine/ext directory. You must specify one of the following values for the JDBC connection to work successfully: JDBC JAR directory. If you choose to specify the JDBC JAR directory, you can place the .jar file in any directory and specify the directory in the JDBC Jar Directory field. JDBC driver class name. If you choose to specify the JDBC driver class name, you must place the JDBC driver .jar file in the following directory: process-engine/ext
JDBC Driver Class Name	The name of the JDBC driver class. Use the following MySQL driver class name: com.mysql.jdbc.Driver You must specify one of the following values for the JDBC connection to work successfully: JDBC JAR directory. If you choose to specify the JDBC JAR directory, you can place the .jar file in any directory and specify the directory in the JDBC Jar Directory field. JDBC driver class name. If you choose to specify the JDBC driver class name, you must place the JDBC driver .jar file in the following directory: process-engine/ext
Schema	The schema name is the database name. For example: customer
User name	User name to connect to the database.
Password	Password to connect to the database.
Object Filter	Object names. For example: customer_onboard

Save and publish the connection.

Using the Synchronize Dynamics 365 Accounts or Contacts with Salesforce Accounts or Contacts recipe

Rename Saved Search

Table of Contents

Synchronize Dynamics 365 Accounts or Contacts with Salesforce Accounts or Contacts

Synchronize Dynamics 365 Accounts or Contacts with Salesforce Accounts or Contacts

Configuring and publishing the MySQLConnectionCustomer connection

Configuring and publishing the MySQLConnectionCustomer connection