![]() In below example we will see loading data into SQL Server database but steps may remain same for other targets which can be accessed using OLEDB Drivers (e.g. Now let's look at how to load data into target like SQL Server, Oracle or Flat File. Drag ZS REST API Task from Control Flow SSIS Toolbox as below.Open SSIS Package and go to SSIS Designer (Control Flow).In the next section we will see how to load data in SQL Server. We will use ZappySys REST API Task to make simple API call. Once you create Zoho OAuth App now its time to call some Zoho API. Register Zoho OAuth App and get ClientID/ Secret (*** MUST READ ***)Ĭheck this article to register your OAuth App and obtain Client ID /Client Secret Create Zoho OAuth Connection in SSIS (for API call) Zoho may discontinue Token based method in future. If you must use static token-method then check next section. OAuth approach is more secure an recommended. It uses OAuth 2.0 instead of static Token based (described in the next section). Optional (If you want to Deploy and Schedule ) - Deploy and Schedule SSIS PackagesĪuthentication Using Zoho V2 REST API (OAuth 2.0).Make sure ZappySys SSIS PowerPack is installed ( download it).Basic knowledge of SSIS package development using Microsoft SQL Server Integration Services.SSIS designer installed. Sometimes it is referred as BIDS or SSDT ( download it from Microsoft site).Now let’s look at step-by-step approach to call Zoho API using SSIS.īefore we perform steps listed in this article, you will need to make sure following prerequisites are met: In the next section, we will look at Write scenario too. Leads, Accounts, Contacts) and load into SQL Server Database Table. We will look at step-by-step instructions to read Zoho CRM data (e.g. We will use SSIS JSON/ REST API Source to extract data from Zoho API and use SSIS Web API Destination to write data to Zoho. In this post, you will learn how to read / write Zoho CRM data using SSIS (Drag and drop approach without any coding). Please visit this page to see all Pre-Configured ready to use API connectors which you can use in SSIS API Source / SSIS API Destination OR API ODBC Driver (for non-SSIS Apps such as Excel, Power BI, Informatica). You can still use steps from this article but if you are new to API or want to avoid learning curve with API then use newer approach. UPDATE: ZappySys has released a brand new API Connector for Zoho CRM Online which makes it much simpler to Read/Write Zoho CRM Data in SSIS compared to the steps listed in this article.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |