CData Software - Knowledge Base
Recent Articles
-
Create Google Campaign Manager 360-Connected Business Apps in AppSheet
Connect to Google Campaign Manager 360 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Campaign Manager 360.
-
Getting Started with the CData JDBC Driver for Box
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Box.
-
Automated Continuous Google Contacts Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Contacts replication to delimited files (CSV/TSV).
-
Build Semantic Layer Views for Printify Data in APOS Live Data Gateway
Use the CData Connector for Printify in APOS Live Data Gateway to build Semantic Layer Views for Printify.
-
AfterShip Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on AfterShip facts in real time.
-
Enable the Qualaroo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Qualaroo.
-
Integrating Cursor CLI with Optimizely Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Process & Analyze Impala Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Impala Data.
-
Getting Started with the CData Tableau Connector for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Creator.
-
Connect to SAP Netweaver Gateway Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Netweaver Gateway as an External Source in Dremio.
-
Connect to Real-Time AdRoll Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AdRoll in Power Apps.
-
Build an OLAP Cube in SSAS from SageHR Data
Establish a connection to SageHR data from SQL Server Analysis Services, and use the SageHR Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Business Warehouse
Provide connectivity to SAP Business Warehouse through an SAP BusinessObjects universe.
-
Automated Continuous Sugar CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sugar CRM replication to SingleStore.
-
Use Biml to Build SSIS Tasks to Replicate Strava Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Strava to SQL Server.
-
Create Reports from Oracle Eloqua Data in Looker Studio
Use CData Connect AI to gain access to live Oracle Eloqua and create custom reports in Looker Studio.
-
Configure the CData JDBC Driver for Close in a Connection Pool in Tomcat
Connect to Close from a connection pool in Tomcat.
-
Analyze Office 365 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Office 365 from Power Pivot. You will use the Table Import Wizard to load Microsoft Office 365. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live SAP Ariba Procurement Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAP Ariba Procurement for you.
-
Connect to ActiveCampaign Data from AWS Glue
Use CData Connect AI to gain access to live ActiveCampaign from your AWS Glue jobs.
-
Use ChatGPT to Talk to Your Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft OneDrive for you.
-
Build an OLAP Cube in SSAS from ShipEngine Data
Establish a connection to ShipEngine data from SQL Server Analysis Services, and use the ShipEngine Data Provider to build OLAP cubes for use in analytics and reporting.
-
Write a Simple Go Application to work with Cloudant Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Cloudant.
-
Integrate Live Microsoft Entra ID Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Access Live SFTP Data in Visual Studio Code via Cline
Run CData MCP Server for SFTP on Windows Subsytem for Linux (WSL) and connect to live SFTP from the Cline extension in Visual Studio Code.
-
Connect to Mailgun Data in CloverDX (formerly CloverETL)
Transfer Mailgun using the visual workflow in the CloverDX data integration tool.
-
Visualize SpaceX Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SpaceX into TIBCO Spotfire.
-
Visualize Live SAP Fieldglass Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Fieldglass into custom reports in Power BI.
-
Query ZohoExpense Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoExpense.
-
Build SingleStore-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SingleStore and build SingleStore-connected web apps with Axios.
-
Integrating LlamaIndex with Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Table Storage in real time.
-
Connect Microsoft Entra ID Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Entra ID using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect and Query Live SurveyMonkey Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SurveyMonkey into Databricks
-
Connect Amazon S3 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amazon S3 using the CData Python MCP Server.
-
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB in MicroStrategy Desktop using the CData Software JDBC Driver for MariaDB.
-
Automate SAP Ariba Procurement Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Ariba Procurement replication to SAP HANA.
-
Build Data Flows from Drift to SQL Server using SSIS
Easily back up Drift to SQL Server using the SSIS components for Drift.
-
Analyze YouTube Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of YouTube Analytics and visualize YouTube Analytics in SAP Analytics Cloud.
-
Connect to LionDesk Data in NetBeans
Connect to LionDesk in NetBeans with the data source configuration wizard.
-
Build Outreach.io-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Outreach.io.
-
Connect to Keap Data from PowerBuilder via ADO.NET
This article demonstrates how to access Keap from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Replicate Multiple Stripe Accounts
Replicate multiple Stripe accounts to one or many databases.
-
How to Design Acumatica Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Acumatica from mobile and tablet Power Apps.
-
Automate OData Services Replication to Azure Data Lake
Use CData Sync to customize and automate OData replication to Azure Data Lake.
-
Easily Integrate MYOB AccountRight Data in Lazarus Pascal IDE
Learn how to easily integrate live MYOB AccountRight in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Omnisend Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Omnisend replication to Google Cloud SQL.
-
Migrating data from SAP Ariba Procurement to Databricks using CData SSIS Components.
Easily push SAP Ariba Procurement to Databricks using the CData SSIS Tasks for SAP Ariba Procurement and Databricks.
-
ETL Paymo in Oracle Data Integrator
This article shows how to transfer Paymo into a data warehouse using Oracle Data Integrator.
-
Connect to Procore Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Procore and work with Procore in your FileMaker application.
-
Access MongoDB Data from MySQL in Amazon QuickSight
Connect to MongoDB and build visualizations of MongoDB using a MySQL Connection in Amazon QuickSight.
-
Use Grok to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Microsoft Entra ID for you.
-
Use the CData Software JDBC Driver for Klaviyo in MicroStrategy Web
Connect to Klaviyo in MicroStrategy Web using the CData Software JDBC Driver for Klaviyo.
-
Use the CData ODBC Driver for Tanda in Microsoft Power Query
You can use the CData Tanda ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Tanda into Microsoft Power Query.
-
Automated Continuous Phoenix Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Phoenix replication to Amazon Redshift.
-
Integrating ConvertKit Data in Talend Cloud Data Management Platform
Connect ConvertKit Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live SparkPost Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SparkPost using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Instantly Data in Jaspersoft Studio
Execute SQL to remote Instantly in Jaspersoft Studio.
-
Design BIRT Reports on Printful Data
Provide current Printful to your embedded analytics.
-
Access Live Dynamics 365 Data in AWS Lambda
Connect to live Microsoft Dynamics 365 in AWS Lambda using the CData JDBC Driver.
-
Build AI/ML Models with Live Aha! Data using Dataiku
Connect Aha! Data with Dataiku using the CData API Driver for JDBC.
-
Build Dashboards with YouTube Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on YouTube Analytics in Dundas BI.
-
Connect to Redis Data in NetBeans
Connect to Redis in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy Desktop
Connect to Everhour in MicroStrategy Desktop using the CData Software JDBC Driver for Everhour.
-
Analyze RabbitMQ Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze RabbitMQ in Microsoft R Open.
-
Use the CData SSIS Components to Insert New or Update Existing Jira Assets Records from SQL Server
Easily push SQL Server data to Jira Assets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Jira Assets or update existing records with data from a SQL Server database.
-
Connect to Microsoft Dataverse Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Dataverse (CDS) in Airbyte.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP HANA XS Advanced
Provide connectivity to SAP HANA XS Advanced through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Deel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Deel.
-
Rapidly Develop Oracle-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Oracle.
-
Connect to Instantly Data from a Connection Pool in Jetty
The Instantly JDBC Driver supports connection pooling: This article shows how to connect faster to Instantly from Web apps in Jetty.
-
Integrate Cursor with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft OneDrive from within the editor.
-
Create Data Visualizations Based On Facebook Data in Mode
Use CData Connect AI to connect to Facebook Data from Mode and build visualizations using live
-
Build Sybase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sybase to explore live Sybase Data in Cursor to assist with building Sybase-powered applications.
-
Build MVC Applications with Connectivity to SAP HANA Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP HANA from an ASP.NET MVC application.
-
Load Cloudant Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM Cloudant to a database.
-
Automate Microsoft Teams Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Teams and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect SharePoint with IBM Cloud Object Storage Data through external lists
Provide IBM Cloud Object Storage to SharePoint users as an external list.
-
Getting Started with the CData Python Connector for Impala
Learn to install and license the CData Python Connector
-
Integrating Cursor CLI with OpenWeatherMap Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Build a Singer.io Tap for Tickspot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tickspot data using
-
Design BIRT Reports on Webflow Data
Provide current Webflow to your embedded analytics.
-
Getting Started with the CData Tableau Connector for LinkedIn
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for LinkedIn.
-
Connect to Twitter Ads Data in Aqua Data Studio
Access Twitter Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Stripe Data Using Azure Data Factory
Use CData Connect AI to connect to Stripe Data from Azure Data Factory and import live Stripe.
-
Query Bright Data Data in DataGrip
Create a Data Source for Bright Data in DataGrip and use SQL to query live Bright Data.
-
Use Grok to Talk to Your Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Microsoft Dynamics CRM for you.
-
LINQ to Outlook Data
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 Outlook Data Provider.
-
Build SAP Ariba Source-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP Ariba Source to explore live SAP Ariba Source Data in Gemini Code Assist to assist with building SAP Ariba Source-powered applications.
-
Visualize Parallel Data in Tableau
The CData ODBC driver for Parallel enables you integrate Parallel into Tableau dashboards.
-
Automated Continuous Power BI XMLA Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to IBM DB2.
-
Publish Reports with Monday.com Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Monday.com.
-
Working with AfterShip Data in LINQPad
Execute LINQ queries to AfterShip in LINQPad.
-
Access Live Highrise Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Highrise CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import and Visualize ZohoMarketingHub Data in Power View
Create data visualizations based on ZohoMarketingHub in Excel.
-
Automated Continuous Tickspot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Tickspot replication to Apache Cassandra.
-
Analyze Oracle Eloqua Reporting Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Eloqua Reporting with the CData JDBC Driver for Oracle Eloqua Reporting.
-
Work with Shippo Data in FoxPro
Load Shippo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Guru Data from a Connection Pool in JBoss
Integrate Guru into Java servlets: Use the Management Console in JBoss to install the Guru JDBC Driver.
-
Add HelloSign Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HelloSign with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Microsoft Copilot Studio to talk to your SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SingleStore for you.