Tools to help load data into Salesforce.com Wave
First, you will need to set your SFDC credencials via environment variables::
export SFDC_USERNAME=youruser@example.com
export SFDC_PASSWORD=yourpassword
export SFDC_TOKEN=yourtoken
More information about getting your Security Token
The quickest way to get started is to load an entire table into Salesforce Wave
pyac-table postgres://username:password@db.example.com/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:password@db.example.com/database table_name -o metadata.json
pyac-dump postgres://username:password@db.example.com/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.