CData Software - Knowledge Base
Recent Articles
-
How to connect to Zoho Books Data from Spring Boot
Connect to Zoho Books in a Spring Boot Application using the CData JDBC Driver for Zoho Books
-
How to Access HDFS Data Using Entity Framework
This article shows how to access HDFS data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Deploy the ADO.NET Provider for Teamgate on an SSRS Report Server
Connect to Teamgate 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.
-
Automated Continuous Hubstaff Replication to SQLite
Use CData Sync for automated, continuous, customizable Hubstaff replication to SQLite.
-
Getting Started with the CData Python Connector for Moosend
Learn to install and license the CData Python Connector and configure a connection to live Moosend data.
-
Integrate Live Zoho Books Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Books from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Books data.
-
Automate Wistia Data Replication to SAP HANA
Use CData Sync to customize and automate Wistia data replication to SAP HANA.
-
Create Apify-Connected Business Apps in AppSheet
Connect to Apify Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apify data.
-
Connect CircleCI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CircleCI data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Sage 200 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage 200 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import SAP SuccessFactors Data Using Azure Data Factory
Use CData Connect AI to connect to SAP SuccessFactors Data from Azure Data Factory and import live SAP SuccessFactors data.
-
Integrate Trae with Live HubDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live HubDB data from within the AI-powered IDE.
-
Build Aircall-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Aircall data.
-
How to connect and process Gong data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Gong data.
-
Integrate Workday with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Workday with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Workday data.
-
Connect to and Query Microsoft Dataverse Data in QlikView over ODBC
Create data visualizations with Microsoft Dataverse data in QlikView.
-
Design BIRT Reports on Oracle Eloqua Data
Provide current Oracle Eloqua data to your embedded analytics.
-
Connect to and Query SAP Ariba Procurement Data in QlikView over ODBC
Create data visualizations with SAP Ariba Procurement data in QlikView.
-
Connect to Microsoft Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Ads data from Filemaker Pro on Mac.
-
Automated Continuous Zoho Recruit Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho Recruit data replication to OneLake in Microsoft Fabric.
-
A PostgreSQL Interface for ZeroBounce Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZeroBounce JDBC Driver to create a PostgreSQL entry-point for data access.
-
FAQ: Licensing and Deploying Builds of Finished Applications
Follow these instructions to test, build, and distribute apps using the CData single developer, royalty-free license.
-
Connect to Apollo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Apollo to connect to Apollo data and execute queries in PowerBuilder.
-
How to Connect to Live iContact 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 iContact data for you.
-
Use the CData Software JDBC Driver for Auth0 in MicroStrategy
Connect to Auth0 data in MicroStrategy Developer using the CData Software JDBC Driver for Auth0.
-
Analyze LinkedIn Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn Ads data and visualize live LinkedIn Ads data in Infragistics Reveal.
-
Build Dashboards with Yelp Data in DBxtra
Create dynamic dashboards and perform analytics based on Yelp data in DBxtra.
-
Integrating LangChain with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Search results within automated workflows.
-
How to Connect to Omnisend Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Omnisend data. Leverage the pyodbc module for ODBC in Python.
-
Import Real-Time Excel Online Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Excel Online data in ColdFusion.
-
Enable the LDAP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LDAP objects.
-
DataBind Mode Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mode data to a chart.
-
Use CData Connect AI to Access Cosmos DB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Cosmos DB data in the Power Pivot business intelligence tool.
-
How to Create Power BI Visual Reports with Real-Time Gumroad Data
Use CData Power BI Connectors to visualize Gumroad data in Power BI.
-
Integrate Factorial with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Factorial with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Factorial data.
-
Access Live Scrapfly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Scrapfly data into the statistical analysis tools available in SAS JMP. This article shows how to use Scrapfly data in the Graph Builder and Query Builder.
-
How to connect to Zendesk Data from IntelliJ
Integrate connectivity to Zendesk data with wizards in IntelliJ.
-
Build Amazon Athena-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Amazon Athena data without replication.
-
Integrate with Dropbox Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Dropbox data in SnapLogic.
-
Integrating LlamaIndex with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle SCM data in real time.
-
Connect to Adobe Target Data in RazorSQL
Connect to Adobe Target from wizards and query Adobe Target data from the GUI in the RazorSQL database management tool.
-
Object-Relational Mapping (ORM) with DocuSign 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 DocuSign data into a Java-based ORM framework, Hibernate.
-
Access Live Dotmailer Data in Coginiti Pro
Connect to and query live Dotmailer data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create MariaDB-Connected Dashboards in Grafana
Connect to MariaDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MariaDB data.
-
A PostgreSQL Interface for DocuSign Data (MySQL Remoting via JDBC)
Use the Remoting features of the DocuSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Zoho Inventory Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Inventory data to a JSON file on disk.
-
Connecting GenSpark with SuiteCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SuiteCRM data without any replication or custom integration required.
-
Connect to Gmail Data from HeidiSQL
Use CData Connect AI to connect to and query live Gmail data from HeidiSQL.
-
How to Access Live Pipeliner CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pipeliner CRM enables you to integrate Pipeliner CRM data into workflows built using Microsoft Power Automate Desktop.
-
Connecting GenSpark with SAP SuccessFactors LMS Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP SuccessFactors LMS data without any replication or custom integration required.
-
Use the CData SSIS Components to Insert New or Update Existing Zoho Creator Records from SQL Server
Easily push SQL Server data to Zoho Creator using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zoho Creator or update existing records with data from a SQL Server database.
-
Bidirectional Access to Oracle Sales Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Sales data in Filemaker Pro for Mac or Windows.
-
How to Access Invoiced Data Using Entity Framework
This article shows how to access Invoiced data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate EnterpriseDB Data to Multiple Databases via the CData Sync CLI
Replicate EnterpriseDB data to disparate databases with a single configuration.
-
Integrate with Printify Data in JReport Designer
Create charts and reports based on Printify data in JReport Designer.
-
ETL CapsuleCRM in Oracle Data Integrator
This article shows how to transfer CapsuleCRM data into a data warehouse using Oracle Data Integrator.
-
Automate Freshsales Data Replication to Azure Data Lake
Use CData Sync to customize and automate Freshsales data replication to Azure Data Lake.
-
Use the CData Software JDBC Driver for Float in MicroStrategy
Connect to Float data in MicroStrategy Developer using the CData Software JDBC Driver for Float.
-
Connect Accelo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Accelo with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Cassandra Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cassandra JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query, Visualize, and Share live Microsoft Planner Data in Redash
Use CData Connect AI to connect to live Microsoft Planner data in Redash for querying, visualizing, and sharing.
-
How to connect to Google Translate Data in DBVisualizer
Integrate Google Translate data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Aweber Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Aweber replication to IBM DB2.
-
Google Ad Manager Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Ad Manager facts in real time.
-
How to create JotForm federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for JotForm data in MySQL .
-
Use the CData Software ODBC Driver for AfterShip in SAS for Real-Time Reporting and Analytics
Connect to real-time AfterShip data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for AfterShip.
-
Connect to Oracle Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle data.
-
Getting Started with the CData Python Connector for QuickBooks
Learn to install and license the CData Python Connector and configure a connection to live QuickBooks data.
-
How to Work with Samanage Data in ETL Validator JDBC
Connect to Samanage from ETL Validator jobs using the CData Software JDBC Driver.
-
Easily Integrate GetResponse Data in Lazarus Pascal IDE
Learn how to easily integrate live GetResponse data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect and Visualize Live Mode Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Mode data into the Databricks platform and create visualization dashboards with real-time Mode data.
-
Analyze Mailjet Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Mailjet data and visualize Mailjet data in SAP Analytics Cloud.
-
Build Sage Intacct-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sage Intacct Data and create custom apps in Mendix.
-
Create Salesforce CRM Analytics-Connected Nintex Workflows
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Nintex Workflow Cloud and build custom workflows using live Salesforce CRM Analytics data.
-
Design BIRT Reports on Vault CRM Data
Provide current Vault CRM data to your embedded analytics.
-
Use CData Connect AI to Access Jumpseller Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Jumpseller data in the Power Pivot business intelligence tool.
-
How to Connect to Live AfterShip 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 AfterShip data for you.
-
Automated Continuous PolarTeamPro Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Google Cloud SQL.
-
DataBind Sybase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sybase with the DevExpress Windows Forms and Web controls to provide Sybase data to a chart.
-
Connect to Jumpseller Data in Ruby
Connect to Jumpseller data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Load ServiceNow Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ServiceNow data to a database.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy Desktop
Connect to Customer.io data in MicroStrategy Desktop using the CData Software ODBC Driver for Customer.io.
-
Connect to Suadeo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Suadeo data from Appeon PowerBuilder using the CData ADO.NET Provider for Suadeo.
-
Connect SuiteCRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SuiteCRM with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SAP Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP to connect to SAP data and execute queries in PowerBuilder.
-
How to Query Live Pingdom Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pingdom data data in natural language using Python.
-
Automate Email Data Replication to Azure Data Lake
Use CData Sync to customize and automate Email data replication to Azure Data Lake.
-
Connect to Workday Data from a Connection Pool in JBoss
Integrate Workday data into Java servlets: Use the Management Console in JBoss to install the Workday JDBC Driver.
-
Integrate FreshBooks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FreshBooks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FreshBooks data.
-
Build Apps with Live ZohoExpense Data Using the Low-Code Development Platform of Mendix
Connect ZohoExpense data with Mendix to build apps using the CData API Driver for JDBC.
-
Bind Live GraphQL Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live GraphQL data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Semantic Layer Views for SendPulse Data in APOS Live Data Gateway
Use the CData Connector for SendPulse in APOS Live Data Gateway to build Semantic Layer Views for SendPulse data.
-
Build Sage 200-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sage 200 Data from Zoho Analytics and import live Sage 200 data.
-
Create Egnyte-Connected Applications in Appsmith
Connect to Egnyte Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Egnyte data.
-
Connect Miro Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Miro data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build an OLAP Cube in SSAS from SAP ByDesign Data
Establish a connection to SAP ByDesign data data from SQL Server Analysis Services, and use the SAP ByDesign Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Dashboards with Yelp Data in Dundas BI
Create dynamic dashboards and perform analytics based on Yelp data in Dundas BI.
-
Connect to Google Search Results in HULFT Integrate
Connect to Google Search as a JDBC data source in HULFT Integrate
-
Automated Continuous Reckon Accounts Hosted Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to delimited files (CSV/TSV).
-
Integrate Goose with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live PayPal data from within the local AI agent.