CData Software - Knowledge Base
Recent Articles
-
Connect to Quickbase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Quickbase.
-
Stream Bitly Data into Apache Kafka Topics
Access and stream Bitly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Scrapfly in SpagoBI
Create reports featuring live Scrapfly in SpagoBI Studio. Host Scrapfly reports on SpagoBI Server.
-
Integrating GitHub Copilot CLI with SAP Ariba Source 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.
-
Connect to Salesforce Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce Data and connect to Salesforce & Force.com in Akorbi Digital RunMyProcess.
-
How to Work with Google Contacts Data in ETL Validator JDBC
Connect to Google Contacts from ETL Validator jobs using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access Simplesat Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Simplesat.
-
Connect to ZarMoney Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZarMoney using standard SQL.
-
How to connect and process SQL Analysis Services from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SQL Analysis Services.
-
Import Real-Time Insightly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Insightly in ColdFusion.
-
Create Data Visualizations Based On Outreach.io Data in Mode
Use CData Connect AI to connect to Outreach.io Data from Mode and build visualizations using live
-
Build Pipelines with Live Dynamics 365 Business Central Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 Business Central from Google Cloud Data Fusion, enabling the integration of live Dynamics 365 Business Central into the building and management of effective data pipelines.
-
Query, Visualize, and Share live BigQuery Data in Redash
Use CData Connect AI to connect to live Google BigQuery in Redash for querying, visualizing, and sharing.
-
Build Apps with Live Snowflake Data Using the Low-Code Development Platform of Mendix
Connect Snowflake with Mendix to build apps using the CData JDBC Driver for Snowflake.
-
Use the CData Software ODBC Driver for SendPulse in SAS for Real-Time Reporting and Analytics
Connect to real-time SendPulse in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SendPulse.
-
Work with Intercom Data in FoxPro
Load Intercom into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bidirectional Access to SAS Data Sets Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAS Data Sets in Filemaker Pro for Mac or Windows.
-
Connect to and Query Vimeo Data in QlikView over ODBC
Create data visualizations with Vimeo in QlikView.
-
Getting Started with the CData SSIS Components for ConvertKit
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ConvertKit.
-
How to create Planio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Planio in MySQL .
-
Visualize REST Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to REST.
-
Integrate Live ZohoExpense Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZohoExpense to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to publish and share Onfleet Data dashboards with Tableau Server
The CData ODBC driver for Onfleet enables you integrate Onfleet into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for Aha!
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Aha!.
-
Analyze Foursquare Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Foursquare in Microsoft R Open.
-
Connect Bugsnag Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bugsnag using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for MarkLogic
Create MarkLogic data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Procore Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Procore replication to PostgreSQL.
-
Automate DB2 for i Data Replication to Azure Data Lake
Use CData Sync to customize and automate DB2 for i replication to Azure Data Lake.
-
Build Google Cloud Storage-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Cloud Storage to explore live Google Cloud Storage Data in GitHub Copilot to assist with building Google Cloud Storage-powered applications.
-
Integrating Gumloop with SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Concur within automated workflows.
-
How to Access Live Shippo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Shippo enables you to integrate Shippo into workflows built using Microsoft Power Automate Desktop.
-
Extend Google Sheets with Highrise Data
Make calls to Highrise from Google Apps Script via the API Server.
-
Building Dynamic Web Pages with Azure Data Lake Storage Data Using AngularJS
Create single-page applications with live connectivity to Azure Data Lake Storage using the CData API Server.
-
DataBind Controls to PDFMonkey Data in Delphi
DataBind to PDFMonkey in Delphi with standard data access components and controls.
-
How to connect to FreeAgent Data in DBVisualizer
Integrate FreeAgent with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Dataiku with Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apollo.
-
Connect to and Visualize Live Cosmos DB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Cosmos DB.
-
Integrating Kiro CLI with Foursquare 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.
-
Connect to AgileCRM Data in Aqua Data Studio
Access AgileCRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for HCL Domino Data using the CData ODBC Driver
Use the SQL Gateway and HCL Domino ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Airtable Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Airtable and perform CRUD operations on Airtable from Node.js.
-
How to Easily Query SAP SuccessFactors LMS Data in OpenOffice Base
Connect to SAP SuccessFactors LMS data in OpenOffice Base using the CData ODBC Driver for SAP SuccessFactors LMS and generate reports with live data insights.
-
Publish Smartsheet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Smartsheet.
-
Connect to Short.io Data in RapidMiner
Integrate Short.io with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Crystal Reports on Stack Exchange Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Stack Exchange.
-
Create Informatica Mappings From/To an ODBC Data Source for Airtable
Create an ODBC connection to Airtable in Informatica and browse and transfer Airtable.
-
Configure the CData JDBC Driver for Sybase IQ in a Connection Pool in Tomcat
Connect to Sybase IQ from a connection pool in Tomcat.
-
Integrating Codex CLI with Zoho Books 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 Printify Replication to Vertica
Use CData Sync for automated, continuous, customizable Printify replication to Vertica.
-
Integrating LlamaIndex with Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Directory in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ConvertKit
Provide connectivity to ConvertKit through an SAP BusinessObjects universe.
-
Access Asana Data from MySQL in PHP
Connect to Asana through the standard MySQL libraries in PHP.
-
Prepare, Blend, and Analyze MongoDB Data in Alteryx Designer (ODBC)
Build workflows to access live MongoDB for self-service data analytics.
-
Query Zoho CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho CRM from Node.js.
-
Connect to Neo4J Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Neo4J.
-
Integrating LangGraph with Asana Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Asana within automated workflows.
-
Use the CData ODBC Driver for Zuora in Microsoft Power Query
You can use the CData Zuora ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zuora into Microsoft Power Query.
-
Create Power BI XMLA-Connected Business Apps in AppSheet
Connect to Power BI XMLA Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Power BI XMLA.
-
Build Apps with Live Bitly Data Using the Low-Code Development Platform of Mendix
Connect Bitly with Mendix to build apps using the CData API Driver for JDBC.
-
Build Pipelines with Live ADP Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ADP from Google Cloud Data Fusion, enabling the integration of live ADP into the building and management of effective data pipelines.
-
Replicate Multiple Planio Accounts
Replicate multiple Planio accounts to one or many databases.
-
Load Bannerbear Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bannerbear to a database.
-
Automated Continuous NetSuite Replication to Databricks
Use CData Sync for automated, continuous, customizable NetSuite replication to Databricks.
-
Query Cassandra Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apache Cassandra from Node.js.
-
Integrate Kintone Data into Power Automate Desktop using CData Connect
CData Connect for Kintone Data enables you to integrate Kintone into workflows built using Microsoft Power Automate Desktop.
-
Connect to ConvertKit from Asprova with CData Software ODBC Driver for ConvertKit
This article shows how to connect faster to ConvertKit data from Asprova.
-
Integrating Gumloop with Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Reckon Accounts Hosted within automated workflows.
-
Moving Data from Apify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Apify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software ODBC Driver for Cloudflare in MicroStrategy Web
Connect to Cloudflare in MicroStrategy Web using the CData Software ODBC Driver for Cloudflare.
-
Use the CData ODBC Driver for Egnyte from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Egnyte to connect to Egnyte from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Egnyte in Excel.
-
DataBind Charts to Stripe Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Stripe 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 to & Open Freshservice Data in Microsoft Excel
This article uses the CData ODBC driver for Freshservice to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Cursor CLI with Twilio 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.
-
Integrate LibreChat with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Ariba Source from within the chat interface.
-
Connect to Sybase Data in CloverDX (formerly CloverETL)
Transfer Sybase using the visual workflow in the CloverDX data integration tool.
-
How to Work with BigQuery Data in ETL Validator JDBC
Connect to BigQuery from ETL Validator jobs using the CData Software JDBC Driver.
-
Create ServiceNow Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ServiceNow data access from reports, embedded analytics, and more.
-
Use the CData Software JDBC Driver for SuiteCRM in MicroStrategy
Connect to SuiteCRM in MicroStrategy Developer using the CData Software JDBC Driver for SuiteCRM.
-
Create Datasets from Highrise in Domo Workbench and Build Visualizations of Highrise Data in Domo
Use the CData Software ODBC Driver for Highrise to create datasets from Highrise CRM in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from Mixpanel to Databricks using CData SSIS Components.
Easily push Mixpanel to Databricks using the CData SSIS Tasks for Mixpanel and Databricks.
-
A PostgreSQL Interface for ZohoSubscriptions Data using the CData ODBC Driver
Use the SQL Gateway and ZohoSubscriptions ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Exa Data in NetBeans
Connect to Exa in NetBeans with the data source configuration wizard.
-
Create Power BI Reports on Real-Time Foursquare Data
Use the CData ODBC Driver for Foursquare to visualize Foursquare in Power BI Desktop.
-
Query Harvest Data as a MySQL Database in Node.js
Execute MySQL queries against Harvest from Node.js.
-
Connect Spotify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Spotify with IBM WebSphere for seamless data integration and connectivity.
-
Working with XML Data in LINQPad
Execute LINQ queries to XML Files in LINQPad.
-
Connect to Basecamp Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Basecamp in Airbyte.
-
Moving Data from Tickspot to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Tickspot data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Data Visualizations Based On Couchbase Data in Mode
Use CData Connect AI to connect to Couchbase Data from Mode and build visualizations using live
-
Create PhantomBuster Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PhantomBuster from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Discord 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 Discord into TIBCO Spotfire.
-
Access LionDesk 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 LionDesk.
-
Visualize ConstantContact Data in Tableau
The CData ODBC driver for ConstantContact enables you integrate ConstantContact into Tableau dashboards.
-
Analyze FTP Data in Looker
Use CData Connect AI to connect to FTP Data from Looker and build custom apps using live FTP Servers.
-
How to Access SAS xpt Data Using Entity Framework
This article shows how to access SAS XPORT using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect and Visualize Live Oracle Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Database into the Databricks platform and create visualization dashboards with real-time Oracle Database.
-
Explore Geographical Relationships in ZohoDesk Data with Power Map
Create data visualizations with ZohoDesk in Power Map.
-
Automated Continuous Optimizely Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Optimizely replication to Amazon Redshift.
-
Automated Continuous QuickBooks Time Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon Redshift.