I gather that with Wave Analytics we can import data from external sources (data that lives outside Salesforce, e.g. SQL Server). Just wondering when we import the data into Wave as datasets is there any additional cost associated with storing that data in salesforce?
Thanks
Both Assumptions are correct.
Following connections are possible with Wave to import data in Salesforce :
Regarding point #2, We tried linked custom object with Account but still not able to see those object in Analytics data set. So, this point needs to be confirmed practically. Demo videos show custom object are supported.
As you mentioned, you can use the union in SAQL as well. Here is the link to documentation, but it's quite weak. I tackled the same issue last week and here is my solution:
q = load "Dataset_1";
q = group q by 'Year__c';
q = foreach q generate 'Year__c' as 'Year__c', "Dataset_1" as 'Status', sum('Number__c') as 'Number__c';
r = load "Dataste_2";
r = foreach r generate 'Year__c' as 'Year__c', "Dataste_2" as 'Status', sum('Number__c') as 'Number__c';
result = union q, r;
result = group result by ('Year__c', 'Status');
result = foreach result generate 'Year__c' as 'Year__c', 'Status' as 'Status', sum('Number__c') as 'Number__c';
result = order result by 'Year__c' desc;
First, the dimensions by which you want to join those datasets have to have same name (at least I couldn't make it work otherwise). Then the next step is to load those datasets, foreach for both and then use a union, where you group by those same dimensions. Group_1 is the
This is how the output looks like in my case:
In Dataset_2 I have data only for Year__c 2017
Hope this helps. I'm also new to Analytics so maybe I could have done something better. Feel free to correct me.
Also, you can give it a try with cogroup but I couldn't make it work.
Best Answer
no, there isn't any additional cost when you are importing data from external sources. I don't think u can import from SQl server. Below are the sources I see(at least in my org).
Note that it is a painful time taking process to import data into salesforce. Also, the data needs to be cleansed at source level before uploading as you don't many options in Wave (right now).
Also if you are importing data from csv file, there is a limit of 500Mb.