+ Start a Discussion
Vishakha Tyagi 2Vishakha Tyagi 2 

How to pull data into Salesforce from data warehouse without API

Hi, I want to pull actual revenue into our Salesforce org from our company's Data warehouse, but we don't have an API to call. What can be the other ways to achieve this.
Andrew GAndrew G
Can your data warehouse produce CSV files on a schedule?
If so, 
1. Schedule Data export of CSV to a "shared location"
2. Install Data Loader CLI 
3. Create mapping files for DataLoader CLI
4. Created batch files for DataLoader CLI uploads 
5. Create scheduled Windows tasks.

A reference https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/using_the_command_line_interface.htm

be wary - i recommend having the logging turned on - but have a batch file to delete any log file over 2 weeks old (or whatever limit you think) - they consume disk space which can cause the Windows process to hang.  Also set up email alerts for failures.

Regards
Andrew
Andrew GAndrew G
I would read the help files located in the link I previously supplied.  
Once you have completed those steps, provide a more precise example of what is not working.  The entire process is a little convoluted, so the failure point could be in many places.

Andrew
akshay khannaakshay khanna

1. Schedule Data export of CSV to a "shared location"
2. Install Data Loader CLI 
3. Create mapping files for DataLoader CLI
4. Created batch files for DataLoader CLI uploads 
5. Create scheduled Windows tasks.

Hello andrew sir the steps you have mentioned are not working for me.
_______________________________________________________________
Best Washing machine in india (https://washingradar.com/best-washing-machine/)