🚫 This project is no longer maintained as of March 12, 2016. Please try the new version of lookml-for-salesforce-and-dashdb at https://github.com/ibm-cds-labs/lookml-for-salesforce-and-dashdb
looker-for-pipes is a set of LookML files for use with the Simple Data Pipe example app that deploys to the IBM Bluemix platform service. The Simple Data Pipe easily moves data from different online sources into IBM’s cloud data warehouse service, dashDB. With data consolidated in dashDB, users can hook up their own analytics tools.
LookML is a data modeling language for the Looker business intelligence platform. With LookML, BI analysts can describe their data and apply business rules in a higher-level language that Looker converts down to SQL. It hooks right into your warehouse and is great at powering Web dashboards and data exploration.
Below, you’ll find a set of files that deals with Salesforce.com (SFDC) data. We’ve written all the LookML for you, and we designed it to solve some of the most common analytics and reporting tasks when warehousing SFDC data. Independent of the data pipe application, Looker customers can use this LookML in their own projects.
- A Looker instance or free trial account
- Access to a SFDC account with admin permissions
- A data movement/ETL tool
- A database (or warehouse) loaded with data
- Optional: If you plan to deploy our Simple Data Pipe application, sign up for an IBM Bluemix account (30-day free trial). See our tutorial for instructions on deploying.
- Fork this repository into your own GitHub account.
- If you customize your LookML to handle proprietary information, you should consider purchasing a private GitHub repository.
- Install LookML for Salesforce data.
- Create a Looker database connection. (Looker docs.)
- Create a new Looker project. (Looker docs.)
- Configure Git for your project to connect to your looker-for-pipes fork. (Looker forum.)
- (Our tutorial steps through this process, with the database connection configured for dashDB.)
- View your data
- Access the SFDC dashboard by selecting Spaces / LookML Dashboards.
- Or Explore your data, where your can add or subtract dimensions and measures.
| Type | File Name | Description |
|---|---|---|
| Dashboard | salesforce.dashboard.lookml | LookML file that powers our SFDC dashboard |
| Model | salesforce.model.lookml | LookML file that transforms the SFDC data extracted from your database, to be loaded into Looker Views |
| View | account.view.lookml | Describes sf_account table; used in the Looker model |
| View | campaign.view.lookml | Describes sf_campaign table; used in the Looker model |
| View | campaignmember.view.lookml | Describes sf_campaignmember table; used in the Looker model |
| View | contact.view.lookml | Describes sf_contact table; used in the Looker model |
| View | lead.view.lookml | Describes sf_lead table; used in the Looker model |
| View | opportunity.view.lookml | Describes sf_opportunity table; used in the Looker model |
If you have any questions about the technical implementation of Simple Data Pipe or IBM dashDB, ask us on stackoverflow using #SimpleDataPipe
Should you choose to deploy the Simple Data Pipe sample web application, be aware that it includes code to track deployments to Bluemix and other Cloud Foundry platforms. The following information is sent to a Deployment Tracker service on each deployment:
- Application Name (
application_name) - Space ID (
space_id) - Application Version (
application_version) - Application URIs (
application_uris)
This data is collected from the VCAP_APPLICATION environment variable in IBM Bluemix and other Cloud Foundry platforms. This data is used by IBM to track metrics around deployments of sample applications to IBM Bluemix. Only deployments of sample applications that include code to ping the Deployment Tracker service will be tracked.
looker-for-pipes is sample code created for the purpose of demonstrating an IBM Bluemix example application. The code is provided as-is with no warranties of any kind, express or implied.