Thursday, 23 March 2017

XMD Edits in Wave Analytics

If you are looking to make changes on names and labels, you would need to go to the XMD file in wave in order to be able to make the change. Wave currently has a heroku app to access this with a User friendly UI.
The site can be accessed from the link below:
https://wave-labs.herokuapp.com/

  1. On logging on to this site, the first step is to choose the org type, Production or Sandbox. 
  2. Once done, Choose XMD, the JSON and SAQL are now available directly on the wave dashboard. 
  3. Choose XMD 
  4. Choose a Dataset to get started. 
  5. Sometimes it might take you back to the screen where the XMD is given, choose XMD again and then choose the dataset.
  6. Your values would be in dimension or measure, date fields would be in date, depending on the structure of your dataset.
  7. There are more options available such as derived dimensions, derived measures, organizations. You can add or remove any values on the XMD via the UI. 

Once done Click the save button on the top right so that it is reflected in your JSON file.

Thanks and Cheers! Let me know if you have any better ways to go about this or any questions, will try to reply asap.

Friday, 17 March 2017

Salesforce : Wave Analytics Bugs 101

The Trend in Wave feature happens to have a limit which is not defined anywhere. This limit seems to be 10. Even if you have stopped trending you would need to delete the dataset to be able to completely remove the trend from the pipe. If you look at the API and you edit, it is possible to delete datasets and the trending reports directly as the UI as of now happens to be really buggy as well.

So thats a heads up for the trending feature if you are planning to use it or suggest it to someone else.

Thursday, 23 February 2017

Magic of CliQ Data Loader

CliQ is a software hosted on google code Archive. It can be found at
https://code.google.com/archive/p/dataloadercliq/downloads

This is really helpful for loading and extracting data from salesforce. We can use this to load data from and to a staging table in an ETL tool. I use this in Talend as this helps in error logging which is not available with the standard salesforce component.

There is a dependency on Data Loader provided by salesforce for this.
Currently you need Apex Data Loader 36+ for Cliq 2.3 which is the last available version.
Its better not to use an older version as this is TLS 1.1 compatible which will be the standard in salesforce production orgs from next month.

Wednesday, 22 February 2017

Top 4 Data Integration Certifications to get in 2017

Lets get to the certifications I believe would be a game changer in 2017.


  1. Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
  1. Talend Data Integration v6 Certified Developer Exam 
  1. Boomi Integration Developer I & II (combined) Certification Exam
  1. PowerCenter Data Integration 10: Developer, Specialist Certification
(https://www.informatica.com/ca/services-and-training/certification/powercenter-data-integration-certification.html#fbid=mdJ-l6IzGWB)

This covers the following DI Tools: SSIS, Talend, Dell Boomi and Informatica Powercenter. 
It would be advised to be well versed in these before taking the exam. 

Talend 6.3 Salesforce Input Connector Issue

The Talend Standard salesforce input connector on 6.3 does not work. It throws Java error messages even if you just try to run a job with just the salesforce connector and the correct credentials. This is build error and we hope that the Talend team is able to address this issue and fix it.
The issue has been addressed on TalendForge, the official Talend Forum/Help for the on-premise/free version of Talend.

This is the exact error:
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.commons.lang3.reflect.TypeUtils.toString(Ljava/lang/reflect/Type)Ljava/lang/String;
at org.talend.daikon.properties.property.Property.<init>(Property.java:126)
at org.talend.daikon.properties.property.Property.<init>(Property.java:151)
at org.talend.daikon.properties.property.Property.<init>(Property.java:147)
at org.talend.daikon.properties.property.StringProperty.<init>(StringProperty.java:32)
at org.talend.daikon.properties.property.PropertyFactory.newString(PropertyFactory.java:35)
at org.talend.components.api.component.ComponentDefinition.<clinit>(ComponentDefinition.java:62)
at org.talend.components.api.component.AbstractComponentDefinition.<init>(AbstractComponentDefinition.java:44)
at org.talend.components.salesforce.SalesforceDefinition.<init>(SalesforceDefinition.java:26)
at org.talend.components.salesforce.tsalesforceinput.TSalesforceInputDefinition.<init>(TSalesforceInputDefinition.java:34)
https://www.talendforge.org/forum/viewtopic.php?pid=196591#p196591


This issue has not be resolved as of date.
Please leave comments below if you believe this has been resolved.

Tuesday, 21 February 2017

Wave Assignment Issues: Org Enablement

Issue:

Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Use Wave Analytics
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Manage Wave Analytics
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Edit Wave Analytics Dataflows
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Create and Edit Wave Analytics Dashboards
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Upload External Data to Wave Analytics
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Create Wave Analytics Apps
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Access Wave Analytics SAQL Editor (Pilot Feature)
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Trend Report Data in Wave Analytics
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: View Wave Analytics on Communities pages.
Can't assign permission set Wave Admin to user ETLHacks. The user license doesn't allow the permission: Download Wave Analytics Data

Solution: 

Go to the User and go to permission set license assignment and then assign the permissions for wave, sales cloud and service cloud, etc. Whatever is applicable in your case.
This would remove the above mentioned error messages.

Tuesday, 7 February 2017

Wave Series: Salesforce Analytics

Hi All,
I am writing a number of posts based on my learnings of Salesforce Analytics Cloud and specifically Wave Analytics.
I am compiling a series of Notes with the naming convention Wave 1__ for now. Hopefully more information on Wave comes out and I am able share more information with you all. Stay tuned and please subscribe and leave comments below for questions or feedback.
Thank you,
Cheers!