Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Use the CData Software ODBC Driver for MarkLogic in SAS for Real-Time Reporting and Analytics

Connect to real-time MarkLogic in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MarkLogic.
How to Seamlessly Import Bing Ads Data into IBM SPSS Modeler

Integrate Bing Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
Migrating data from Trello to Databricks using CData SSIS Components.

Easily push Trello to Databricks using the CData SSIS Tasks for Trello and Databricks.
Use the CData Software ODBC Driver for Bing Ads in MicroStrategy

Connect to Bing Ads in MicroStrategy Developer using the CData Software ODBC Driver for Bing Ads.
Automated Continuous Stripe Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Stripe replication to AlloyDB.
Create SSAS Tabular Models from SuiteCRM

How to build a SQL Server Analysis Service Tabular Model from SuiteCRM using CData drivers.
Analyze SAP HANA in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of SAP HANA and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
Choosing the Best Method to Connect Kafka to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Apache Kafka from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
Rapidly Develop Excel-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
How to Access Xero Using Entity Framework

This article shows how to access Xero Accounting using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
Integrate with FHIR using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy FHIR to a JSON file on disk.
Connect to Procore in Google Apps Script via SQL Gateway

Use the ODBC Driver for Procore and the SQL Gateway to access Procore from Google Apps Script.
How to connect PolyBase to Sage 50 UK

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage 50 UK.
Seamlessly Bring PCA Sales into Retool Using CData Connect Cloud

Integrate PCA Sales data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
Create Power BI Reports on Real-Time Airtable

Use the CData ODBC Driver for Airtable to visualize Airtable in Power BI Desktop.
Automated Continuous SharePoint Excel Services Replication to Databricks

Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Databricks.
How to pipe Google Ad Manager to CSV in PowerShell

Use standard PowerShell cmdlets to access Google Ad Manager tables.
How to pipe Google Spanner to CSV in PowerShell

Use standard PowerShell cmdlets to access Google Spanner tables.
ETL SAP Netweaver Gateway in Oracle Data Integrator

This article shows how to transfer SAP Netweaver Gateway into a data warehouse using Oracle Data Integrator.
Object-Relational Mapping (ORM) with Procore Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Procore into a Java-based ORM framework, Hibernate.
Integrate with BigQuery in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Google BigQuery in SnapLogic.
Use the CData Software ODBC Driver for Square in SAS for Real-Time Reporting and Analytics

Connect to real-time Square in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Square.
Access SAP in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAP ERP/NetWeaver.
DataBind Controls to Calendly in C++Builder

DataBind to Calendly in C++Builder with standard components and controls.
Access Live Reckon in Excel 365 Online (Excel for the web)

Connect to Reckon from Excel 365 Online (Excel for the web) with CData Connect Cloud.
Import ADP into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to ADP and provide access to live ADP for custom reports in the Power BI Service.
Build Semantic Layer Views for Facebook in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Facebook.
Automated Continuous Google Campaign Manager 360 Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Google BigQuery.
How to Use a Microsoft Access Database to Update SAS Data Sets in Real Time

Update SAS Data Sets data by creating a linked table in Microsoft Access with the CData SAS Data Sets ODBC Driver.
Build Automated SAP Hybris C4C-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live SAP Hybris C4C and build automated workflows in Zapier.
Import and Visualize Basecamp in Power View

Create data visualizations based on Basecamp in Excel.
Connect to Jira as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Atlassian Jira.
Validate Monday.com with QuerySurge

Access and validate Monday.com in QuerySurge using the CData JDBC Driver.
Build Apps with Live LinkedIn in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live LinkedIn into the Adalo platform and build custom mobile and web applications with real-time LinkedIn.
LINQ to Zoom

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zoom Data Provider.
ETL GraphQL in Oracle Data Integrator

This article shows how to transfer GraphQL into a data warehouse using Oracle Data Integrator.
Choosing the Best Method to Connect HBase to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Apache HBase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
How to integrate AlloyDB with Apache Airflow

Access and process Google AlloyDB in Apache Airflow using the CData JDBC Driver.
How to connect to Hive from IntelliJ

Integrate connectivity to Apache Hive with wizards in IntelliJ.
Connect to Freshdesk from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Freshdesk, and over 250 other data sources, right inside your Excel and Google spreadsheets!
Create SSAS Tabular Models from Oracle

How to build a SQL Server Analysis Service Tabular Model from Oracle Database using CData drivers.
Consume CockroachDB OData Feeds in PowerBuilder

This article demonstrates how to consume CockroachDB as OData feeds from PowerBuilder using the API Server.
Connect to ShipStation in DBArtisan

Use wizards in DBArtisan to configure ShipStation as a data source.
Automated ServiceNow Replication to Teradata

Use CData Sync to Customize and automate ServiceNow replication to Teradata.
How to use SQLAlchemy ORM to access Shopify in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shopify.
How to create SAP ByDesign federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Business ByDesign in MySQL .
Connect to SAP Netweaver Gateway in SpagoBI

Create reports featuring live SAP Netweaver Gateway in SpagoBI Studio. Host SAP Netweaver Gateway reports on SpagoBI Server.
Automate Outreach.io Replication to Azure Data Lake

Use CData Sync to customize and automate Outreach.io replication to Azure Data Lake.
Connect to Microsoft OneDrive in the Denodo Platform

Use CData driver technologies to create a virtual data source for Microsoft OneDrive in the Denodo Virtual DataPort Administrator.
Build Dashboards with Adobe Analytics in DBxtra

Create dynamic dashboards and perform analytics based on Adobe Analytics in DBxtra.
Automated Continuous CouchDB Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable CouchDB replication to Google Cloud SQL.
Build Dynamics NAV-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Dynamics NAV.
Integrate Live Salesforce Marketing into Blue Prism for Intelligent Robotic Process Automation (RPA)