Can someone please tell me who exactly is an Analytics cloud integration user and what is the role of such an user ?
[SalesForce] Analytics cloud integration user
Related Solutions
This functionality is available in the Summer 15 release
http://releasenotes.docs.salesforce.com/en-us/summer15/release-notes/rn_bi_dataset_delete.htm
I was experiencing the same issue on our org. I reset the ELT script back to a default version without builder input, ran the Data flow Manually, it was successful. I then added some extra objects and various fields to the ELT Data flow via the dataset builder and the flow was successful again.
Below is my "default" version of a ELT JSON, This should work with all orgs:
{ "100": { "action": "sfdcDigest", "parameters": { "object": "Account", "fields": [ { "name": "Description" }, { "name": "Fax" }, { "name": "Id" }, { "name": "Name" }, { "name": "Phone" }, { "name": "AccountSource" }, { "name": "Type" }, { "name": "AnnualRevenue" }, { "name": "BillingCity" }, { "name": "BillingCountry" }, { "name": "BillingLatitude" }, { "name": "BillingLongitude" }, { "name": "BillingState" }, { "name": "BillingStreet" }, { "name": "BillingPostalCode" }, { "name": "CreatedDate" }, { "name": "Jigsaw" }, { "name": "IsDeleted" }, { "name": "NumberOfEmployees" }, { "name": "Industry" }, { "name": "JigsawCompanyId" }, { "name": "LastActivityDate" }, { "name": "LastModifiedDate" }, { "name": "LastReferencedDate" }, { "name": "LastViewedDate" }, { "name": "PhotoUrl" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingLatitude" }, { "name": "ShippingLongitude" }, { "name": "ShippingState" }, { "name": "ShippingStreet" }, { "name": "ShippingPostalCode" }, { "name": "SicDesc" }, { "name": "SystemModstamp" }, { "name": "Website" } ] } }, "101": { "action": "sfdcDigest", "parameters": { "object": "Account", "fields": [ { "name": "Name" }, { "name": "BillingCity" } ] } }, "102": { "action": "sfdcRegister", "parameters": { "source": "101", "alias": "test2", "name": "test" } } }
Best Answer
The Analytics Cloud Integration User is a default user that gets created when Wave/Analytics Cloud is enabled in an org. Like Daniel mentioned, this is the "user" that accesses the data within SFDC when the Dataflow is used to bring data in as datasets to Wave. It's important that this user has the proper level of permissions to access the data you're trying to pull from the org to Wave. For example, the integration user needs have object level access to all the objects from which data you want to pull, and field level access to the fields within those objects.