CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Amazon Athena Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amazon Athena replication to PostgreSQL.
-
Connect ZohoMarketingHub Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoMarketingHub using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software ODBC Driver for TaxJar in MicroStrategy Desktop
Connect to TaxJar in MicroStrategy Desktop using the CData Software ODBC Driver for TaxJar.
-
Automated Continuous Stack Exchange Replication to SingleStore
Use CData Sync for automated, continuous, customizable Stack Exchange replication to SingleStore.
-
Create Data Visualizations in Cognos BI with Salesforce Data
Access Salesforce & Force.com as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect SAS Data Sets to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAS Data Sets using the CData Python MCP Server.
-
Natively Connect to Scrapfly Data in PHP
The CData ODBC driver for Scrapfly enables you to create PHP applications with connectivity to Scrapfly. Leverage the native support for ODBC in PHP.
-
Connect to Live MarkLogic Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MarkLogic in CData Connect AI and connect to your MarkLogic from PostgreSQL.
-
Visualize Redshift Data in TIBCO Spotfire through OData
Integrate Amazon Redshift into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Active Directory in MicroStrategy Web
Connect to Active Directory in MicroStrategy Web using the CData Software ODBC Driver for Active Directory.
-
Import Real-Time Vercel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Vercel in ColdFusion.
-
Automate SAP BusinessObjects BI Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP BusinessObjects BI replication to Azure Synapse.
-
Moving Data from BigCommerce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BigCommerce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Work with Productboard Data in AWS Glue Jobs Using JDBC
Connect to Productboard from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Seamlessly Import Placid Data into IBM SPSS Modeler
Integrate Placid data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Jodoo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Jodoo and the SQL Gateway to access Jodoo from Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Clockify
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate SAP ByDesign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP ByDesign with External Services.
-
Integrate LibreChat with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Dynamics CRM from within the chat interface.
-
Connect to SageHR Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to SageHR and work with SageHR in your FileMaker applications.
-
Access Live Azure DevOps Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure DevOps from your Google Sheets.
-
How to connect to Postmark Data from IntelliJ
Integrate connectivity to Postmark with wizards in IntelliJ.
-
Automated Continuous Printful Replication to Snowflake
Use CData Sync for automated, continuous, customizable Printful replication to Snowflake.
-
Connect to Workable Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Workable in the Denodo Virtual DataPort Administrator.
-
View Reports on Real-Time Superchat Data in Power BI Report Server
Use the CData ODBC Driver for Superchat to visualize Superchat in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect GitHub Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live GitHub data in real time using natural language.
-
Create WordPress-Connected Nintex Workflows
Use CData Connect AI to connect to WordPress Data from Nintex Workflow Cloud and build custom workflows using live WordPress.
-
How to Visualize Sage Intacct Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sage Intacct in Python.
-
Getting Started with the CData JDBC Driver for Suadeo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Suadeo.
-
Integrating GitHub Copilot CLI with SAP Business One 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.
-
Access Live QuickBooks Online Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to QuickBooks Online from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Explore Geographical Relationships in ActiveCampaign Data with Power Map
Create data visualizations with ActiveCampaign in Power Map.
-
Use Biml to Build SSIS Tasks to Replicate Shopify Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Shopify to SQL Server.
-
Build Semantic Layer Views for Demio Data in APOS Live Data Gateway
Use the CData Connector for Demio in APOS Live Data Gateway to build Semantic Layer Views for Demio.
-
Easily Integrate Placid Data in Lazarus Pascal IDE
Learn how to easily integrate live Placid in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Apps with Live SpaceX Data Using the Low-Code Development Platform of Mendix
Connect SpaceX with Mendix to build apps using the CData API Driver for JDBC.
-
Migrating data from Authorize.Net to Databricks using CData SSIS Components.
Easily push Authorize.Net to Databricks using the CData SSIS Tasks for Authorize.Net and Databricks.
-
Enable the SAP HANA JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP HANA.
-
Automate Tanda Data Replication to Azure Synapse
Use CData Sync to customize and automate Tanda replication to Azure Synapse.
-
Consume Databricks OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Databricks feeds that reflect any changes in SAP Lumira.
-
Connect to and Visualize Live ZohoExpense Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZohoExpense.
-
Getting Started with the CData Connect AI Python SDK for BigCommerce
Install the CData Connect AI Python SDK to read and write live BigCommerce with standard DB-API 2.0 Python code.
-
Integrate Live Authorize.Net Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
DataBind Salesforce Marketing Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesforce Marketing with the DevExpress Windows Forms and Web controls to provide Salesforce Marketing Cloud to a chart.
-
Integrating Kiro CLI with Printful 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 Workday Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Workday replication to Google Cloud SQL.
-
Create Datasets from RSS in Domo Workbench and Build Visualizations of RSS Feeds in Domo
Use the CData Software ODBC Driver for RSS to create datasets from RSS Feeds in Domo Workbench and then build visualizations in the Domo service.
-
Build Data Flows from Apify to SQL Server using SSIS
Easily back up Apify to SQL Server using the SSIS components for Apify.
-
Query REST Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume REST entities in PHP by modeling them as objects.
-
Import Exact Online Data Using Azure Data Factory
Use CData Connect AI to connect to Exact Online Data from Azure Data Factory and import live Exact Online.
-
How to publish and share DB2 Data dashboards with Tableau Server
The CData ODBC driver for DB2 enables you integrate IBM DB2 into Tableau dashboards.
-
Connect to Live JSON Services in PostGresSQL Interface through CData Connect AI
Create a live connection to JSON in CData Connect AI and connect to your JSON from PostgreSQL.
-
Excel Spreadsheet Automation on Authorize.Net Data with the QUERY Formula
Pull data from Authorize.Net, automate spreadsheets, and more with the QUERY formula.
-
Connect Vercel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Vercel using the CData Python MCP Server.
-
Automated Continuous YouTube Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to PostgreSQL.
-
Connect to SAP ByDesign Data in DBeaver
Use the CData ODBC Driver to connect to SAP Business ByDesign in DBeaver.
-
Automated Continuous JSON Replication to IBM DB2
Use CData Sync for automated, continuous, customizable JSON replication to IBM DB2.
-
Displaying Data from Related Tables Using Angular with the API Server
Use the API Server and Angular to build a Web App to dynamically display related tables.
-
Visualize Live Samanage Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Samanage.
-
Access Live Jumpseller Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Jumpseller in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Using the CData Software ODBC Driver for Zoho Projects in PyCharm
Connect to Zoho Projects as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Projects.
-
Query Google Cloud Storage Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Cloud Storage.
-
Explore Geographical Relationships in Avaza Data with Power Map
Create data visualizations with Avaza in Power Map.
-
Access ScrapingBee Data from MySQL in PHP
Connect to ScrapingBee through the standard MySQL libraries in PHP.
-
How to Access Live CircleCI Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CircleCI enables you to integrate CircleCI into workflows built using Microsoft Power Automate Desktop.
-
Rapidly Develop Front-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 Front.
-
Access Live Nethunt Data in Coginiti Pro
Connect to and query live Nethunt from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
Create Dashboards and Visualize Live Zendesk Data in Geckoboard
Use CData Connect AI to connect to live Zendesk and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Gong Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Gong and work with Gong in your FileMaker applications.
-
Automate Salesforce CRM Analytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate Salesforce CRM Analytics replication to Azure Data Lake.
-
Integrate Missive Data in the Pentaho Report Designer
Publish reports based on Missive in the Pentaho BI tool.
-
Access QuickBooks Online Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Online from HeidiSQL.
-
Build a Singer.io Tap for iContact With the CData Python Connector
Learn how to easily build a Singer.io Tap for live iContact data using
-
DataBind Controls to AgileCRM Data in C++Builder
DataBind to AgileCRM in C++Builder with standard components and controls.
-
Access Live Webex Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Webex in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Power BI Connector for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create HBase-Connected Business Apps in AppSheet
Connect to HBase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache HBase.
-
Getting Started with the CData Python Connector for SAP ByDesign
Learn to install and license the CData Python Connector
-
How to create an RPA flow for Dropbox Data in UiPath Studio
Use the Dropbox ODBC Driver to create workflows that access real-time Dropbox without any coding.
-
Import BigCommerce Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to BigCommerce Data and provide access to live BigCommerce for custom reports in the Power BI Service.
-
How to Seamlessly Import Bannerbear Data into IBM SPSS Modeler
Integrate Bannerbear data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Jira Assets Data in Claris FileMaker Pro
Use the CData ODBC Driver for Jira Assets in FileMaker Pro to connect to Jira Assets and work with Jira Assets in your FileMaker applications.
-
How to work with Notion Data in Apache Spark using SQL
Access and process Notion Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to HCL Domino Data in Ruby
Connect to HCL Domino in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Jumpseller Replication to Oracle
Use CData Sync for automated, continuous, customizable Jumpseller replication to Oracle.
-
Work with Live SAP Hybris C4C Data in Power Query
Use CData Connect AI to connect to SAP Hybris C4C and work with live SAP Hybris C4C in Microsoft Power Query.
-
Access Live Azure Analysis Services Data in Coginiti Pro
Connect to and query live Azure Analysis Services from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Migrating data from Parquet to Snowflake using CData SSIS Components.
Easily push Apache Parquet to Snowflake using the CData SSIS Tasks for Parquet and Snowflake.
-
Connect to Certinia Data in NetBeans
Connect to Certinia in NetBeans with the data source configuration wizard.
-
Connect to Aha! Data in DBArtisan
Use wizards in DBArtisan to configure Aha! as a data source.
-
Excel Spreadsheet Automation on Dropbox Data with the QUERY Formula
Pull data from Dropbox, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from Phoenix to Snowflake using CData SSIS Components.
Easily push Apache Phoenix to Snowflake using the CData SSIS Tasks for Phoenix and Snowflake.
-
Integrate Oracle Service Cloud with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Service Cloud with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Service Cloud.
-
Create Planio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Planio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connecting Moonlit Workflow with SendGrid Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SendGrid in real time.
-
Query Live Greenhouse Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Greenhouse directly from the development environment.
-
Extract, Transform, and Load PagerDuty Data in Informatica PowerCenter
Create a simple Workflow for PagerDuty in Informatica PowerCenter.
-
Object-Relational Mapping (ORM) with Pipedrive 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 Pipedrive into a Java-based ORM framework, Hibernate.
-
Integrate Theia IDE with Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE