After configuring PolyBase, you can load data directly into your SQL Data Warehouse by simply creating an external table that points to your data in storage and then mapping that data to a new table within SQL Data Warehouse. PolyBase’s ability to transparently parallelize loads from Azure Blob Storage will make it the fastest tool for loading data. In summary, the required steps to do it are the following: To do that you should follow the directions in the Load with PolyBase documentation. When you are done putting your data into Azure Blobs you are ready to load it into SQL Data Warehouse using PolyBase. It’s easy to get a list of all the resource we have access to, for example using CURL we can execute the following: After you successfully authenticate with the REST API, you have to start interacting with its resources and fetching data to load them into your data warehouse. The SalesforceREST API supports OAuth 2.0 authentication, more information can be found in the Understanding Authentication article. Interacting with the REST API can be done by using tools like CURL or Postman by using HTTP clients for your favorite language or framework. The REST API and the SOAP API are exposing the same functionalities but using different protocols. More specifically, and as it can be found at this excellent post from their Helpdesk about which API to use, we have the following options:įrom the above list, the complexity and feature richness of the Salesforce API is more than evident. In this post, we’ll focus only on Salesforce CRM, which again exposes a large number of APIs to the world. This means that it offers a plethora of APIs to access the services and the underlying data. Salesforce has many products, and it’s also a pioneer in cloud computing and the API economy. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |