Need a database built in heroku postgress for my ruby app. Currently my data is stored in [url removed, login to view] and I want to remake the a portion of the schema in postgress. I have all the objects and fields created already and will simply you with exactly what needs to be made.
Also, need to create a script that grabs the data from salesforce via bulk api and loads it in to the postgress database on-demand or on a scheduled basis. Here is information on API, [url removed, login to view] . There is also a bulk API gem in ruby if that's the language this is built in.
Full Access to salesforce schema will be provided to the winner. Need job started ASAP.