Apex Code Development You need to sign in to do that
Don't have an account?
Vinothini Rajan Which is the best and cost effective external Database to store Salesforce data
Hi All,
Currenty our data storage limit exceeded and looking for an option to storage some data outside salesforce and only read/display them in SF. Would like to know various options/suggestions from you.
Thank you!!
Currenty our data storage limit exceeded and looking for an option to storage some data outside salesforce and only read/display them in SF. Would like to know various options/suggestions from you.
Thank you!!
There are several databases offered which you can check on https://www3.technologyevaluation.com/sd/category/database. Since you know your org's capabilities and compatibility with multiple systems better than anyone, you would be the best person to decide what suits your need. Once decided, you can consider using external objects
External data sources have associated external objects, which your users and the Lightning platform use to interact with the external data and content. External Objects: are similar to custom objects in salesforce, But external object record data is stored outside your salesforce Organization.
Also recommend review the data management strategies listed in https://www.salesforce.org/blog/ask-an-architect-5-steps-to-an-effective-salesforce-data-management-strategy/
If this information helps, please mark the answer as best.Thank you
HI Vinothini,
There are various databases offered in the industry like you can integrate Salesforce with Google and store your data in google drive.
thanks
There are a few information bases offered which you can keep an eye on https://www3.technologyevaluation.com/sd/class/data set. Since you know your organization's abilities and similarity with numerous frameworks better than anybody, you would be the best individual to choose what suits your need. When concluded, you can think about utilizing outside objects (https://completedraincare.co.uk/)
Outside information sources have related outer items, which your clients and the Lightning stage use to cooperate with the outside information and substance. Outer Objects: are like custom articles in salesforce, But outside object record information is put away outside your salesforce Organization.
I would add some further considerations on the database to use with external objects.
To deliver a good read/display user experience you need to consider the external db's query performance.
The main factors that will affect this:
- How big is the data?
- How many concurrent CRM users will access the data?
- How will the db handle surges in demand?
Process wise, consider how easily you can move data to the external db, and how easily you can connect back to it using SF Connect.Our company has an AppExchange product that connects to cloud data warehouses.
In our opinion, the leading technologies for the Salesforce Connect/external objects use case are Snowflake, Google BigQuery and Rockset.
Each have specific strengths in performance, scalability and are well supported by tools to replicate data out of Salesforce.
There is a more detailed write up on our blog https://omnata.com/blog/the-best-external-database-for-salesforce-connect
Try Skivia app. It can sync Cloud and Database Data. Read more here (https://skyvia.com/data-integration/replicate-salesforce-to-google-bigquery)