CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in ChartMogul Data with Power Map
Create data visualizations with ChartMogul in Power Map.
-
Use the CData Software ODBC Driver for FormSite in MicroStrategy Desktop
Connect to FormSite in MicroStrategy Desktop using the CData Software ODBC Driver for FormSite.
-
How to Import Data from SFTP into Google Sheets
Import SFTP into a Google spreadsheet that is automatically refreshed.
-
Analyze Bitly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bitly from Power Pivot. You will use the Table Import Wizard to load Bitly. You can visually build the import query or use any SQL supported by the driver.
-
Integrating GitHub Copilot CLI with Samanage 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.
-
Create Amazon Athena-Connected Business Apps in AppSheet
Connect to Amazon Athena Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon Athena.
-
Build MarkLogic-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MarkLogic Data from Zoho Analytics and import live MarkLogic.
-
Connect to Power BI XMLA Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Power BI XMLA and the SQL Gateway to access Power BI XMLA from Google Apps Script.
-
Connect to SendGrid Data from AWS Glue
Use CData Connect AI to gain access to live SendGrid from your AWS Glue jobs.
-
Integrating Codex CLI with AfterShip 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.
-
How to load Humanity data into Elasticsearch via Logstash
Introducing a simple method to load Humanity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Wave Financial Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Wave Financial using standard SQL.
-
Bridge Amazon DynamoDB Connectivity with Apache NiFi
Access and process Amazon DynamoDB in Apache NiFi using the CData JDBC Driver.
-
Integrating Phoenix Data in Talend Cloud Data Management Platform
Connect Phoenix Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Phoenix.
-
Automated Continuous Adobe Target Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Adobe Target replication to Apache Cassandra.
-
Automate Billsby Data Replication to Azure Data Lake
Use CData Sync to customize and automate Billsby replication to Azure Data Lake.
-
Connect to Freshservice from Asprova with CData Software ODBC Driver for Freshservice
This article shows how to connect faster to Freshservice data from Asprova.
-
Automated Continuous SageHR Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SageHR replication to Apache Cassandra.
-
Automate iContact Data Replication to Couchbase
Use CData Sync to Customize and automate iContact replication to Couchbase.
-
Integrating Claude Code with SurveyMonkey Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SurveyMonkey within assisted coding and automated development workflows.
-
Establish a Live Connection with Webex Data using Tableau Bridge
The CData ODBC Driver for Webex enables you to integrate live Webex into Tableau Cloud dashboards using the Tableau Bridge.
-
Stream ZohoInvoice Data into Apache Kafka Topics
Access and stream ZohoInvoice in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Crystal Reports on LaunchDarkly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LaunchDarkly.
-
Automated Continuous Google Spanner Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Spanner replication to OneLake in Microsoft Fabric.
-
Build Act CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Act CRM and build visualizations in Tableau.
-
Use JayDeBeApi to access Productboard Data in Python
Use standard Python scripting and the development environment of your choice to access live Productboard.
-
Integrating Claude Code with SAP ByDesign Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Business ByDesign within assisted coding and automated development workflows.
-
Integrate LibreChat with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Service Cloud from within the chat interface.
-
How to Build an ETL App for Couchbase Data in Python with CData Connect AI
Build ETL pipelines that read and write live Couchbase in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to & Open NASA Data in Microsoft Excel
This article uses the CData ODBC driver for NASA to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Power BI XMLA Data in RapidMiner
Integrate Power BI XMLA with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time IBM Cloud Object Storage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use IBM Cloud Object Storage in ColdFusion.
-
How to connect to Productboard Data in DBVisualizer
Integrate Productboard with visual data analysis tools and data connection wizards in DBVisualizer
-
Stream DocuSign Data into Apache Kafka Topics
Access and stream DocuSign in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coda
Provide connectivity to Coda through an SAP BusinessObjects universe.
-
Analyze Asana Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Asana and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connecting Agentforce with SAP Fieldglass 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 SAP Fieldglass for you.
-
Excel Spreadsheet Automation on Spark Data with the QUERY Formula
Pull data from Spark, automate spreadsheets, and more with the QUERY formula.
-
Connect to YouTube Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from YouTube Analytics, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Klaviyo
Provide connectivity to Klaviyo through an SAP BusinessObjects universe.
-
How to connect to Shopify Data in DBVisualizer
Integrate Shopify with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate ZarMoney Data in Heroku for Use in Salesforce Connect
Replicate ZarMoney to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Data Visualizations in Cognos BI with Google Directory Data
Access Google Directory as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Visualizations of Timely Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Timely in Birst.
-
DataBind eBay Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for eBay with the DevExpress Windows Forms and Web controls to provide eBay to a chart.
-
Automate Tanda Data Replication to SAP HANA
Use CData Sync to customize and automate Tanda replication to SAP HANA.
-
Connect to Blackbaud FE NXT Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Blackbaud FE NXT and the Script function in FileMaker Pro to connect to Blackbaud FE NXT and work with Blackbaud FE NXT in your FileMaker application.
-
Getting Started with the CData Python Connector for Presto
Learn to install and license the CData Python Connector
-
Integrate Cline with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Act-On from within your IDE.
-
Connect to Highrise Data from PowerBuilder via ADO.NET
This article demonstrates how to access Highrise CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Highrise.
-
Automate Acumatica Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Acumatica ERP and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze Campaigner Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Campaigner from Power Pivot. You will use the Table Import Wizard to load Campaigner. You can visually build the import query or use any SQL supported by the driver.
-
How to Create Power BI Visual Reports with Real-Time Ontraport Data
Use CData Power BI Connectors to visualize Ontraport in Power BI.
-
Edit and Search External ShipStation Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ShipStation to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ShipStation Data objects that you can access from apps and the dashboard.
-
Visualize Gong Data in TIBCO Spotfire through ADO.NET
Integrate Gong into dashboards in TIBCO Spotfire.
-
Automate QuickBooks Data Replication to Azure Synapse
Use CData Sync to customize and automate QuickBooks Desktop replication to Azure Synapse.
-
Access Live Active Directory 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 Active Directory through MCP integration.
-
Connect to Amazon DynamoDB Data in JRuby
Create a simple JRuby app with access to live Amazon DynamoDB.
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy
Connect to Reckon Accounts Hosted in MicroStrategy Developer using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Use the CData Software ODBC Driver for MYOB AccountRight in MicroStrategy Desktop
Connect to MYOB AccountRight in MicroStrategy Desktop using the CData Software ODBC Driver for MYOB AccountRight.
-
Connect to Opsgenie Data in HULFT Integrate
Connect to Opsgenie as a JDBC data source in HULFT Integrate
-
Extend Google Sheets with Microsoft Teams Data
Make calls to Microsoft Teams from Google Apps Script via the API Server.
-
Explore Geographical Relationships in Okta Data with Power Map
Create data visualizations with Okta in Power Map.
-
DataBind Controls to Toggl Data in C++Builder
DataBind to Toggl in C++Builder with standard components and controls.
-
Add WooCommerce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WooCommerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Zoho CRM Data in DBeaver
Use the CData ODBC Driver to connect to Zoho CRM in DBeaver.
-
Connect to SageHR Data from a Connection Pool in JBoss
Integrate SageHR into Java servlets: Use the Management Console in JBoss to install the SageHR JDBC Driver.
-
Connect to and Query Epicor Kinetic Data in QlikView over ODBC
Create data visualizations with Epicor Kinetic in QlikView.
-
Access Live Authorize.Net Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Authorize.Net in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Oracle Eloqua Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Eloqua replication to Couchbase.
-
Add Splunk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Splunk with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Aha! Data from Spring Boot
Connect to Aha! in a Spring Boot Application using the CData API Driver for JDBC
-
Build an OLAP Cube in SSAS from IBM Cloud Object Storage Data
Establish a connection to IBM Cloud Object Storage data from SQL Server Analysis Services, and use the IBM Cloud Object Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live CouchDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CouchDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache CouchDB.
-
Model Email Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Email, enabling the direct import of real-time Email.
-
Connect to Oracle Data in CloverDX (formerly CloverETL)
Transfer Oracle Database using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software ODBC Driver for Anaplan in MicroStrategy
Connect to Anaplan in MicroStrategy Developer using the CData Software ODBC Driver for Anaplan.
-
Migrating data from Instantly to Snowflake using CData SSIS Components.
Easily push Instantly to Snowflake using the CData SSIS Tasks for Instantly and Snowflake.
-
Visualize Codat Data in TIBCO Spotfire through ADO.NET
Integrate Codat into dashboards in TIBCO Spotfire.
-
Create Amazon Athena Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Amazon Athena from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating GitHub Copilot CLI with ZohoInvoice 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.
-
Integrating Antigravity CLI with Apache Phoenix via CData CLI
Connect Apache Phoenix to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream Parallel Data into Apache Kafka Topics
Access and stream Parallel in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Live Cosmos DB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure Cosmos DB and integrate live Azure Cosmos DB into apps built in Microsoft Power Apps.
-
Getting Started with the CData Connect AI Python SDK for Dynamics 365 Business Central
Install the CData Connect AI Python SDK to read and write live Dynamics 365 Business Central with standard DB-API 2.0 Python code.
-
Getting Started with the CData Tableau Connector for CouchDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for CouchDB.
-
Build Dashboards with Pushbullet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pushbullet in Dundas BI.
-
Analyze Shopify Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Shopify and visualize live Shopify in Infragistics Reveal.
-
Integrate SAP Netweaver Gateway Data into Power Automate Desktop using CData Connect
CData Connect for SAP Netweaver Gateway Data enables you to integrate SAP Netweaver Gateway into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Ariba Source
Create SAP Ariba Source data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to and Visualize Live IBM Informix Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live IBM Informix.
-
Build MVC Applications with Connectivity to BigCommerce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigCommerce from an ASP.NET MVC application.
-
Viewing Microsoft OneDrive Data in RAD Studio Data Explorer
How to view Microsoft OneDrive in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft OneDrive.
-
Query LinkedIn Ads Data as a MySQL Database in Node.js
Execute MySQL queries against LinkedIn Ads from Node.js.
-
How to use SQLAlchemy ORM to access Quickbase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Quickbase.
-
Automated Continuous Optimizely Replication to Databricks
Use CData Sync for automated, continuous, customizable Optimizely replication to Databricks.
-
Establish a Live Connection with Oracle Financials Cloud Data using Tableau Bridge
The CData ODBC Driver for Oracle Financials Cloud enables you to integrate live Oracle Financials Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Build an ETL App for MailerLite Data in Python with CData
Create ETL applications and real-time data pipelines for MailerLite in Python with petl.
-
How to load Monday.com data into Elasticsearch via Logstash
Introducing a simple method to load Monday.com data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dashboards and Visualize Live MailChimp Data in Geckoboard
Use CData Connect AI to connect to live MailChimp and create dashboards for real-time monitoring and visualization in Geckoboard.