CData Software - Knowledge Base
Recent Articles
-
Visualize eBay Data in Sisense
Create an ElastiCube in Sisense app with access to eBay data.
-
How to Easily Query Microsoft Entra ID Data in OpenOffice Base
Connect to Microsoft Entra ID data in OpenOffice Base using the CData ODBC Driver for Microsoft Entra ID and generate reports with live data insights.
-
Create Power BI Reports on Real-Time Supabase Data
Use the CData ODBC Driver for Supabase to visualize Supabase data in Power BI Desktop.
-
Create Zoho CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho CRM Data from Nintex Workflow Cloud and build custom workflows using live Zoho CRM data.
-
Replicate Aweber Data to Multiple Databases via the CData Sync CLI
Replicate Aweber data to disparate databases with a single configuration.
-
How to connect PolyBase to Sentry
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sentry data.
-
Query Box Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Box data from Node.js.
-
Moving Data from MariaDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MariaDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Microsoft Planner Data in JReport Designer
Create charts and reports based on Microsoft Planner data in JReport Designer.
-
Seamlessly Bring Suadeo Data into Retool Using CData Connect AI
Integrate Suadeo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Claude Code CLI with Azure Analysis Services 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 connect to Instantly Data from Spring Boot
Connect to Instantly in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating OpenCode with ActiveCampaign 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.
-
Automated Continuous Auth0 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Auth0 replication to Apache Cassandra.
-
Integrate Omnisend Data in Pentaho Data Integration
Build ETL pipelines based on Omnisend data in the Pentaho Data Integration tool.
-
Integrating Antigravity CLI with Microsoft Ads data via CData CLI
Connect Microsoft Ads data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate Productboard Data Replication to SAP HANA
Use CData Sync to customize and automate Productboard data replication to SAP HANA.
-
Easily Integrate Discourse Data in Lazarus Pascal IDE
Learn how to easily integrate live Discourse data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to & Open AlloyDB Data in Microsoft Excel
This article uses the CData ODBC driver for AlloyDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Cosmos DB 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 Cosmos DB data into TIBCO Spotfire.
-
Integrate Real-Time Access to QuickBooks Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to QuickBooks Online data in real time.
-
How to connect to Klaviyo Data in DBVisualizer
Integrate Klaviyo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Exa Data from AWS Glue
Use CData Connect AI to gain access to live Exa data from your AWS Glue jobs.
-
Analyze Confluence Data in Cognos Analytics
Use CData Connect AI to connect to Confluence Data from Cognos Analytics and analyze live Confluence data.
-
Enable the Outlook JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Outlook data.
-
Connecting Mastra with Act-On 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 Act-On data, no replication required.
-
Connect and Query Live Reckon Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Reckon data into Databricks and enable direct, live querying and analysis without replication.
-
Natively Connect to Cvent Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cvent data. Leverage the native support for ODBC in PHP.
-
Integrate Devin with Live Azure Analysis Services Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Azure Analysis Services data.
-
Integrate Live Twilio Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Twilio data and integrate live Twilio data into apps built in Microsoft Power Apps.
-
Use Dash to Build to Web Apps on Trello Data
Create Python applications that use pandas and Dash to build Trello-connected web apps.
-
How to Connect to QuickBooks Time Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Time data. Leverage the pyodbc module for ODBC in Python.
-
Import Figshare Data Using Azure Data Factory
Use CData Connect AI to connect to Figshare Data from Azure Data Factory and import live Figshare data.
-
How to work with Instagram Data in Apache Spark using SQL
Access and process Instagram Data in Apache Spark using the CData Software JDBC Driver.
-
Seamlessly Bring IBM Cloud Object Storage Data into Retool Using CData Connect AI
Integrate IBM Cloud Object Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Live Microsoft Entra ID 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 Microsoft Entra ID data through natural language.
-
Build a PostgreSQL Interface for Oracle Eloqua Reporting Data using the CData JDBC Driver
Use the Remoting features of the Oracle Eloqua Reporting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Certinia Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Certinia as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Dropbox in MicroStrategy Desktop
Connect to Dropbox data in MicroStrategy Desktop using the CData Software ODBC Driver for Dropbox.
-
Connect to Freshdesk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Freshdesk and the Script function in FileMaker Pro to connect to Freshdesk and work with Freshdesk data in your FileMaker application.
-
Integrate Nuclia Data in the Pentaho Report Designer
Publish reports based on Nuclia data in the Pentaho BI tool.
-
How to use SQLAlchemy ORM to access Ontraport Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Ontraport data.
-
Viewing Dynamics 365 Business Central Data in RAD Studio Data Explorer
How to view Dynamics 365 Business Central data in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics 365 Business Central.
-
How to connect to Optimizely Data with Squirrel SQL client
Connect to Optimizely data and execute queries in the Squirrel SQL Client.
-
Replicate Sage Cloud Accounting Data from PowerShell
Write a quick PowerShell script to query Sage Cloud Accounting data. Use connectivity to the live data to replicate Sage Cloud Accounting data to SQL Server.
-
Connect to Discourse Data in RazorSQL
Connect to Discourse from wizards and query Discourse data from the GUI in the RazorSQL database management tool.
-
Query Salesforce Marketing Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce Marketing entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for AfterShip in Microsoft Power Query
You can use the CData AfterShip ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import AfterShip data into Microsoft Power Query.
-
Connect to Dynamics CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Dynamics CRM data from HeidiSQL.
-
Configure the CData JDBC Driver for Dynamics NAV in a Connection Pool in Tomcat
Connect to Dynamics NAV data from a connection pool in Tomcat.
-
Build Snowflake-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Snowflake Data from Zoho Analytics and import live Snowflake data.
-
Create Informatica Mappings From/To a JDBC Data Source for MailChimp
Create MailChimp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Natively Connect to Amazon S3 Data in PHP
The CData ODBC driver for Amazon S3 enables you to create PHP applications with connectivity to Amazon S3 data. Leverage the native support for ODBC in PHP.
-
Import eBay Data Using Azure Data Factory
Use CData Connect AI to connect to eBay Data from Azure Data Factory and import live eBay data.
-
Connect and Query Live Wave Financial Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Wave Financial data into Databricks and enable direct, live querying and analysis without replication.
-
Create SSAS Tabular Models from Qualaroo Data
How to build a SQL Server Analysis Service Tabular Model from Qualaroo data using CData drivers.
-
Connect to Toggl Data from a Connection Pool in JBoss
Integrate Toggl data into Java servlets: Use the Management Console in JBoss to install the Toggl JDBC Driver.
-
Automated Continuous Airtable Replication to Oracle
Use CData Sync for automated, continuous, customizable Airtable replication to Oracle.
-
Connect to Salesloft Data in DBArtisan
Use wizards in DBArtisan to configure Salesloft data as a data source.
-
Automated Continuous ScrapingBee Replication to Snowflake
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Snowflake.
-
Integrate with Slack Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Slack data in SnapLogic.
-
Build SparkPost-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SparkPost Data and create custom apps in Mendix.
-
Automated Continuous Cloudflare Replication to MongoDB
Use CData Sync for automated, continuous, customizable Cloudflare replication to MongoDB.
-
Integrate Freshsales with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshsales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshsales data.
-
Automated Continuous OneNote Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable OneNote replication to PostgreSQL.
-
Connect to LeadDesk Data from a Connection Pool in JBoss
Integrate LeadDesk data into Java servlets: Use the Management Console in JBoss to install the LeadDesk JDBC Driver.
-
Connect to ZohoInvoice Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoInvoice data.
-
Automate EmailOctopus Data Replication to Couchbase
Use CData Sync to Customize and automate EmailOctopus data replication to Couchbase.
-
Visualize SFTP Data in TIBCO Spotfire through ADO.NET
Integrate SFTP data into dashboards in TIBCO Spotfire.
-
Build AgileCRM-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 AgileCRM data without replication.
-
Automated Continuous HelloSign Replication to Databricks
Use CData Sync for automated, continuous, customizable HelloSign replication to Databricks.
-
Connecting Pipedream with Acumatica Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Acumatica data in real time.
-
Connecting Pipedream with MailerLite Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on MailerLite data in real time.
-
Create Invoiced Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Invoiced from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live Simplesat Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Simplesat data.
-
DataBind Charts to Moosend Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Moosend data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous Dynamics CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to SingleStore.
-
Choosing the Best Method to Connect Outreach.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Outreach.io data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connecting Mastra with Avalara AvaTax 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 Avalara AvaTax data, no replication required.
-
Use Grok to Talk to Your Azure Table 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 Azure Table data for you.
-
Build Charts with Databricks Data in Clear Analytics
Create dynamic charts and perform analytics based on Databricks data in Clear Analytics.
-
Analyze RSS Feeds with Power Pivot
This article walks you through the process of using the CData ODBC Driver for RSS from Power Pivot. You will use the Table Import Wizard to load RSS feeds. You can visually build the import query or use any SQL supported by the driver.
-
Connect and Query Live SFTP Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SFTP data into Databricks and enable direct, live querying and analysis without replication.
-
Create Campaigner Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Campaigner data access from reports, embedded analytics, and more.
-
Automated Continuous Google Ad Manager Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Vertica.
-
Integrate Printify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Printify with External Services.
-
Build MVC Applications with Connectivity to Printify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Printify from an ASP.NET MVC application.
-
How to Connect to & Open Google Translate Data in Microsoft Excel
This article uses the CData ODBC driver for Google Translate to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Qualaroo Replication to MySQL
Use CData Sync for automated, continuous, customizable Qualaroo replication to MySQL.
-
Connect to LaunchDarkly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LaunchDarkly data in the Denodo Virtual DataPort Administrator.
-
Analyze GitLab Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GitLab from Power Pivot. You will use the Table Import Wizard to load GitLab data. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for ClickUp Data using the CData ODBC Driver
Use the SQL Gateway and ClickUp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Eventbrite Data in Power View
Create data visualizations based on Eventbrite data in Excel.
-
How to work with GetResponse Data in Apache Spark using SQL
Access and process GetResponse Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Zoho Books Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Books replication to Amazon S3.
-
Use the CData Software ODBC Driver for Coda in SAS for Real-Time Reporting and Analytics
Connect to real-time Coda data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Coda.
-
Create Informatica Mappings From/To a JDBC Data Source for Copper
Create Copper data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Python Connector for Bitly
Learn to install and license the CData Python Connector and configure a connection to live Bitly data.
-
Back Up Azure DevOps data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure DevOps. In this article, we will employ an SSIS workflow to populate a database with Azure DevOps data data.
-
DataBind Charts to Quaderno Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Quaderno data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.