Page History

...

• Once into the DBSync console, click on Create profile Button, Enter Profile Name and click on Save Button as shown. Image Modified
  Image Modified
• A new Profile will be created by given Name. In this tutorial I have used name Intact-Database. The Profile will be listed in the profile area as shown below:

...

• Click on Edit link next to the Intacct adapter and you will be presented with properties for the Adapter at the bottom left of the window. Enter values for all the properties and click on Save Properties. Both the sections of the window are shown below sequentially.

• Click on Validate link Next to Intacct Adapter. A message box is displayed; if the message says "Connection Settings are valid" you are good to go. Else Click on Edit and enter correct values for Adapter properties and repeat the steps. Click OK.

...

• Click on Edit link next to the Database adapter and you will be presented with properties for the Adapter at the bottom left of the window. Enter values for all the properties and click on Save Properties. Both the sections of the window are shown below sequentially.

• Click on Validate Link Next to Database Adapter. A message box is displayed; if the message says "Connection Settings are valid" you are good to go. Else Click on Edit and enter correct values for Adapter properties and repeat the steps. Click OK.

...

• Click on Add Process Icon on the Right side of the screen. Enter Process Name and Click on Ok. A new process will be created and will be listed under profile name on the right side of the screen.

• Double Click on the Process Name "IntacctToDataBaseSync" to open the process in the Control flow for Intact to Database Sync process. The process will contain 2 States by default:

...

• Follow the same step for Create Map and Create Writer button. And you will get a data flow area as shown below in the screenshot. In this tutorial I have used "IntacctMap" for Create Map and "DBWriter" for Create Writer component.** Reader: Reader is a process component that reads data from source "data source". Reading the data is also known as "Extracting" the data. Note one state can have only one Reader.** Map: Map component converts data into the format that could be understood by writer and target data source. Converting the data so that it could be understood by target data source is also known as "Transforming" the data. Note One state can have more than one Map.
  • Writer: Writer component writes the data to target "data source". Writing the data into a data source is also known as "Loading" the data. Note One State can have more than one writer.

...

• Right Click on IntacctReader and click on Connect followed by left click on IntacctMap to create a control flow from IntacctReader to IntacctMap. Right Click on IntacctMap and click on Connect followed by left click on DBWriter to create control flow from IntacctMap to DBWriter. All control flows will be displayed using arrows. A screenshot is shown below displaying the control flow after following the above process.

• Right Click on IntacctReader and click on Properties. The properties will be displayed in the bottom left area of DBSync Console. Select IntacctAdapter from Adapter Drop Down. Once IntacctAdapter is selected, all the properties for IntacctReader will be listed in the properties area with lookup icon. Click on the lookup icon and list of objects from Intacct will be displayed in the query section on the right. Query section will contain all the table listing from Intacct. Select Intacct entities and fields from the list to auto generate the query in query builder section. You can also write your own query. In this tutorial I am selecting few fields from "customer" entity of Intacct. Click on save button once done. The screen shot is shown below:

...

• Right Click on IntacctMap and click on Properties. Enter 1 in the sequence text box. Enter description for the mapping. Click on Edit link for *******_map.xml file. You will be presented with a new window with source and target columns. Screenshots for Map properties and map editor is shown below respectively.

• In the Map window click on Target column followed by source column to create field to field mapping. You can also use various functions provided by DBSync. In the mappings shown below I have used few of these functions. Rest of the functions and their details you can find in the wiki link "Mapping Functions". The Map window with all mappings done is shown below.

...