Sales force updating databases

So for example, every time you get a new account created the API will push a notification about the event to your desired service.This is an extremely powerful mechanism that can guarantee almost real-time updates on a Data Warehouse repository.At this post, we’ll focus only on Salesforce CRM, which again exposes a large number of APIs.

sales force updating databases-55

Another interesting way of interacting with Sales Force is through the Streaming API.With it you define queries and every time something changes to the data that register to this query you get notifications.With Snowflake, is possible to load directly data in JSON, Avro, ORC, Parquet, or XML format.Hierarchical data is treated as a first class citizen, similar to what Google Big Query offers.Alternatively, you may checkout Blendo to load your data from Salesforce to Snowflake in minutes for you, so you can focus on what really matters, which is how to extract more value from your data.

You can’t use a Data Warehouse without data, so the first and most important step is to extract the data you want from Salesforce.For example, the following curl command will return the name fields of accounts: Again, the result can be either in JSON or XML serialization.We would recommend using JSON as it will make the whole data moving process easier because the most popular data warehousing solutions natively support it.If for any reason you would prefer to use SOAP, then you should create a SOAP client first, you can, for example, use the Web Service Connector (WSC) client.Or create your own using the WSDL using the information provided by this guide.Snowflake has a great tutorial on the different ways of handling updates, especially using primary keys.