CData Software - Knowledge Base
Recent Articles
-
Connect to Productboard Data in DBeaver
Use the CData ODBC Driver to connect to Productboard in DBeaver.
-
Prepare, Blend, and Analyze Tally Data in Alteryx Designer (Connect AI)
Build workflows to access live Tally ERP for self-service data analytics.
-
Design BIRT Reports on Google Campaign Manager 360 Data
Provide current Google Campaign Manager 360 to your embedded analytics.
-
Automated Continuous SAP Fieldglass Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to MongoDB.
-
How to connect to Lakebase Data in DBVisualizer
Integrate Lakebase with visual data analysis tools and data connection wizards in DBVisualizer
-
Import Real-Time SAP SuccessFactors LMS Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP SuccessFactors LMS in ColdFusion.
-
Getting Started with the CData ODBC Driver for Avro
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Avro.
-
How to Create Power BI Visual Reports with Real-Time Google Tasks Data
Use CData Power BI Connectors to visualize Google Tasks in Power BI.
-
Integrating Claude Code with Xero Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Xero Accounting within assisted coding and automated development workflows.
-
How to Connect to Live BigCommerce Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live BigCommerce securely in real time.
-
Automated Front Data Replication to Teradata
Use CData Sync to Customize and automate Front replication to Teradata.
-
Connect to SingleStore Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SingleStore in Airbyte.
-
Connect to Sybase IQ Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sybase IQ Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Sage 300-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sage 300 to explore live Sage 300 Data in Cursor to assist with building Sage 300-powered applications.
-
Integrating Claude Code CLI with SAP Ariba Procurement 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 & Open Rebilly Data in Microsoft Excel
This article uses the CData ODBC driver for Rebilly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with WordPress Data in DBxtra
Create dynamic dashboards and perform analytics based on WordPress in DBxtra.
-
Establish a Live Connection with Clockify Data using Tableau Bridge
The CData ODBC Driver for Clockify enables you to integrate live Clockify into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Biml to Build SSIS Tasks to Replicate SharePoint Excel Services Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SharePoint Excel Services to SQL Server.
-
Use the CData Software JDBC Driver for Autopilot in MicroStrategy Web
Connect to Autopilot in MicroStrategy Web using the CData Software JDBC Driver for Autopilot.
-
Working with GraphQL Data in LINQPad
Execute LINQ queries to GraphQL in LINQPad.
-
Connect to FormSite Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FormSite using standard SQL.
-
Working with PhantomBuster Data in LINQPad
Execute LINQ queries to PhantomBuster in LINQPad.
-
Choosing the Best Method to Connect AlloyDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google AlloyDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Salesforce Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Salesforce & Force.com securely in real time.
-
Connect to SAP Data in JRuby
Create a simple JRuby app with access to live SAP ERP/NetWeaver.
-
Query Accelo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Accelo from Node.js.
-
Create Deel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Deel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Pipelines with Live Gmail Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Gmail from Google Cloud Data Fusion, enabling the integration of live Gmail into the building and management of effective data pipelines.
-
Create SSAS Tabular Models from ScrapingBee Data
How to build a SQL Server Analysis Service Tabular Model from ScrapingBee using CData drivers.
-
Model SAP BusinessObjects BI Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP BusinessObjects BI, enabling the direct import of real-time SAP BusinessObjects BI.
-
How to Query SAP SuccessFactors Data in MySQL Workbench
Execute MySQL queries against live SAP SuccessFactors from MySQL Workbench.
-
Access Live SAP SuccessFactors Data in TIBCO Data Virtualization
Use the SAP SuccessFactors Tibco DV Adapter to create a SAP SuccessFactors data source in TIBCO Data Virtualization Studio and gain access to live SAP SuccessFactors from your TDV Server.
-
Natively Connect to TaxJar Data in PHP
The CData ODBC driver for TaxJar enables you to create PHP applications with connectivity to TaxJar. Leverage the native support for ODBC in PHP.
-
Integrate Tanda with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Tanda with External Services.
-
Create SSAS Tabular Models from Rootly Data
How to build a SQL Server Analysis Service Tabular Model from Rootly using CData drivers.
-
Automated Continuous ZendeskSell Replication to MySQL
Use CData Sync for automated, continuous, customizable ZendeskSell replication to MySQL.
-
Build Visualizations of Tanda Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tanda in Birst.
-
DataBind Charts to Azure Data Lake Storage Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Data Lake Storage 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.
-
Build Zoho Inventory-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho Inventory and build web apps with connectivity to live Zoho Inventory.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy
Connect to Unbounce in MicroStrategy Developer using the CData Software ODBC Driver for Unbounce.
-
Access Live Facebook Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Facebook through MCP integration.
-
Connect to Redis Data in ACL Analytics
Connect to Redis via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Redis.
-
Import Monday.com Data Using Azure Data Factory
Use CData Connect AI to connect to Monday.com Data from Azure Data Factory and import live Monday.com.
-
How to integrate Access with Apache Airflow
Access and process Microsoft Access in Apache Airflow using the CData JDBC Driver.
-
Connect Google Calendar to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Calendar using the CData Python MCP Server.
-
Integrate with live Oracle Financials Cloud Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle Financials Cloud in Jitterbit.
-
How to Work with Kafka Data in AWS Glue Jobs Using JDBC
Connect to Kafka from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Controls to LinkedIn Data in C++Builder
DataBind to LinkedIn in C++Builder with standard components and controls.
-
Build Apps with Live PayPal Data Using the Low-Code Development Platform of Mendix
Connect PayPal with Mendix to build apps using the CData JDBC Driver for PayPal.
-
Automated Continuous Access Replication to SingleStore
Use CData Sync for automated, continuous, customizable Access replication to SingleStore.
-
Stream Salesloft Data into Apache Kafka Topics
Access and stream Salesloft in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Elorus Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Elorus from your Oracle system.
-
Build Visualizations of Mailgun Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mailgun in Birst.
-
Automate Box Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Box and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Using the CData Software ODBC Driver for Chargebee in PyCharm
Connect to Chargebee as an ODBC data source in PyCharm using the CData Software ODBC Driver for Chargebee.
-
Access Live Zoom Data in Coginiti Pro
Connect to and query live Zoom from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate with Live SharePoint Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SharePoint from the MuleSoft Anypoint Platform to integrate live Microsoft SharePoint into custom reports and dashboards.
-
Getting Started with the CData ADO.NET Provider for iContact
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Attio Replication to Databricks
Use CData Sync for automated, continuous, customizable Attio replication to Databricks.
-
Use Azure AI Foundry to Talk to Your IBM Cloud Object Storage 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 IBM Cloud Object Storage for you.
-
How to Design HBase Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to HBase from mobile and tablet Power Apps.
-
Build an OLAP Cube in SSAS from Smartsheet Data
Establish a connection to Smartsheet data from SQL Server Analysis Services, and use the Smartsheet Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Autopilot Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Autopilot replication to IBM DB2.
-
A PostgreSQL Interface for Greenplum Data (MySQL Remoting via JDBC)
Use the Remoting features of the Greenplum JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with ChartMogul Data in Apache Spark using SQL
Access and process ChartMogul Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect and process ConstantContact from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ConstantContact.
-
Replicate Dynamics 365 Data from PowerShell
Write a quick PowerShell script to query Microsoft Dynamics 365. Use connectivity to the live data to replicate Microsoft Dynamics 365 to SQL Server.
-
Build Automated Workflows with Live Vault CRM Data in Workato
Use CData Connect AI to connect to live Veeva Vault & Vault CRM and build automated workflows in Workato.
-
Automated Continuous Procore Replication to SingleStore
Use CData Sync for automated, continuous, customizable Procore replication to SingleStore.
-
Create Zoho Projects-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho Projects Data from Klipfolio and build custom visualizations using live Zoho Projects.
-
Access Live Airtable Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Airtable from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Live eBay Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Procore Data in DBArtisan
Use wizards in DBArtisan to configure Procore as a data source.
-
Connect to Figshare Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Figshare to connect to Figshare and execute queries in PowerBuilder.
-
Connect to Auth0 Data in CloverDX (formerly CloverETL)
Transfer Auth0 using the visual workflow in the CloverDX data integration tool.
-
Connect to Act-On Data in DBArtisan
Use wizards in DBArtisan to configure Act-On as a data source.
-
Create ScrapingBee Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ScrapingBee data access from reports, embedded analytics, and more.
-
Integrate Cassandra Data into Power Automate Desktop using CData Connect
CData Connect for Cassandra Data enables you to integrate Apache Cassandra into workflows built using Microsoft Power Automate Desktop.
-
Connect to SendGrid Data in Claris FileMaker Pro
Use the CData ODBC Driver for SendGrid in FileMaker Pro to connect to SendGrid and work with SendGrid in your FileMaker applications.
-
Automated Continuous Exa Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Exa replication to Apache Kafka.
-
Create Data Visualizations in Cognos BI with Bright Data Data
Access Bright Data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize XML 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 XML Files into TIBCO Spotfire.
-
How to Connect to & Open Brex Data in Microsoft Excel
This article uses the CData ODBC driver for Brex to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Charts with Nethunt Data in Clear Analytics
Create dynamic charts and perform analytics based on Nethunt in Clear Analytics.
-
Access Placid 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 Placid.
-
Automate HubDB Data Replication to Couchbase
Use CData Sync to Customize and automate HubDB replication to Couchbase.
-
Connect to Real-Time CloudConvert Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CloudConvert in Power Apps.
-
Write a Simple Go Application to work with MailerSend Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailerSend.
-
Build MVC Applications with Connectivity to ActiveCampaign Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ActiveCampaign from an ASP.NET MVC application.
-
DataBind Charts to Microsoft Planner Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Planner 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.
-
Build IBM Cloud Object Storage-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for IBM Cloud Object Storage to explore live IBM Cloud Object Storage Data in Cursor to assist with building IBM Cloud Object Storage-powered applications.
-
How to create Anaplan federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Anaplan in MySQL .
-
Replicate Multiple eBay Analytics Accounts
Replicate multiple eBay Analytics accounts to one or many databases.
-
Automate SAP ByDesign Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Business ByDesign replication to Azure Data Lake.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Atlassian Confluence to Power BI dashboards. Simply drag and drop Atlassian Confluence into data visuals on the Power BI canvas.
-
Prepare, Blend, and Analyze Snowflake Data in Alteryx Designer (ODBC)
Build workflows to access live Snowflake for self-service data analytics.
-
Integrate Theia IDE with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Migrating data from Bitly to Databricks using CData SSIS Components.
Easily push Bitly to Databricks using the CData SSIS Tasks for Bitly and Databricks.
-
Automated Continuous Bitbucket Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Bitbucket replication to Apache Kafka.