CData Software - Knowledge Base
Recent Articles
-
Connect to Dynamics 365 Business Central Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Dynamics 365 Business Central in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Samanage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Samanage replication to Apache Cassandra.
-
Build HubSpot Visualizations in Tableau Desktop
Use CData Connect AI to connect to live HubSpot and build visualizations in Tableau.
-
Getting Started with the CData ADO.NET Provider for ClickTime
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Stack Exchange Replication to Snowflake
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Snowflake.
-
Know Your LLMs: Mistral AI
A comprehensive technical evaluation of Mistral AI models for enterprise integration with CData Connect AI, covering architecture, capabilities, security, and deployment guidance.
-
Automated Continuous CData Connect AI Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CData Connect AI replication to OneLake in Microsoft Fabric.
-
Build Apps with Live LaunchDarkly Data Using the Low-Code Development Platform of Mendix
Connect LaunchDarkly with Mendix to build apps using the CData API Driver for JDBC.
-
Migrating data from Qualaroo to Google BigQuery using CData SSIS Components.
Easily push Qualaroo to Google BigQuery using the CData SSIS Tasks for Qualaroo and Google BigQuery.
-
How to create ZohoDesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZohoDesk in MySQL .
-
How to Work with QuickBooks Time Data in ETL Validator JDBC
Connect to QuickBooks Time from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with Sugar CRM 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.
-
Migrating data from Amazon Marketplace to Databricks using CData SSIS Components.
Easily push Amazon Marketplace to Databricks using the CData SSIS Tasks for Amazon Marketplace and Databricks.
-
Connect to Suadeo Data from PowerBuilder via JDBC
This article demonstrates how to access Suadeo from PowerBuilder using the Suadeo JDBC Driver.
-
How to Seamlessly Import SageHR Data into IBM SPSS Modeler
Integrate SageHR data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access AfterShip Data 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 AfterShip.
-
Create Smartsheet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Smartsheet from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connecting GenSpark with Neo4J Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Neo4J without any replication or custom integration required.
-
Automated Continuous Confluence Replication to Oracle
Use CData Sync for automated, continuous, customizable Confluence replication to Oracle.
-
Build Automated Workflows with Live FHIR Data in Workato
Use CData Connect AI to connect to live FHIR and build automated workflows in Workato.
-
Build Facebook Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Facebook Ads.
-
Integrating Cursor CLI with JSON Services 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.
-
View Reports on Real-Time SAP BusinessObjects BI Data in Power BI Report Server
Use the CData ODBC Driver for SAP BusinessObjects BI to visualize SAP BusinessObjects BI in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Work with IBM Cloud Object Storage Data in ETL Validator JDBC
Connect to IBM Cloud Object Storage from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Reply.io Data in JRuby
Create a simple JRuby app with access to live Reply.io.
-
NASA Reporting in OBIEE with the NASA JDBC Driver
Deploy the NASA JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Excel Add-In for SendPulse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SendPulse.
-
Integrating Antigravity CLI with Gong via CData CLI
Connect Gong to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
View Reports on Real-Time Discourse Data in Power BI Report Server
Use the CData ODBC Driver for Discourse to visualize Discourse in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Excel Online Data in DBVisualizer
Integrate Microsoft Excel Online with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Avalara AvaTax-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Avalara AvaTax Data from OutSystems and build custom enterprise apps using live Avalara AvaTax.
-
Automated Continuous ZohoDesk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Azure SQL Database.
-
Publish Snowflake-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Snowflake.
-
Automated Continuous Google Forms Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Forms replication to MongoDB.
-
Back Up Superchat to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Superchat data.
-
Use the CData Software JDBC Driver for HCL Domino in MicroStrategy Desktop
Connect to HCL Domino in MicroStrategy Desktop using the CData Software JDBC Driver for HCL Domino.
-
Query Lakebase Data in ColdFusion
Write standard ColdFusion data access code to connect to Lakebase.
-
Extract, Transform, and Load CampaignMonitor Data in Informatica PowerCenter
Create a simple Workflow for CampaignMonitor in Informatica PowerCenter.
-
Build PostgreSQL Visualizations in Tableau Cloud
Use CData Connect AI to connect to live PostgreSQL and build visualizations in Tableau Cloud.
-
Visualize Live Azure Table Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Azure Table Storage into custom reports in Power BI.
-
How to Connect Flowise AI Agents to Live EnterpriseDB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live EnterpriseDB without replication.
-
Build AI/ML Models with Live SAP Business One Data using Dataiku
Connect SAP Business One Data with Dataiku using the CData JDBC Driver for SAP Business One.
-
Use Agno to Talk to Your Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Apache Avro for you.
-
Build Semantic Layer Views for Snowflake Data in APOS Live Data Gateway
Use the CData Connector for Snowflake in APOS Live Data Gateway to build Semantic Layer Views for Snowflake.
-
Getting Started with the CData Connect AI Python SDK for Dropbox
Install the CData Connect AI Python SDK to read and write live Dropbox with standard DB-API 2.0 Python code.
-
Query SendGrid Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SendGrid entities in PHP by modeling them as objects.
-
Use the CData Software ODBC Driver for Apify in SAS for Real-Time Reporting and Analytics
Connect to real-time Apify in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Apify.
-
Create Office 365-Connected Business Apps in AppSheet
Connect to Office 365 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Office 365.
-
Create Informatica Mappings From/To an ODBC Data Source for Samanage
Create an ODBC connection to Samanage in Informatica and browse and transfer Samanage.
-
Query Airtable Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Airtable from Node.js.
-
Replicate Exa Data to Multiple Databases
Replicate Exa to disparate databases with a point-and-click configuration.
-
Create a Data Access Object for Sentry Data using JDBI
A brief overview of creating a SQL Object API for Sentry in JDBI.
-
How to use SQLAlchemy ORM to access Paymo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Paymo.
-
Import Real-Time Timely Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Timely in ColdFusion.
-
Connect to Microsoft Dataverse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Dataverse (CDS).
-
Integrate Mouseflow with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mouseflow with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mouseflow.
-
Build a Simple VCL Application for SAP SuccessFactors Data
How to build a simple VCL Application to view SAP SuccessFactors in RAD Studio using the CData ODBC Driver for SAP SuccessFactors.
-
FTP Reporting in OBIEE with the FTP JDBC Driver
Deploy the FTP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating OpenCode Terminal with Dynamics 365 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.
-
Back Up Elorus to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Elorus data.
-
Connect to Coinbase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Visualize Adobe Experience Manager Data in Python with pandas
Use pandas and other modules to analyze and visualize live Adobe Experience Manager in Python.
-
Publish Reports with Google Calendar Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Calendar.
-
Working with Mode Data in LINQPad
Execute LINQ queries to Mode in LINQPad.
-
Create Dashboards and Visualize Live Procore Data in Geckoboard
Use CData Connect AI to connect to live Procore and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software JDBC Driver for Twitter Ads in MicroStrategy Web
Connect to Twitter Ads in MicroStrategy Web using the CData Software JDBC Driver for Twitter Ads.
-
Integrate Impala with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Impala with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Impala.
-
Easily Integrate Harvest Data in Lazarus Pascal IDE
Learn how to easily integrate live Harvest in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Enable the MailerLite JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MailerLite.
-
How to Connect to & Open XML Data in Microsoft Excel
This article uses the CData ODBC driver for XML to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Delighted Data in the Pentaho Report Designer
Publish reports based on Delighted in the Pentaho BI tool.
-
Provide OData Services of SpaceX Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SpaceX by developing a WCF Service Application.
-
Connect to and Visualize Live TaxJar Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live TaxJar.
-
Connect to LinkedIn Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Live Oracle Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Data in CData Connect AI and connect to your Oracle Database from MicroStrategy.
-
Query QuickBooks Time Data as a MySQL Database in Node.js
Execute MySQL queries against QuickBooks Time from Node.js.
-
Microsoft Entra ID Reporting in OBIEE with the Microsoft Entra ID JDBC Driver
Deploy the Microsoft Entra ID JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Live Pipedrive Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Pipedrive in CData Connect AI and connect to your Pipedrive from PostgreSQL.
-
Use the CData ODBC Driver for NetSuite from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for NetSuite to connect to NetSuite CRM & ERP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring NetSuite CRM & ERP in Excel.
-
Connect to Adobe Commerce Data in Ruby
Connect to Adobe Commerce in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Datadog with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Datadog with External Services.
-
Connect to Shopify Data in Claris FileMaker Pro
Use the CData ODBC Driver for Shopify in FileMaker Pro to connect to Shopify and work with Shopify in your FileMaker applications.
-
Automated Continuous Sendwithus Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sendwithus replication to SingleStore.
-
How to Work with Vimeo Data in AWS Glue Jobs Using JDBC
Connect to Vimeo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Dynamic LionDesk Grids Using the Infragistics XamDataGrid
Learn how you can connect LionDesk to Infragistics XamDataGrid to build dynamic grids.
-
How to Seamlessly Import Recurly Data into IBM SPSS Modeler
Integrate Recurly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Excel Add-In for Browserless
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Browserless.
-
LINQ to Chargebee 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 Chargebee Data Provider.
-
Access Twilio Data from MySQL in Amazon QuickSight
Connect to Twilio and build visualizations of Twilio using a MySQL Connection in Amazon QuickSight.
-
Build a Singer.io Tap for Oracle HCM Cloud With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle HCM Cloud data using
-
Use Dash to Build to Web Apps on Salesforce CRM Analytics Data
Create Python applications that use pandas and Dash to build Salesforce CRM Analytics-connected web apps.
-
How to Build an ETL App for Humanity Data in Python with CData
Create ETL applications and real-time data pipelines for Humanity in Python with petl.
-
Process & Analyze HelloSign Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HelloSign Data.
-
Connect to AlloyDB Data from AWS Glue
Use CData Connect AI to gain access to live Google AlloyDB from your AWS Glue jobs.
-
Import Impala Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Impala Data and provide access to live Apache Impala for custom reports in the Power BI Service.
-
How to connect and process Zoho Inventory from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Inventory.
-
Use Databricks Agent Bricks to Talk to Your BigCommerce Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your BigCommerce for you.
-
Use the CData ODBC Driver for Google Tasks from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Tasks to connect to Google Tasks from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Tasks in Excel.
-
Build Automated Workflows with Live OData Services in Workato
Use CData Connect AI to connect to live OData and build automated workflows in Workato.
-
Integrate Google Tasks with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Tasks with External Services.