CData Software - Knowledge Base
Recent Articles
-
Connect to Oracle Eloqua Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Eloqua and the Script function in FileMaker Pro to connect to Oracle Eloqua and work with Oracle Eloqua data in your FileMaker application.
-
Automated Continuous Microsoft Dataverse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Google BigQuery.
-
Publish Reports with MarkLogic Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MarkLogic data.
-
Automated Continuous Telegram Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Telegram replication to AlloyDB.
-
Connect to Real-Time Dynamics CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Dynamics CRM and Dataflow to import and use Dynamics CRM data in Power Apps.
-
Model Shippo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Shippo, enabling the direct import of real-time Shippo data.
-
Integrate Theia IDE with Live ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ZohoDesk data from within the development environment.
-
Connect to SAP Hybris C4C Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Hybris C4C data from HeidiSQL.
-
Connect to Auth0 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Auth0 as an External Source in Dremio.
-
Automate Printify Data Replication to Couchbase
Use CData Sync to Customize and automate Printify data replication to Couchbase.
-
How to Create Power BI Visual Reports with Real-Time ShipEngine Data
Use CData Power BI Connectors to visualize ShipEngine data in Power BI.
-
Query Live Quickbase Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Quickbase data through a conversational interface.
-
Visualize Live Google Directory Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Directory data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Facebook Ads Data in PHP
The CData ODBC driver for Facebook Ads enables you to create PHP applications with connectivity to Facebook Ads data. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for Azure Synapse in Microsoft Power Query
You can use the CData Azure Synapse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Synapse data into Microsoft Power Query.
-
How to work with Zuora Data in Apache Spark using SQL
Access and process Zuora Data in Apache Spark using the CData Software JDBC Driver.
-
How to work with Klaviyo Data in Apache Spark using SQL
Access and process Klaviyo Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live xBase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live xBase data securely in real time.
-
Build MVC Applications with Connectivity to Outlook Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Outlook from an ASP.NET MVC application.
-
Provide OData Services of Coda Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Coda data by developing a WCF Service Application.
-
Use JayDeBeApi to access SparkPost Data in Python
Use standard Python scripting and the development environment of your choice to access live SparkPost data.
-
Integrate Cline with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Avalara AvaTax data from within your IDE.
-
Connect to Webflow Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Webflow data.
-
Connect to Miro Data from a Connection Pool in Jetty
The Miro JDBC Driver supports connection pooling: This article shows how to connect faster to Miro data from Web apps in Jetty.
-
Working with Cohere Data in LINQPad
Execute LINQ queries to Cohere data in LINQPad.
-
Process & Analyze FTP Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FTP Data.
-
Replicate Rootly Data from PowerShell
Write a quick PowerShell script to query Rootly data. Use connectivity to the live data to replicate Rootly data to SQL Server.
-
Integrating Everhour Data in Talend Cloud Data Management Platform
Connect Everhour Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to load MessageBird data into Elasticsearch via Logstash
Introducing a simple method to load MessageBird data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Insightly in MicroStrategy Desktop
Connect to Insightly data in MicroStrategy Desktop using the CData Software ODBC Driver for Insightly.
-
LINQ to Strava 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 Strava Data Provider.
-
How to Connect to Live SageHR Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SageHR data without replication.
-
How to Connect to Exact Online Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Exact Online data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Postmark Data in RazorSQL
Connect to Postmark from wizards and query Postmark data from the GUI in the RazorSQL database management tool.
-
Consume Exact Online OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Exact Online feeds that reflect any changes in SAP Lumira.
-
Use Manus AI to Talk to Your Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Confluence data.
-
Integrating LangChain with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on API data within automated workflows.
-
Analyze Float Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Float data with the CData JDBC Driver for Float.
-
Integrate SAP SuccessFactors Data in Pentaho Data Integration
Build ETL pipelines based on SAP SuccessFactors data in the Pentaho Data Integration tool.
-
Getting Started with the CData ADO.NET Provider for Google Spanner
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Spanner.
-
Design BIRT Reports on Oracle Service Cloud Data
Provide current Oracle Service Cloud data to your embedded analytics.
-
Automated Continuous Asana Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Asana replication to IBM DB2.
-
Connect to SAP SuccessFactors Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP SuccessFactors data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP SuccessFactors.
-
Connect to PabblySubscriptions Data in NetBeans
Connect to PabblySubscriptions data in NetBeans with the data source configuration wizard.
-
Query FTP Data in ColdFusion
Write standard ColdFusion data access code to connect to FTP data.
-
Automated Continuous Coda Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Coda replication to Amazon Redshift.
-
How to import MySQL Data into Apache Solr
Use the CData Software JDBC Driver for MySQL in Data Import Handler and create an automated import of MySQL data to Apache Solr Enterprise Search platform.
-
Integrating Sybase Data in Talend Cloud Data Management Platform
Connect Sybase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sybase.
-
Natively Connect to FTP Data in PHP
The CData ODBC driver for FTP enables you to create PHP applications with connectivity to FTP data. Leverage the native support for ODBC in PHP.
-
Build Apps with Live Gong Data Using the Low-Code Development Platform of Mendix
Connect Gong data with Mendix to build apps using the CData API Driver for JDBC.
-
Create Reckon-Connected Applications in Appsmith
Connect to Reckon Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Reckon data.
-
How to connect and process Postmark data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Postmark data.
-
Use Agno to Talk to Your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your WooCommerce data for you.
-
Anaplan Reporting in OBIEE with the Anaplan JDBC Driver
Deploy the Anaplan JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Explore Geographical Relationships in ServiceNow Data with Power Map
Create data visualizations with ServiceNow data in Power Map.
-
Connect to Mailgun Data in ACL Analytics
Connect to Mailgun data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Mailgun data.
-
Consume Google Cloud Storage OData Feeds in PowerBuilder
This article demonstrates how to consume Google Cloud Storage data as OData feeds from PowerBuilder using the API Server.
-
Create Marketo-Connected Applications in Appsmith
Connect to Marketo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Marketo data.
-
Migrating data from Oracle Financials Cloud to Snowflake using CData SSIS Components.
Easily push Oracle Financials Cloud data to Snowflake using the CData SSIS Tasks for Oracle Financials Cloud and Snowflake.
-
Getting Started with the CData ADO.NET Provider for Pingdom
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze ShipStation Data in Looker
Use CData Connect AI to connect to ShipStation Data from Looker and build custom apps using live ShipStation data.
-
Copper Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Copper facts in real time.
-
How to Visualize Pipedrive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pipedrive data in Python.
-
Integrate OpenCode with Live ADP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ADP data from within your AI coding agent.
-
Integrate Live Zoho Books Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Books data to Blue Prism using the CData ODBC Driver for Zoho Books to create automated workflows for repetitive business tasks.
-
Integrating Claude Code CLI with Salesforce CRM Analytics 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.
-
Automated Continuous Google Forms Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Forms replication to Oracle.
-
Moving Data from Azure Data Catalog to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Data Catalog data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Sendwithus-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sendwithus Data and create custom apps in Bubble.
-
Build Automated eBay-Connected Workflows in Zapier
Use CData Connect AI to connect to live eBay data and build automated workflows in Zapier.
-
How to connect PolyBase to Google Ad Manager
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Ad Manager data.
-
Connect to Real-Time ServiceNow Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ServiceNow and Dataflow to import and use ServiceNow data in Power Apps.
-
How to create Shortcut federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Shortcut data in MySQL .
-
Visualize Live Trello Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Trello data.
-
Access ConstantContact Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ConstantContact data from HeidiSQL.
-
Create Cloudant-Connected Dashboards in Grafana
Connect to Cloudant Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Cloudant data.
-
DataBind ZohoMarketingHub Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoMarketingHub data to a chart.
-
Load Amazon DynamoDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon DynamoDB data to a database.
-
Moosend Reporting in OBIEE with the Moosend JDBC Driver
Deploy the Moosend JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect Salesforce to SQL Server with SSIS
Easily back-up Salesforce data to SQL Server using the CData ADO.NET Provider for Salesforce. This example uses an SSIS workflow to populate a database with Salesforce data using the CData ADO.NET Data Provider for Salesforce.
-
Create Reports with Reckon Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reckon data.
-
Easily Integrate Avalara AvaTax Data in Lazarus Pascal IDE
Learn how to easily integrate live Avalara AvaTax data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Choosing the Best Method to Connect Couchbase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Couchbase data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to QuickBooks from Asprova with CData Software ODBC Driver for QuickBooks
This article shows how to connect faster to QuickBooks data from Asprova.
-
Migrating data from PayPal to Google BigQuery using CData SSIS Components.
Easily push PayPal data to Google BigQuery using the CData SSIS Tasks for PayPal and Google BigQuery.
-
How to connect to SAP Concur Data from Spring Boot
Connect to SAP Concur in a Spring Boot Application using the CData JDBC Driver for SAP Concur
-
Publish ChargeOver-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ChargeOver data.
-
Integrate with Live Salesforce Pardot Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Pardot from the MuleSoft Anypoint Platform to integrate live Salesforce Pardot data into custom reports and dashboards.
-
Add Power BI XMLA Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Power BI XMLA with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Amazon DynamoDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon DynamoDB data to Blue Prism using the CData ODBC Driver for Amazon DynamoDB to create automated workflows for repetitive business tasks.
-
Manage Reckon Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Reckon.
-
Connect to Wrike Data from a Connection Pool in Jetty
The Wrike JDBC Driver supports connection pooling: This article shows how to connect faster to Wrike data from Web apps in Jetty.
-
Getting Started with the CData Python Connector for Jira Assets
Learn to install and license the CData Python Connector and configure a connection to live Jira Assets data.
-
Integrating GitHub Copilot with Sage 300 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.
-
Integrate with Freshteam Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshteam data to a JSON file on disk.
-
Automated Continuous OneNote Replication to SQL Server
Use CData Sync for automated, continuous, customizable OneNote replication to SQL Server.
-
Automated Continuous Couchbase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Couchbase replication to SingleStore.
-
Build Splunk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Splunk data and build web apps with connectivity to live Splunk data.
-
Integrate with live HDFS Data in Jitterbit
Use CData Connect AI to connect to and integrate live HDFS data in Jitterbit.
-
Integrating Antigravity CLI with SparkPost data via CData CLI
Connect SparkPost data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.