CData Software - Knowledge Base
Recent Articles
-
Enable the Webflow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Webflow.
-
Create a Data Access Object for Elasticsearch Data using JDBI
A brief overview of creating a SQL Object API for Elasticsearch in JDBI.
-
Analyze MYOB AccountRight Data in Cognos Analytics
Use CData Connect AI to connect to MYOB AccountRight Data from Cognos Analytics and analyze live MYOB AccountRight.
-
Import Real-Time QuickBooks Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Desktop in ColdFusion.
-
Access Live Freshservice Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshservice into the statistical analysis tools available in SAS JMP. This article shows how to use Freshservice in the Graph Builder and Query Builder.
-
Connect Shortcut to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Shortcut using the CData Python MCP Server.
-
Back Up CockroachDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CockroachDB. In this article, we will employ an SSIS workflow to populate a database with CockroachDB data.
-
Back Up QuickBooks Desktop to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for QuickBooks. In this article, we will employ an SSIS workflow to populate a database with QuickBooks Desktop data.
-
Integrate Adobe Experience Manager Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Experience Manager from Informatica Cloud.
-
Bind Live Harvest Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Harvest data
-
Connect to HubDB in SpagoBI
Create reports featuring live HubDB in SpagoBI Studio. Host HubDB reports on SpagoBI Server.
-
Enable the VWO JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with VWO.
-
Build Semantic Layer Views for Cosmos DB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Cosmos DB.
-
Manage Basecamp Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Basecamp.
-
Validate SAP SuccessFactors LMS Data with QuerySurge
Access and validate SAP SuccessFactors LMS in QuerySurge using the CData JDBC Driver.
-
How to load Klipfolio data into Elasticsearch via Logstash
Introducing a simple method to load Klipfolio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
A PostgreSQL Interface for SAP Ariba Procurement Data using the CData ODBC Driver
Use the SQL Gateway and SAP Ariba Procurement ODBC Driver to create a PostgreSQL entry-point for data access.
-
CData AWS Glue Connector for Salesforce Deployment Guide
A detailed deployment and usage guide for the CData AWS Glue Connector for Salesforce
-
Automated Continuous Todoist Replication to SQL Server
Use CData Sync for automated, continuous, customizable Todoist replication to SQL Server.
-
Visualize Close Data in Sisense
Create an ElastiCube in Sisense app with access to Close.
-
Build AI/ML Models with Live Customer.io Data using Dataiku
Connect Customer.io Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to Quaderno Data with Squirrel SQL client
Connect to Quaderno and execute queries in the Squirrel SQL Client.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy
Connect to Customer.io in MicroStrategy Developer using the CData Software ODBC Driver for Customer.io.
-
Getting Started with the CData SSIS Components for Perplexity
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Perplexity.
-
Automate SuiteCRM Data Replication to Azure Synapse
Use CData Sync to customize and automate SuiteCRM replication to Azure Synapse.
-
How to integrate Reckon Accounts Hosted with Apache Airflow
Access and process Reckon Accounts Hosted in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous HubSpot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HubSpot replication to Apache Cassandra.
-
Build Act-On-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Act-On and build Act-On-connected web apps with Axios.
-
Build Charts with Avalara AvaTax Data in Clear Analytics
Create dynamic charts and perform analytics based on Avalara AvaTax in Clear Analytics.
-
Use JayDeBeApi to access QuickBooks Data in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks Desktop.
-
Visualize Live Printful Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Printful.
-
Import Real-Time ZendeskSell Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZendeskSell in ColdFusion.
-
Connect to Mailgun Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mailgun in the Denodo Virtual DataPort Administrator.
-
Connect to Epicor Kinetic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Epicor Kinetic.
-
Automated Continuous BigCommerce Replication to Vertica
Use CData Sync for automated, continuous, customizable BigCommerce replication to Vertica.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Ad Manager
Create Google Ad Manager data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate Multiple Basecamp Accounts via the CData Sync CLI
Replicate multiple Basecamp accounts to one or many databases.
-
Build MVC Applications with Connectivity to Close Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Close from an ASP.NET MVC application.
-
How to Connect to Live Paylocity Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Paylocity without replication.
-
Establish a Live Connection with Klaviyo Data using Tableau Bridge
The CData ODBC Driver for Klaviyo enables you to integrate live Klaviyo into Tableau Cloud dashboards using the Tableau Bridge.
-
Work with Live SAP Ariba Source Data in Power Query
Use CData Connect AI to connect to SAP Ariba Source and work with live SAP Ariba Source in Microsoft Power Query.
-
Replicate Shortcut Data in Heroku for Use in Salesforce Connect
Replicate Shortcut to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build ConstantContact-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live ConstantContact Data in Cursor to assist with building ConstantContact-powered applications.
-
Build AI/ML Models with Live Excel Data using Dataiku
Connect Excel Data with Dataiku using the CData JDBC Driver for Microsoft Excel.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zoho Books to Power BI dashboards. Simply drag and drop Zoho Books into data visuals on the Power BI canvas.
-
Visualize Klaviyo Data in TIBCO Spotfire through ADO.NET
Integrate Klaviyo into dashboards in TIBCO Spotfire.
-
Automated Continuous Excel Online Replication to Databricks
Use CData Sync for automated, continuous, customizable Excel Online replication to Databricks.
-
Create SSAS Tabular Models from Office 365 Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Office 365 using CData drivers.
-
How to integrate Metabase with DB2 Data
Use CData Connect AI to connect to live IBM DB2 and create an interactive dashboard in Metabase from IBM DB2.
-
Connect to Microsoft Teams Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Teams to connect to Microsoft Teams and execute queries in PowerBuilder.
-
Create Apps from JSON Services in Qlik Sense Cloud
Use CData Connect AI to connect to JSON Services and build apps from live JSON in Qlik Sense Cloud.
-
Visualize Live Gong Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Gong into custom reports in Power BI.
-
Consume Azure DevOps OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure DevOps feeds that reflect any changes in SAP Lumira.
-
Visualize MariaDB Data in Tableau
The CData ODBC driver for MariaDB enables you integrate MariaDB into Tableau dashboards.
-
Build Vertica-Connected Apps in Choreo
Use CData Connect AI to connect to Vertica Data from Choreo and build custom apps using live Vertica.
-
Consume Postmark OData Feeds in PowerBuilder
This article demonstrates how to consume Postmark as OData feeds from PowerBuilder using the API Server.
-
Integrating Bannerbear Data in Talend Cloud Data Management Platform
Connect Bannerbear Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Tanda Replication to Snowflake
Use CData Sync for automated, continuous, customizable Tanda replication to Snowflake.
-
Build MySQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MySQL.
-
Connect to Basecamp from Asprova with CData Software ODBC Driver for Basecamp
This article shows how to connect faster to Basecamp data from Asprova.
-
Query Opsgenie Data in DataGrip
Create a Data Source for Opsgenie in DataGrip and use SQL to query live Opsgenie.
-
Build MVC Applications with Connectivity to iContact Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access iContact from an ASP.NET MVC application.
-
How to Connect DBeaver to Notion via a JDBC Driver
Manage Notion with visual tools in DBeaver like the query browser.
-
Connecting Mastra with Redis 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 Redis, no replication required.
-
Publish Crystal Reports on Recurly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Recurly.
-
Access Parquet 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 Apache Parquet.
-
Create Informatica Mappings From/To a JDBC Data Source for Instantly
Create Instantly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Smartsheet
Provide connectivity to Smartsheet through an SAP BusinessObjects universe.
-
Connect to ActiveCampaign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ActiveCampaign, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to load CSV data into Elasticsearch via Logstash
Introducing a simple method to load CSV data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData JDBC Driver for Jodoo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jodoo.
-
Build Apps with Live ConvertKit Data Using the Low-Code Development Platform of Mendix
Connect ConvertKit with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Microsoft OneLake Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Apache Kafka.
-
How to Connect to Live BigCommerce Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your BigCommerce through natural language.
-
Integrating Claude Code CLI with ConvertKit 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.
-
Bridge Reckon Accounts Hosted Connectivity with Apache NiFi
Access and process Reckon Accounts Hosted in Apache NiFi using the CData JDBC Driver.
-
Model Dynamics CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics CRM, enabling the direct import of real-time Microsoft Dynamics CRM.
-
Automated Continuous Xero Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Xero replication to IBM DB2.
-
Build Pinecone-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Pinecone Data in Cursor to assist with building Pinecone-powered applications.
-
Create Power BI Reports on Real-Time ZendeskSell Data
Use the CData ODBC Driver for ZendeskSell to visualize ZendeskSell in Power BI Desktop.
-
Build a PostgreSQL Interface for Paylocity Data using the CData JDBC Driver
Use the Remoting features of the Paylocity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Live Zoho Books Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoho Books from the MuleSoft Anypoint Platform to integrate live Zoho Books into custom reports and dashboards.
-
Connect to PhantomBuster Data in RazorSQL
Connect to PhantomBuster from wizards and query PhantomBuster from the GUI in the RazorSQL database management tool.
-
Provide OData Services of Datadog Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Datadog by developing a WCF Service Application.
-
Connect to Wrike Data in JRuby
Create a simple JRuby app with access to live Wrike.
-
Integrate with live Asana Data in Jitterbit
Use CData Connect AI to connect to and integrate live Asana in Jitterbit.
-
Connect to Presto Data from a Connection Pool in JBoss
Integrate Presto into Java servlets: Use the Management Console in JBoss to install the Presto JDBC Driver.
-
Build Semantic Layer Views for Google Calendar Data in APOS Live Data Gateway
Use the CData Connector for Google Calendar in APOS Live Data Gateway to build Semantic Layer Views for Google Calendar.
-
Integrating LangChain with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apache Avro within automated workflows.
-
How to Connect to Live Zoho Projects Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Zoho Projects for you.
-
Visualize SuiteCRM Data in TIBCO Spotfire through ADO.NET
Integrate SuiteCRM into dashboards in TIBCO Spotfire.
-
Design BIRT Reports on Zoho CRM Data
Provide current Zoho CRM to your embedded analytics.
-
How to create an RPA flow for Avro Data in UiPath Studio
Use the Avro ODBC Driver to create workflows that access real-time Apache Avro without any coding.
-
DataBind Controls to Google Spanner Data in Delphi
DataBind to Google Spanner in Delphi with standard data access components and controls.
-
How to import Suadeo Data into Apache Solr
Use the CData Software JDBC Driver for Suadeo in Data Import Handler and create an automated import of Suadeo to Apache Solr Enterprise Search platform.
-
Create Informatica Mappings From/To an ODBC Data Source for PabblySubscriptions
Create an ODBC connection to PabblySubscriptions in Informatica and browse and transfer PabblySubscriptions.
-
Create Slack-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Slack Data from OutSystems and build custom enterprise apps using live Slack.
-
Manage Reckon Accounts Hosted Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Reckon Accounts Hosted.
-
Object-Relational Mapping (ORM) with SAP Business One 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 SAP Business One into a Java-based ORM framework, Hibernate.
-
Automate ZendeskSell Data Replication to SAP HANA
Use CData Sync to customize and automate ZendeskSell replication to SAP HANA.