CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to Invoiced Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Invoiced in Filemaker Pro for Mac or Windows.
-
Automated Continuous Klaviyo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Klaviyo replication to PostgreSQL.
-
How to Query Live Billsby Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Billsby data in natural language using Python.
-
Build SAP Ariba Procurement Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Ariba Procurement and build visualizations in Tableau Cloud.
-
Create Workday Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Workday from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect Amazon QuickSight to PayPal Data
Create a connection to PayPal in CData Connect AI and insert PayPal into Amazon QuickSight SPICE to build interactive dashboards.
-
DataBind Charts to Facebook Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Facebook Ads 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 Adobe Experience Manager Data in Microsoft Excel
This article uses the CData ODBC driver for Adobe Experience Manager to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Import Data from WooCommerce into Google Sheets
Import WooCommerce into a Google spreadsheet that is automatically refreshed.
-
Analyze eBay Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of eBay Analytics and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Using Claude Projects to Work Effectively with Dynamic Data Models with CData Connect AI
Learn how Claude Projects and CData Connect AI work together to understand dynamic Google Sheets schemas and generate accurate, efficient queries.
-
How to connect and process Freshservice from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Freshservice.
-
Build AI/ML Models with Live SpaceX Data using Dataiku
Connect SpaceX Data with Dataiku using the CData API Driver for JDBC.
-
Integrating GitHub Copilot CLI with BigCommerce 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.
-
Visualize Google Drive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Drive.
-
Create Data Visualizations in Cognos BI with Nethunt Data
Access Nethunt as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Google Forms with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Forms with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Forms.
-
Work with Live Workday Data in Power Query
Use CData Connect AI to connect to Workday and work with live Workday in Microsoft Power Query.
-
Deploy the ADO.NET Provider for NetSuite on an SSRS Report Server
Connect to NetSuite CRM & ERP 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 Telegram federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Telegram in MySQL .
-
Use JayDeBeApi to access ScrapingBee Data in Python
Use standard Python scripting and the development environment of your choice to access live ScrapingBee.
-
Connect to ServiceNow Data in NetBeans
Connect to ServiceNow in NetBeans with the data source configuration wizard.
-
Use Microsoft Copilot Studio to talk to your MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MySQL for you.
-
Write a Simple Go Application to work with Superchat Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Superchat.
-
Connecting Pipedream with Act-On Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Act-On data in real time.
-
Integrating LangGraph with Oracle Service Cloud Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Service Cloud within automated workflows.
-
Integrating Codex CLI with Apache Hive 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 Odoo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Odoo as an External Source in Dremio.
-
Build Semantic Layer Views for Microsoft Dataverse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dataverse (CDS).
-
Connect to MySQL Data in Google Apps Script via Connect AI
Use CData Connect AI to access MySQL in Google Apps Script.
-
Add AfterShip Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AfterShip with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Cursor CLI with Nethunt 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.
-
How to use SQLAlchemy ORM to access MailerLite Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MailerLite.
-
Use the CData Software JDBC Driver for Marketo in MicroStrategy Desktop
Connect to Marketo in MicroStrategy Desktop using the CData Software JDBC Driver for Marketo.
-
Connect Google Ad Manager Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Ad Manager using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Egnyte Replication to SingleStore
Use CData Sync for automated, continuous, customizable Egnyte replication to SingleStore.
-
Connect to Amazon Marketplace Data from PowerBuilder via ADO.NET
This article demonstrates how to access Amazon Marketplace from Appeon PowerBuilder using the CData ADO.NET Provider for Amazon Marketplace.
-
Create Data Visualizations in Cognos BI with Todoist Data
Access Todoist as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Seamlessly Bring Authorize.Net Data into Retool Using CData Connect AI
Integrate Authorize.Net data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Pingdom Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pingdom replication to Apache Cassandra.
-
Automated Zoho Books Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Books replication to Teradata.
-
Automated Continuous HBase Replication to SingleStore
Use CData Sync for automated, continuous, customizable HBase replication to SingleStore.
-
Build Data Flows from Salesforce Pardot to SQL Server using SSIS
Easily back up Salesforce Pardot to SQL Server using the SSIS components for Salesforce Pardot.
-
Stream Wave Financial Data into Apache Kafka Topics
Access and stream Wave Financial in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize SAP Hybris C4C Data in Tableau
The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C into Tableau dashboards.
-
LINQ to Sybase IQ 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 Sybase IQ Data Provider.
-
Automated Continuous HelloSign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HelloSign replication to AlloyDB.
-
Feed Chargebee Data into FineReport
How to set Chargebee as a JDBC data source in FineReport.
-
Build AI Agents with Splunk 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 Splunk through CData Connect AI.
-
Create QuickBooks Time-Connected Applications in Appsmith
Connect to QuickBooks Time Data via CData Connect AI in Appsmith and create custom business applications with real-time access to QuickBooks Time.
-
A PostgreSQL Interface for Xero Data using the CData ODBC Driver
Use the SQL Gateway and Xero ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Codex CLI with Wistia 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 Lakebase Replication to Databricks
Use CData Sync for automated, continuous, customizable Lakebase replication to Databricks.
-
Connect to MailChimp Data in DBeaver
Use the CData ODBC Driver to connect to MailChimp in DBeaver.
-
Analyze HubSpot Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of HubSpot and visualize live HubSpot in Infragistics Reveal.
-
Add XML Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for XML with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Xero actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Access Live JobNimbus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate JobNimbus into the statistical analysis tools available in SAS JMP. This article shows how to use JobNimbus in the Graph Builder and Query Builder.
-
Automate Billsby Data Replication to Couchbase
Use CData Sync to Customize and automate Billsby replication to Couchbase.
-
Connect to Workable Data from a Connection Pool in Jetty
The Workable JDBC Driver supports connection pooling: This article shows how to connect faster to Workable from Web apps in Jetty.
-
Integrate with ServiceNow Data in JReport Designer
Create charts and reports based on ServiceNow in JReport Designer.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Facebook Ads to Power BI dashboards. Simply drag and drop Facebook Ads into data visuals on the Power BI canvas.
-
Migrating data from Notion to Snowflake using CData SSIS Components.
Easily push Notion to Snowflake using the CData SSIS Tasks for Notion and Snowflake.
-
Automate SparkPost Data Replication to Couchbase
Use CData Sync to Customize and automate SparkPost replication to Couchbase.
-
Validate Odoo Data with QuerySurge
Access and validate Odoo ERP in QuerySurge using the CData JDBC Driver.
-
Integrating Cursor CLI with Shopify 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 the CData Software ODBC Driver for Bannerbear in MicroStrategy Desktop
Connect to Bannerbear in MicroStrategy Desktop using the CData Software ODBC Driver for Bannerbear.
-
Prepare, Blend, and Analyze Freshdesk Data in Alteryx Designer (ODBC)
Build workflows to access live Freshdesk for self-service data analytics.
-
Connect to MessageBird from Asprova with CData Software ODBC Driver for MessageBird
This article shows how to connect faster to MessageBird data from Asprova.
-
Integrate Avro Data in Pentaho Data Integration
Build ETL pipelines based on Apache Avro in the Pentaho Data Integration tool.
-
Getting Started with the CData Power BI Connector for Parallel
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to JotForm Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time JotForm using standard SQL.
-
Replicate Multiple SpaceX Accounts via the CData Sync CLI
Replicate multiple SpaceX accounts to one or many databases.
-
Integrate with Live Facebook Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Facebook from the MuleSoft Anypoint Platform to integrate live Facebook into custom reports and dashboards.
-
Integrate TaxJar Data in Pentaho Data Integration
Build ETL pipelines based on TaxJar in the Pentaho Data Integration tool.
-
Query, Visualize, and Share live Google Analytics Data in Redash
Use CData Connect AI to connect to live Google Analytics in Redash for querying, visualizing, and sharing.
-
How to Build an ETL App for Mixpanel Data in Python with CData
Create ETL applications and real-time data pipelines for Mixpanel in Python with petl.
-
Create FHIR-Connected Nintex Workflows
Use CData Connect AI to connect to FHIR Data from Nintex Workflow Cloud and build custom workflows using live FHIR.
-
Import and Visualize Snapchat Ads Data in Power View
Create data visualizations based on Snapchat Ads in Excel.
-
Create Datasets from Oracle Service Cloud in Domo Workbench and Build Visualizations of Oracle Service Cloud Data in Domo
Use the CData Software ODBC Driver for Oracle Service Cloud to create datasets from Oracle Service Cloud in Domo Workbench and then build visualizations in the Domo service.
-
How to connect Amazon QuickSight to SQL Analysis Services Data
Create a connection to SQL Analysis Services in CData Connect AI and insert SQL Analysis Services into Amazon QuickSight SPICE to build interactive dashboards.
-
Import ShipStation Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ShipStation Data and provide access to live ShipStation for custom reports in the Power BI Service.
-
Automate Snapchat Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Snapchat Ads replication to Couchbase.
-
Working with Quaderno Data in LINQPad
Execute LINQ queries to Quaderno in LINQPad.
-
Connect to SendPulse Data in HULFT Integrate
Connect to SendPulse as a JDBC data source in HULFT Integrate
-
Integrate Kafka with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Kafka with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Kafka.
-
Connect to Box Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Box and the Script function in FileMaker Pro to connect to Box and work with Box in your FileMaker application.
-
Migrating data from ChargeOver to Databricks using CData SSIS Components.
Easily push ChargeOver to Databricks using the CData SSIS Tasks for ChargeOver and Databricks.
-
Connect MessageBird to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MessageBird using the CData Python MCP Server.
-
Connect to and Query Microsoft Exchange Data in QlikView over ODBC
Create data visualizations with Microsoft Exchange in QlikView.
-
Connect to Hacker News Data from PowerBuilder via JDBC
This article demonstrates how to access Hacker News from PowerBuilder using the Hacker News JDBC Driver.
-
Add Jodoo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Jodoo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to PhantomBuster 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 PhantomBuster and work with PhantomBuster in your FileMaker application.
-
How to Access MongoDB Data Using Entity Framework
This article shows how to access MongoDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live SAS xpt Data in Coginiti Pro
Connect to and query live SAS XPORT from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access GetResponse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live GetResponse from HeidiSQL.
-
Connect to Klaviyo Data from Crystal Reports
Use CData Connect AI to connect to and report on live Klaviyo from Crystal Reports.
-
DataBind Charts to MongoDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MongoDB 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.
-
Analyze Bannerbear Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bannerbear with the CData JDBC Driver for Bannerbear.
-
Create Reports with SQL Server Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft SQL Server.