CData Software - Knowledge Base
Recent Articles
-
Build Agents in Relevance AI with Access to Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Dynamics 365 within intelligent agent workflows.
-
How to Query Live MYOB AccountRight Data in Claude Desktop
Connect to and query live MYOB AccountRight Data in Claude Desktop using CData MCP Server.
-
How to Build an ETL App for Bugsnag Data in Python with CData
Create ETL applications and real-time data pipelines for Bugsnag in Python with petl.
-
Analyze Microsoft Ads Data in Looker
Use CData Connect AI to connect to Microsoft Ads Data from Looker and build custom apps using live Microsoft Ads.
-
Extract, Transform, and Load Sage 300 Data in Informatica PowerCenter
Create a simple Workflow for Sage 300 in Informatica PowerCenter.
-
Query GraphQL Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume GraphQL entities in PHP by modeling them as objects.
-
Getting Started with the CData Python Connector for SAP Business One
Learn to install and license the CData Python Connector
-
ETL MYOB AccountRight in Oracle Data Integrator
This article shows how to transfer MYOB AccountRight into a data warehouse using Oracle Data Integrator.
-
Connect to Ontraport Data from PowerBuilder via JDBC
This article demonstrates how to access Ontraport from PowerBuilder using the Ontraport JDBC Driver.
-
Automated Continuous Jodoo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jodoo replication to Snowflake.
-
How to Connect to Live OData Services from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your OData for you.
-
Use Grok to Talk to Your Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Lakebase for you.
-
Create Power BI Reports on Real-Time QuickBooks Time Data
Use the CData ODBC Driver for QuickBooks Time to visualize QuickBooks Time in Power BI Desktop.
-
Redis Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Redis facts in real time.
-
Connect Amazon DynamoDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon DynamoDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize HCL Domino Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HCL Domino.
-
Automated Continuous OData Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable OData replication to Amazon Redshift.
-
Build Productboard-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Productboard.
-
Publish ZohoPeople-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoPeople.
-
Create Google Search-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Search Results from OutSystems and build custom enterprise apps using live Google Search.
-
Access Typeform Data from MySQL in Amazon QuickSight
Connect to Typeform and build visualizations of Typeform using a MySQL Connection in Amazon QuickSight.
-
Connect Workday to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Workday with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Avro Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Avro replication to Google Cloud SQL.
-
Integrate Live Zoho Books Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Import Real-Time Sage Intacct Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sage Intacct in ColdFusion.
-
Getting Started with the CData Tableau Connector for Paddle
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Extract, Transform, and Load Harvest Data in Informatica PowerCenter
Create a simple Workflow for Harvest in Informatica PowerCenter.
-
Integrating LangChain with HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on HCL Domino within automated workflows.
-
Build Semantic Layer Views for YouTube Analytics Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for YouTube Analytics.
-
Connect SAP Ariba Procurement to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Ariba Procurement with IBM WebSphere for seamless data integration and connectivity.
-
Integrate MYOB AccountRight with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MYOB AccountRight with External Services.
-
How to create Bugsnag federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bugsnag in MySQL .
-
Access Live Marketo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Marketo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Load Recurly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Recurly to a database.
-
Validate Testmonitor Data with QuerySurge
Access and validate Testmonitor in QuerySurge using the CData JDBC Driver.
-
Connect to Live GitHub Data in MicroStrategy through CData Connect AI
Create a live connection to GitHub Data in CData Connect AI and connect to your GitHub from MicroStrategy.
-
Explore Geographical Relationships in SAP ByDesign Data with Power Map
Create data visualizations with SAP Business ByDesign in Power Map.
-
Stream Coinbase Data into Apache Kafka Topics
Access and stream Coinbase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Deploy the ADO.NET Provider for LinkedIn Ads on an SSRS Report Server
Connect to LinkedIn Ads 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 Microsoft Planner Data in TIBCO Data Virtualization
Use the Microsoft Planner Tibco DV Adapter to create a Microsoft Planner data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Planner from your TDV Server.
-
Model Spark Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Spark, enabling the direct import of real-time Apache Spark SQL.
-
LINQ to Intercom Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Intercom Data Provider.
-
Connect Pipedrive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pipedrive using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Stream SAP Ariba Procurement Data into Apache Kafka Topics
Access and stream SAP Ariba Procurement in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Dashboards with Azure DevOps Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure DevOps in Dundas BI.
-
Import Zoho Creator Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Creator Data from Azure Data Factory and import live Zoho Creator.
-
Object-Relational Mapping (ORM) with Dynamics CRM 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 Microsoft Dynamics CRM into a Java-based ORM framework, Hibernate.
-
Access Unbounce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Unbounce from HeidiSQL.
-
Automate Google Search Results Replication to Azure Data Lake
Use CData Sync to customize and automate Google Search replication to Azure Data Lake.
-
Integrating LlamaIndex with Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Stripe in real time.
-
Connect to CampaignMonitor Data in CloverDX (formerly CloverETL)
Transfer CampaignMonitor using the visual workflow in the CloverDX data integration tool.
-
How to Import Data from Act CRM into Google Sheets
Import Act CRM into a Google spreadsheet that is automatically refreshed.
-
Connect to Auth0 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Auth0 and the SQL Gateway to access Auth0 from Google Apps Script.
-
Extend Google Sheets with Google Spanner Data
Make calls to Google Spanner from Google Apps Script via the API Server.
-
Connect to Discord Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Discord and work with Discord in your FileMaker applications.
-
Deploy the ADO.NET Provider for Opsgenie on an SSRS Report Server
Connect to Opsgenie 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.
-
How to Create Power BI Visual Reports with Real-Time Missive Data
Use CData Power BI Connectors to visualize Missive in Power BI.
-
Create Nethunt Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Nethunt from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Dropbox Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Suadeo Data in Pentaho Data Integration
Build ETL pipelines based on Suadeo in the Pentaho Data Integration tool.
-
Load Pipeline CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pipeline CRM to a database.
-
Moving Data from Google Campaign Manager 360 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Campaign Manager 360 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Operational Reporting on Onfleet Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Onfleet.
-
Access Zoho Projects 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 Zoho Projects.
-
How to work with SAS Data Sets Data in Apache Spark using SQL
Access and process SAS Data Sets Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Cohere Data in the Pentaho Report Designer
Publish reports based on Cohere in the Pentaho BI tool.
-
How to Connect the Power BI Service to Coda: Complete Guide
Connect to the CData Software Power BI Connector for Coda from PowerBI.com to provide real-time Coda across the organization.
-
Integrate Open WebUI with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Search from within the chat interface.
-
How to Connect DBeaver to Gong via a JDBC Driver
Manage Gong with visual tools in DBeaver like the query browser.
-
Build AI Agents with SendGrid 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 SendGrid through CData Connect AI.
-
Replicate Multiple Google Tasks Accounts via the CData Sync CLI
Replicate multiple Google Tasks accounts to one or many databases.
-
Integrating GitHub Copilot CLI with ZeroBounce 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 Quaderno Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Quaderno from an ASP.NET MVC application.
-
Create Data Visualizations in Cognos BI with Azure Data Catalog Data
Access Azure Data Catalog as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
LINQ to Optimizely Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Optimizely Data Provider.
-
Connect to Vault CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Vault CRM as an External Source in Dremio.
-
Automated Continuous Dynamics NAV Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to MySQL.
-
Integrating Boomi Agentstudio with Okta Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Okta, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Extend Google Sheets with Presto Data
Make calls to Presto from Google Apps Script via the API Server.
-
Build AI/ML Models with Live Eventbrite Data using Dataiku
Connect Eventbrite Data with Dataiku using the CData API Driver for JDBC.
-
Bidirectional Access to EnterpriseDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate EnterpriseDB in Filemaker Pro for Mac or Windows.
-
Stream Teamwork Data into Apache Kafka Topics
Access and stream Teamwork in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Excel Spreadsheet Automation on LightSpeedRetail Data with the QUERY Formula
Pull data from LightSpeedRetail, automate spreadsheets, and more with the QUERY formula.
-
Use the CData API Server to Access Sage 200 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sage 200 in the Power Pivot business intelligence tool.
-
Integrating Gumloop with Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Contacts within automated workflows.
-
Migrating data from Facebook to Databricks using CData SSIS Components.
Easily push Facebook to Databricks using the CData SSIS Tasks for Facebook and Databricks.
-
Integrating Claude Code CLI with SAP Ariba Source 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 AI/ML Models with Live Facebook Ads Data using Dataiku
Connect Facebook Ads Data with Dataiku using the CData JDBC Driver for Facebook Ads.
-
Build Agents in Relevance AI with Access to Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Directory within intelligent agent workflows.
-
Publish Reports with Kafka Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Kafka.
-
How to connect PolyBase to Adobe Commerce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Commerce.
-
How to Build an ETL App for LaunchDarkly Data in Python with CData
Create ETL applications and real-time data pipelines for LaunchDarkly in Python with petl.
-
Integrate Oracle Financials Cloud with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Financials Cloud with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Financials Cloud.
-
Create Power BI Reports on Real-Time SparkPost Data
Use the CData ODBC Driver for SparkPost to visualize SparkPost in Power BI Desktop.
-
Access Live Salesforce Pardot Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce Pardot from your Excel spreadsheets.
-
Connect to Snowflake Data in HULFT Integrate
Connect to Snowflake as a JDBC data source in HULFT Integrate
-
Build IBM Cloud Object Storage Visualizations in Tableau Desktop
Use CData Connect AI to connect to live IBM Cloud Object Storage and build visualizations in Tableau.
-
Connect to Cvent in SpagoBI
Create reports featuring live Cvent in SpagoBI Studio. Host Cvent reports on SpagoBI Server.
-
Build Automated Google Ad Manager-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Ad Manager and build automated workflows in Zapier.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy Web
Connect to Sage Business Cloud Accounting in MicroStrategy Web using the CData Software ODBC Driver for Sage Cloud Accounting.