Tools to help load data into Salesforce.com Analytics Cloud
Salesforce.com Wave Data Loader
Tools to help load data into Salesforce.com Wave
First, you will need to set your SFDC credencials via environment variables:
export SFDC_USERNAMEemail@example.com export SFDC_PASSWORD=yourpassword export SFDC_TOKEN=yourtoken
More information about getting your [Security Token](https://help.salesforce.com/apex/HTViewHelpDoc?id=user_security_token.htm)
The quickest way to get started is to load an entire table into Salesforce Wave
pyac-table postgres://username:firstname.lastname@example.org/database table_name
This command will execute the following three step process.
- generate a JSON file containing metadata describing your data
- generate a CSV file with your data
- upload the metadata and data to Analytics Cloud
pyAnalyticsCloud also provides commands help with each step, this allows you to customize your data before upload:
pyac-metadata postgres://username:email@example.com/database table_name -o metadata.json pyac-dump postgres://username:firstname.lastname@example.org/database table_name -o data.csv pyac-upload metadata.json data.csv
Rather than manually editing the datafiles, you may want to simply create a new DB table that is populated with your data and use pyac-table.
If you want to develop more advanced workflows you can use pyAnalyticsCloud as a library for a Python application.