Skip to main content

Tools to help load data into Salesforce.com Wave

Project description

Tools to help load data into Salesforce.com Wave

Usage

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](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:password@db.example.com/database table_name

This command will execute the following three step process.

  1. generate a JSON file containing metadata describing your data

  2. generate a CSV file with your data

  3. 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.

Library

If you want to develop more advanced workflows you can use pyAnalyticsCloud as a library for a Python application.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyAnalyticsCloud-0.7.0.tar.gz (13.3 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page