CData Software - Knowledge Base
Recent Articles
-
Viewing Guru Data in RAD Studio Data Explorer
How to view Guru data in RAD Studio Data Explorer using the CData ODBC Driver for Guru.
-
Getting Started with the CData SSIS Components for Oracle
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle.
-
Automated Continuous Amazon Marketplace Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Google Cloud SQL.
-
Connect to SAP Fieldglass from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Fieldglass to connect to SAP Fieldglass data from Web applications running on WebLogic.
-
Access Live Omnisend Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Omnisend data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Dynamics 365 Business Central-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Dynamics 365 Business Central Data and create custom apps in Bubble.
-
Access Live Attio 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 Attio data through MCP integration.
-
Build Pipelines with Live SharePoint Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SharePoint from Google Cloud Data Fusion, enabling the integration of live SharePoint data into the building and management of effective data pipelines.
-
Operational Reporting on Confluence Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Confluence data.
-
Connect to Zendesk Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zendesk data from Filemaker Pro on Mac.
-
Automated Continuous Google Translate Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Translate replication to Oracle.
-
Connect Dynamics NAV to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dynamics NAV with IBM WebSphere for seamless data integration and connectivity.
-
Trigger HBase IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for HBase with standard wizards in Logic Apps.
-
Build SingleStore-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SingleStore Data and create custom apps in Mendix.
-
Connect to Twitter Ads Data in JRuby
Create a simple JRuby app with access to live Twitter Ads data.
-
How to Work with LaunchDarkly Data in ETL Validator JDBC
Connect to LaunchDarkly from ETL Validator jobs using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Campaigner
Provide connectivity to Campaigner data through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Greenplum
Provide connectivity to Greenplum data through an SAP BusinessObjects universe.
-
Moving Data from Microsoft Exchange to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Exchange data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Pingdom Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pingdom replication to Amazon Redshift.
-
Integrate Coinbase Data in the Pentaho Report Designer
Publish reports based on Coinbase data in the Pentaho BI tool.
-
Visualize Instagram 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 Instagram data into TIBCO Spotfire.
-
Use the CData ODBC Driver for Jira Assets in Microsoft Power Query
You can use the CData Jira Assets ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jira Assets data into Microsoft Power Query.
-
Access Live Attio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Attio data into the statistical analysis tools available in SAS JMP. This article shows how to use Attio data in the Graph Builder and Query Builder.
-
Use ChatGPT to Talk to Your Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Egnyte data for you.
-
Integrate Goose with Live Printify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Printify data from within the local AI agent.
-
Automate Hive Data Replication to Couchbase
Use CData Sync to Customize and automate Hive data replication to Couchbase.
-
Load GitHub Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load GitHub data to a database.
-
Integrate Google's Vertex AI Agent with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Monday.com data within intelligent workflows.
-
Integrate Goose with Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live GetResponse data from within the local AI agent.
-
How to Work with ZendeskSell Data in ETL Validator JDBC
Connect to ZendeskSell from ETL Validator jobs using the CData Software JDBC Driver.
-
Import Real-Time Copper Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Copper data in ColdFusion.
-
Seamlessly Bring Reckon Accounts Hosted Data into Retool Using CData Connect AI
Integrate Reckon Accounts Hosted data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Oracle Eloqua Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Eloqua data from Node.js.
-
Migrating data from Omnisend to Snowflake using CData SSIS Components.
Easily push Omnisend data to Snowflake using the CData SSIS Tasks for Omnisend and Snowflake.
-
Integrate Blackbaud FE NXT Data into Power Automate Desktop using CData Connect
CData Connect for Blackbaud FE NXT Data enables you to integrate Blackbaud FE NXT data into workflows built using Microsoft Power Automate Desktop.
-
Connect to PostgreSQL Data in Google Apps Script via Connect AI
Use CData Connect AI to access PostgreSQL data in Google Apps Script.
-
Integrating Claude Code CLI with Aha! 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 Automated Reckon Accounts Hosted-Connected Workflows in Zapier
Use CData Connect AI to connect to live Reckon Accounts Hosted data and build automated workflows in Zapier.
-
Create Power BI Reports on Real-Time Strava Data
Use the CData ODBC Driver for Strava to visualize Strava data in Power BI Desktop.
-
Build Voice Agents in ElevenLabs with access to Live CapsuleCRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live CapsuleCRM data.
-
DataBind Perigon Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Perigon data to a chart.
-
Model Egnyte Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Egnyte, enabling the direct import of real-time Egnyte data.
-
Connect to ActiveCampaign Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ActiveCampaign and the SQL Gateway to access ActiveCampaign data from Google Apps Script.
-
How to connect and process Excel data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Excel data.
-
Easily Integrate PingOne Data in Lazarus Pascal IDE
Learn how to easily integrate live PingOne data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData SSIS Components for SFTP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SFTP.
-
Integrate OpenCode with Live QuickBooks Time Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live QuickBooks Time data from within your AI coding agent.
-
Build Dashboards with JSON Services in Dundas BI
Create dynamic dashboards and perform analytics based on JSON services in Dundas BI.
-
Provide OData Services of OpenWeatherMap Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for OpenWeatherMap data by developing a WCF Service Application.
-
Connect to Lakebase Data in RazorSQL
Connect to Lakebase from wizards and query Lakebase data from the GUI in the RazorSQL database management tool.
-
Connect to Google Analytics Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Analytics data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Analytics.
-
Use the CData ODBC Driver for Mixpanel from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mixpanel to connect to Mixpanel data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mixpanel data in Excel.
-
Create Power BI Reports on Real-Time Marketo Data
Use the CData ODBC Driver for Marketo to visualize Marketo data in Power BI Desktop.
-
Connect to Azure Analysis Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Analysis Services data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Moosend Replication to SQLite
Use CData Sync for automated, continuous, customizable Moosend replication to SQLite.
-
A PostgreSQL Interface for Mouseflow Data using the CData ODBC Driver
Use the SQL Gateway and Mouseflow ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Gumloop with MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MailerLite data within automated workflows.
-
Create Datasets from Pinterest in Domo Workbench and Build Visualizations of Pinterest Data in Domo
Use the CData Software ODBC Driver for Pinterest to create datasets from Pinterest data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData SSIS Components for Close
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Close.
-
Connect to Rebilly Data from PowerBuilder via JDBC
This article demonstrates how to access Rebilly data from PowerBuilder using the Rebilly JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks data for you.
-
Build Microsoft Dataverse-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Microsoft Dataverse data without replication.
-
Connect to Avro Data in NetBeans
Connect to Avro data in NetBeans with the data source configuration wizard.
-
Automated Continuous Email Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Email replication to Google Cloud SQL.
-
Publish Reports with Strava Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Strava data.
-
Automated Continuous Greenplum Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Greenplum replication to Apache Cassandra.
-
Connect to Optimizely Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Optimizely data in Airbyte.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Snowflake.
-
How to Connect to Live NetSuite Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your NetSuite data for you.
-
How to integrate FTP with Apache Airflow
Access and process FTP data in Apache Airflow using the CData JDBC Driver.
-
Access Live Zoho Books 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 Zoho Books data through MCP integration.
-
Create Reports with Zuora Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zuora data.
-
Create a Data Access Object for RabbitMQ Data using JDBI
A brief overview of creating a SQL Object API for RabbitMQ data in JDBI.
-
How to create Simplesat federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Simplesat data in MySQL .
-
How to load Microsoft Dataverse data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Dataverse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Trae with Live Sage 200 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sage 200 data from within the AI-powered IDE.
-
Extract, Transform, and Load Trello Data in Informatica PowerCenter
Create a simple Workflow for Trello data in Informatica PowerCenter.
-
Access MYOB AccountRight Data from MySQL in Amazon QuickSight
Connect to MYOB AccountRight and build visualizations of MYOB AccountRight data using a MySQL Connection in Amazon QuickSight.
-
Create SSAS Tabular Models from ConstantContact Data
How to build a SQL Server Analysis Service Tabular Model from ConstantContact data using CData drivers.
-
Connect to Real-Time Google Calendar Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Calendar and Dataflow to import and use Google Calendar data in Power Apps.
-
How to Access Reckon Data Using Entity Framework
This article shows how to access Reckon data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Visualizations of SAP Hybris C4C Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Hybris C4C data in Birst.
-
Use Dash to Build to Web Apps on Missive Data
Create Python applications that use pandas and Dash to build Missive-connected web apps.
-
Use the CData Software JDBC Driver for Paddle in MicroStrategy Web
Connect to Paddle data in MicroStrategy Web using the CData Software JDBC Driver for Paddle.
-
Working with Rebilly Data in LINQPad
Execute LINQ queries to Rebilly data in LINQPad.
-
How to connect and process Dropbox data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Dropbox data.
-
Migrating data from ConvertAPI to Snowflake using CData SSIS Components.
Easily push ConvertAPI data to Snowflake using the CData SSIS Tasks for ConvertAPI and Snowflake.
-
DataBind Charts to QuickBooks Online Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks Online 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.
-
Create Google Cloud Storage Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Cloud Storage from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData JDBC Driver for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle Eloqua Reporting.
-
Extract, Transform, and Load Microsoft Teams Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Teams data in Informatica PowerCenter.
-
Build AI Agents with HCL Domino Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live HCL Domino data through CData Connect AI.
-
Publish SAP Business One-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Business One data.
-
Automated Continuous Google Tasks Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Tasks data replication to OneLake in Microsoft Fabric.
-
A PostgreSQL Interface for SendPulse Data (MySQL Remoting via JDBC)
Use the Remoting features of the SendPulse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous IBM Informix Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable IBM Informix replication to Azure SQL Database.
-
Prepare, Blend, and Analyze ShipEngine Data in Alteryx Designer (Connect AI)
Build workflows to access live ShipEngine data for self-service data analytics.
-
Connect to Foursquare 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 Foursquare and work with Foursquare data in your FileMaker application.
-
Integrating Antigravity CLI with Amazon Athena data via CData CLI
Connect Amazon Athena data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.