CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time Avalara AvaTax Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Avalara and Dataflow to import and use Avalara AvaTax in Power Apps.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live CockroachDB using the Model Context Protocol.
-
Connect to SharePoint Excel Services Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SharePoint Excel Services to connect to SharePoint Excel Services and execute queries in PowerBuilder.
-
Visualize QuickBooks Time 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 QuickBooks Time into TIBCO Spotfire.
-
How to Visualize Exact Online Data in Python with pandas
Use pandas and other modules to analyze and visualize live Exact Online in Python.
-
Build Semantic Layer Views for Perigon Data in APOS Live Data Gateway
Use the CData Connector for Perigon in APOS Live Data Gateway to build Semantic Layer Views for Perigon.
-
Connect to Highrise Data from Crystal Reports
Use CData Connect AI to connect to and report on live Highrise CRM from Crystal Reports.
-
Natively Connect to AgileCRM Data in PHP
The CData ODBC driver for AgileCRM enables you to create PHP applications with connectivity to AgileCRM. Leverage the native support for ODBC in PHP.
-
Create LeadDesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LeadDesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Power BI XMLA Data in Heroku for Use in Salesforce Connect
Replicate Power BI XMLA to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build MVC Applications with Connectivity to Amazon S3 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon S3 from an ASP.NET MVC application.
-
Getting Started with the CData ODBC Driver for Exa
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Exa.
-
Create Dynamic Webex Grids Using the Infragistics XamDataGrid
Learn how you can connect Webex to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Claude Code CLI with Airtable 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.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy Web
Connect to Chargebee in MicroStrategy Web using the CData Software ODBC Driver for Chargebee.
-
Build Adobe Commerce-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Adobe Commerce Data from Zoho Analytics and import live Adobe Commerce.
-
Automate Opsgenie Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Opsgenie and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect to CSV Data with Squirrel SQL client
Connect to CSV/TSV Files and execute queries in the Squirrel SQL Client.
-
Integrate with live Sugar CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sugar CRM in Jitterbit.
-
Create Power BI Reports on Real-Time Lakebase Data
Use the CData ODBC Driver for Lakebase to visualize Lakebase in Power BI Desktop.
-
Prepare, Blend, and Analyze MySQL Data in Alteryx Designer (ODBC)
Build workflows to access live MySQL for self-service data analytics.
-
Use Dash to Build to Web Apps on ZeroBounce Data
Create Python applications that use pandas and Dash to build ZeroBounce-connected web apps.
-
Use the CData Software JDBC Driver for Sentry in MicroStrategy Desktop
Connect to Sentry in MicroStrategy Desktop using the CData Software JDBC Driver for Sentry.
-
Connect to Cosmos DB Data in DBeaver
Use the CData ODBC Driver to connect to Azure Cosmos DB in DBeaver.
-
Connect to PingOne Data in DBArtisan
Use wizards in DBArtisan to configure PingOne as a data source.
-
How to create an RPA flow for Sendwithus Data in UiPath Studio
Use the Sendwithus ODBC Driver to create workflows that access real-time Sendwithus without any coding.
-
Automated Continuous Accelo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Accelo replication to IBM DB2.
-
Getting Started with the CData Python Connector for Notion
Learn to install and license the CData Python Connector
-
Build AlloyDB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for AlloyDB to explore live AlloyDB Data in Cursor to assist with building AlloyDB-powered applications.
-
How to Connect DBeaver to Dotmailer via a JDBC Driver
Manage Dotmailer with visual tools in DBeaver like the query browser.
-
Work with OpenWeatherMap Data in FoxPro
Load OpenWeatherMap into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Active Directory-Connected Apps in Choreo
Use CData Connect AI to connect to Active Directory Data from Choreo and build custom apps using live Active Directory.
-
Replicate Zoho Books Data to Multiple Databases via the CData Sync CLI
Replicate Zoho Books to disparate databases with a single configuration.
-
Integrate Cline with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft OneDrive from within your IDE.
-
How to use SQLAlchemy ORM to access GraphQL Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GraphQL.
-
Getting Started with the CData JDBC Driver for Kafka
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Kafka.
-
Connect to Reckon Accounts Hosted from a Connection Pool in WebLogic
Use the CData JDBC Driver for Reckon Accounts Hosted to connect to Reckon Accounts Hosted from Web applications running on WebLogic.
-
Using the CData Data Providers with the DevExpress Data Grid
The CData ADO.NET providers are standards-based libraries that can be used with various third-party components and tools. This article shows how to use the CData ADO.NET Provider for Salesforce with the DevExpress Chart Control.
-
Create Epicor Kinetic-Connected Nintex Workflows
Use CData Connect AI to connect to Epicor Kinetic Data from Nintex Workflow Cloud and build custom workflows using live Epicor Kinetic.
-
Figshare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Figshare facts in real time.
-
Access Live SAP Business Warehouse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business Warehouse in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build an OLAP Cube in SSAS from Paddle Data
Establish a connection to Paddle data from SQL Server Analysis Services, and use the Paddle Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live Instantly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Instantly.
-
Automated Continuous Keap Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Keap replication to OneLake in Microsoft Fabric.
-
Automated Continuous AgileCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable AgileCRM replication to Databricks.
-
Prepare, Blend, and Analyze Oracle Sales Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Sales for self-service data analytics.
-
Automated Continuous SparkPost Replication to SQLite
Use CData Sync for automated, continuous, customizable SparkPost replication to SQLite.
-
Connect to Delighted Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Delighted.
-
Use Claude to Talk to Your CockroachDB 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 CockroachDB for you.
-
Automated Continuous Aweber Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aweber replication to delimited files (CSV/TSV).
-
Replicate NASA Data from PowerShell
Write a quick PowerShell script to query NASA. Use connectivity to the live data to replicate NASA to SQL Server.
-
Add Lakebase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Lakebase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create SSAS Tabular Models from Zoho Creator Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Creator using CData drivers.
-
Automate Okta Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Okta from PowerShell? This article demonstrates how to utilize the Okta Cmdlets for tasks like connecting to Okta, automating operations, downloading data, and more.
-
Getting Started with the CData Tableau Connector for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Migrating data from SAP Ariba Source to Google BigQuery using CData SSIS Components.
Easily push SAP Ariba Source to Google BigQuery using the CData SSIS Tasks for SAP Ariba Source and Google BigQuery.
-
Dynamics 365 Business Central Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Dynamics 365 Business Central through CData Connect AI using different applications and tools.
-
Import AlloyDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google AlloyDB. In this article, you will use the OData format to import Google AlloyDB into Microsoft Power Query.
-
Migrating data from Tanda to Databricks using CData SSIS Components.
Easily push Tanda to Databricks using the CData SSIS Tasks for Tanda and Databricks.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy
Connect to SAS Data Sets in MicroStrategy Developer using the CData Software JDBC Driver for SAS Data Sets.
-
Access Live Salesforce Marketing Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesforce Marketing Cloud from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to JDBC-ODBC Bridge Data in NetBeans
Connect to JDBC-ODBC Bridge in NetBeans with the data source configuration wizard.
-
Visualize Codat Data in Sisense
Create an ElastiCube in Sisense app with access to Codat.
-
Connect to PabblySubscriptions Data in CloverDX (formerly CloverETL)
Transfer PabblySubscriptions using the visual workflow in the CloverDX data integration tool.
-
How to Query Freshsales Data in MySQL Workbench
Execute MySQL queries against live Freshsales from MySQL Workbench.
-
Query Cvent Data as a SQL Server Database in Node.js
Execute SQL Server queries against Cvent from Node.js.
-
ETL Oracle HCM Cloud in Oracle Data Integrator
This article shows how to transfer Oracle HCM Cloud into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Google Tasks Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Tasks replication to Google Cloud SQL.
-
Query Workable Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Workable from Node.js.
-
How to connect SharePoint with Redis Data through external lists
Provide Redis to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy
Connect to Epicor Kinetic in MicroStrategy Developer using the CData Software ODBC Driver for Epicor Kinetic.
-
Work with PayPal Data in FoxPro
Load PayPal into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to create Adobe Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Adobe Analytics in MySQL .
-
Connect to HBase Data in Aqua Data Studio
Access Apache HBase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Natively Connect to Greenplum Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pivotal GreenPlum. Leverage the native support for ODBC in PHP.
-
How to Query Live PDFMonkey Data in Claude Desktop
Connect to and query live PDFMonkey Data in Claude Desktop using CData MCP Server.
-
How to Query Live EmailOctopus Data in Perplexity MacOS Desktop
Connect to and query live EmailOctopus Data in Perplexity Desktop using CData MCP Server.
-
Integrate LibreChat with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cvent from within the chat interface.
-
Visualize Live PostgreSQL Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PostgreSQL using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize MessageBird Data in TIBCO Spotfire through OData
Integrate MessageBird into dashboards in TIBCO Spotfire.
-
Access Live SAP Business One Data in Coginiti Pro
Connect to and query live SAP Business One from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData JDBC Driver for Zoho Books
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Books.
-
Integrate with Insightly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Insightly to a JSON file on disk.
-
Integrate Real-Time Access to Beeminder in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Beeminder in real time.
-
DataBind Discord Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Discord to a chart.
-
SingleStore Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SingleStore through CData Connect AI using different applications and tools.
-
How to connect PolyBase to AlloyDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google AlloyDB.
-
Analyze Grafana Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Grafana with the CData JDBC Driver for Grafana.
-
Build Microsoft Planner-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Planner to explore live Microsoft Planner Data in GitHub Copilot to assist with building Microsoft Planner-powered applications.
-
Integrating Cursor CLI with JobNimbus 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.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Entra ID Records from SQL Server
Easily push SQL Server data to Microsoft Entra ID using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Entra ID or update existing records with data from a SQL Server database.
-
Moving Data from MailerSend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MailerSend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build a Simple VCL Application for Unbounce Data
How to build a simple VCL Application to view Unbounce in RAD Studio using the CData ODBC Driver for Unbounce.
-
Build Odoo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Odoo ERP and build Odoo-connected web apps with Axios.
-
Edit and Search External Google Directory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Directory to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Directory Data objects that you can access from apps and the dashboard.
-
Connect to PagerDuty Data in Jaspersoft Studio
Execute SQL to remote PagerDuty in Jaspersoft Studio.
-
Build Dashboards with Superchat Data in Dundas BI
Create dynamic dashboards and perform analytics based on Superchat in Dundas BI.
-
DataBind Google Ad Manager Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for DoubleClick (DFP) with the DevExpress Windows Forms and Web controls to provide Google Ad Manager to a chart.
-
Connect to Rebilly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Rebilly and work with Rebilly in your FileMaker application.
-
Choosing the Best Method to Connect RabbitMQ to SQL Server: 5 Options Explained
Discover multiple ways to connect and use RabbitMQ from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.