CData Software - Knowledge Base
Recent Articles
-
Work with Jumpseller Data in FoxPro
Load Jumpseller into a FoxPro database. This article includes full code and a walk-through of the process.
-
Work with Power BI XMLA Data in FoxPro
Load Power BI XMLA into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Gong-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gong.
-
Connect to BigQuery Data in CloverDX (formerly CloverETL)
Transfer Google BigQuery using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Zoho Projects to Snowflake using CData SSIS Components.
Easily push Zoho Projects to Snowflake using the CData SSIS Tasks for Zoho Projects and Snowflake.
-
Connect to Snapchat Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Snapchat Ads using standard SQL.
-
Build an OLAP Cube in SSAS from Coinbase Data
Establish a connection to Coinbase data from SQL Server Analysis Services, and use the Coinbase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Bridge SpaceX Connectivity with Apache NiFi
Access and process SpaceX in Apache NiFi using the CData JDBC Driver.
-
Work with Live Oracle Sales Data in Power Query
Use CData Connect AI to connect to Oracle Sales and work with live Oracle Sales in Microsoft Power Query.
-
Automated Google Tasks Data Replication to Teradata
Use CData Sync to Customize and automate Google Tasks replication to Teradata.
-
Integrate with Amazon S3 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon S3 to a JSON file on disk.
-
How to Easily Query Kintone Data in OpenOffice Base
Connect to Kintone data in OpenOffice Base using the CData ODBC Driver for Kintone and generate reports with live data insights.
-
Automated Continuous ZohoInvoice Replication to Oracle
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Oracle.
-
Create Informatica Mappings From/To a JDBC Data Source for Freshservice
Create Freshservice data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Deploy the ADO.NET Provider for YouTube Analytics on an SSRS Report Server
Connect to YouTube Analytics 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.
-
Use Biml to Build SSIS Tasks to Replicate MarkLogic Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MarkLogic to SQL Server.
-
How to Connect to Live Shopify 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 Shopify for you.
-
Build Visualizations of PolarTeamPro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PolarTeamPro in Birst.
-
Getting Started with the CData SSIS Components for Toggl
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Toggl.
-
Access Live Databricks Data in Excel 365 Online (Excel for the web)
Connect to Databricks from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Gumroad Data in MySQL Workbench
Execute MySQL queries against live Gumroad from MySQL Workbench.
-
Connect to Parquet Data in RapidMiner
Integrate Apache Parquet with standard components and data source configuration wizards in RapidMiner Studio.
-
Create SendGrid Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SendGrid data access from reports, embedded analytics, and more.
-
Visualize FreeAgent Data in TIBCO Spotfire through ADO.NET
Integrate FreeAgent into dashboards in TIBCO Spotfire.
-
Build Spark-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Spark to explore live Spark Data in Gemini Code Assist to assist with building Spark-powered applications.
-
Import and Visualize FHIR Data in Power View
Create data visualizations based on FHIR in Excel.
-
Automated Continuous Clockify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Clockify replication to Google Cloud SQL.
-
How to Query Spark Data in MySQL Workbench
Execute MySQL queries against live Apache Spark SQL from MySQL Workbench.
-
How to Connect to Live GitHub Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live GitHub without replication.
-
Automated Continuous Smartsheet Replication to Databricks
Use CData Sync for automated, continuous, customizable Smartsheet replication to Databricks.
-
Connect to Procore from a Connection Pool in WebLogic
Use the CData JDBC Driver for Procore to connect to Procore from Web applications running on WebLogic.
-
Connect ZohoInvoice Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoInvoice using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous XML Replication to SQL Server
Use CData Sync for automated, continuous, customizable XML replication to SQL Server.
-
Automated Continuous Asana Replication to Vertica
Use CData Sync for automated, continuous, customizable Asana replication to Vertica.
-
Create Bitly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bitly from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to & Open SAP Business Warehouse Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Business Warehouse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live SAP Concur Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Concur in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Parquet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Parquet.
-
Build Semantic Layer Views for Quaderno Data in APOS Live Data Gateway
Use the CData Connector for Quaderno in APOS Live Data Gateway to build Semantic Layer Views for Quaderno.
-
How to Easily Query Parquet Data in OpenOffice Base
Connect to Parquet data in OpenOffice Base using the CData ODBC Driver for Parquet and generate reports with live data insights.
-
Connect to BenchmarkEmail Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect and Visualize Live Sybase IQ Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sybase IQ into the Databricks platform and create visualization dashboards with real-time Sybase IQ.
-
Integrating LangChain with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Elasticsearch within automated workflows.
-
Replicate Front Data in Heroku for Use in Salesforce Connect
Replicate Front to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for MessageBird from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MessageBird to connect to MessageBird from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MessageBird in Excel.
-
Work with Salesforce Data 360 Data in FoxPro
Load Salesforce Data 360 into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build LightSpeedRetail-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LightSpeedRetail.
-
Integrate Cline with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Business ByDesign from within your IDE.
-
Build Oracle Financials Cloud-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Financials Cloud Data from Choreo and build custom apps using live Oracle Financials Cloud.
-
Create SAP SuccessFactors-Connected Business Apps in AppSheet
Connect to SAP SuccessFactors Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP SuccessFactors.
-
Validate FreeAgent Data with QuerySurge
Access and validate FreeAgent in QuerySurge using the CData JDBC Driver.
-
How to Visualize Vercel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Vercel in Python.
-
Connect to Superchat in SpagoBI
Create reports featuring live Superchat in SpagoBI Studio. Host Superchat reports on SpagoBI Server.
-
Create Datasets from Mailjet in Domo Workbench and Build Visualizations of Mailjet Data in Domo
Use the CData Software ODBC Driver for Mailjet to create datasets from Mailjet in Domo Workbench and then build visualizations in the Domo service.
-
Feed SQL Analysis Services Data into FineReport
How to set SQL Analysis Services as a JDBC data source in FineReport.
-
Getting Started with the CData ADO.NET Provider for Deel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create a Data Access Object for Parallel Data using JDBI
A brief overview of creating a SQL Object API for Parallel in JDBI.
-
Integrate Cline with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live IBM DB2 from within your IDE.
-
Getting Started with the CData ADO.NET Provider for Harvest
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze Mocean Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mocean with the CData JDBC Driver for Mocean.
-
Bridge Miro Connectivity with Apache NiFi
Access and process Miro in Apache NiFi using the CData JDBC Driver.
-
Integrating Cursor CLI with Google Sheets 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 Azure AI Foundry to Talk to Your SAS Data Sets 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 SAS Data Sets for you.
-
Visualize Live SQL Analysis Services Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SQL Analysis Services into custom reports in Power BI.
-
Visualize LionDesk 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 LionDesk into TIBCO Spotfire.
-
DataBind Templated Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Templated to a chart.
-
Neo4J Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Neo4J through CData Connect AI using different applications and tools.
-
How to connect PolyBase to ConvertAPI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ConvertAPI.
-
Analyze Oracle Service Cloud Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Service Cloud and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to load FHIR data into Elasticsearch via Logstash
Introducing a simple method to load FHIR data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous SageHR Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SageHR replication to Amazon Redshift.
-
Extract, Transform, and Load ZohoSubscriptions Data in Informatica PowerCenter
Create a simple Workflow for ZohoSubscriptions in Informatica PowerCenter.
-
Add Dropbox Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dropbox with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect Float to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Float using the CData Python MCP Server.
-
Prepare, Blend, and Analyze Facebook Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Facebook Ads for self-service data analytics.
-
DataBind Charts to Elasticsearch Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Elasticsearch 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.
-
Connect to WordPress Data in Ruby
Connect to WordPress in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Wistia Data in ColdFusion
Write standard ColdFusion data access code to connect to Wistia.
-
How to connect to Salesforce CRM Analytics Data from IntelliJ
Integrate connectivity to Salesforce CRM Analytics with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy
Connect to Chargebee in MicroStrategy Developer using the CData Software ODBC Driver for Chargebee.
-
Use Biml to Build SSIS Tasks to Replicate SendGrid Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendGrid to SQL Server.
-
How to connect to JDBC-ODBC Bridge Data in DBVisualizer
Integrate JDBC-ODBC Bridge with visual data analysis tools and data connection wizards in DBVisualizer
-
Easily Integrate Zoho Projects Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Projects in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ActiveCampaign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ActiveCampaign in the Denodo Virtual DataPort Administrator.
-
Create SSAS Tabular Models from Instantly Data
How to build a SQL Server Analysis Service Tabular Model from Instantly using CData drivers.
-
Validate ZarMoney Data with QuerySurge
Access and validate ZarMoney in QuerySurge using the CData JDBC Driver.
-
Model API Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and API, enabling the direct import of real-time API.
-
How to Visualize Apollo Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Apollo in Python.
-
Build Automated Workflows with Live Apollo Data in Workato
Use CData Connect AI to connect to live Apollo and build automated workflows in Workato.
-
Migrating data from SFTP to Snowflake using CData SSIS Components.
Easily push SFTP to Snowflake using the CData SSIS Tasks for SFTP and Snowflake.
-
Automated Continuous Testmonitor Replication to Snowflake
Use CData Sync for automated, continuous, customizable Testmonitor replication to Snowflake.
-
A PostgreSQL Interface for Tally Data using the CData ODBC Driver
Use the SQL Gateway and Tally ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Azure Table 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 Azure Table Storage for you.
-
Integrate LibreChat with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Data Lake Storage from within the chat interface.
-
Connect to Couchbase Data from a Connection Pool in Jetty
The Couchbase JDBC Driver supports connection pooling: This article shows how to connect faster to Couchbase from Web apps in Jetty.
-
Automated Continuous eBay Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Google BigQuery.
-
Build FTP-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for FTP to explore live FTP Data in Gemini Code Assist to assist with building FTP-powered applications.
-
Use Dash to Build Web Apps on Avro Data via CData Connect AI
Build interactive Dash web apps on live Apache Avro using pandas and the CData Connect AI Python SDK.
-
Connect to Sentry Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build MVC Applications with Connectivity to Browserless Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Browserless from an ASP.NET MVC application.