CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for Snowflake
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Snowflake.
-
Configure the CData JDBC Driver for ADP in a Connection Pool in Tomcat
Connect to ADP from a connection pool in Tomcat.
-
Connect to Google Contacts Data from a Connection Pool in Jetty
The Google Contacts JDBC Driver supports connection pooling: This article shows how to connect faster to Google Contacts from Web apps in Jetty.
-
Automated Continuous Aha! Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aha! replication to delimited files (CSV/TSV).
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Power BI XMLA to Power BI dashboards. Simply drag and drop Power BI XMLA into data visuals on the Power BI canvas.
-
Visualize Live Auth0 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Auth0 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from SuiteCRM to Google BigQuery using CData SSIS Components.
Easily push SuiteCRM to Google BigQuery using the CData SSIS Tasks for SuiteCRM and Google BigQuery.
-
Access Live Workday Data in Coginiti Pro
Connect to and query live Workday from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect PolyBase to Printify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Printify.
-
Provide OData Services of Zoho CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho CRM by developing a WCF Service Application.
-
Stream PivotalTracker Data into Apache Kafka Topics
Access and stream PivotalTracker in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Rootly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Rootly.
-
How to Build an ETL App for Anaplan Data in Python with CData
Create ETL applications and real-time data pipelines for Anaplan in Python with petl.
-
How to Query Discourse Data in MySQL Workbench
Execute MySQL queries against live Discourse from MySQL Workbench.
-
Import Microsoft Entra ID Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Entra ID. In this article, you will use the OData format to import Microsoft Entra ID into Microsoft Power Query.
-
Use Azure AI Foundry to Talk to Your Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Adobe Commerce for you.
-
Integrating Gumloop with IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on IBM Informix within automated workflows.
-
Connect to Float Data from a Connection Pool in Jetty
The Float JDBC Driver supports connection pooling: This article shows how to connect faster to Float from Web apps in Jetty.
-
Bidirectional Access to Anaplan Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Anaplan in Filemaker Pro for Mac or Windows.
-
Build Cloudant-Connected Apps in Choreo
Use CData Connect AI to connect to Cloudant Data from Choreo and build custom apps using live IBM Cloudant.
-
Rapidly Develop HubSpot-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 HubSpot.
-
DataBind Cassandra Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Cassandra with the DevExpress Windows Forms and Web controls to provide Apache Cassandra to a chart.
-
Build Voice Agents in ElevenLabs with access to Live Sybase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sybase.
-
Import Google Spanner Data Using Azure Data Factory
Use CData Connect AI to connect to Google Spanner Data from Azure Data Factory and import live Google Spanner.
-
Easily Integrate Lakebase Data in Lazarus Pascal IDE
Learn how to easily integrate live Lakebase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Design ADP Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to ADP from mobile and tablet Power Apps.
-
Automated Continuous Authorize.Net Replication to Oracle
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Oracle.
-
Connect to BigQuery Data as an External Source in Dremio
Use the CData JDBC Driver to connect to BigQuery as an External Source in Dremio.
-
Query Acumatica Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Acumatica ERP and perform CRUD operations on Acumatica from Node.js.
-
Work with Live SAP Ariba Procurement Data in Power Query
Use CData Connect AI to connect to SAP Ariba Procurement and work with live SAP Ariba Procurement in Microsoft Power Query.
-
Connect and Visualize Live Google Cloud Storage Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Cloud Storage into the Databricks platform and create visualization dashboards with real-time Google Cloud Storage.
-
Automated Continuous SharePoint Excel Services Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to AlloyDB.
-
Build a Simple VCL Application for Invoiced Data
How to build a simple VCL Application to view Invoiced in RAD Studio using the CData ODBC Driver for Invoiced.
-
Use Claude to Talk to Your Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Amazon DynamoDB for you.
-
Connect to Impala Data in Claris FileMaker Pro
Use the CData ODBC Driver for Impala in FileMaker Pro to connect to Impala and work with Apache Impala in your FileMaker applications.
-
How to publish and share Beeminder Data dashboards with Tableau Server
The CData ODBC driver for Beeminder enables you integrate Beeminder into Tableau dashboards.
-
Automated Continuous Azure Data Lake Storage Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to MySQL.
-
Connect to Excel Online Data in HULFT Integrate
Connect to Excel Online as a JDBC data source in HULFT Integrate
-
Create Data Visualizations in Cognos BI with Spotify Data
Access Spotify as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Spark Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Spark replication to Azure SQL Database.
-
Integrate with live Odoo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Odoo ERP in Jitterbit.
-
Integrating Kiro CLI with SAP Fieldglass 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.
-
How to use SQLAlchemy ORM to access Printify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Printify.
-
Integrate Cline with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoho Creator from within your IDE.
-
How to Connect to & Open Pipeline CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Pipeline CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Landbot Data in NetBeans
Connect to Landbot in NetBeans with the data source configuration wizard.
-
Automated Continuous Mailjet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mailjet replication to SingleStore.
-
Integrate with LinkedIn Ads Data in SnapLogic
Use CData Connect AI to connect to and integrate with live LinkedIn Ads in SnapLogic.
-
Connect to Bright Data 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 Bright Data and work with Bright Data in your FileMaker application.
-
How to connect to ClickTime Data from IntelliJ
Integrate connectivity to ClickTime with wizards in IntelliJ.
-
Automated Continuous iContact Replication to Amazon S3
Use CData Sync for automated, continuous, customizable iContact replication to Amazon S3.
-
Query SAP Hybris C4C Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Hybris C4C and perform CRUD operations on SAP Hybris C4C from Node.js.
-
Consume SAP Concur OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Concur feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Wistia Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Wistia replication to Google Cloud SQL.
-
Automated Continuous Moosend Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Moosend replication to Apache Kafka.
-
Create Reports with Greenplum Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pivotal GreenPlum.
-
How to Build an ETL App for Freshservice Data in Python with CData
Create ETL applications and real-time data pipelines for Freshservice in Python with petl.
-
Connect to and Query Teradata Data in QlikView over ODBC
Create data visualizations with Teradata in QlikView.
-
How to create Deel federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Deel in MySQL .
-
Connect to SurveyMonkey Data in Jaspersoft Studio
Execute SQL to remote SurveyMonkey in Jaspersoft Studio.
-
Access Live Apollo Data in Excel 365 Online (Excel for the web)
Connect to Apollo from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Work with Freshteam Data in AWS Glue Jobs Using JDBC
Connect to Freshteam from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Rapidly Develop Anaplan-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 Anaplan.
-
Integrating Boomi Agentstudio with AlloyDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google AlloyDB, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Migrating data from eBay Analytics to Databricks using CData SSIS Components.
Easily push eBay Analytics to Databricks using the CData SSIS Tasks for eBay Analytics and Databricks.
-
Object-Relational Mapping (ORM) with Outlook Data 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 Outlook into a Java-based ORM framework, Hibernate.
-
Configure the CData JDBC Driver for Clockify in a Connection Pool in Tomcat
Connect to Clockify from a connection pool in Tomcat.
-
How to Import Data from Sybase into Google Sheets
Import Sybase into a Google spreadsheet that is automatically refreshed.
-
Use Dash to Build to Web Apps on Google Ads Data
Create Python applications that use pandas and Dash to build Google Ads-connected web apps.
-
Visualize Bullhorn CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bullhorn CRM.
-
Use Grok to Talk to Your SAP Business One 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 SAP Business One for you.
-
How to create an RPA flow for FreshBooks Data in UiPath Studio
Use the FreshBooks ODBC Driver to create workflows that access real-time FreshBooks without any coding.
-
Analyze PolarTeamPro Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PolarTeamPro from Power Pivot. You will use the Table Import Wizard to load PolarTeamPro. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Attio Replication to MySQL
Use CData Sync for automated, continuous, customizable Attio replication to MySQL.
-
Connect to and Query Bullhorn CRM Data in QlikView over ODBC
Create data visualizations with Bullhorn CRM in QlikView.
-
Model Greenhouse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Greenhouse, enabling the direct import of real-time Greenhouse.
-
Moving Data from Pingdom to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pingdom data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Pipeline CRM Data using the CData ODBC Driver
Use the SQL Gateway and Pipeline CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Import Data from Salesforce Pardot into Google Sheets
Import Salesforce Pardot into a Google spreadsheet that is automatically refreshed.
-
Query Google Ad Manager Data as a MySQL Database in Node.js
Execute MySQL queries against Google Ad Manager from Node.js.
-
Connect to Salesforce Pardot Data in CloverDX (formerly CloverETL)
Transfer Salesforce Pardot using the visual workflow in the CloverDX data integration tool.
-
Build Automated Airtable-Connected Workflows in Zapier
Use CData Connect AI to connect to live Airtable and build automated workflows in Zapier.
-
Build WooCommerce-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for WooCommerce to explore live WooCommerce Data in Cursor to assist with building WooCommerce-powered applications.
-
How to connect PolyBase to MongoDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MongoDB.
-
Automate Ontraport Data Replication to Azure Data Lake
Use CData Sync to customize and automate Ontraport replication to Azure Data Lake.
-
ETL SendGrid in Oracle Data Integrator
This article shows how to transfer SendGrid into a data warehouse using Oracle Data Integrator.
-
Integrate Google Campaign Manager 360 Data in the Pentaho Report Designer
Publish reports based on Google Campaign Manager 360 in the Pentaho BI tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for GraphQL
Provide connectivity to GraphQL through an SAP BusinessObjects universe.
-
Creating GitHub-Connected Applications in Unqork
You can use CData Connect AI to feed GitHub to Unqork and build custom business apps.
-
Use Agno to Talk to Your Oracle 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 Oracle Database for you.
-
Replicate LightSpeedRetail Data in Heroku for Use in Salesforce Connect
Replicate LightSpeedRetail to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Microsoft OneDrive Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft OneDrive from Node.js.
-
Query Live Google Campaign Manager 360 Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Campaign Manager 360 directly from the development environment.
-
Build a Simple VCL Application for SFTP Data
How to build a simple VCL Application to view SFTP in RAD Studio using the CData ODBC Driver for SFTP.
-
Query Adobe Experience Manager Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Adobe Experience Manager from Node.js.
-
Deploy the ADO.NET Provider for Tickspot on an SSRS Report Server
Connect to Tickspot from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Create Dynamic Microsoft OneDrive Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft OneDrive to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to & Open Active Directory Data in Microsoft Excel
This article uses the CData ODBC driver for Active Directory to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect and Visualize Live Apollo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apollo into the Databricks platform and create visualization dashboards with real-time Apollo.
-
Getting Started with the CData Power BI Connector for Egnyte
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.