CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Ontraport Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Ontraport replication to delimited files (CSV/TSV).
-
Connect to Egnyte Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Egnyte and work with Egnyte in your FileMaker applications.
-
Deploy the ADO.NET Provider for Chargebee on an SSRS Report Server
Connect to Chargebee 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.
-
Integrating ClickTime Data in Talend Cloud Data Management Platform
Connect ClickTime Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Azure AI Foundry to Talk to Your Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Contacts for you.
-
Viewing Sage 200 Data in RAD Studio Data Explorer
How to view Sage 200 in RAD Studio Data Explorer using the CData ODBC Driver for Sage 200.
-
Automated Continuous Kafka Replication to Oracle
Use CData Sync for automated, continuous, customizable Kafka replication to Oracle.
-
Use JayDeBeApi to access Browserless Data in Python
Use standard Python scripting and the development environment of your choice to access live Browserless.
-
Connect to Adobe Commerce Data in DBeaver
Use the CData ODBC Driver to connect to Adobe Commerce in DBeaver.
-
Publish Suadeo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Suadeo.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle Financials Cloud using the Model Context Protocol.
-
Automated Continuous Grafana Replication to Databricks
Use CData Sync for automated, continuous, customizable Grafana replication to Databricks.
-
Publish Crystal Reports on ZarMoney Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZarMoney.
-
Use the CData Software ODBC Driver for Parallel in MicroStrategy Web
Connect to Parallel in MicroStrategy Web using the CData Software ODBC Driver for Parallel.
-
Automated Continuous PostgreSQL Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Azure SQL Database.
-
Connect and Visualize Live CockroachDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live CockroachDB into the Databricks platform and create visualization dashboards with real-time CockroachDB.
-
How to Easily Query Nethunt Data in OpenOffice Base
Connect to Nethunt data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Apps from API Data in Qlik Sense Cloud
Use CData Connect AI to connect to API Data and build apps from live API in Qlik Sense Cloud.
-
Connect to Salesforce Marketing Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Operational Reporting on Spark Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Spark SQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Klipfolio
Provide connectivity to Klipfolio through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Snapchat Ads in MicroStrategy
Connect to Snapchat Ads in MicroStrategy Developer using the CData Software JDBC Driver for Snapchat Ads.
-
Use Dash to Build to Web Apps on Nuclia Data
Create Python applications that use pandas and Dash to build Nuclia-connected web apps.
-
Visualize Printify Data in Tableau
The CData ODBC driver for Printify enables you integrate Printify into Tableau dashboards.
-
Automate MySQL Data Replication to SAP HANA
Use CData Sync to customize and automate MySQL replication to SAP HANA.
-
Automated Continuous Google Spanner Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Spanner replication to Google Cloud SQL.
-
Connect to Factorial Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Factorial as an External Source in Dremio.
-
Feed AlloyDB Data into FineReport
How to set Google AlloyDB as a JDBC data source in FineReport.
-
Build Visualizations of XML Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of XML Files in Birst.
-
Connect to SuiteCRM Data in HULFT Integrate
Connect to SuiteCRM as a JDBC data source in HULFT Integrate
-
Build Azure DevOps-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure DevOps.
-
Create Data Visualizations in Cognos BI with Redis Data
Access Redis as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
LINQ to Square 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 Square Data Provider.
-
Automated Continuous SingleStore Replication to MongoDB
Use CData Sync for automated, continuous, customizable SingleStore replication to MongoDB.
-
Access Live Freshservice Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Freshservice from your Google Sheets.
-
Integrating Codex CLI with Retently 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.
-
Validate AlloyDB Data with QuerySurge
Access and validate Google AlloyDB in QuerySurge using the CData JDBC Driver.
-
Connect to Cassandra Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Cassandra.
-
Create Reports from Stripe Data in Looker Studio
Use CData Connect AI to gain access to live Stripe and create custom reports in Looker Studio.
-
Edit and Search External BambooHR Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of BambooHR to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BambooHR Data objects that you can access from apps and the dashboard.
-
Build Automated Presto-Connected Workflows in Zapier
Use CData Connect AI to connect to live Presto and build automated workflows in Zapier.
-
Connect to Telegram Data in CloverDX (formerly CloverETL)
Transfer Telegram using the visual workflow in the CloverDX data integration tool.
-
Integrating LlamaIndex with Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Dataverse (CDS) in real time.
-
Consume SAS Data Sets OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAS Data Sets feeds that reflect any changes in SAP Lumira.
-
Connect to Amazon DynamoDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Amazon DynamoDB to connect to Amazon DynamoDB and execute queries in PowerBuilder.
-
Back Up Miro to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Miro data.
-
Enable the Shippo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Shippo.
-
How to connect PolyBase to SQL Analysis Services
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SQL Analysis Services.
-
How to Access Beeminder Data Using Entity Framework
This article shows how to access Beeminder using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Datasets from Sybase in Domo Workbench and Build Visualizations of Sybase Data in Domo
Use the CData Software ODBC Driver for Sybase to create datasets from Sybase in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous CouchDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CouchDB replication to Amazon Redshift.
-
Use the CData ODBC Driver for Reckon in Microsoft Power Query
You can use the CData Reckon ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Reckon into Microsoft Power Query.
-
Object-Relational Mapping (ORM) with Active Directory 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 Active Directory into a Java-based ORM framework, Hibernate.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon Marketplace within intelligent workflows.
-
Use CData Connect AI to Access Oracle Service Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Service Cloud in the Power Pivot business intelligence tool.
-
Automated Continuous Oracle Service Cloud Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Google Cloud SQL.
-
Visualize Live Odoo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Odoo ERP.
-
Build Visualizations of Testmonitor Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Testmonitor in Birst.
-
Automate WordPress Integration Tasks from PowerShell
Are you in search of a quick and easy way to access WordPress from PowerShell? This article demonstrates how to utilize the WordPress Cmdlets for tasks like connecting to WordPress, automating operations, downloading data, and more.
-
Integrate SQL Server Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft SQL Server from Informatica Cloud.
-
Connect to Oracle SCM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle SCM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Work with Amplitude Data in ETL Validator JDBC
Connect to Amplitude from ETL Validator jobs using the CData Software JDBC Driver.
-
Natively Connect to ZohoMarketingHub Data in PHP
The CData ODBC driver for ZohoMarketingHub enables you to create PHP applications with connectivity to ZohoMarketingHub. Leverage the native support for ODBC in PHP.
-
How to connect to Mode Data with Squirrel SQL client
Connect to Mode and execute queries in the Squirrel SQL Client.
-
Query Planio Data as a MySQL Database in Node.js
Execute MySQL queries against Planio from Node.js.
-
Load DocuSign Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load DocuSign to a database.
-
Build CouchDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for CouchDB to explore live CouchDB Data in Gemini Code Assist to assist with building CouchDB-powered applications.
-
How to Connect to & Open SAP Ariba Source Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Ariba Source to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import Real-Time JDBC-ODBC Bridge Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use JDBC-ODBC Bridge in ColdFusion.
-
How to connect to Confluence Data from IntelliJ
Integrate connectivity to Atlassian Confluence with wizards in IntelliJ.
-
Replicate Azure DevOps Data to Multiple Databases
Replicate Azure DevOps to disparate databases with a point-and-click configuration.
-
Load Adobe Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Analytics to a database.
-
Access Live Trello Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Trello from your Excel spreadsheets.
-
Access Live ShipStation Data in Coginiti Pro
Connect to and query live ShipStation from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Parquet Data to Multiple Databases via the CData Sync CLI
Replicate Apache Parquet to disparate databases with a single configuration.
-
Migrating data from Google Tasks to Google BigQuery using CData SSIS Components.
Easily push Google Tasks to Google BigQuery using the CData SSIS Tasks for Google Tasks and Google BigQuery.
-
Natively Connect to Suadeo Data in PHP
The CData ODBC driver for Suadeo enables you to create PHP applications with connectivity to Suadeo. Leverage the native support for ODBC in PHP.
-
Visualize Paddle Data in TIBCO Spotfire through ADO.NET
Integrate Paddle into dashboards in TIBCO Spotfire.
-
Build SAP Netweaver Gateway-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Netweaver Gateway and build SAP Netweaver Gateway-connected web apps with Axios.
-
Connect to Redshift Data from AWS Glue
Use CData Connect AI to gain access to live Amazon Redshift from your AWS Glue jobs.
-
Publish Marketo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Marketo.
-
How to Access Sendwithus Data Using Entity Framework
This article shows how to access Sendwithus using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Greenplum Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Pivotal GreenPlum.
-
How to Connect to Live GitHub 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 GitHub for you.
-
DataBind Controls to Google Ad Manager Data in Delphi
DataBind to Google Ad Manager in Delphi with standard data access components and controls.
-
DataBind Controls to Avro Data in Delphi
DataBind to Apache Avro in Delphi with standard data access components and controls.
-
Explore Geographical Relationships in Foursquare Data with Power Map
Create data visualizations with Foursquare in Power Map.
-
Automated Continuous MarkLogic Replication to MongoDB
Use CData Sync for automated, continuous, customizable MarkLogic replication to MongoDB.
-
Automated Continuous Samanage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Samanage replication to delimited files (CSV/TSV).
-
Connect Paddle Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Paddle using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live SendGrid Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SendGrid from your Google Sheets.
-
Build Automated CouchDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache CouchDB and build automated workflows in Zapier.
-
Process & Analyze SAP Business One Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Business One Data.
-
Connect and Visualize Live Sage 200 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sage 200 into the Databricks platform and create visualization dashboards with real-time Sage 200.
-
Automated Continuous Google Sheets Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Sheets replication to Google Cloud SQL.
-
Integrate Cline with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAS Data Sets from within your IDE.
-
How to connect to PolarTeamPro Data with Squirrel SQL client
Connect to PolarTeamPro and execute queries in the Squirrel SQL Client.
-
Connect to ChargeOver 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 ChargeOver and work with ChargeOver in your FileMaker application.
-
Build Agents in Relevance AI with Access to Live HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Apache HBase within intelligent agent workflows.
-
Visualize SAP Concur Data in TIBCO Spotfire through ADO.NET
Integrate SAP Concur into dashboards in TIBCO Spotfire.