CData Software - Knowledge Base
Recent Articles
-
Replicate Multiple TaxJar Accounts via the CData Sync CLI
Replicate multiple TaxJar accounts to one or many databases.
-
Printful Reporting in OBIEE with the Printful JDBC Driver
Deploy the Printful JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Real-Time Spotify Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Spotify data in Power Apps.
-
How to Connect to Live Power BI XMLA Data 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 Power BI XMLA data for you.
-
Connect to Shortcut Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Shortcut data from Filemaker Pro on Mac.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in MicroStrategy Desktop
Connect to Microsoft OneDrive data in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft OneDrive.
-
How to Visualize Apollo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apollo data in Python.
-
How to connect to FTP Data from Spring Boot
Connect to FTP in a Spring Boot Application using the CData JDBC Driver for FTP
-
Build Agents in Relevance AI with Access to Live Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Coda data within intelligent agent workflows.
-
Integrate xBase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to xBase data and integrate live xBase data into your Power Automate tasks.
-
Process & Analyze Certinia Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Certinia Data.
-
Automated Continuous Factorial Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Factorial replication to Apache Kafka.
-
Use the CData Software JDBC Driver for GitLab in MicroStrategy
Connect to GitLab data in MicroStrategy Developer using the CData Software JDBC Driver for GitLab.
-
Analyze Unbounce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Unbounce from Power Pivot. You will use the Table Import Wizard to load Unbounce data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live ADP Data in Excel 365 Online (Excel for the web)
Connect to ADP data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build an OLAP Cube in SSAS from IBM Informix Data
Establish a connection to IBM Informix data data from SQL Server Analysis Services, and use the IBM Informix Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy Desktop
Connect to Elasticsearch data in MicroStrategy Desktop using the CData Software ODBC Driver for Elasticsearch.
-
Automated Continuous Salesforce Pardot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to SingleStore.
-
LINQ to SAP Business Warehouse 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 SAP Business Warehouse Data Provider.
-
Integrate Cursor with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sybase IQ data from within the editor.
-
Replicate Multiple GitLab Accounts via the CData Sync CLI
Replicate multiple GitLab accounts to one or many databases.
-
Use the CData Software JDBC Driver for Rootly in MicroStrategy Desktop
Connect to Rootly data in MicroStrategy Desktop using the CData Software JDBC Driver for Rootly.
-
Migrating data from OpenWeatherMap to Databricks using CData SSIS Components.
Easily push OpenWeatherMap data to Databricks using the CData SSIS Tasks for OpenWeatherMap and Databricks.
-
How to Easily Query FreeAgent Data in OpenOffice Base
Connect to FreeAgent data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Replicate SAP Netweaver Gateway Data in Heroku for Use in Salesforce Connect
Replicate SAP Netweaver Gateway data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Establish a Live Connection with OpenWeatherMap Data using Tableau Bridge
The CData ODBC Driver for OpenWeatherMap enables you to integrate live OpenWeatherMap data into Tableau Cloud dashboards using the Tableau Bridge.
-
Feed ZohoSubscriptions Data into FineReport
How to set ZohoSubscriptions data as a JDBC data source in FineReport.
-
Use Grok to Talk to Your SAP Netweaver Gateway 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 SAP Netweaver Gateway data for you.
-
Automated Continuous Autopilot Replication to Vertica
Use CData Sync for automated, continuous, customizable Autopilot replication to Vertica.
-
Connecting Moonlit Workflow with SAS xpt Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAS xpt data in real time.
-
Extract, Transform, and Load Mixpanel Data in Informatica PowerCenter
Create a simple Workflow for Mixpanel data in Informatica PowerCenter.
-
How to work with Foursquare Data in Apache Spark using SQL
Access and process Foursquare Data in Apache Spark using the CData Software JDBC Driver.
-
Excel Spreadsheet Automation on Toggl Data with the QUERY Formula
Pull data from Toggl, automate spreadsheets, and more with the QUERY formula.
-
Build Oracle Service Cloud-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Service Cloud Data from Choreo and build custom apps using live Oracle Service Cloud data.
-
Moving Data from Certinia to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Certinia data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Work with Billsby Data in AWS Glue Jobs Using JDBC
Connect to Billsby from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize ScrapingBee Data in Tableau
The CData ODBC driver for ScrapingBee enables you integrate ScrapingBee data into Tableau dashboards.
-
Build Semantic Layer Views for Bannerbear Data in APOS Live Data Gateway
Use the CData Connector for Bannerbear in APOS Live Data Gateway to build Semantic Layer Views for Bannerbear data.
-
Bridge GetResponse Connectivity with Apache NiFi
Access and process GetResponse data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous AlloyDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AlloyDB replication to Apache Kafka.
-
DataBind Controls to GetResponse Data in Delphi
DataBind to GetResponse data in Delphi with standard data access components and controls.
-
Analyze SAS Data Sets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAS Data Sets data and visualize live SAS Data Sets data in Infragistics Reveal.
-
Integrating Dataiku with Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Exact Online data.
-
Visualize Live Oracle Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle data.
-
Automated Continuous Front Replication to Oracle
Use CData Sync for automated, continuous, customizable Front replication to Oracle.
-
Build Salesforce Pardot-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce Pardot Data and create custom apps in Bubble.
-
Connect to Spark Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Spark data.
-
How to Connect to & Open MailChimp Data in Microsoft Excel
This article uses the CData ODBC driver for MailChimp to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Natively Connect to Wave Financial Data in PHP
The CData ODBC driver for Wave Financial enables you to create PHP applications with connectivity to Wave Financial data. Leverage the native support for ODBC in PHP.
-
Analyze CapsuleCRM Data in Cognos Analytics
Use CData Connect AI to connect to CapsuleCRM Data from Cognos Analytics and analyze live CapsuleCRM data.
-
Analyze BenchmarkEmail Data in Cognos Analytics
Use CData Connect AI to connect to BenchmarkEmail Data from Cognos Analytics and analyze live BenchmarkEmail data.
-
Viewing AlloyDB Data in RAD Studio Data Explorer
How to view AlloyDB data in RAD Studio Data Explorer using the CData ODBC Driver for AlloyDB.
-
Connect to WordPress Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for WordPress and the Script function in FileMaker Pro to connect to WordPress and work with WordPress data in your FileMaker application.
-
Connect to DB2 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from DB2 data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy Web
Connect to Azure Data Lake Storage data in MicroStrategy Web using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Create Data Visualizations in Cognos BI with WooCommerce Data
Access WooCommerce data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Live HCL Domino Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live HCL Domino data from within the IDE.
-
How to Connect to Live IBM Cloud Object Storage Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your IBM Cloud Object Storage data for you.
-
How to Connect Flowise AI Agents to Live Square Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Square data without replication.
-
ETL Microsoft Dataverse in Oracle Data Integrator
This article shows how to transfer Microsoft Dataverse data into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aweber
Provide connectivity to Aweber data through an SAP BusinessObjects universe.
-
Connect to Sugar CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sugar CRM in FileMaker Pro to connect to Sugar CRM and work with Sugar CRM data in your FileMaker applications.
-
Using the CData Software ODBC Driver for Suadeo in PyCharm
Connect to Suadeo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Suadeo.
-
Write a Simple Go Application to work with Perplexity Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Perplexity data.
-
DataBind Controls to Wrike Data in Delphi
DataBind to Wrike data in Delphi with standard data access components and controls.
-
Integrate Theia IDE with Live Facebook 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 Facebook data from within the development environment.
-
DataBind Controls to WordPress Data in C++Builder
DataBind to WordPress data in C++Builder with standard components and controls.
-
Automate Flowlu Data Replication to Azure Data Lake
Use CData Sync to customize and automate Flowlu data replication to Azure Data Lake.
-
Visualize Live Typeform Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Typeform data into custom reports in Power BI.
-
Automate Amplitude Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amplitude data from PowerShell? This article demonstrates how to utilize the Amplitude Cmdlets for tasks like connecting to Amplitude data, automating operations, downloading data, and more.
-
Access Live REST Data in Coginiti Pro
Connect to and query live REST data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Claude Code with Snapchat Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Snapchat Ads data within assisted coding and automated development workflows.
-
How to Work with xBase Data in ETL Validator JDBC
Connect to xBase from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Paylocity Data in Excel 365 Online (Excel for the web)
Connect to Paylocity data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Multiple Stripe Accounts via the CData Sync CLI
Replicate multiple Stripe accounts to one or many databases.
-
Moving Data from Workday to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Workday data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live SAP Business One 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 SAP Business One data through MCP integration.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce data without replication.
-
Access Live Square Data in Excel 365 Online (Excel for the web)
Connect to Square data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Outreach.io Data in DBeaver
Use the CData ODBC Driver to connect to Outreach.io data in DBeaver.
-
Automated Continuous VWO Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable VWO replication to Azure SQL Database.
-
Integrate Amazon S3 Data in the Pentaho Report Designer
Publish reports based on Amazon S3 data in the Pentaho BI tool.
-
How to Build an ETL App for Google Tasks Data in Python with CData
Create ETL applications and real-time data pipelines for Google Tasks data in Python with petl.
-
A PostgreSQL Interface for Gumroad Data (MySQL Remoting via JDBC)
Use the Remoting features of the Gumroad JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on Gong Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gong data.
-
Replicate LinkedIn Ads Data from PowerShell
Write a quick PowerShell script to query LinkedIn Ads data. Use connectivity to the live data to replicate LinkedIn Ads data to SQL Server.
-
How to Connect to Live SparkPost Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SparkPost data through natural language.
-
Build Apps with Live ActiveCampaign data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ActiveCampaign data into the Adalo platform and build custom mobile and web applications with real-time ActiveCampaign data.
-
Getting Started with the CData ADO.NET Provider for Jira
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Jira.
-
Build Pipelines with Live Google Contacts Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Contacts from Google Cloud Data Fusion, enabling the integration of live Google Contacts data into the building and management of effective data pipelines.
-
Connect to Live CockroachDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to CockroachDB in CData Connect AI and connect to your CockroachDB data from PostgreSQL.
-
Automated Continuous Codat Replication to MongoDB
Use CData Sync for automated, continuous, customizable Codat replication to MongoDB.
-
Automated Continuous Procore Replication to Vertica
Use CData Sync for automated, continuous, customizable Procore replication to Vertica.
-
Analyze PostgreSQL Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PostgreSQL data with the CData JDBC Driver for PostgreSQL.
-
Integrate with Apollo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apollo data to a JSON file on disk.
-
ETL Zoho Books in Oracle Data Integrator
This article shows how to transfer Zoho Books data into a data warehouse using Oracle Data Integrator.
-
Use Dash to Build Web Apps on Perplexity Data via CData Connect AI
Build interactive Dash web apps on live Perplexity data using pandas and the CData Connect AI Python SDK.
-
Use Manus AI to Talk to Your GitLab 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 GitLab data.
-
Edit and Search External Airtable Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Airtable data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Airtable Data objects that you can access from apps and the dashboard.
-
Connect to Live SQL Analysis Services Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SQL Analysis Services in CData Connect AI and connect to your SQL Analysis Services data from PostgreSQL.