CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Sybase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sybase replication to Google Cloud SQL.
-
Connect to Redshift Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Redshift and the SQL Gateway to access Redshift data from Google Apps Script.
-
Back Up MailChimp data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MailChimp. In this article, we will employ an SSIS workflow to populate a database with MailChimp data data.
-
Link ZendeskSell with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZendeskSell data in Filemaker Pro for Mac or Windows.
-
Import Real-Time Square Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Square data in ColdFusion.
-
Automated Continuous RSS Replication to SingleStore
Use CData Sync for automated, continuous, customizable RSS replication to SingleStore.
-
Deploy the ADO.NET Provider for VWO on an SSRS Report Server
Connect to VWO 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.
-
How to Query Live Bullhorn CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bullhorn CRM data data in natural language using Python.
-
Validate Google Analytics Data with QuerySurge
Access and validate Google Analytics data in QuerySurge using the CData JDBC Driver.
-
Analyze Paymo Data in Cognos Analytics
Use CData Connect AI to connect to Paymo Data from Cognos Analytics and analyze live Paymo data.
-
Build a Simple VCL Application for ConvertKit Data
How to build a simple VCL Application to view ConvertKit data in RAD Studio using the CData ODBC Driver for ConvertKit.
-
Working with SpaceX Data in LINQPad
Execute LINQ queries to SpaceX data in LINQPad.
-
Create LinkedIn Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LinkedIn Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating OpenCode with Sentry 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.
-
Trigger Dynamics 365 IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dynamics 365 with standard wizards in Logic Apps.
-
How to Create Power BI Visual Reports with Real-Time Apify Data
Use CData Power BI Connectors to visualize Apify data in Power BI.
-
Import Authorize.Net Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Authorize.Net Data and provide access to live Authorize.Net data for custom reports in the Power BI Service.
-
Workday Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Workday facts in real time.
-
Access Live Excel Online 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 Excel Online data through MCP integration.
-
Connect to Real-Time Shippo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Shippo data in Power Apps.
-
Integrate with live Google Drive Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Drive data in Jitterbit.
-
ETL Redshift in Oracle Data Integrator
This article shows how to transfer Redshift data into a data warehouse using Oracle Data Integrator.
-
Integrating Dataiku with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce Pardot data.
-
Seamlessly Bring Confluence Data into Retool Using CData Connect AI
Integrate Confluence data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Quickbase Data Replication to Couchbase
Use CData Sync to Customize and automate Quickbase data replication to Couchbase.
-
Search External ZohoSubscriptions Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ZohoSubscriptions data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ZohoSubscriptions Data objects that you can access from apps and the dashboard.
-
Connect to Highrise Data from a Connection Pool in Jetty
The Highrise JDBC Driver supports connection pooling: This article shows how to connect faster to Highrise data from Web apps in Jetty.
-
Access Live SharePoint 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 SharePoint data through MCP integration.
-
How to Visualize Oracle Eloqua Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Eloqua data in Python.
-
Analyze Excel Online Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Excel Online data with the CData JDBC Driver for Excel Online.
-
Getting Started with the CData Tableau Connector for Scrapfly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Jira Assets Replication to Databricks
Use CData Sync for automated, continuous, customizable Jira Assets replication to Databricks.
-
How to Easily Query Exa Data in OpenOffice Base
Connect to Exa data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Work with Clio Data in AWS Glue Jobs Using JDBC
Connect to Clio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Charts to Cvent Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cvent data 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.
-
Microsoft Ads Reporting in OBIEE with the Microsoft Ads JDBC Driver
Deploy the Microsoft Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Copper in Microsoft Power Query
You can use the CData Copper ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Copper data into Microsoft Power Query.
-
Connect to and Visualize Live Jira Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Jira data.
-
Create Power BI Reports on Real-Time Cvent Data
Use the CData ODBC Driver for Cvent to visualize Cvent data in Power BI Desktop.
-
Integrating Gumloop with LDAP Objects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on LDAP objects within automated workflows.
-
Excel Spreadsheet Automation on iContact Data with the QUERY Formula
Pull data from iContact, automate spreadsheets, and more with the QUERY formula.
-
Enable the Authorize.Net JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Authorize.Net data.
-
How to Visualize Google Analytics Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Analytics data in Python.
-
Prepare, Blend, and Analyze Telegram Data in Alteryx Designer (ODBC)
Build workflows to access live Telegram data for self-service data analytics.
-
How to Access Cloudflare Data Using Entity Framework
This article shows how to access Cloudflare data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze MongoDB Data in Cognos Analytics
Use CData Connect AI to connect to MongoDB Data from Cognos Analytics and analyze live MongoDB data.
-
Integrating LlamaIndex with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Search results in real time.
-
Use the CData ODBC Driver for Power BI XMLA in Microsoft Power Query
You can use the CData Power BI XMLA ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Power BI XMLA data into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for Mouseflow
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Query Live BenchmarkEmail Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live BenchmarkEmail data directly from the development environment.
-
Getting Started with the CData ADO.NET Provider for MongoDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MongoDB.
-
Connect to Insightly Data in RapidMiner
Integrate Insightly data with standard components and data source configuration wizards in RapidMiner Studio.
-
Bridge ShipEngine Connectivity with Apache NiFi
Access and process ShipEngine data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous FormSite Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FormSite data replication to OneLake in Microsoft Fabric.
-
Integrate Printify Data in Pentaho Data Integration
Build ETL pipelines based on Printify data in the Pentaho Data Integration tool.
-
Visualize CapsuleCRM Data in TIBCO Spotfire through ADO.NET
Integrate CapsuleCRM data into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access Spotify Data in Python
Use standard Python scripting and the development environment of your choice to access live Spotify data.
-
Visualize Sybase Data in Sisense
Create an ElastiCube in Sisense app with access to Sybase data.
-
How to connect Amazon QuickSight to Raisers Edge NXT Data
Create a connection to Raisers Edge NXT data in CData Connect AI and insert Raisers Edge NXT data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData JDBC Driver for Aweber
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Aweber.
-
Automated Continuous Jumpseller Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jumpseller replication to IBM DB2.
-
Build Automated HDFS-Connected Workflows in Zapier
Use CData Connect AI to connect to live HDFS data and build automated workflows in Zapier.
-
Connect to Gmail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Gmail and the SQL Gateway to access Gmail data from Google Apps Script.
-
Query ZohoSubscriptions Data in DataGrip
Create a Data Source for ZohoSubscriptions in DataGrip and use SQL to query live ZohoSubscriptions data.
-
Using the CData Software ODBC Driver for CSV in PyCharm
Connect to CSV as an ODBC data source in PyCharm using the CData Software ODBC Driver for CSV.
-
Access Email Data from MySQL in PHP
Connect to Email through the standard MySQL libraries in PHP.
-
How to Connect to Live eBay Analytics 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 eBay Analytics data for you.
-
Automate Hubstaff Data Replication to SAP HANA
Use CData Sync to customize and automate Hubstaff data replication to SAP HANA.
-
Replicate Teamwork Data in Heroku for Use in Salesforce Connect
Replicate Teamwork data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query SAP SuccessFactors LMS Data in DataGrip
Create a Data Source for SAP SuccessFactors LMS in DataGrip and use SQL to query live SAP SuccessFactors LMS data.
-
Connect to QuickBooks Time Data from PowerBuilder via ADO.NET
This article demonstrates how to access QuickBooks Time data from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks Time.
-
Excel Spreadsheet Automation on SurveyMonkey Data with the QUERY Formula
Pull data from SurveyMonkey, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Unbounce Data in JReport Designer
Create charts and reports based on Unbounce data in JReport Designer.
-
Connect to Exa Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Exa Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Visualize Neo4J Data in Python with pandas
Use pandas and other modules to analyze and visualize live Neo4J data in Python.
-
Build ServiceDesk Plus-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ServiceDesk Plus data.
-
Visualize Twilio Data in Sisense
Create an ElastiCube in Sisense app with access to Twilio data.
-
Connect to Cloudant Data in Google Apps Script via Connect AI
Use CData Connect AI to access Cloudant data in Google Apps Script.
-
Integrating GitHub Copilot with FTP 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.
-
Build Semantic Layer Views for Miro Data in APOS Live Data Gateway
Use the CData Connector for Miro in APOS Live Data Gateway to build Semantic Layer Views for Miro data.
-
Create Reports with CampaignMonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CampaignMonitor data.
-
Build Dashboards with Reckon Accounts Hosted Data in DBxtra
Create dynamic dashboards and perform analytics based on Reckon Accounts Hosted data in DBxtra.
-
Connect to Wistia Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Wistia data from Filemaker Pro on Mac.
-
How to connect PolyBase to ConstantContact
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ConstantContact data.
-
How to Connect to SAP Business One Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business One data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Dify with Live Outreach.io Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Outreach.io data.
-
Create SSAS Tabular Models from Oracle Financials Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Financials Cloud data using CData drivers.
-
Write a Simple Go Application to work with Oracle HCM Cloud Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle HCM Cloud data.
-
Use the CData ODBC Driver for WooCommerce in Microsoft Power Query
You can use the CData WooCommerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import WooCommerce data into Microsoft Power Query.
-
Consume SAP Business Warehouse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Business Warehouse feeds that reflect any changes in SAP Lumira.
-
Create Zoho Books-Connected Dashboards in Grafana
Connect to Zoho Books Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Books data.
-
Connect to and Visualize Live MessageBird Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MessageBird data.
-
Integrating Codex with Sentry 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.
-
Build Voice Agents in ElevenLabs with access to Live Guru Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Guru data.
-
Automated Continuous Klaviyo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Klaviyo replication to IBM DB2.
-
How to Connect the Power BI Service to Close: Complete Guide
Connect to the CData Software Power BI Connector for Close from PowerBI.com to provide real-time Close data across the organization.
-
Create Reports with Miro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Miro data.
-
Integrate Real-Time Access to Amazon Athena in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Athena data in real time.
-
Automated Continuous Oracle Financials Cloud Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to IBM DB2.
-
Query Facebook Data as a MySQL Database in Node.js
Execute MySQL queries against Facebook data from Node.js.