Introduction In our previous article, we saw How to Get Office 365 data in Power BI. Now let’s look at How to Get Office 365 Mail Attachments using SSIS without any coding. Microsoft Graph API is a unified way to access many Microsoft services API including Office 365 API. In this post, we will use SSIS JSON / […]
Introduction In this article, we will get Office 365 data in Power BI using Microsoft Graph API and ODBC drivers. Specifically, we will get Excel file data in OneDrive, events from a Calendar and finally, a list in a note in OneNote and then load that data into a Power BI report. We will achieve […]
Introduction In our previous article, we talked about how to read from Dynamics CRM. Now let’s look at how to Load data into Dynamics CRM using SSIS. We will see a few important aspects of loading data into Dynamics CRM Online (i.e. Dynamics 365) and On-premises / IFD (Internet facing hosted instance). We will show you how to […]
Introduction Today Microsoft Dynamics CRM is one of the most popular CRMs in the world. SSIS Dynamics CRM read operation can be achieved using Dynamics CRM Source Connector. It allows connecting to Dynamics CRM 365 Online or On-Premises Installation / Hosted CRM instance (IFD – internet facing deployment). You can read data from Dynamics CRM […]
Introduction In this post you will learn how to access Microsoft Graph API (Office 365 REST API / Sharepoint API) inside SSIS without any coding. Microsoft Graph API is a unified way to access many Microsoft services API including Office 365 API. In this post we will use SSIS JSON / REST API Source Connector to […]