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.
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?
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
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?