BigMachines Connector > Synchronization Tasks with BigMachines Connector > Adding Data Tables
  

Adding Data Tables

Perform the following steps to add Data Tables in a BigMachines source or target in a synchronization task:
    1Specify the Datatables.tbl file name in Data Tables Schema Path field while creating a BigMachines connection.
    2The default Datatables.tbl file saves in the following directory. C:\a_IOD\Files\BigMachines\Datatables.tbl
    You must create a Datatables.tbl in a specific format.
    The following image shows the Datatables.tbl file.
    You can use the following table definitions to create Datatables.tbl.
    Header Name
    Allowable Value
    Remarks
    ISCUSTOMOBJ
    Y
    Only Y is supported in the current release.
    OPR_READ
    Y,N, Any Character
    When you enter Y, the table is displayed in source tab. When you enter any other character, the table does not display in source tab.
    OPR_CREATE
    Y, N
    Insert (create) task operation is not supported for Data Table.
    OPR_UPDATE
    Y, N
    Update task operation is not supported for Data Table.
    OPR_DELETE
    Y, N, Any Character
    Enter Y to support the delete task operation.
    OPR_UPSERT
    Y,N, Any Character
    Enter Y to support the upsert task operation.
    TABLE_NAME
    <object Name>
    Object name as shown in Data Integration UI.
    OBJECT_TYPE
    CUSTOMOBJECT
    Enter the CUSTOMOBJECT as static value, same as table_name.
    CUSTOMOBJ_NAME
    <object Name>
    Custom object, mostly same as table name.

Sample Datatables.tbl file

Perform the following steps to create a sample Datatables.tbl file.
    1Copy and paste the following code sample in a blank text file.
    "ISCUSTOMOBJ","OPR_READ","OPR_CREATE","OPR_UPDATE","OPR_DELETE","OPR_UPSERT","TABLE_NAME","BUSINESS_TABLE_NAME","CUSTOMOBJ_NAME"
    "Y","Y","N","N","Y","Y","Supplemental","Supplemental","Supplemental"
    "Y","Y","N","N","Y","Y","Retail_Visit","Retail_Visit","Retail_Visit"
    2Name the file as Datatables.tbl.
    3Click Save.