CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Omnisend Data in Alteryx Designer (ODBC)
Build workflows to access live Omnisend data for self-service data analytics.
-
Integrate OpenCode with Live Oracle Eloqua Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Oracle Eloqua data from within your AI coding agent.
-
Enable the PhantomBuster JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PhantomBuster data.
-
Integrate with Jira Assets Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Jira Assets data in SnapLogic.
-
Integrate LibreChat with Live Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Shortcut data from within the chat interface.
-
Integrate Microsoft Teams Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Teams Data enables you to integrate Microsoft Teams data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Mixpanel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mixpanel and the SQL Gateway to access Mixpanel data from Google Apps Script.
-
Build Dashboards with Google Spanner Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Spanner data in DBxtra.
-
How to Work with Everhour Data in ETL Validator JDBC
Connect to Everhour from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for AlloyDB
Install the CData Connect AI Python SDK to read and write live AlloyDB data with standard DB-API 2.0 Python code.
-
Natively Connect to SendPulse Data in PHP
The CData ODBC driver for SendPulse enables you to create PHP applications with connectivity to SendPulse data. Leverage the native support for ODBC in PHP.
-
Automated Continuous LinkedIn Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to MySQL.
-
Migrating data from Email to Snowflake using CData SSIS Components.
Easily push Email data to Snowflake using the CData SSIS Tasks for Email and Snowflake.
-
Replicate FreshBooks Data in Heroku for Use in Salesforce Connect
Replicate FreshBooks data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Stream SendPulse Data into Apache Kafka Topics
Access and stream SendPulse data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Drip Data in Tableau
The CData ODBC driver for Drip enables you integrate Drip data into Tableau dashboards.
-
DataBind Controls to Jira Assets Data in Delphi
DataBind to Jira Assets data in Delphi with standard data access components and controls.
-
Connect to Mode Data in Jaspersoft Studio
Execute SQL to remote Mode data in Jaspersoft Studio.
-
Create Datasets from Flowlu in Domo Workbench and Build Visualizations of Flowlu Data in Domo
Use the CData Software ODBC Driver for Flowlu to create datasets from Flowlu data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Reckon Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Reckon data.
-
Query SAP Fieldglass Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Fieldglass entities in PHP by modeling them as objects.
-
Getting Started with the CData SSIS Components for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP BusinessObjects BI.
-
Integrate OpenCode with Live FTP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live FTP data from within your AI coding agent.
-
Integrate Azure Table Data into Power Automate Desktop using CData Connect
CData Connect for Azure Table Data enables you to integrate Azure Table data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Adobe Experience Manager Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Experience Manager data in Microsoft R Open.
-
Automated Continuous Greenhouse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Greenhouse replication to Amazon S3.
-
How to create an RPA flow for GetResponse Data in UiPath Studio
Use the GetResponse ODBC Driver to create workflows that access real-time GetResponse data without any coding.
-
How to Access Gmail Data Using Entity Framework
This article shows how to access Gmail data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Procore Replication to Snowflake
Use CData Sync for automated, continuous, customizable Procore replication to Snowflake.
-
Import and Visualize Aha! Data in Power View
Create data visualizations based on Aha! data in Excel.
-
Use Dash to Build to Web Apps on Vimeo Data
Create Python applications that use pandas and Dash to build Vimeo-connected web apps.
-
Create ChartMogul Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ChartMogul from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a PostgreSQL Interface for Contentful Data using the CData JDBC Driver
Use the Remoting features of the Contentful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Exa Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Exa data.
-
Connect to Sage Cloud Accounting Data in JRuby
Create a simple JRuby app with access to live Sage Cloud Accounting data.
-
Build a Singer.io Tap for Pinterest With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pinterest data using the CData Python Connector.
-
How to Seamlessly Import Odoo Data into IBM SPSS Modeler
Integrate Odoo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Voice Agents in ElevenLabs with access to Live Google Drive Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Drive data.
-
Use the CData Software JDBC Driver for DocuSign in MicroStrategy Desktop
Connect to DocuSign data in MicroStrategy Desktop using the CData Software JDBC Driver for DocuSign.
-
Access Email Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Email data from HeidiSQL.
-
Getting Started with the CData SSIS Components for Impala
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Impala.
-
Create Apps from SAP SuccessFactors LMS Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP SuccessFactors LMS Data and build apps from live SAP SuccessFactors LMS data in Qlik Sense Cloud.
-
A PostgreSQL Interface for Webex Data (MySQL Remoting via JDBC)
Use the Remoting features of the Webex JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Google's Antigravity Agent with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle Eloqua data using the Model Context Protocol.
-
A PostgreSQL Interface for Shortcut Data using the CData ODBC Driver
Use the SQL Gateway and Shortcut ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Sage 300 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage 300 data using the CData Python MCP Server.
-
Build a Singer.io Tap for NetSuite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live NetSuite data using the CData Python Connector.
-
Query Sage Cloud Accounting Data in DataGrip
Create a Data Source for Sage Cloud Accounting in DataGrip and use SQL to query live Sage Cloud Accounting data.
-
Integrate Real-Time Access to IBM Cloud Object Storage in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Cloud Object Storage data in real time.
-
How to create an RPA flow for Grafana Data in UiPath Studio
Use the Grafana ODBC Driver to create workflows that access real-time Grafana data without any coding.
-
Connect EnterpriseDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your EnterpriseDB data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Sentry
Learn to install and license the CData Python Connector and configure a connection to live Sentry data.
-
Getting Started with the CData Excel Add-In for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua Reporting.
-
Getting Started with the CData ODBC Driver for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Ad Manager.
-
Connect to Anaplan Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Anaplan data.
-
Create Google Drive-Connected Dashboards in Grafana
Connect to Google Drive Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Drive data.
-
Migrating data from Demio to Databricks using CData SSIS Components.
Easily push Demio data to Databricks using the CData SSIS Tasks for Demio and Databricks.
-
Work with Jumpseller Data in FoxPro
Load Jumpseller data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Work with Power BI XMLA Data in FoxPro
Load Power BI XMLA data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Gong-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gong data.
-
Connect to BigQuery Data in CloverDX (formerly CloverETL)
Transfer BigQuery data using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Zoho Projects to Snowflake using CData SSIS Components.
Easily push Zoho Projects data to Snowflake using the CData SSIS Tasks for Zoho Projects and Snowflake.
-
Connect to Snapchat Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Snapchat Ads data using standard SQL.
-
Build an OLAP Cube in SSAS from Coinbase Data
Establish a connection to Coinbase data data from SQL Server Analysis Services, and use the Coinbase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Bridge SpaceX Connectivity with Apache NiFi
Access and process SpaceX data in Apache NiFi using the CData JDBC Driver.
-
Replicate Deel Data to Multiple Databases via the CData Sync CLI
Replicate Deel data to disparate databases with a single configuration.
-
Work with Live Oracle Sales Data in Power Query
Use CData Connect AI to connect to Oracle Sales data and work with live Oracle Sales data in Microsoft Power Query.
-
Automated Google Tasks Data Replication to Teradata
Use CData Sync to Customize and automate Google Tasks data replication to Teradata.
-
Connect to AgileCRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from AgileCRM data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate with Amazon S3 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon S3 data to a JSON file on disk.
-
How to Easily Query Kintone Data in OpenOffice Base
Connect to Kintone data in OpenOffice Base using the CData ODBC Driver for Kintone and generate reports with live data insights.
-
Automated Continuous Google Translate Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Translate replication to MySQL.
-
Automated Continuous ZohoInvoice Replication to Oracle
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Oracle.
-
Create Informatica Mappings From/To a JDBC Data Source for Freshservice
Create Freshservice data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Deploy the ADO.NET Provider for YouTube Analytics on an SSRS Report Server
Connect to YouTube Analytics data 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.
-
Use Biml to Build SSIS Tasks to Replicate MarkLogic Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MarkLogic data to SQL Server.
-
How to Connect to Live Shopify Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Shopify data for you.
-
Build Visualizations of PolarTeamPro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PolarTeamPro data in Birst.
-
Getting Started with the CData SSIS Components for Toggl
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Toggl.
-
Access Live Databricks Data in Excel 365 Online (Excel for the web)
Connect to Databricks data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Gumroad Data in MySQL Workbench
Execute MySQL queries against live Gumroad data from MySQL Workbench.
-
Connect to Parquet Data in RapidMiner
Integrate Parquet data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create SendGrid Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SendGrid data access from reports, embedded analytics, and more.
-
Visualize FreeAgent Data in TIBCO Spotfire through ADO.NET
Integrate FreeAgent data into dashboards in TIBCO Spotfire.
-
Create Dashboards and Visualize Live TaxJar Data in Geckoboard
Use CData Connect AI to connect to live TaxJar data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Import and Visualize FHIR Data in Power View
Create data visualizations based on FHIR data in Excel.
-
Automated Continuous Clockify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Clockify replication to Google Cloud SQL.
-
How to Query Spark Data in MySQL Workbench
Execute MySQL queries against live Spark data from MySQL Workbench.
-
Getting Started with the CData Connect AI Python SDK for Klipfolio
Install the CData Connect AI Python SDK to read live Klipfolio data with standard DB-API 2.0 Python code.
-
How to Connect to Live GitHub 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 GitHub data without replication.
-
Automated Continuous Smartsheet Replication to Databricks
Use CData Sync for automated, continuous, customizable Smartsheet replication to Databricks.
-
Connect to Procore from a Connection Pool in WebLogic
Use the CData JDBC Driver for Procore to connect to Procore data from Web applications running on WebLogic.
-
Connect ZohoInvoice Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoInvoice data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous XML Replication to SQL Server
Use CData Sync for automated, continuous, customizable XML replication to SQL Server.
-
Automated Continuous Asana Replication to Vertica
Use CData Sync for automated, continuous, customizable Asana replication to Vertica.
-
How to Connect to Live xBase 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 xBase data through natural language.
-
Create Bitly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bitly from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to & Open SAP Business Warehouse Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Business Warehouse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live SAP Concur Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Concur data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Parquet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Parquet data.