User Tools

Site Tools


extensions:sample-collector-sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

extensions:sample-collector-sql [2020/07/08 10:07] (current)
Line 1: Line 1:
 +===== Sample Collector Definition for SQL =====
  
 +Here is a sample of a Synchro Data Source definition file for SQL collector example.
 +
 +<code json DocumentNotesCollector.json>​
 +{
 + "​name":​ "​$prefix$DocumentNote",​
 + "​description":​ "",​
 + "​status":​ "​production",​
 + "​user_id":​ "​$synchro_user$",​
 + "​notify_contact_id":​ "​$contact_to_notify$",​
 + "​scope_class":​ "​DocumentNote",​
 + "​database_table_name":​ "",​
 + "​scope_restriction":​ "",​
 + "​full_load_periodicity":​ "​604800",​
 + "​reconciliation_policy":​ "​use_attributes",​
 + "​action_on_zero":​ "​create",​
 + "​action_on_one":​ "​update",​
 + "​action_on_multiple":​ "​error",​
 + "​delete_policy":​ "​update",​
 + "​delete_policy_update":​ "​status:​obsolete",​
 + "​delete_policy_retention":​ "​0",​
 + "​attribute_list":​ [
 + {
 + "​attcode":​ "​cis_list",​
 + "​update":​ "​0",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​row_separator":​ "​|",​
 + "​attribute_separator":​ ";",​
 + "​value_separator":​ ":",​
 + "​attribute_qualifier":​ "'",​
 + "​finalclass":​ "​SynchroAttLinkSet",​
 + "​friendlyname":​ "​cis_list"​
 + },
 + {
 + "​attcode":​ "​contracts_list",​
 + "​update":​ "​0",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​row_separator":​ "​|",​
 + "​attribute_separator":​ ";",​
 + "​value_separator":​ ":",​
 + "​attribute_qualifier":​ "'",​
 + "​finalclass":​ "​SynchroAttLinkSet",​
 + "​friendlyname":​ "​contracts_list"​
 + },
 + {
 + "​attcode":​ "​description",​
 + "​update":​ "​1",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​finalclass":​ "​SynchroAttribute",​
 + "​friendlyname":​ "​description"​
 + },
 + {
 + "​attcode":​ "​documenttype_id",​
 + "​update":​ "​1",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​reconciliation_attcode":​ "",​
 + "​finalclass":​ "​SynchroAttExtKey",​
 + "​friendlyname":​ "​documenttype_id"​
 + },
 + {
 + "​attcode":​ "​name",​
 + "​update":​ "​1",​
 + "​reconcile":​ "​1",​
 + "​update_policy":​ "​master_locked",​
 + "​finalclass":​ "​SynchroAttribute",​
 + "​friendlyname":​ "​name"​
 + },
 + {
 + "​attcode":​ "​org_id",​
 + "​update":​ "​1",​
 + "​reconcile":​ "​1",​
 + "​update_policy":​ "​master_locked",​
 + "​reconciliation_attcode":​ "",​
 + "​finalclass":​ "​SynchroAttExtKey",​
 + "​friendlyname":​ "​org_id"​
 + },
 + {
 + "​attcode":​ "​services_list",​
 + "​update":​ "​0",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​row_separator":​ "​|",​
 + "​attribute_separator":​ ";",​
 + "​value_separator":​ ":",​
 + "​attribute_qualifier":​ "'",​
 + "​finalclass":​ "​SynchroAttLinkSet",​
 + "​friendlyname":​ "​services_list"​
 + },
 + {
 + "​attcode":​ "​status",​
 + "​update":​ "​1",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​finalclass":​ "​SynchroAttribute",​
 + "​friendlyname":​ "​status"​
 + },
 + {
 + "​attcode":​ "​text",​
 + "​update":​ "​1",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​finalclass":​ "​SynchroAttribute",​
 + "​friendlyname":​ "​text"​
 + },
 + {
 + "​attcode":​ "​version",​
 + "​update":​ "​1",​
 + "​reconcile":​ "​0",​
 + "​update_policy":​ "​master_locked",​
 + "​finalclass":​ "​SynchroAttribute",​
 + "​friendlyname":​ "​version"​
 + }
 + ],
 + "​user_delete_policy":​ "​nobody",​
 + "​url_icon":​ "",​
 + "​url_application":​ ""​
 +}
 +</​code>​
extensions/sample-collector-sql.txt ยท Last modified: 2020/07/08 10:07 (external edit)

";