Posibility of upload an Oracle database using Data Loader CLIq

[antonio...@accenture.com]

Hello all.

I have seen your demo in YouTube (very useful thank you!!!!). Do you
have developed a similar CLIq to populate data directly from
Salesforce to a local database (Oracle) in one shot directly?. Is it
possible to do it?.

Regards.

[theswami]

CLIq does not configure database connections for you, but you can
configure it yourself after using CLIq to get started.

1. Use CLIq to configure an "Export" operation.
2. Look at the documentation to configure the database insert:
- https://na1.salesforce.com/help/doc/en/salesforce_data_loader.pdf
- page 31
- For MySQL this is an insert (to salesforce) example -
http://code.google.com/p/dataloadercliq/wiki/CLIqWithMySQL

You will need to edit the process-conf.xml and database-conf.xml
files.

Vijay

On Dec 7, 9:29 am, "antonio.esp...@accenture.com"

[sankalp Jhingran]

Hi Antonio,

You can use command line data loader to upload data from salesforce to oracle directly. You need to modify database-conf.xml file to include the DSN connection name or JDBC Driver.

Visit this link: http://code.google.com/p/dataloadercliq/wiki/CLIqWithMySQL

Here one from my blog: http://forcesecrets.blogspot.com/2011/12/ending-your-search-for-using-command.html

Regards,

Sankalp

--
Thanks & Regards,
Sankalp Jhingran
HCL Technologies
Maple Towers, Sec-125, Noida - 201 301
Mob:  +91-9811520633

======================================================
"I will not say I failed 1000 times, I will say that I discovered there are 1000 ways that cause failure."

[theswami]

Thanks, Sankalp.
That is a good writeup.

On Dec 7, 7:51 pm, sankalp Jhingran <sankalp.jhing...@gmail.com>
wrote:

> Hi Antonio,
>
> You can use command line data loader to upload data from salesforce to
> oracle directly. You need to modify database-conf.xml file to include the
> DSN connection name or JDBC Driver.
>
> Visit this link:http://code.google.com/p/dataloadercliq/wiki/CLIqWithMySQL

> Here one from my blog:http://forcesecrets.blogspot.com/2011/12/ending-your-search-for-using...
>
> Regards,
> Sankalp
>
> On Wed, Dec 7, 2011 at 10:59 PM, antonio.esp...@accenture.com <

>
> antonio.esp...@accenture.com> wrote:
> > Hello all.
>
> > I have seen your demo in YouTube (very useful thank you!!!!). Do you
> > have developed a similar CLIq to populate data directly from
> > Salesforce to a local database (Oracle) in one shot directly?. Is it
> > possible to do it?.
>
> > Regards.
>
> --

> *Thanks & Regards,*

> Sankalp Jhingran
> HCL Technologies
> Maple Towers, Sec-125, Noida - 201 301

> *Mob: * +91-9811520633

[antonio...@accenture.com]

Thanks for the information. I´ll have a look and let you know.

 

Regards.

---

Subject to local law, communications with Accenture and its affiliates including telephone calls and emails (including content), may be monitored by our systems for the purposes of security and the assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com