CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for Twitter Ads in Microsoft Power Query
You can use the CData Twitter Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Twitter Ads into Microsoft Power Query.
-
Consume Sybase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sybase feeds that reflect any changes in SAP Lumira.
-
How to Access Live Act-On Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Act-On enables you to integrate Act-On into workflows built using Microsoft Power Automate Desktop.
-
Connect to Cosmos DB 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 Azure Cosmos DB.
-
Instagram Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Instagram facts in real time.
-
Excel Spreadsheet Automation on Workday Data with the QUERY Formula
Pull data from Workday, automate spreadsheets, and more with the QUERY formula.
-
Visualize IBM Informix Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM Informix.
-
Use Agno to Talk to Your Splunk 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 Splunk for you.
-
Create SSAS Tabular Models from Zoom Data
How to build a SQL Server Analysis Service Tabular Model from Zoom using CData drivers.
-
Build Reply.io-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Reply.io Data in Claude Code to assist with building Reply.io-powered applications.
-
Connect to Asana Data in DBeaver
Use the CData ODBC Driver to connect to Asana in DBeaver.
-
Import Microsoft Exchange Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Exchange Data from Azure Data Factory and import live Microsoft Exchange.
-
Connect to Azure Data Lake Storage Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Data Lake Storage in FileMaker Pro to connect to Azure Data Lake Storage and work with Azure Data Lake Storage in your FileMaker applications.
-
Rapidly Develop Quaderno-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Quaderno.
-
How to connect PolyBase to SpaceX
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SpaceX.
-
Access Live SageHR Data in Coginiti Pro
Connect to and query live SageHR from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query, Visualize, and Share live Amazon DynamoDB Data in Redash
Use CData Connect AI to connect to live Amazon DynamoDB in Redash for querying, visualizing, and sharing.
-
Integrate MYOB AccountRight Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MYOB AccountRight and integrate live MYOB AccountRight into your Power Automate tasks.
-
Automated Continuous Avalara AvaTax Replication to Oracle
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Oracle.
-
Connect to Real-Time Zoho Projects Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Projects and Dataflow to import and use Zoho Projects in Power Apps.
-
Connecting Agentforce with Jira Assets Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Jira Assets for you.
-
Create Dashboards and Visualize Live Act-On Data in Geckoboard
Use CData Connect AI to connect to live Act-On and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Spotify Data in DBeaver
Use the CData ODBC Driver to connect to Spotify in DBeaver.
-
Rapidly Develop ChargeOver-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ChargeOver.
-
Connect to CloudConvert Data from PowerBuilder via JDBC
This article demonstrates how to access CloudConvert from PowerBuilder using the CloudConvert JDBC Driver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Google Calendar actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Neo4J Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Neo4J replication to Amazon Redshift.
-
How to Build an ETL App for Dropbox Data in Python with CData
Create ETL applications and real-time data pipelines for Dropbox in Python with petl.
-
Explore Geographical Relationships in Oracle Eloqua Reporting Data with Power Map
Create data visualizations with Oracle Eloqua Reporting in Power Map.
-
How to integrate Humanity with Apache Airflow
Access and process Humanity in Apache Airflow using the CData JDBC Driver.
-
Analyze Gong Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Gong from Power Pivot. You will use the Table Import Wizard to load Gong. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect DBeaver to Google Contacts via a JDBC Driver
Manage Google Contacts with visual tools in DBeaver like the query browser.
-
Use CData Connect AI to Access MySQL Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MySQL in the Power Pivot business intelligence tool.
-
Connect to Helpscout Data in RapidMiner
Integrate Helpscout with standard components and data source configuration wizards in RapidMiner Studio.
-
Build FTP-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for FTP to explore live FTP Data in GitHub Copilot to assist with building FTP-powered applications.
-
Visualize Freshteam Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Freshteam.
-
A PostgreSQL Interface for ZendeskSell Data using the CData ODBC Driver
Use the SQL Gateway and ZendeskSell ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Freshservice Data
Use the CData ODBC Driver for Freshservice to visualize Freshservice in Power BI Desktop.
-
Integrating GitHub Copilot CLI with Wave Financial 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.
-
Query Paddle Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Paddle and perform CRUD operations on Paddle from Node.js.
-
How to import Freshteam Data into Apache Solr
Use the CData Software JDBC Driver for Freshteam in Data Import Handler and create an automated import of Freshteam to Apache Solr Enterprise Search platform.
-
Automated Continuous ADP Replication to MySQL
Use CData Sync for automated, continuous, customizable ADP replication to MySQL.
-
Build a PostgreSQL Interface for Oracle Sales Data using the CData JDBC Driver
Use the Remoting features of the Oracle Sales JDBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Paylocity Data in FoxPro
Load Paylocity into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate WooCommerce Data in the Pentaho Report Designer
Publish reports based on WooCommerce in the Pentaho BI tool.
-
Build ServiceDesk Plus-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live ServiceDesk Plus Data in Claude Code to assist with building ServiceDesk Plus-powered applications.
-
Integrate LibreChat with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Planner from within the chat interface.
-
Publish Reports with Twitter Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twitter Ads.
-
Connect to Anaplan Data in CloverDX (formerly CloverETL)
Transfer Anaplan using the visual workflow in the CloverDX data integration tool.
-
Build a PostgreSQL Interface for Campaigner Data using the CData JDBC Driver
Use the Remoting features of the Campaigner JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Slack Data from MySQL in PHP
Connect to Slack through the standard MySQL libraries in PHP.
-
Bind Live PayPal Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live PayPal data
-
Integrate with IBM Informix Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy IBM Informix to a JSON file on disk.
-
Query PingOne Data in ColdFusion
Write standard ColdFusion data access code to connect to PingOne.
-
Prepare, Blend, and Analyze SAP Concur Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Concur for self-service data analytics.
-
Connect to Rebilly Data from a Connection Pool in Jetty
The Rebilly JDBC Driver supports connection pooling: This article shows how to connect faster to Rebilly from Web apps in Jetty.
-
Automated Continuous Microsoft Teams Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SQLite.
-
Automated Continuous RSS Replication to AlloyDB
Use CData Sync for automated, continuous, customizable RSS replication to AlloyDB.
-
Extend Google Sheets with Excel Online Data
Make calls to Excel Online from Google Apps Script via the API Server.
-
Migrating data from SharePoint Excel Services to Google BigQuery using CData SSIS Components.
Easily push SharePoint Excel Services to Google BigQuery using the CData SSIS Tasks for SharePoint Excel Services and Google BigQuery.
-
Automated Continuous OData Services Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable OData replication to OneLake in Microsoft Fabric.
-
Integrating GitHub Copilot CLI with Amazon Marketplace 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.
-
Analyze Odoo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Odoo ERP and visualize Odoo ERP in SAP Analytics Cloud.
-
Publish Reports with Pipedrive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipedrive.
-
Connect to and Visualize Live Elasticsearch Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Elasticsearch.
-
Connect to MailerSend Data in RapidMiner
Integrate MailerSend with standard components and data source configuration wizards in RapidMiner Studio.
-
Feed DocuSign Data into FineReport
How to set DocuSign as a JDBC data source in FineReport.
-
How to publish and share Drift Data dashboards with Tableau Server
The CData ODBC driver for Drift enables you integrate Drift into Tableau dashboards.
-
Connect to Copper Data in RazorSQL
Connect to Copper from wizards and query Copper from the GUI in the RazorSQL database management tool.
-
Build MVC Applications with Connectivity to Elasticsearch Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Elasticsearch from an ASP.NET MVC application.
-
How to Work with Google Ads Data in ETL Validator JDBC
Connect to Google Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Templated Data in Sisense
Create an ElastiCube in Sisense app with access to Templated.
-
Create Apps from Impala Data in Qlik Sense Cloud
Use CData Connect AI to connect to Impala Data and build apps from live Apache Impala in Qlik Sense Cloud.
-
Back Up ScrapingBee 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 ScrapingBee data.
-
Use the CData Software JDBC Driver for Perigon in MicroStrategy Desktop
Connect to Perigon in MicroStrategy Desktop using the CData Software JDBC Driver for Perigon.
-
How to Design ActiveCampaign Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to ActiveCampaign from mobile and tablet Power Apps.
-
Explore Geographical Relationships in YouTube Analytics Data with Power Map
Create data visualizations with YouTube Analytics in Power Map.
-
How to publish and share Oracle Eloqua Reporting Data dashboards with Tableau Server
The CData ODBC driver for Oracle Eloqua Reporting enables you integrate Oracle Eloqua Reporting into Tableau dashboards.
-
How to connect to Autopilot Data with Squirrel SQL client
Connect to Autopilot and execute queries in the Squirrel SQL Client.
-
A Comparison of JDBC & ODBC Drivers for Amazon Athena
A performance comparison of the CData JDBC Driver and ODBC Driver for Amazon Athena and the Amazon-supported Athena JDBC Driver and ODBC Driver.
-
How to Seamlessly Import Couchbase Data into IBM SPSS Modeler
Integrate Couchbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Zoho Creator Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize Front Data in Sisense
Create an ElastiCube in Sisense app with access to Front.
-
How to Connect the Power BI Service to Egnyte: Complete Guide
Connect to the CData Software Power BI Connector for Egnyte from PowerBI.com to provide real-time Egnyte across the organization.
-
Replicate Amazon Marketplace Data to Multiple Databases via the CData Sync CLI
Replicate Amazon Marketplace to disparate databases with a single configuration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Couchbase
Provide connectivity to Couchbase through an SAP BusinessObjects universe.
-
Automate Contentful Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Contentful from PowerShell? This article demonstrates how to utilize the Contentful Cmdlets for tasks like connecting to Contentful, automating operations, downloading data, and more.
-
Connect to Tickspot Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Tickspot and the SQL Gateway to access Tickspot from Google Apps Script.
-
How to Query MongoDB Data in MySQL Workbench
Execute MySQL queries against live MongoDB from MySQL Workbench.
-
Easily Integrate SAP ByDesign Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Business ByDesign in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to publish and share Reply.io Data dashboards with Tableau Server
The CData ODBC driver for Reply.io enables you integrate Reply.io into Tableau dashboards.
-
Integrate FTP Data in the Pentaho Report Designer
Publish reports based on FTP Servers in the Pentaho BI tool.
-
How to Query Live Mode Data in Claude Desktop
Connect to and query live Mode Data in Claude Desktop using CData MCP Server.
-
Analyze MariaDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MariaDB and visualize MariaDB in SAP Analytics Cloud.
-
How to connect Amazon QuickSight to AlloyDB Data
Create a connection to Google AlloyDB in CData Connect AI and insert Google AlloyDB into Amazon QuickSight SPICE to build interactive dashboards.
-
Use CData Connect AI to Access WordPress Data in Microsoft Power Pivot
Use CData Connect AI to connect to live WordPress in the Power Pivot business intelligence tool.
-
DataBind Codat Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Codat to a chart.
-
Stream Sage 300 Data into Apache Kafka Topics
Access and stream Sage 300 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Redis Replication to SingleStore
Use CData Sync for automated, continuous, customizable Redis replication to SingleStore.
-
Connect to Airtable Data from PowerBuilder via JDBC
This article demonstrates how to access Airtable from PowerBuilder using the Airtable JDBC Driver.