Tools to help load data into Salesforce.com Analytics Cloud
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.