DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version Current

changes.mady.by.user Munira Majumdar

Saved on

Key

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

The data from Sage 100 is fetched through a mechanism within sage Sage 100 - referred to as a Visual Integrator for which we .  We have created export jobs to fetch data from various tables of Sage 100. Instead of creating the relevant export and import jobs, we have created the jobs dump file which you . You can restore the file in your Sage 100 instance.

Image Removed

 Follow the below steps to create the required jobs in to Sage 100 These export jobs dump can be downloaded from the following link Sage_ExportJobs.EXP. 

Image Added

 Export Job Setup: 

Follow the steps to set up the Export Jobs that are required to export data from Sage 100  to staging database.

  1. Login to Sage 100 with valid credentials.

  2. Navigate to visual integrator -> Job Import.

  3. Select the Job import file from the file location (Which should be copied to your server).

  4. The job import wizard shows up all the Available jobs, . Select all the jobs which that are necessary for your integration.

  5. Click on Accept button which will to create all the jobs in your visual integrator of sage Sage 100.

Below is the table containing the description of Export jobs

Job NameDescription
DB_AP_VENDORExports all the
vendors
Vendors records from AP_Vendor table of Sage 100 to DBSync staging.
DB_AR_SALESPRSNExports all of
sales reps
Sales Reps records from the table AR_Salesperson from sage 100 to DBsync Staging.
DB_AR_CUSTOMERExports all of Customer records from AR_Customer recods from sage 100 to DBSync Staging
DB_CI_EXTDESCExports all
of
records from the table CI_ExtendedDescription.
DB_CI_UOMExports all
of
records from the table CI_UnitofMeasure.
DB_SO_SHIPTOADDExport all
of
records from SO_ShipToAddress to DBSync staging
db
database.
DB_IM_WAREHSEExports all
of
records from table IM_Warehouse to DBSync staging
db
database.
DB_CI_ITEMExports all
of
item records from table CI_Items to DBSync staging
db
database.
DB_AR_INVHISHDRExports all
of
invoice history from table AR_InvoiceHistoryHeader
 to
to DBSync staging
db
database.
DB_AR_INVHISDTLExport all
of
invoice line item history from table AR_InvoiceHistoryDetail to DBSync staging
db
database.
DB_IM_ITMWAREHSEExports all
of
records from IM_Itemwarehouse to DBSync staging
db
database.
DB_AR_OPNINVExports all of records from table AR_OpenInvoices to DBSync staging db.

Import Job Setup: 

Follow the steps to set up the Import Job required to import data from staging to Sage 100. You can download the Import job from the link IMPJOBS.EXP.

  1. Login to Sage 100 with valid credentials.

  2. Navigate to visual integrator -> Job Import.

  3. Select the Job import file from the file location (Which should be copied to your server).

  4. The job import wizard shows all the Available jobs. Select all the jobs that are necessary for your integration.

  5. Click Accept. This will create all the jobs in your visual integrator of sage 100.

Following table contains description of Export jobs:

Job NameDescription
DB_SO_IMImports all Sales Order header and its related line items in Sage 100.

RUNNING JOBS FROM VISUAL INTEGRATOR OF SAGE 100

The below are the Follow steps to run the job but precondition . However, the precondition for this is to have ODBC setup, before hand, on which the sage Sage 100 is hosted, this . This is done by DBSync implementation as a part of setup.

  1. Login to Sage 100 with valid credentials credentials. 

  2. On the left navigation, select visual integrator -> Main -> Job Select option.

  3. Select the import/export job from the existing list.

  4. A job popup is opened, now select on accept will open. Select Accept to run the job.

  5. Now An alert pops up saying do stating, 'Do you want to continue?' as shown in below screen.

...