We need to intergrate couple of objects from oracle to salesforce on a daily basis. To acheive this , we need to integrate salesforce and oracle - then read data from two tables in oracle. Does anyone have experience in this ?
We wish to know about some tool that facilitates automatic data import/export between SFDC database and SQL database on a button click. Please let us know of any such tool available.
Generally using salesforce reports we click the export deatils button to download the csv file. But our company needs to automate the process and send the CSV file from report over to tableau external platform .
Can we leverage Analytics rest api on this one.
Thanks in advance for the help.
How would you import csv files into Salesforce from an external source that are kept on a FTP server?"
I am wondering is it possible to push information straight from salesforce to an external system. For example pull information from Salesforce using DBamp at the moment which is then sent to out payroll system. I am looking for alternatives to DBamp and what are other companies using to do this?
I've been trying to set up a data sync job between Salesforce and a MySQL database hosted on Amazon's RDS using Talend, but I've been running into some issues.
I just want to check - is this supported/approved? Or is there a silient block in place to make this impossible?
I have one .csv file on Server, which has few fields. I simply want to insert that .csv file data to SFDc twice in a week.
Please let me know how can i achieve this functionality. And that is ofcourse should be very practical.
I'm trying to use the Data Loader to extract data from SalesForce and insert it into a MySql table. The DataLoader.jar has the drivers for oracle, so what's the best way of getting it to load in the mysql drivers? I can manually force the drivers into the jar file, but that doesn't seem to be the best idea. I can modify the process.bat to include the drivers in the classpath. Is there a best practice for this?