Geeks 4 Data

  🧩 Using OIC3 To Integrate Azure Blob Storage and On-Premises Files - Part 2 A brief guide to integrating on-premises files and Azure Storage using OIC3 🧭 Overview We have multiple on-premises servers hosting file shares, used for integrating data between systems. We also have Azure storage, both our own and third-party storage, also used for integrating file based data. We now have a Oracle cloud based solution which uses Oracle Integration Cloud version 3 (OIC3) to import and export data. We would like to leverage our investment in Oracle to integrate our data between our file systems and Azure storage. This second part will explain how to move files from an Azure Blob Container to an on-premises folder. 📌 What This Post Covers ✅ Configuring an on-premises file connection from OIC3 ✅ Configuring an Azure Blob Storage connection from OIC3 ✅ Configuring a REST connection to access the Azure Storage API from OIC3 ✅ Managing REST data using the XML datatype in SQL Server ✅ Utiliz...

  🧩 Using OIC3 To Integrate Azure Blob Storage and On-Premises Files - Part 1 A brief guide to integrating on-premises files and Azure Storage using OIC3 🧭 Overview We have multiple on-premises servers hosting file shares, used for integrating data between systems. We also have Azure storage, both our own and third-party storage, also used for integrating file based data. We now have a Oracle cloud based solution which uses Oracle Integration Cloud version 3 (OIC3) to import and export data. We would like to leverage our investment in Oracle to integrate our data between our file systems and Azure storage. This first part will explain how to move files from an on-premises folder to an Azure Blob Container. 📌 What This Post Covers ✅ Configuring an on-premises file connection from OIC3 ✅ Configuring an Azure Blob Storage connection from OIC3 ✅ Utilizing those connections to read and write data ✅ Managing data using the XML datatype in SQL Server ⚠️ Configuring an on-premises Oracl...

  🧩 Accessing API Data In Power BI - Part 1 A step-by-step guide to getting data from web APIs. 🧭 Overview Power BI is great for analyzing information from data sources such as SQL Server databases where the information is held together in a single, easily accessed, secure source. However, it can also be great for analyzing data information from web based systems which often have more complex security configurations and limitations on how much data can be accessed in a single query. This series of articles will give step-by-step instructions about how to access web based information, gradually building on more and more complex scenarios until you have a complete picture of how to manage data from web based services. This guide will assume you have access to Concepts The first concept to grasp is, what is an API? API stands for Application Programming Interface. As the name suggests, they are designed to provide a standard interface to a the underlying data within a service so tha...