CData Software - Knowledge Base
Recent Articles
-
Integrating GitHub Copilot with Brex 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.
-
Migrating data from Sage Cloud Accounting to Databricks using CData SSIS Components.
Easily push Sage Cloud Accounting data to Databricks using the CData SSIS Tasks for Sage Cloud Accounting and Databricks.
-
Connect to LinkedIn from Asprova with CData Software ODBC Driver for LinkedIn
This article shows how to connect faster to LinkedIn data from Asprova.
-
Automated Continuous Productboard Replication to MongoDB
Use CData Sync for automated, continuous, customizable Productboard replication to MongoDB.
-
Access Coda Data from MySQL in Amazon QuickSight
Connect to Coda and build visualizations of Coda data using a MySQL Connection in Amazon QuickSight.
-
How to work with Typeform Data in Apache Spark using SQL
Access and process Typeform Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Live MailChimp Data in MicroStrategy through CData Connect AI
Create a live connection to MailChimp Data in CData Connect AI and connect to your MailChimp data from MicroStrategy.
-
Visualize Acumatica 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 Acumatica data into TIBCO Spotfire.
-
Build Phoenix-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Phoenix data and build Phoenix-connected web apps with Axios.
-
Import Sybase IQ Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sybase IQ Data and provide access to live Sybase IQ data for custom reports in the Power BI Service.
-
DataBind Controls to Azure Synapse Data in Delphi
DataBind to Azure Synapse data in Delphi with standard data access components and controls.
-
Build a Singer.io Tap for Tally With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tally data using the CData Python Connector.
-
Use the CData ODBC Driver for Planio in Microsoft Power Query
You can use the CData Planio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Planio data into Microsoft Power Query.
-
Using the CData Software ODBC Driver for ZohoExpense in PyCharm
Connect to ZohoExpense as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoExpense.
-
Build Dashboards with REST Data in DBxtra
Create dynamic dashboards and perform analytics based on REST data in DBxtra.
-
How to Connect to Live Epicor Kinetic Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Epicor Kinetic data securely in real time.
-
A PostgreSQL Interface for WooCommerce Data using the CData ODBC Driver
Use the SQL Gateway and WooCommerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Notion Data in RazorSQL
Connect to Notion from wizards and query Notion data from the GUI in the RazorSQL database management tool.
-
Connect to Toggl Data in Aqua Data Studio
Access Toggl data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to publish and share Coinbase Data dashboards with Tableau Server
The CData ODBC driver for Coinbase enables you integrate Coinbase data into Tableau dashboards.
-
Create Reports with Hugging Face Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hugging Face data.
-
How to Query Live MYOB AccountRight Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MYOB AccountRight data data in natural language using Python.
-
Import Real-Time ConstantContact Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ConstantContact data in ColdFusion.
-
How to import Bitbucket Data into Apache Solr
Use the CData Software JDBC Driver for Bitbucket in Data Import Handler and create an automated import of Bitbucket data to Apache Solr Enterprise Search platform.
-
Replicate Scrapfly Data to Multiple Databases via the CData Sync CLI
Replicate Scrapfly data to disparate databases with a single configuration.
-
Connect and Query Live Act-On Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Act-On data into Databricks and enable direct, live querying and analysis without replication.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoExpense
Provide connectivity to ZohoExpense data through an SAP BusinessObjects universe.
-
Connect to Presto Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Presto data.
-
Analyze Azure DevOps Data in Looker
Use CData Connect AI to connect to Azure DevOps Data from Looker and build custom apps using live Azure DevOps data.
-
Access Live Blackbaud FE NXT Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Blackbaud FE NXT data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Provide OData Services of SQL Analysis Services Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SQL Analysis Services data by developing a WCF Service Application.
-
DataBind HCL Domino Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HCL Domino with the DevExpress Windows Forms and Web controls to provide HCL Domino data to a chart.
-
DataBind Charts to Mistral AI Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mistral AI 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.
-
How to Connect DBeaver to SparkPost via a JDBC Driver
Manage SparkPost data with visual tools in DBeaver like the query browser.
-
Analyze SFTP Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SFTP data and visualize SFTP data in SAP Analytics Cloud.
-
Connect to Teamgate 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 Teamgate and work with Teamgate data in your FileMaker application.
-
Connect to SQL Analysis Services Data from a Connection Pool in JBoss
Integrate SQL Analysis Services data into Java servlets: Use the Management Console in JBoss to install the SQL Analysis Services JDBC Driver.
-
Create EnterpriseDB-Connected Applications in Appsmith
Connect to EnterpriseDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to EnterpriseDB data.
-
Integrate Perigon with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Perigon with External Services.
-
Getting Started with the CData SSIS Components for Copper
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Copper.
-
Create a Data Access Object for Sage Intacct Data using JDBI
A brief overview of creating a SQL Object API for Sage Intacct data in JDBI.
-
Build Lakebase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Lakebase data and build visualizations in Tableau.
-
How to connect to CloudConvert Data from IntelliJ
Integrate connectivity to CloudConvert data with wizards in IntelliJ.
-
Integrating Antigravity CLI with Wrike data via CData CLI
Connect Wrike data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to update SAP Ariba Source from Excel
This article explains how to transfer data from Excel to SAP Ariba Source using the Excel Add-In for SAP Ariba Source.
-
Viewing Act-On Data in RAD Studio Data Explorer
How to view Act-On data in RAD Studio Data Explorer using the CData ODBC Driver for Act-On.
-
Use Microsoft Copilot Studio to talk to your Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Instagram data for you.
-
Getting Started with the CData Tableau Connector for BigQuery
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for BigQuery.
-
Create Data Visualizations in Cognos BI with Zoom Data
Access Zoom data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish SharePoint Excel Services-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SharePoint Excel Services data.
-
Connect to Live Toggl Data in MicroStrategy through CData Connect AI
Create a live connection to Toggl Data in CData Connect AI and connect to your Toggl data from MicroStrategy.
-
Analyze Elasticsearch Data in Looker
Use CData Connect AI to connect to Elasticsearch Data from Looker and build custom apps using live Elasticsearch data.
-
Integrating GitHub Copilot with MYOB AccountRight 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.
-
Build MVC Applications with Connectivity to Pipeliner CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pipeliner CRM from an ASP.NET MVC application.
-
How to Seamlessly Import Google Drive Data into IBM SPSS Modeler
Integrate Google Drive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Back Up Apify data 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 Apify data data.
-
Connect SAP SuccessFactors LMS Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP SuccessFactors LMS data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Deploy the ADO.NET Provider for Oracle Eloqua on an SSRS Report Server
Connect to Oracle Eloqua data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous ZeroBounce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZeroBounce replication to Amazon Redshift.
-
Creating Grafana-Connected Applications in Unqork
You can use CData Connect AI to feed Grafana data to Unqork and build custom business apps.
-
Integrate Live Basecamp Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Basecamp data and integrate live Basecamp data into apps built in Microsoft Power Apps.
-
Access Live Shippo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Shippo data into the statistical analysis tools available in SAS JMP. This article shows how to use Shippo data in the Graph Builder and Query Builder.
-
How to Connect to Live Mailgun Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Mailgun data for you.
-
How to connect and process GitHub data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live GitHub data.
-
Automated Continuous Outreach.io Replication to Databricks
Use CData Sync for automated, continuous, customizable Outreach.io replication to Databricks.
-
Build Sentry-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sentry data.
-
Manage Coda Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Coda.
-
Visualize NetSuite Data in Sisense
Create an ElastiCube in Sisense app with access to NetSuite data.
-
Connect to Mailjet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Mailjet.
-
Use CData Connect AI to Access LinkedIn Data in Microsoft Power Pivot
Use CData Connect AI to connect to live LinkedIn data in the Power Pivot business intelligence tool.
-
Connect to Procore Data from HeidiSQL
Use CData Connect AI to connect to and query live Procore data from HeidiSQL.
-
Connecting Moonlit Workflow with MySQL 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 MySQL data in real time.
-
Connect to Contentful Data from PowerBuilder via ADO.NET
This article demonstrates how to access Contentful data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Work with Paylocity Data in AWS Glue Jobs Using JDBC
Connect to Paylocity from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Google Cloud Storage Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Cloud Storage Data and provide access to live Google Cloud Storage data for custom reports in the Power BI Service.
-
How to connect and process FreeAgent data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live FreeAgent data.
-
Query ZohoInvoice Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoInvoice data.
-
How to Connect to Live Azure Table 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 Azure Table data through natural language.
-
Create Vercel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Vercel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Jira Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Jira from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Jira data.
-
Automated Continuous Tickspot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Tickspot replication to AlloyDB.
-
Work with Live YouTube Analytics Data in Power Query
Use CData Connect AI to connect to YouTube Analytics data and work with live YouTube Analytics data in Microsoft Power Query.
-
Analyze SageHR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SageHR data and visualize live SageHR data in Infragistics Reveal.
-
Automated Continuous Short.io Replication to Oracle
Use CData Sync for automated, continuous, customizable Short.io replication to Oracle.
-
Create Azure Analysis Services-Connected Business Apps in AppSheet
Connect to Azure Analysis Services Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Analysis Services data.
-
Connect to Bannerbear Data from AWS Glue
Use CData Connect AI to gain access to live Bannerbear data from your AWS Glue jobs.
-
Integrating Gumloop with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PayPal data within automated workflows.
-
Automated Continuous Oracle SCM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle SCM data replication to OneLake in Microsoft Fabric.
-
Connect to ServiceNow Data from a Connection Pool in Jetty
The ServiceNow JDBC Driver supports connection pooling: This article shows how to connect faster to ServiceNow data from Web apps in Jetty.
-
Create Reports from Jira Data in Looker Studio
Use CData Connect AI to gain access to live Jira data and create custom reports in Looker Studio.
-
How to Access Sentry Data Using Entity Framework
This article shows how to access Sentry data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Dynamics NAV with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics NAV with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dynamics NAV data.
-
A PostgreSQL Interface for Amplitude Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amplitude JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Accelo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Accelo and work with Accelo data in your FileMaker applications.
-
Integrate Google's Antigravity Agent with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live HubSpot data using the Model Context Protocol.
-
Analyze Live Excel Online Data in SAS Viya
Use CData Connect AI to connect to Excel Online data from SAS Viya and deploy self-service analytics using live Excel Online data.
-
Use Manus AI to Talk to Your DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on DB2 data.
-
Load Qualaroo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Qualaroo data to a database.
-
Integrate Dify with Live Azure Analysis Services Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Azure Analysis Services data.
-
Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy Desktop
Connect to eBay Analytics data in MicroStrategy Desktop using the CData Software JDBC Driver for eBay Analytics.