CData Software - Knowledge Base
Recent Articles
-
Build Amazon Athena-Connected Apps in Choreo
Use CData Connect AI to connect to Amazon Athena Data from Choreo and build custom apps using live Amazon Athena data.
-
Create Slack Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Slack data access from reports, embedded analytics, and more.
-
Connect Scrapfly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Scrapfly with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Vertica Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Vertica replication to delimited files (CSV/TSV).
-
Import Real-Time Airtable Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Airtable data in ColdFusion.
-
How to Connect Guru Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Guru data in real time using natural language.
-
Integrate Live Redshift Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Redshift data and integrate live Redshift data into apps built in Microsoft Power Apps.
-
Import and Visualize GetResponse Data in Power View
Create data visualizations based on GetResponse data in Excel.
-
View Reports on Real-Time PabblySubscriptions Data in Power BI Report Server
Use the CData ODBC Driver for PabblySubscriptions to visualize PabblySubscriptions data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Salesloft Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesloft data and visualize live Salesloft data in Infragistics Reveal.
-
Load Avro Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Avro data to a database.
-
Automated Authorize.Net Data Replication to Teradata
Use CData Sync to Customize and automate Authorize.Net data replication to Teradata.
-
DataBind Charts to LightSpeedRetail Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LightSpeedRetail 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.
-
Getting Started with the CData ADO.NET Provider for Redshift
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Redshift.
-
Create Data Visualizations in Cognos BI with Oracle Sales Data
Access Oracle Sales data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Validate Invoiced Data with QuerySurge
Access and validate Invoiced data in QuerySurge using the CData JDBC Driver.
-
Create Apps from Timely Data in Qlik Sense Cloud
Use CData Connect AI to connect to Timely Data and build apps from live Timely data in Qlik Sense Cloud.
-
Feed Beeminder Data into FineReport
How to set Beeminder data as a JDBC data source in FineReport.
-
Connect to Google Directory Data in NetBeans
Connect to Google Directory data in NetBeans with the data source configuration wizard.
-
Access Live SAP Business Warehouse Data in Excel 365 Online (Excel for the web)
Connect to SAP Business Warehouse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Publish Crystal Reports on ChartMogul Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ChartMogul data.
-
Create SSAS Tabular Models from Scrapfly Data
How to build a SQL Server Analysis Service Tabular Model from Scrapfly data using CData drivers.
-
Connecting Mastra with Teradata Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Teradata data, no replication required.
-
Connect to Couchbase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Couchbase in FileMaker Pro to connect to Couchbase and work with Couchbase data in your FileMaker applications.
-
Replicate Pipeline CRM Data to Multiple Databases
Replicate Pipeline CRM data to disparate databases with a point-and-click configuration.
-
Operational Reporting on REST Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote REST data.
-
Automated Continuous Zoom Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoom replication to Oracle.
-
Analyze Live Azure Data Lake Storage Data in SAS Viya
Use CData Connect AI to connect to Azure Data Lake Storage data from SAS Viya and deploy self-service analytics using live Azure Data Lake Storage data.
-
Visualize Live Gorgias Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Gorgias data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Prepare, Blend, and Analyze SQL Analysis Services Data in Alteryx Designer (Connect AI)
Build workflows to access live SQL Analysis Services data for self-service data analytics.
-
How to load Amazon DynamoDB data into Elasticsearch via Logstash
Introducing a simple method to load Amazon DynamoDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Placid Data in Coginiti Pro
Connect to and query live Placid data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Notion Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Notion data through MCP integration.
-
Use CData Connect AI to Access Google Calendar Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Calendar data in the Power Pivot business intelligence tool.
-
Build a Singer.io Tap for Mixpanel With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mixpanel data using the CData Python Connector.
-
Integrating OpenCode with BigQuery 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.
-
Viewing EmailOctopus Data in RAD Studio Data Explorer
How to view EmailOctopus data in RAD Studio Data Explorer using the CData ODBC Driver for EmailOctopus.
-
Feed TigerGraph Data into FineReport
How to set TigerGraph data as a JDBC data source in FineReport.
-
Automated Continuous Google Cloud Storage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Apache Kafka.
-
Use Agno to Talk to Your SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP HANA XS Advanced data for you.
-
Integrate Goose with Live PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live PingOne data from within the local AI agent.
-
Access Live Exact Online Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Exact Online data through MCP integration.
-
Visualize Reckon Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Reckon data.
-
Build a Singer.io Tap for Sentry With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sentry data using the CData Python Connector.
-
How to Work with Brex Data in AWS Glue Jobs Using JDBC
Connect to Brex from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Freshdesk Replication to MySQL
Use CData Sync for automated, continuous, customizable Freshdesk replication to MySQL.
-
Excel Spreadsheet Automation on Webex Data with the QUERY Formula
Pull data from Webex, automate spreadsheets, and more with the QUERY formula.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Sheets
Create an ODBC connection to Google Sheets in Informatica and browse and transfer Google Sheets data.
-
Build an OLAP Cube in SSAS from ZohoMarketingHub Data
Establish a connection to ZohoMarketingHub data data from SQL Server Analysis Services, and use the ZohoMarketingHub Data Provider to build OLAP cubes for use in analytics and reporting.
-
Natively Connect to Copper Data in PHP
The CData ODBC driver for Copper enables you to create PHP applications with connectivity to Copper data. Leverage the native support for ODBC in PHP.
-
Build Semantic Layer Views for Ontraport Data in APOS Live Data Gateway
Use the CData Connector for Ontraport in APOS Live Data Gateway to build Semantic Layer Views for Ontraport data.
-
How to integrate Perplexity with Apache Airflow
Access and process Perplexity data in Apache Airflow using the CData JDBC Driver.
-
How to Query Telegram Data in MySQL Workbench
Execute MySQL queries against live Telegram data from MySQL Workbench.
-
How to Connect to & Open Certinia Data in Microsoft Excel
This article uses the CData ODBC driver for Certinia to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Aweber-Connected Nintex Workflows
Use CData Connect AI to connect to Aweber Data from Nintex Workflow Cloud and build custom workflows using live Aweber data.
-
Use the CData ODBC Driver for ZeroBounce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZeroBounce to connect to ZeroBounce data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZeroBounce data in Excel.
-
Access Live Exa Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Exa data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Billsby Data in Tableau
The CData ODBC driver for Billsby enables you integrate Billsby data into Tableau dashboards.
-
Integrating Kiro with ZohoPeople 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.
-
Analyze ConstantContact Data in Looker
Use CData Connect AI to connect to ConstantContact Data from Looker and build custom apps using live ConstantContact data.
-
Automated Continuous Apollo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Apollo replication to Azure SQL Database.
-
Analyze FTP Data in Cognos Analytics
Use CData Connect AI to connect to FTP Data from Cognos Analytics and analyze live FTP data.
-
Process & Analyze ZeroBounce Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZeroBounce Data.
-
Build a Singer.io Tap for Bannerbear With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bannerbear data using the CData Python Connector.
-
Connect to Invoiced Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Invoiced data using standard SQL.
-
Integrate with Basecamp Data in JReport Designer
Create charts and reports based on Basecamp data in JReport Designer.
-
Connecting GenSpark with Klipfolio Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Klipfolio data without any replication or custom integration required.
-
How to Connect to Live Discord 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 Discord data for you.
-
Connect to SingleStore Data in JRuby
Create a simple JRuby app with access to live SingleStore data.
-
Access ZohoPeople Data from MySQL in Amazon QuickSight
Connect to ZohoPeople and build visualizations of ZohoPeople data using a MySQL Connection in Amazon QuickSight.
-
Query Sugar CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sugar CRM entities in PHP by modeling them as objects.
-
Automated Continuous Oracle Eloqua Reporting Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Databricks.
-
Automated Continuous Bitbucket Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bitbucket replication to AlloyDB.
-
Object-Relational Mapping (ORM) with SAS Data Sets 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 SAS Data Sets data into a Java-based ORM framework, Hibernate.
-
Build eBay Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live eBay Analytics data and build visualizations in Tableau Cloud.
-
Connect to Freshteam Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshteam to connect to Freshteam data and execute queries in PowerBuilder.
-
Consume Azure Data Lake Storage OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Data Lake Storage data as OData feeds from PowerBuilder using the API Server.
-
Bridge SendPulse Connectivity with Apache NiFi
Access and process SendPulse data in Apache NiFi using the CData JDBC Driver.
-
Integrate Devin with Live SAP Ariba Procurement Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SAP Ariba Procurement data.
-
Analyze Redis Data in Looker
Use CData Connect AI to connect to Redis Data from Looker and build custom apps using live Redis data.
-
Pinecone Reporting in OBIEE with the Pinecone JDBC Driver
Deploy the Pinecone JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Access Live Webflow Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Webflow enables you to integrate Webflow data into workflows built using Microsoft Power Automate Desktop.
-
Model Trello Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Trello, enabling the direct import of real-time Trello data.
-
Design BIRT Reports on Blackbaud FE NXT Data
Provide current Blackbaud FE NXT data to your embedded analytics.
-
How to load Bitbucket data into Elasticsearch via Logstash
Introducing a simple method to load Bitbucket data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Crystal Reports on Teradata Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teradata data.
-
Import Real-Time Jumpseller Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Jumpseller data in ColdFusion.
-
Connect to SendPulse Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SendPulse data in Airbyte.
-
Connect to Salesforce CRM Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce CRM Analytics and the Script function in FileMaker Pro to connect to Salesforce CRM Analytics and work with Salesforce CRM Analytics data in your FileMaker application.
-
Connect to Bright Data Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bright Data to connect to Bright Data data and execute queries in PowerBuilder.
-
How to create an RPA flow for Google Campaign Manager 360 Data in UiPath Studio
Use the Google Campaign Manager 360 ODBC Driver to create workflows that access real-time Google Campaign Manager 360 data without any coding.
-
Deploy the ADO.NET Provider for ConstantContact on an SSRS Report Server
Connect to ConstantContact 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.
-
Access Live Egnyte Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Egnyte data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Rapidly Develop GetResponse-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by GetResponse.
-
Connect to ServiceNow Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ServiceNow data in Airbyte.
-
Build Apps with Live Redshift data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Redshift data into the Adalo platform and build custom mobile and web applications with real-time Redshift data.
-
Access Act CRM 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 Act CRM data.
-
Query Freshteam Data as a SQL Server Database in Node.js
Execute SQL Server queries against Freshteam data from Node.js.
-
Working with GitHub Data in LINQPad
Execute LINQ queries to GitHub data in LINQPad.
-
Interact with Live Mailjet Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Mailjet data.