CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Connect AI Python SDK for PingOne
Install the CData Connect AI Python SDK to read live PingOne data with standard DB-API 2.0 Python code.
-
Object-Relational Mapping (ORM) with Aha! 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 Aha! data into a Java-based ORM framework, Hibernate.
-
Access Live MailChimp Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MailChimp data into the statistical analysis tools available in SAS JMP. This article shows how to use MailChimp data in the Graph Builder and Query Builder.
-
Connect TaxJar to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect TaxJar with IBM WebSphere for seamless data integration and connectivity.
-
Create Data Visualizations in Cognos BI with Parquet Data
Access Parquet data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Microsoft Teams Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Teams data from your AWS Glue jobs.
-
Visualize Zoho Books Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Books data into dashboards in TIBCO Spotfire.
-
Build Data Flows from Coinbase to SQL Server using SSIS
Easily back up Coinbase data to SQL Server using the SSIS components for Coinbase.
-
Connect to ShipEngine Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ShipEngine data.
-
Use Grok to Talk to Your Okta 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 Okta data for you.
-
Analyze Cvent Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Cvent data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use the CData Software ODBC Driver for iContact in MicroStrategy Web
Connect to iContact data in MicroStrategy Web using the CData Software ODBC Driver for iContact.
-
Replicate Multiple ConvertAPI Accounts
Replicate multiple ConvertAPI accounts to one or many databases.
-
Integrating Codex with Act-On 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 Oracle-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Data from Zoho Analytics and import live Oracle data.
-
Replicate Redis Data to Multiple Databases
Replicate Redis data to disparate databases with a point-and-click configuration.
-
Choosing the Best Method to Connect Egnyte to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Egnyte data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Salesforce Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce data to disparate databases with a single configuration.
-
How to integrate EmailOctopus with Apache Airflow
Access and process EmailOctopus data in Apache Airflow using the CData JDBC Driver.
-
Connect to Kafka Data in CloverDX (formerly CloverETL)
Transfer Kafka data using the visual workflow in the CloverDX data integration tool.
-
Prepare, Blend, and Analyze GetResponse Data in Alteryx Designer (Connect AI)
Build workflows to access live GetResponse data for self-service data analytics.
-
Connect to Reply.io Data from PowerBuilder via JDBC
This article demonstrates how to access Reply.io data from PowerBuilder using the Reply.io JDBC Driver.
-
Automated Continuous Twitter Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Apache Kafka.
-
Connect to AlloyDB Data from PowerBuilder via JDBC
This article demonstrates how to access AlloyDB data from PowerBuilder using the AlloyDB JDBC Driver.
-
How to work with Postmark Data in Apache Spark using SQL
Access and process Postmark Data in Apache Spark using the CData Software JDBC Driver.
-
Creating Cloudflare-Connected Applications in Unqork
You can use CData Connect AI to feed Cloudflare data to Unqork and build custom business apps.
-
Getting Started with the CData ADO.NET Provider for Google Tasks
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Pushbullet Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pushbullet data using standard SQL.
-
Build Apps with Live FreshBooks data in Adalo using CData Connect AI
Use CData Connect AI to integrate live FreshBooks data into the Adalo platform and build custom mobile and web applications with real-time FreshBooks data.
-
Add Billsby Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Billsby with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting GenSpark with Odoo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Odoo data without any replication or custom integration required.
-
Integrate Goose with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Twitter Ads data from within the local AI agent.
-
Connect to Salesloft Data from a Connection Pool in Jetty
The Salesloft JDBC Driver supports connection pooling: This article shows how to connect faster to Salesloft data from Web apps in Jetty.
-
Prepare, Blend, and Analyze Sage 300 Data in Alteryx Designer (ODBC)
Build workflows to access live Sage 300 data for self-service data analytics.
-
How to integrate Klaviyo with Apache Airflow
Access and process Klaviyo data in Apache Airflow using the CData JDBC Driver.
-
Easily Integrate Wistia Data in Lazarus Pascal IDE
Learn how to easily integrate live Wistia data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ZohoExpense Data in HULFT Integrate
Connect to ZohoExpense as a JDBC data source in HULFT Integrate
-
Connect to Pinterest Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pinterest to connect to Pinterest data and execute queries in PowerBuilder.
-
Use Dash to Build to Web Apps on Cvent Data
Create Python applications that use pandas and Dash to build Cvent-connected web apps.
-
Create Data Visualizations Based On Google Drive Data in Mode
Use CData Connect AI to connect to Google Drive Data from Mode and build visualizations using live Google Drive data.
-
Link BenchmarkEmail with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate BenchmarkEmail data in Filemaker Pro for Mac or Windows.
-
Deploy the ADO.NET Provider for JotForm on an SSRS Report Server
Connect to JotForm data 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.
-
LINQ to Jodoo 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 Jodoo Data Provider.
-
Natively Connect to Amplitude Data in PHP
The CData ODBC driver for Amplitude enables you to create PHP applications with connectivity to Amplitude data. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Tasks
Provide connectivity to Google Tasks data through an SAP BusinessObjects universe.
-
Connect to LinkedIn Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for LinkedIn Ads in FileMaker Pro to connect to LinkedIn Ads and work with LinkedIn Ads data in your FileMaker applications.
-
How to integrate Metabase with ServiceDesk Plus Data
Use CData Connect AI to connect to live ServiceDesk Plus data and create an interactive dashboard in Metabase from ServiceDesk Plus data.
-
Connecting Mastra with Omnisend Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Omnisend data, no replication required.
-
Automated Continuous Landbot Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Landbot data replication to OneLake in Microsoft Fabric.
-
Configure the CData JDBC Driver for SAP Business One in a Connection Pool in Tomcat
Connect to SAP Business One data from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for eBay Analytics
Provide connectivity to eBay Analytics data through an SAP BusinessObjects universe.
-
Migrating data from ChartMogul to Databricks using CData SSIS Components.
Easily push ChartMogul data to Databricks using the CData SSIS Tasks for ChartMogul and Databricks.
-
Access Azure DevOps Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure DevOps data from HeidiSQL.
-
Build Dashboards with Google Campaign Manager 360 Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Campaign Manager 360 data in DBxtra.
-
How to Connect to & Open FHIR Data in Microsoft Excel
This article uses the CData ODBC driver for FHIR to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind Google Forms Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Google Forms data to a chart.
-
Build Semantic Layer Views for Mixpanel Data in APOS Live Data Gateway
Use the CData Connector for Mixpanel in APOS Live Data Gateway to build Semantic Layer Views for Mixpanel data.
-
Integrating Codex with Slack 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Redshift
Provide connectivity to Redshift data through an SAP BusinessObjects universe.
-
Access Live Google Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Ads data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Ads data in the Graph Builder and Query Builder.
-
DataBind Controls to FTP Data in Delphi
DataBind to FTP data in Delphi with standard data access components and controls.
-
Integrate SAP Hybris C4C Data in Pentaho Data Integration
Build ETL pipelines based on SAP Hybris C4C data in the Pentaho Data Integration tool.
-
Back Up AdRoll data 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 AdRoll data data.
-
Integrate PDFMonkey Data in Pentaho Data Integration
Build ETL pipelines based on PDFMonkey data in the Pentaho Data Integration tool.
-
Automated Continuous Mocean Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mocean replication to Snowflake.
-
Getting Started with the CData Excel Add-In for HubDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HubDB.
-
How to import ZendeskSell Data into Apache Solr
Use the CData Software JDBC Driver for ZendeskSell in Data Import Handler and create an automated import of ZendeskSell data to Apache Solr Enterprise Search platform.
-
Prepare, Blend, and Analyze Apify Data in Alteryx Designer (Connect AI)
Build workflows to access live Apify data for self-service data analytics.
-
Back Up ConvertAPI data 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 ConvertAPI data data.
-
Bridge CockroachDB Connectivity with Apache NiFi
Access and process CockroachDB data in Apache NiFi using the CData JDBC Driver.
-
How to Seamlessly Import Sage 200 Data into IBM SPSS Modeler
Integrate Sage 200 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Choosing the Best Method to Connect Everhour to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Everhour data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Multiple HelloSign Accounts
Replicate multiple HelloSign accounts to one or many databases.
-
Create Dynamic Scrapfly Grids Using the Infragistics XamDataGrid
Learn how you can connect Scrapfly to Infragistics XamDataGrid to build dynamic grids.
-
Moving Data from PhantomBuster to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PhantomBuster data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Perigon 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 Perigon data.
-
Integrating GitHub Copilot with Autopilot 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Avro
Create Avro data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Dynamics 365 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 Dynamics 365 data into TIBCO Spotfire.
-
Analyze Live Salesforce CRM Analytics Data in SAS Viya
Use CData Connect AI to connect to Salesforce CRM Analytics data from SAS Viya and deploy self-service analytics using live Salesforce CRM Analytics data.
-
Automate Workable Data Replication to Azure Data Lake
Use CData Sync to customize and automate Workable data replication to Azure Data Lake.
-
Automated Continuous DB2 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable DB2 replication to Google Cloud SQL.
-
Connect to Gorgias 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 Gorgias and work with Gorgias data in your FileMaker application.
-
Integrating Codex with Teradata 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.
-
Create Anaplan-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Anaplan Data from Klipfolio and build custom visualizations using live Anaplan data.
-
Use Dash to Build to Web Apps on ShipEngine Data
Create Python applications that use pandas and Dash to build ShipEngine-connected web apps.
-
A PostgreSQL Interface for Microsoft Ads Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to & Open Avalara AvaTax Data in Microsoft Excel
This article uses the CData ODBC driver for Avalara AvaTax to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Visualize Flowlu Data in Python with pandas
Use pandas and other modules to analyze and visualize live Flowlu data in Python.
-
How to Build an ETL App for SendInBlue Data in Python with CData
Create ETL applications and real-time data pipelines for SendInBlue data in Python with petl.
-
Connecting GenSpark with ShipEngine Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ShipEngine data without any replication or custom integration required.
-
How to connect to Amazon DynamoDB Data from Spring Boot
Connect to Amazon DynamoDB in a Spring Boot Application using the CData JDBC Driver for Amazon DynamoDB
-
How to connect to LeadDesk Data from Spring Boot
Connect to LeadDesk in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData Software JDBC Driver for Beeminder in MicroStrategy
Connect to Beeminder data in MicroStrategy Developer using the CData Software JDBC Driver for Beeminder.
-
Analyze ShipEngine Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ShipEngine from Power Pivot. You will use the Table Import Wizard to load ShipEngine data. You can visually build the import query or use any SQL supported by the driver.
-
Feed Databricks Data into FineReport
How to set Databricks data as a JDBC data source in FineReport.
-
Automated Continuous Reckon Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Reckon replication to Amazon Redshift.
-
Integrate Open WebUI with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Avro data from within the chat interface.
-
Create SAP HANA Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP HANA from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Visualize PabblySubscriptions Data in Python with pandas
Use pandas and other modules to analyze and visualize live PabblySubscriptions data in Python.