DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 5

changes.mady.by.user admin

Saved on

compared with

New Version 6

changes.mady.by.user admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleLog Table Schema
CREATE TABLE `sys_dataflow_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `records_processed` varchar(20) DEFAULT NULL,
  `message` text,
  `log_messages` longtext COMMENT 'Log messages for processed data for c2c',
  `created_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`username`),
  UNIQUE KEY `id` (`id`)
)

Setting up Configuration Files

There are 2 sets of files that will need to be configured

  • Configuration files to let engine know how to interact with user and log storage
  • The "Process" files that needs to run for a given application.
  •  

partner.properties  

Location: (inside  “www/WEB-INF/conf/”  folder)

Property

 

Description

partnerAppKey

Required

Will be provided by DBSync

partnerAppToken

Required

Will be provided by DBSync

partner.database.driverClassName

Required

Profile Details and Logs are stored in Database, for this property, provide the Database driver class name. For example : for mysql database, this property will be com.mysql.jdbc.Driver

partner.database.url

Required

Profile Details and Logs are stored in Database, for this property, provide the Database Url along with Database name. For example : for mysql database, this property will look like jdbc:mysql://<ServerName>:<Port>/<Database Name>.

partner.database.username

Required

Profile Details and Logs are stored in Database, for this property, provide the Database Username.

partner.database.password

Required

Profile Details and Logs are stored in Database, for this property, provide the Database Password.

dbsync.logger

Optional

If you don’t want to store the logs in the default database and want to store the logs in other database, then enable this property. Property value will be constant : com.mydbsync.cw.embedded.EmbeddedLogger
If you want to store the logs in the default database itself, then remove or comment this property.
If you enable dbsync.logger, below 4 properties will be used for storing the logs in the different database.

log.database.driverClassName

Optional

Provide the Driver class name.
Ex: If mysql, then com.mysql.jdbc.Driver

log.database.url

Optional

Provide the Database Url along with Database Name.
Ex: If my sql, then jdbc:mysql://<ServerName>:<Port>/<Database Name>.

log.database.username

Optional

Provide the Logging database Username.

log.database.password

Optional

Provide the database Password.

partner.profile.template

Optional

profile.xml is the file, where all connector properties are stored. If you have profile.xml and want to use it as template, then provide the absolute path of profile.xml
Ex: <Your path>/profile.xml

partner.app.qbdesktop.pdl

Required

This is for QuickBooks desktop. Provide the process xml absolute path, which you want to run. Process xml will be inside the pdl (project). Ex : If your pdl name is QuickBooksPdl, and process xml name is processdefinition_CustomerToAccount.xml, then the path will be
<Path to the Directory>/QuickBooksPdl/processdefinition_CustomerToAccount.xml

partner_profile.xml  

Location: (inside  “www/WEB-INF/conf/”  folder). Also see "partner.profile.template" property above in case you want to store it outside of the default installation (Recommended)

This file contains all connector properties. Connector properties are the application properties, from where and to where, you sync the data. All connector properties are closed within <adapters> root tag. Each specific connector will be enclosed within <adapter> tag.

There are 2 ways to generate this file

  1. User CloudWorkflow to define a process that you would like to deploy on ECW. Download the Zip file, the default "profile.xml" will be your starting point.
  2. Use notepad to create your default setup (Advanced Users)
    Code Block
    langxml
    titleSample Profile
    <?xml version="1.0" encoding="UTF-8"?>
<profile id="localhost@avankia.com" name="Salesforce_to_Database" loglevel="ALL" email="" guid="325735D5">

  <adapter name="mysql" type="com.avankia.appmashups.engine.conversion.adapters.DatabaseAdapter">
    <property name="password" encrypted="false" >XXXX</property>
    <property name="url">jdbc:mysql://localhost:3306/dbsync</property>
    <property name="autocommit">true</property>
    <property name="adp_name">mysql</property>
    <property name="driver">mysql</property>
    <property name="dbname">dbsync</property>
    <property name="username">root</property>
  </adapter>

  <adapter name="Salesforce" type="com.avankia.appmashups.engine.conversion.adapters.SalesforceAdapter">
    <property name="securityToken" />
    <property name="sid">XXXX</property>
    <property name="transport.compression" />
    <property name="username">abc@def.com</property>
    <property name="refreshToken">AAA</property>
    <property name="password" encrypted="false">YYYY</property>
    <property name="endpoint">https://login.salesforce.com/services/Soap/u/32.0</property>
    <property name="adp_name">Salesforce</property>
  </adapter>
</profile>