CData Software - Knowledge Base
Recent Articles
-
Automated Continuous PayPal Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PayPal replication to Azure SQL Database.
-
Build Pipelines with Live GraphQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to GraphQL from Google Cloud Data Fusion, enabling the integration of live GraphQL into the building and management of effective data pipelines.
-
Validate Google Ads Data with QuerySurge
Access and validate Google Ads in QuerySurge using the CData JDBC Driver.
-
Visualize Twilio Data in Tableau
The CData ODBC driver for Twilio enables you integrate Twilio into Tableau dashboards.
-
Create Reports with SAP Business Warehouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business Warehouse.
-
Visualize XML Data in Sisense
Create an ElastiCube in Sisense app with access to XML Files.
-
How to integrate Shopify with Apache Airflow
Access and process Shopify in Apache Airflow using the CData JDBC Driver.
-
How to Connect to SageHR Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SageHR. Leverage the pyodbc module for ODBC in Python.
-
Design BIRT Reports on PDFMonkey Data
Provide current PDFMonkey to your embedded analytics.
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud for you.
-
Create Reports with ChartMogul Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChartMogul.
-
Create Datasets from AgileCRM in Domo Workbench and Build Visualizations of AgileCRM Data in Domo
Use the CData Software ODBC Driver for AgileCRM to create datasets from AgileCRM in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for Drip Data (MySQL Remoting via JDBC)
Use the Remoting features of the Drip JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous MailChimp Replication to Databricks
Use CData Sync for automated, continuous, customizable MailChimp replication to Databricks.
-
How to connect to Customer.io Data in DBVisualizer
Integrate Customer.io with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple GraphQL Accounts via the CData Sync CLI
Replicate multiple GraphQL accounts to one or many databases.
-
Automate Epicor Kinetic Data Replication to SAP HANA
Use CData Sync to customize and automate Epicor Kinetic replication to SAP HANA.
-
Connecting Agentforce with Sybase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Sybase for you.
-
How to Design Facebook Ads Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Facebook Ads from mobile and tablet Power Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Mocean
Create an ODBC connection to Mocean in Informatica and browse and transfer Mocean.
-
Integrating GitHub Copilot CLI with Productboard 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 Work with SAP Hybris C4C Data in AWS Glue Jobs Using JDBC
Connect to SAP Hybris C4C from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData ODBC Driver for iContact in Microsoft Power Query
You can use the CData iContact ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import iContact into Microsoft Power Query.
-
Integrating Kiro CLI with Zoho Recruit 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.
-
Create Datasets from Zoho CRM in Domo Workbench and Build Visualizations of Zoho CRM Data in Domo
Use the CData Software ODBC Driver for Zoho CRM to create datasets from Zoho CRM in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Query Egnyte Data in QlikView over ODBC
Create data visualizations with Egnyte in QlikView.
-
Connect to Opsgenie from a Connection Pool in WebLogic
Use the CData JDBC Driver for Opsgenie to connect to Opsgenie from Web applications running on WebLogic.
-
How to Work with Salesforce Marketing Data in ETL Validator JDBC
Connect to Salesforce Marketing from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with Quickbase Data in FoxPro
Load Quickbase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Pipelines with Live CSV Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CSV from Google Cloud Data Fusion, enabling the integration of live CSV/TSV Files into the building and management of effective data pipelines.
-
Access Live Amazon Marketplace 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 Amazon Marketplace through MCP integration.
-
How to Create Power BI Visual Reports with Real-Time Deel Data
Use CData Power BI Connectors to visualize Deel in Power BI.
-
ETL Insightly in Oracle Data Integrator
This article shows how to transfer Insightly into a data warehouse using Oracle Data Integrator.
-
Analyze Adobe Target Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Adobe Target and visualize live Adobe Target in Infragistics Reveal.
-
Connect to Rebilly from Asprova with CData Software ODBC Driver for Rebilly
This article shows how to connect faster to Rebilly data from Asprova.
-
Visualize SAP SuccessFactors LMS 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 SAP SuccessFactors LMS into TIBCO Spotfire.
-
Automated Continuous SAP Concur Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Concur replication to Vertica.
-
Integrate Monday.com Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Monday.com and integrate live Monday.com into your Power Automate tasks.
-
Import Real-Time Salesforce Data 360 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Data 360 in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Avalara.
-
DataBind Charts to Aha! Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Aha! 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.
-
Build AI/ML Models with Live Email Data using Dataiku
Connect Email Data with Dataiku using the CData JDBC Driver for Email.
-
Automated Continuous MYOB AccountRight Replication to Snowflake
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Snowflake.
-
Integrate Live Oracle Financials Cloud Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Dashboards with Bitbucket Data in Dundas BI
Create dynamic dashboards and perform analytics based on Bitbucket in Dundas BI.
-
Moving Data from Bugsnag to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bugsnag data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed GraphQL to Power BI dashboards. Simply drag and drop GraphQL into data visuals on the Power BI canvas.
-
Automated Accelo Data Replication to Teradata
Use CData Sync to Customize and automate Accelo replication to Teradata.
-
Build GitHub-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for GitHub to explore live GitHub Data in GitHub Copilot to assist with building GitHub-powered applications.
-
Integrating Antigravity CLI with Google Analytics via CData CLI
Connect Google Analytics to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live Salesforce Marketing 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 Salesforce Marketing Cloud through MCP integration.
-
How to Connect DBeaver to Hive via a JDBC Driver
Manage Apache Hive with visual tools in DBeaver like the query browser.
-
Use Biml to Build SSIS Tasks to Replicate Pipeliner CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pipeliner CRM to SQL Server.
-
Connect to SAP ByDesign Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Business ByDesign from HeidiSQL.
-
How to connect to Amazon S3 Data from Spring Boot
Connect to Amazon S3 in a Spring Boot Application using the CData JDBC Driver for Amazon S3
-
Connect to Real-Time GraphQL Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for GraphQL and Dataflow to import and use GraphQL in Power Apps.
-
Use Claude to Talk to Your ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your ServiceNow for you.
-
Publish Reports with Hive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Hive.
-
Create SSAS Tabular Models from Onfleet Data
How to build a SQL Server Analysis Service Tabular Model from Onfleet using CData drivers.
-
Query HBase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apache HBase from Node.js.
-
Access Live LinkedIn Ads Data in Coginiti Pro
Connect to and query live LinkedIn Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Create Power BI Visual Reports with Real-Time Simplesat Data
Use CData Power BI Connectors to visualize Simplesat in Power BI.
-
Viewing Factorial Data in RAD Studio Data Explorer
How to view Factorial in RAD Studio Data Explorer using the CData ODBC Driver for Factorial.
-
How to Work with Oracle Eloqua Reporting Data in AWS Glue Jobs Using JDBC
Connect to Oracle Eloqua Reporting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Live Adobe Commerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Adobe Commerce and integrate live Adobe Commerce into apps built in Microsoft Power Apps.
-
Analyze Amazon S3 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon S3 and visualize live Amazon S3 in Infragistics Reveal.
-
How to Access Live Rebilly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Rebilly enables you to integrate Rebilly into workflows built using Microsoft Power Automate Desktop.
-
Automate Tasks in Power Automate Using the CData API Server
Automate AlloyDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Rapidly Develop Basecamp-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 Basecamp.
-
Access Live YouTube Analytics 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 YouTube Analytics through MCP integration.
-
Automated Continuous SingleStore Replication to Snowflake
Use CData Sync for automated, continuous, customizable SingleStore replication to Snowflake.
-
Connect to Google Sheets from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Sheets, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software JDBC Driver for Greenhouse in MicroStrategy Desktop
Connect to Greenhouse in MicroStrategy Desktop using the CData Software JDBC Driver for Greenhouse.
-
Access Live Cohere Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Cohere into the statistical analysis tools available in SAS JMP. This article shows how to use Cohere in the Graph Builder and Query Builder.
-
Build FreshBooks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for FreshBooks Data and create custom apps in Bubble.
-
DataBind CloudConvert Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CloudConvert to a chart.
-
Analyze SAP Netweaver Gateway Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Netweaver Gateway in Microsoft R Open.
-
DataBind Controls to Clockify Data in C++Builder
DataBind to Clockify in C++Builder with standard components and controls.
-
CockroachDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to CockroachDB through CData Connect AI using different applications and tools.
-
Operational Reporting on Eventbrite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Eventbrite.
-
Stream LDAP Objects into Apache Kafka Topics
Access and stream LDAP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Dashboards with Webflow Data in Dundas BI
Create dynamic dashboards and perform analytics based on Webflow in Dundas BI.
-
Connect to Instantly Data from PowerBuilder via JDBC
This article demonstrates how to access Instantly from PowerBuilder using the Instantly JDBC Driver.
-
Connect to SAP HANA Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP HANA and the Script function in FileMaker Pro to connect to SAP HANA and work with SAP HANA in your FileMaker application.
-
Build Freshservice-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Freshservice Data in GitHub Copilot to assist with building Freshservice-powered applications.
-
Access Templated Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Templated from your Oracle system.
-
Create Reports with Google Ad Manager Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ad Manager.
-
Build Semantic Layer Views for WordPress Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for WordPress.
-
Automate ShipStation Data Replication to Azure Data Lake
Use CData Sync to customize and automate ShipStation replication to Azure Data Lake.
-
Bridge Billsby Connectivity with Apache NiFi
Access and process Billsby in Apache NiFi using the CData JDBC Driver.
-
How to Build an ETL App for SingleStore Data in Python with CData
Create ETL applications and real-time data pipelines for SingleStore in Python with petl.
-
Building Dynamic Web Pages with Bullhorn CRM Data Using AngularJS
Create single-page applications with live connectivity to Bullhorn CRM using the CData API Server.
-
How to Import Data from SurveyMonkey into Google Sheets
Import SurveyMonkey into a Google spreadsheet that is automatically refreshed.
-
Build Coinbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Coinbase.
-
Bridge Dynamics CRM Connectivity with Apache NiFi
Access and process Microsoft Dynamics CRM in Apache NiFi using the CData JDBC Driver.
-
Visualize Splunk Data in TIBCO Spotfire through OData
Integrate Splunk into dashboards in TIBCO Spotfire.
-
Deploy the ADO.NET Provider for MailerLite on an SSRS Report Server
Connect to MailerLite 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.
-
Connect to Slack from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Slack, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Amazon DynamoDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Azure SQL Database.
-
Analyze Oracle HCM Cloud Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle HCM Cloud and visualize live Oracle HCM Cloud in Infragistics Reveal.