function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
aklkkaklkk 

how to get the data from Neteeza to salesfroce ?

hi all ,

Please support me how to get the data from Neteeza  to salesfroce ? 


Thanks 
aklkk
Mohan ChanderMohan Chander

Hi Aklkk,

There are options as to how you can load data into salesforce but depends on your requirement. 

1) do you want the data to persist in Salesforce ?

2) What is the data size ?

3) what is the future road map i.e how to do you want to keep the data in sync or other considerations.

 

if you want to data in Netezza and access a record on demand
------------------------------------------------------------------------------------

You go with Salesforce Connect where you can integrate external database with Salesforce. You can view, create, update records of other databases.

 

if you want a real time synchronous integration 
--------------------------------------------------------------
You want the data in salesforce and keep the sync with external database you can go with the standard REST API's. These deal with single record.

 

if you have a one time data load/ scheduled data Loads
---------------------------------------------------------------------------
one time dataload - use dataloader

Scheduled loads - leverage the Bulk API's for records ranging from 1000's to millions. There are many ETL's that are available in the market. You can pick and choose the ETL tool as per your budget and requirement.

Let me know if this helps

Regards,
Mohan

Shalika PabrejaShalika Pabreja
Hi Mohan,

I have a similar requirement in salesforce project. In our proect, we'll get data from Netezza and it will get weekly refresh.
This data needs to be acccessed via salesforce app/web page we have created. What are the best possible solution?