CData Software - Knowledge Base
Recent Articles
-
Access Live OData Services in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate OData services into the statistical analysis tools available in SAS JMP. This article shows how to use OData services in the Graph Builder and Query Builder.
-
Query Nethunt Data in ColdFusion
Write standard ColdFusion data access code to connect to Nethunt data.
-
Publish Crystal Reports on Zoho Recruit Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Recruit data.
-
Integrating Claude Code CLI with Perplexity 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.
-
Integrate GraphQL Data in the Pentaho Report Designer
Publish reports based on GraphQL data in the Pentaho BI tool.
-
Bridge Printify Connectivity with Apache NiFi
Access and process Printify data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Acumatica Replication to SingleStore
Use CData Sync for automated, continuous, customizable Acumatica replication to SingleStore.
-
Use the CData ODBC Driver for Clio in Microsoft Power Query
You can use the CData Clio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Clio data into Microsoft Power Query.
-
Connect to NetSuite SuiteAnalytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access NetSuite SuiteAnalytics data in Google Apps Script.
-
How to Work with Klipfolio Data in ETL Validator JDBC
Connect to Klipfolio from ETL Validator jobs using the CData Software JDBC Driver.
-
Model, Search, and Visualize Live Blackbaud FE NXT Data in ThoughtSpot
Use CData Connect AI to connect to live Blackbaud FE NXT data for modeling, searching, and visualizing.
-
Use Azure AI Foundry to Talk to Your Reckon 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 Reckon data for you.
-
Integrating Cursor with Billsby 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.
-
Connect to Pipedrive Data in Aqua Data Studio
Access Pipedrive data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from Cassandra to Snowflake using CData SSIS Components.
Easily push Cassandra data to Snowflake using the CData SSIS Tasks for Cassandra and Snowflake.
-
Automated Continuous Dynamics 365 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Google BigQuery.
-
Connect to QuickBooks Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with QuickBooks Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Agents in Relevance AI with Access to Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on LinkedIn Ads data within intelligent agent workflows.
-
Replicate Zoom Data in Heroku for Use in Salesforce Connect
Replicate Zoom data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate with LeadDesk Data in JReport Designer
Create charts and reports based on LeadDesk data in JReport Designer.
-
How to Connect to & Open Amplitude Data in Microsoft Excel
This article uses the CData ODBC driver for Amplitude to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Trae with Live Azure Data Catalog Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Azure Data Catalog data from within the AI-powered IDE.
-
How to use SQLAlchemy ORM to access Missive Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Missive data.
-
Replicate Multiple Microsoft Ads Accounts
Replicate multiple Microsoft Ads accounts to one or many databases.
-
Build Apps with Live CampaignMonitor Data Using the Low-Code Development Platform of Mendix
Connect CampaignMonitor data with Mendix to build apps using the CData API Driver for JDBC.
-
How to create Visio diagrams from Airtable Data
Automatically update Airtable data with the changes you make to Visio master shapes.
-
Create Dashboards and Visualize Live Amazon DynamoDB Data in Geckoboard
Use CData Connect AI to connect to live Amazon DynamoDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use JayDeBeApi to access MYOB AccountRight Data in Python
Use standard Python scripting and the development environment of your choice to access live MYOB AccountRight data.
-
How to Connect to Live RSS Feeds in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your RSS feeds for you.
-
Use the CData ODBC Driver for OnePageCrm in Microsoft Power Query
You can use the CData OnePageCrm ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import OnePageCrm data into Microsoft Power Query.
-
Connect to ZohoPeople Data in HULFT Integrate
Connect to ZohoPeople as a JDBC data source in HULFT Integrate
-
Connect to Epicor Kinetic Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Epicor Kinetic data using standard SQL.
-
Connect Smartsheet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Smartsheet with IBM WebSphere for seamless data integration and connectivity.
-
Build an OLAP Cube in SSAS from SAP Data
Establish a connection to SAP data data from SQL Server Analysis Services, and use the SAP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Dash to Build to Web Apps on AfterShip Data
Create Python applications that use pandas and Dash to build AfterShip-connected web apps.
-
Working with Salesforce CRM Analytics Data in LINQPad
Execute LINQ queries to Salesforce CRM Analytics data in LINQPad.
-
Connect to Freshservice Data in Google Apps Script via Connect AI
Use CData Connect AI to access Freshservice data in Google Apps Script.
-
Build Charts with Foursquare Data in Clear Analytics
Create dynamic charts and perform analytics based on Foursquare data in Clear Analytics.
-
Analyze IBM Informix Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of IBM Informix data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Databricks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Databricks data into the statistical analysis tools available in SAS JMP. This article shows how to use Databricks data in the Graph Builder and Query Builder.
-
Rapidly Develop MessageBird-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 MessageBird.
-
Enable the Copper JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Copper data.
-
Build ZohoSubscriptions-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ZohoSubscriptions data and build ZohoSubscriptions-connected web apps with Axios.
-
Create Informatica Mappings From/To a JDBC Data Source for Guru
Create Guru data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Testmonitor Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Testmonitor data from your Google Sheets.
-
Replicate Bugsnag Data to Multiple Databases
Replicate Bugsnag data to disparate databases with a point-and-click configuration.
-
Connect to Testmonitor Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Testmonitor.
-
Model Stripe Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Stripe, enabling the direct import of real-time Stripe data.
-
Connect to MarkLogic Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MarkLogic data using standard SQL.
-
Create Apps from SAP Ariba Procurement Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Ariba Procurement Data and build apps from live SAP Ariba Procurement data in Qlik Sense Cloud.
-
Back Up Act-On data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Act-On. In this article, we will employ an SSIS workflow to populate a database with Act-On data data.
-
How to Query PostgreSQL Data in MySQL Workbench
Execute MySQL queries against live PostgreSQL data from MySQL Workbench.
-
Automated Continuous Instagram Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Instagram replication to AlloyDB.
-
Integrate with Perplexity Data in JReport Designer
Create charts and reports based on Perplexity data in JReport Designer.
-
A PostgreSQL Interface for SendGrid Data using the CData ODBC Driver
Use the SQL Gateway and SendGrid ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with Authorize.Net Data in Clear Analytics
Create dynamic charts and perform analytics based on Authorize.Net data in Clear Analytics.
-
Connect to Confluence Data from Crystal Reports
Use CData Connect AI to connect to and report on live Confluence data from Crystal Reports.
-
Getting Started with the CData ODBC Driver for Redis
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Redis.
-
Import Real-Time Invoiced Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Invoiced data in ColdFusion.
-
Use JayDeBeApi to access Reckon Data in Python
Use standard Python scripting and the development environment of your choice to access live Reckon data.
-
Create Databricks Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Databricks from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Spark Data in DataGrip
Create a Data Source for Spark in DataGrip and use SQL to query live Spark data.
-
How to Connect to Live Campaigner 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 Campaigner data for you.
-
Getting Started with the CData ADO.NET Provider for Act CRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Act CRM.
-
Choosing the Best Method to Connect Oracle Financials Cloud to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Financials Cloud data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
ETL DB2 in Oracle Data Integrator
This article shows how to transfer DB2 data into a data warehouse using Oracle Data Integrator.
-
How to Work with SAP Netweaver Gateway Data in ETL Validator JDBC
Connect to SAP Netweaver Gateway from ETL Validator jobs using the CData Software JDBC Driver.
-
Seamlessly Bring Oracle Eloqua Data into Retool Using CData Connect AI
Integrate Oracle Eloqua data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Process & Analyze Twilio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Twilio Data.
-
Use the CData Software ODBC Driver for FreeAgent in MicroStrategy Desktop
Connect to FreeAgent data in MicroStrategy Desktop using the CData Software ODBC Driver for FreeAgent.
-
Use Databricks Agent Bricks to Talk to Your SAP SuccessFactors Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP SuccessFactors data for you.
-
How to create an RPA flow for Quaderno Data in UiPath Studio
Use the Quaderno ODBC Driver to create workflows that access real-time Quaderno data without any coding.
-
How to load Avro data into Elasticsearch via Logstash
Introducing a simple method to load Avro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Claude to Talk to Your BigQuery 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 BigQuery data for you.
-
Working with Adobe Target Data in LINQPad
Execute LINQ queries to Adobe Target data in LINQPad.
-
Quaderno Reporting in OBIEE with the Quaderno JDBC Driver
Deploy the Quaderno JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData ADO.NET Provider for Slack
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Slack.
-
View Reports on Real-Time Twilio Data in Power BI Report Server
Use the CData ODBC Driver for Twilio to visualize Twilio data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Grafana-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Grafana Data and create custom apps in Mendix.
-
Connect to SAP BusinessObjects BI Data from a Connection Pool in JBoss
Integrate SAP BusinessObjects BI data into Java servlets: Use the Management Console in JBoss to install the SAP BusinessObjects BI JDBC Driver.
-
Getting Started with the CData Power BI Connector for MongoDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MongoDB.
-
Model QuickBooks Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and QuickBooks, enabling the direct import of real-time QuickBooks data.
-
Use the CData Software ODBC Driver for Reckon Accounts Hosted in MicroStrategy Web
Connect to Reckon Accounts Hosted data in MicroStrategy Web using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Connect Freshsales Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Freshsales data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate Intercom Data Replication to Couchbase
Use CData Sync to Customize and automate Intercom data replication to Couchbase.
-
Integrating GitHub Copilot with ClickUp 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.
-
Prepare, Blend, and Analyze Tally Data in Alteryx Designer (Connect AI)
Build workflows to access live Tally data for self-service data analytics.
-
Automate PhantomBuster Data Replication to SAP HANA
Use CData Sync to customize and automate PhantomBuster data replication to SAP HANA.
-
Back Up Tally data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Tally. In this article, we will employ an SSIS workflow to populate a database with Tally data data.
-
Migrating data from Sybase IQ to Databricks using CData SSIS Components.
Easily push Sybase IQ data to Databricks using the CData SSIS Tasks for Sybase IQ and Databricks.
-
Automated Continuous ActiveCampaign Replication to Snowflake
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Snowflake.
-
How to import Elasticsearch Data into Apache Solr
Use the CData Software JDBC Driver for Elasticsearch in Data Import Handler and create an automated import of Elasticsearch data to Apache Solr Enterprise Search platform.
-
Automated Continuous ServiceDesk Plus Replication to Oracle
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Oracle.
-
How to Easily Query Amazon Athena Data in OpenOffice Base
Connect to Amazon Athena data in OpenOffice Base using the CData ODBC Driver for Amazon Athena and generate reports with live data insights.
-
Access Mixpanel Data from MySQL in Amazon QuickSight
Connect to Mixpanel and build visualizations of Mixpanel data using a MySQL Connection in Amazon QuickSight.
-
Create Reports from SAP Business Warehouse Data in Looker Studio
Use CData Connect AI to gain access to live SAP Business Warehouse data and create custom reports in Looker Studio.
-
Access Live Zoom Data in AWS Lambda
Connect to live Zoom data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Telegram Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Telegram replication to Amazon S3.
-
How to load Act CRM data into Elasticsearch via Logstash
Introducing a simple method to load Act CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for Asana in Microsoft Power Query
You can use the CData Asana ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Asana data into Microsoft Power Query.