CData Software - Knowledge Base
Recent Articles
-
Easily Integrate Avro Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache Avro in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect the Power BI Service to Nethunt: Complete Guide
Connect to the CData Software Power BI Connector for Nethunt from PowerBI.com to provide real-time Nethunt across the organization.
-
Connect to Pipeline CRM Data in DBArtisan
Use wizards in DBArtisan to configure Pipeline CRM as a data source.
-
How to Query Live Google Drive Data in Perplexity MacOS Desktop
Connect to and query live Google Drive Data in Perplexity Desktop using CData MCP Server.
-
Connecting GenSpark with Snowflake Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Snowflake without any replication or custom integration required.
-
View Reports on Real-Time Simplesat Data in Power BI Report Server
Use the CData ODBC Driver for Simplesat to visualize Simplesat in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Live Oracle Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle in CData Connect AI and connect to your Oracle Database from PostgreSQL.
-
Integrate Live BambooHR Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to BambooHR from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live BambooHR.
-
Getting Started with the CData ODBC Driver for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PhantomBuster.
-
Analyze Bullhorn CRM Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Bullhorn CRM and visualize live Bullhorn CRM in Infragistics Reveal.
-
DataBind Short.io Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Short.io to a chart.
-
Process & Analyze Teamwork Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Teamwork Data.
-
How to Connect to Live GitLab Data 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 GitLab for you.
-
Choosing the Best Method to Connect Planio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Planio from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Import and Visualize Tally Data in Power View
Create data visualizations based on Tally ERP in Excel.
-
Build Apps with Live Excel Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Excel with Mendix to build apps using the CData JDBC Driver for Excel.
-
Getting Started with the CData Tableau Connector for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Snapchat Ads.
-
Use Claude to Talk to Your Lakebase 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 Lakebase for you.
-
Use the CData ODBC Driver for eBay in Microsoft Power Query
You can use the CData eBay ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import eBay into Microsoft Power Query.
-
Getting Started with the CData ODBC Driver for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SurveyMonkey.
-
Replicate Shortcut Data to Multiple Databases via the CData Sync CLI
Replicate Shortcut to disparate databases with a single configuration.
-
Use the CData ODBC Driver for Demio in Microsoft Power Query
You can use the CData Demio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Demio into Microsoft Power Query.
-
Replicate Multiple ADP Accounts
Replicate multiple ADP accounts to one or many databases.
-
Analyze QuickBooks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for QuickBooks from Power Pivot. You will use the Table Import Wizard to load QuickBooks Desktop. You can visually build the import query or use any SQL supported by the driver.
-
How to integrate Sage 300 with Apache Airflow
Access and process Sage 300 in Apache Airflow using the CData JDBC Driver.
-
Connect to Oracle Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle and the Script function in FileMaker Pro to connect to Oracle and work with Oracle Database in your FileMaker application.
-
Connect to Gmail Data from Crystal Reports
Use CData Connect AI to connect to and report on live Gmail from Crystal Reports.
-
Access Live CSV Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live CSV/TSV Files from your Excel spreadsheets.
-
Build MVC Applications with Connectivity to VWO Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access VWO from an ASP.NET MVC application.
-
Query Instantly Data as a MySQL Database in Node.js
Execute MySQL queries against Instantly from Node.js.
-
Connecting Pipedream with Salesforce Marketing 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 Salesforce Marketing data in real time.
-
Provide OData Services of Notion Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Notion by developing a WCF Service Application.
-
Getting Started with the CData JDBC Driver for Customer.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Customer.io.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Dataverse
Provide connectivity to Microsoft Dataverse (CDS) through an SAP BusinessObjects universe.
-
Access Live Mistral AI Data in AWS Lambda
Connect to live Mistral AI in AWS Lambda using the CData JDBC Driver.
-
Natively Connect to Planio Data in PHP
The CData ODBC driver for Planio enables you to create PHP applications with connectivity to Planio. Leverage the native support for ODBC in PHP.
-
Visualize Dynamics 365 Data in TIBCO Spotfire through OData
Integrate Microsoft Dynamics 365 into dashboards in TIBCO Spotfire.
-
Connect Stripe Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Stripe using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Work with Stack Exchange Data in AWS Glue Jobs Using JDBC
Connect to Stack Exchange from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Salesforce Marketing Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Marketing data access from reports, embedded analytics, and more.
-
How to Connect to Live Freshservice Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Freshservice securely in real time.
-
Use Azure AI Foundry to Talk to Your Zendesk 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 Zendesk for you.
-
Automated Continuous OnePageCrm Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OnePageCrm replication to IBM DB2.
-
Connect and Query Live Amazon DynamoDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon DynamoDB into Databricks
-
Use the CData API Server to Access Email Data in Microsoft PowerPivot
Use the CData API Server to connect to live Email in the Power Pivot business intelligence tool.
-
Access Live Trello Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Trello from your Google Sheets.
-
DataBind Yelp Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Yelp to a chart.
-
How to Connect the Power BI Service to Reckon Accounts Hosted: Complete Guide
Connect to the CData Software Power BI Connector for Reckon Accounts Hosted from PowerBI.com to provide real-time Reckon Accounts Hosted across the organization.
-
Integrating GitHub Copilot CLI with Teamgate 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 with API Data in SnapLogic
Use CData Connect AI to connect to and integrate with live API in SnapLogic.
-
Access Live HBase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache HBase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Perform Batch Operations with Cosmos DB Data in Apache NiFi
Connect to Azure Cosmos DB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create Sage Cloud Accounting-Connected Dashboards in Grafana
Connect to Sage Cloud Accounting Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sage Business Cloud Accounting.
-
Publish Notion-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Notion.
-
Object-Relational Mapping (ORM) with Sugar CRM 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 Sugar CRM into a Java-based ORM framework, Hibernate.
-
Publish Stripe-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Stripe.
-
Analyze Live Xero Data in SAS Viya
Use CData Connect AI to connect to Xero Accounting from SAS Viya and deploy self-service analytics using live Xero Accounting.
-
Stream Sybase IQ Data into Apache Kafka Topics
Access and stream Sybase IQ in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import and Visualize Facebook Ads Data in Power View
Create data visualizations based on Facebook Ads in Excel.
-
Connect LinkedIn Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LinkedIn Ads with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Oracle Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Data enables you to integrate Oracle Database into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Power BI Connector for Avaza
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build an OLAP Cube in SSAS from Tanda Data
Establish a connection to Tanda data from SQL Server Analysis Services, and use the Tanda Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Easily Query QuickBooks Time Data in OpenOffice Base
Connect to QuickBooks Time data in OpenOffice Base using the CData ODBC Driver for QuickBooks Time and generate reports with live data insights.
-
Build Semantic Layer Views for Adobe Analytics Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Adobe Analytics.
-
Create TigerGraph Dataflows on PowerBI.com
Connect to the CData Power BI Connector for TigerGraph from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Browserless Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Browserless. Leverage the pyodbc module for ODBC in Python.
-
How to Query Live Cloudant Data in Claude Desktop
Connect to and query live Cloudant Data in Claude Desktop using CData MCP Server.
-
Configure the CData JDBC Driver for FHIR in a Connection Pool in Tomcat
Connect to FHIR from a connection pool in Tomcat.
-
Use the CData Software JDBC Driver for Parallel in MicroStrategy Desktop
Connect to Parallel in MicroStrategy Desktop using the CData Software JDBC Driver for Parallel.
-
Automated Continuous Harvest Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Harvest replication to OneLake in Microsoft Fabric.
-
Connect to Apollo Data from a Connection Pool in JBoss
Integrate Apollo into Java servlets: Use the Management Console in JBoss to install the Apollo JDBC Driver.
-
Integrating Codex CLI with BigCommerce 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.
-
Back Up Printful to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Printful data.
-
Prepare, Blend, and Analyze Cosmos DB Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure Cosmos DB for self-service data analytics.
-
Automated Continuous Adobe Commerce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Amazon Redshift.
-
Getting Started with the CData SSIS Components for ConstantContact
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ConstantContact.
-
Import Freshservice Data Using Azure Data Factory
Use CData Connect AI to connect to Freshservice Data from Azure Data Factory and import live Freshservice.
-
Build Automated GitLab-Connected Workflows in Zapier
Use CData Connect AI to connect to live GitLab and build automated workflows in Zapier.
-
Access Live Vertica Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Vertica from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous SharePoint Excel Services Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Apache Cassandra.
-
Integrating Dataiku with BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live BigCommerce.
-
Connect to Billsby Data in Aqua Data Studio
Access Billsby from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Twitter Ads to Power BI dashboards. Simply drag and drop Twitter Ads into data visuals on the Power BI canvas.
-
Query Adobe Target Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Adobe Target from Node.js.
-
How to Query MailerSend Data in MySQL Workbench
Execute MySQL queries against live MailerSend from MySQL Workbench.
-
Analyze Bullhorn CRM Data in Looker
Use CData Connect AI to connect to Bullhorn CRM Data from Looker and build custom apps using live Bullhorn CRM.
-
Replicate LionDesk Data in Heroku for Use in Salesforce Connect
Replicate LionDesk to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Work with Live Gmail Data in Power Query
Use CData Connect AI to connect to Gmail and work with live Gmail in Microsoft Power Query.
-
Connect to and Query Mailgun Data in QlikView over ODBC
Create data visualizations with Mailgun in QlikView.
-
Integrate with Paylocity Data in JReport Designer
Create charts and reports based on Paylocity in JReport Designer.
-
Viewing QuickBooks Online Data in RAD Studio Data Explorer
How to view QuickBooks Online in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks Online.
-
Access Live Freshdesk Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Freshdesk from your Excel spreadsheets.
-
Integrate with CouchDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache CouchDB in SnapLogic.
-
Visualize Phoenix 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 Apache Phoenix into TIBCO Spotfire.
-
Build Charts with Elorus Data in Clear Analytics
Create dynamic charts and perform analytics based on Elorus in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pipeline CRM
Provide connectivity to Pipeline CRM through an SAP BusinessObjects universe.
-
Visualize Shippo Data in Tableau
The CData ODBC driver for Shippo enables you integrate Shippo into Tableau dashboards.
-
Integrating OpenCode Terminal with SurveyMonkey 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.
-
Automate Raisers Edge NXT Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Raisers Edge NXT and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.