Skip to content

Instantly share code, notes, and snippets.

@cvengros
Last active August 29, 2015 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cvengros/94719200f17c6f44ab2d to your computer and use it in GitHub Desktop.
Save cvengros/94719200f17c6f44ab2d to your computer and use it in GitHub Desktop.
Typical setup for the salesapp_sfdc_to_dss brick
{
"salesforce_username": "customer@theircompany.com",
"salesforce_password": "theirpassword",
"salesforce_token": "theirtoken",
"salesforce_client_id": "sfdc oauth app id",
"salesforce_client_secret": "sfdc oauth app secret",
"dss_jdbc_url": "jdbc:dss://secure.gooddata.com/gdc/dss/instances/something",
"dss_GDC_USERNAME": "you@gooddata.com",
"dss_GDC_PASSWORD": "yourpassword",
"dss_name_prefix": "sfdc",
"skip_backup": true,
"salesforce_single_batch": false,
"salesforce_objects": ["Account", "Event", "OpportunityLineItem", "Opportunity", "User", "PricebookEntry", "Product2", "OpportunityStage", "Task", "OpportunityHistory"],
"dss_historized_objects": {
"Opportunity": {
"load_history_from": {
"name": "OpportunityHistory",
"column_mapping": {
"Id": "OpportunityId",
"_VALID_FROM": "SystemModstamp",
"CreatedDate": null,
"CreatedById": null,
"IsDeleted": null
}
},
"merge_from": {
"name": "Opportunity",
"column_mapping": {
"_VALID_FROM": "_LOAD_AT"
}
}
},
"OpportunityLineItem": {
"merge_from": {
"name": "OpportunityLineItem",
"column_mapping": {
"_VALID_FROM": "_LOAD_AT"
}
}
},
"PricebookEntry": {
"merge_from": {
"name": "PricebookEntry",
"column_mapping": {
"_VALID_FROM": "_LOAD_AT"
}
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment