CData Software - Knowledge Base
Recent Articles
-
Access Live Flowlu Data in Coginiti Pro
Connect to and query live Flowlu from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Gong-Connected Apps in Choreo
Use CData Connect AI to connect to Gong Data from Choreo and build custom apps using live Gong.
-
Replicate Humanity Data to Multiple Databases
Replicate Humanity to disparate databases with a point-and-click configuration.
-
Replicate MariaDB Data to Multiple Databases via the CData Sync CLI
Replicate MariaDB to disparate databases with a single configuration.
-
Build AI Agents with SurveyMonkey Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SurveyMonkey through CData Connect AI.
-
Access xBase Data from MySQL in Amazon QuickSight
Connect to xBase and build visualizations of xBase using a MySQL Connection in Amazon QuickSight.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Nuclia
Provide connectivity to Nuclia through an SAP BusinessObjects universe.
-
Integrate with eBay Data in JReport Designer
Create charts and reports based on eBay in JReport Designer.
-
Connect to and Visualize Live SendPulse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SendPulse.
-
Automate Everhour Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Everhour from PowerShell? This article demonstrates how to utilize the Everhour Cmdlets for tasks like connecting to Everhour, automating operations, downloading data, and more.
-
Build MySQL-Connected Apps in Choreo
Use CData Connect AI to connect to MySQL Data from Choreo and build custom apps using live MySQL.
-
Connect Odoo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Odoo ERP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Google Directory Data in Pentaho Data Integration
Build ETL pipelines based on Google Directory in the Pentaho Data Integration tool.
-
Automated Continuous ClickTime Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ClickTime replication to OneLake in Microsoft Fabric.
-
How to Import Data from Excel Online into Google Sheets
Import Microsoft Excel Online into a Google spreadsheet that is automatically refreshed.
-
Use the CData Software JDBC Driver for Shortcut in MicroStrategy Desktop
Connect to Shortcut in MicroStrategy Desktop using the CData Software JDBC Driver for Shortcut.
-
Connect to Microsoft Dataverse Data in ACL Analytics
Connect to Microsoft Dataverse (CDS) via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Dataverse (CDS).
-
Work with Live Oracle SCM Data in Power Query
Use CData Connect AI to connect to Oracle SCM and work with live Oracle SCM in Microsoft Power Query.
-
Suadeo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Suadeo facts in real time.
-
Integrating YouTube Analytics Data in Talend Cloud Data Management Platform
Connect YouTube Analytics Data with Talend Cloud Data Management Platform using the CData JDBC Driver for YouTube Analytics.
-
Use the CData Software ODBC Driver for Klaviyo in MicroStrategy Web
Connect to Klaviyo in MicroStrategy Web using the CData Software ODBC Driver for Klaviyo.
-
How to create Demio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Demio in MySQL .
-
Integrating Boomi Agentstudio with Monday.com Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Monday.com, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use JayDeBeApi to access Discord Data in Python
Use standard Python scripting and the development environment of your choice to access live Discord.
-
Write a Simple Go Application to work with Flowlu Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Flowlu.
-
Access Adobe Analytics Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Adobe Analytics.
-
Choosing the Best Method to Connect Cloudant to SQL Server: 5 Options Explained
Discover multiple ways to connect and use IBM Cloudant from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to load MailerSend data into Elasticsearch via Logstash
Introducing a simple method to load MailerSend data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Claude Code CLI with Templated 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.
-
Create Data Visualizations in Cognos BI with HBase Data
Access Apache HBase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Provide OData Services of REST Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for REST by developing a WCF Service Application.
-
Explore Geographical Relationships in Amazon Athena Data with Power Map
Create data visualizations with Amazon Athena in Power Map.
-
How to Build an ETL App for YouTube Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for YouTube Analytics in Python with petl.
-
Getting Started with the CData Python Connector for Mouseflow
Learn to install and license the CData Python Connector
-
Integrating Codex CLI with CSV/TSV Files 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.
-
Access Live Deel Data in AWS Lambda
Connect to live Deel in AWS Lambda using the CData JDBC Driver.
-
Analyze Workday Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Workday and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use JayDeBeApi to access Front Data in Python
Use standard Python scripting and the development environment of your choice to access live Front.
-
Publish Zoho Inventory-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Inventory.
-
How to Access Live Dynamics 365 Business Central Data in Visual Studio Code via Cline
Run CData MCP Server for Dynamics 365 Business Central on Windows Subsytem for Linux (WSL) and connect to live Dynamics 365 Business Central from the Cline extension in Visual Studio Code.
-
Use Grok to Talk to Your Airtable 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 Airtable for you.
-
Connect to and Query ZohoDesk Data in QlikView over ODBC
Create data visualizations with ZohoDesk in QlikView.
-
Write a Simple Go Application to work with Insightly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Insightly.
-
Build a PostgreSQL Interface for Demio Data using the CData JDBC Driver
Use the Remoting features of the Demio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create LinkedIn-Connected Business Apps in AppSheet
Connect to LinkedIn Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to LinkedIn.
-
Automate Harvest Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Harvest from PowerShell? This article demonstrates how to utilize the Harvest Cmdlets for tasks like connecting to Harvest, automating operations, downloading data, and more.
-
Establish a Live Connection with Epicor Kinetic Data using Tableau Bridge
The CData ODBC Driver for Epicor Kinetic enables you to integrate live Epicor Kinetic into Tableau Cloud dashboards using the Tableau Bridge.
-
Edit and Search External EnterpriseDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of EnterpriseDB to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create EnterpriseDB Data objects that you can access from apps and the dashboard.
-
Build Automated Workflows with Live Google Directory Data in Workato
Use CData Connect AI to connect to live Google Directory and build automated workflows in Workato.
-
Using the CData Software ODBC Driver for Dynamics 365 Business Central in PyCharm
Connect to Dynamics 365 Business Central as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Use the CData ODBC Driver for Epicor Kinetic in Microsoft Power Query
You can use the CData Epicor Kinetic ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Epicor Kinetic into Microsoft Power Query.
-
Getting Started with the CData ODBC Driver for Superchat
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Superchat.
-
Import and Visualize Qualaroo Data in Power View
Create data visualizations based on Qualaroo in Excel.
-
Create Datasets from Chargebee in Domo Workbench and Build Visualizations of Chargebee Data in Domo
Use the CData Software ODBC Driver for Chargebee to create datasets from Chargebee in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from ShipStation to Snowflake using CData SSIS Components.
Easily push ShipStation to Snowflake using the CData SSIS Tasks for ShipStation and Snowflake.
-
Migrating data from Reckon Accounts Hosted to Snowflake using CData SSIS Components.
Easily push Reckon Accounts Hosted to Snowflake using the CData SSIS Tasks for Reckon Accounts Hosted and Snowflake.
-
Getting Started with the CData ADO.NET Provider for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Amazon Marketplace.
-
Use Biml to Build SSIS Tasks to Replicate Pushbullet Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pushbullet to SQL Server.
-
Bidirectional Access to MongoDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MongoDB in Filemaker Pro for Mac or Windows.
-
Publish Reports with Apify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apify.
-
Integrate Salesforce Data 360 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce Data 360 from Informatica Cloud.
-
How to load GetResponse data into Elasticsearch via Logstash
Introducing a simple method to load GetResponse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for ZeroBounce in Microsoft Power Query
You can use the CData ZeroBounce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZeroBounce into Microsoft Power Query.
-
Automated Continuous Email Replication to SQL Server
Use CData Sync for automated, continuous, customizable Email replication to SQL Server.
-
Connect to Redis Data in JRuby
Create a simple JRuby app with access to live Redis.
-
Query DocuSign Data through ODBC in Node.js
Use node-odbc to execute SQL queries against DocuSign from Node.js.
-
Import Microsoft OneDrive Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft OneDrive Data from Azure Data Factory and import live Microsoft OneDrive.
-
Establish a Live Connection with Oracle Eloqua Reporting Data using Tableau Bridge
The CData ODBC Driver for Oracle Eloqua Reporting enables you to integrate live Oracle Eloqua Reporting into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Billsby Data in ColdFusion
Write standard ColdFusion data access code to connect to Billsby.
-
Create Data Visualizations in Cognos BI with Avalara AvaTax Data
Access Avalara AvaTax as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Easily Query Raisers Edge NXT Data in OpenOffice Base
Connect to Raisers Edge NXT data in OpenOffice Base using the CData ODBC Driver for Raisers Edge NXT and generate reports with live data insights.
-
Connect to Oracle Financials Cloud Data in NetBeans
Connect to Oracle Financials Cloud in NetBeans with the data source configuration wizard.
-
SpaceX Reporting in OBIEE with the SpaceX JDBC Driver
Deploy the SpaceX JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting GenSpark with Reckon Accounts Hosted Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Reckon Accounts Hosted without any replication or custom integration required.
-
Access PostgreSQL Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PostgreSQL from HeidiSQL.
-
Automate Spotify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Spotify from PowerShell? This article demonstrates how to utilize the Spotify Cmdlets for tasks like connecting to Spotify, automating operations, downloading data, and more.
-
Use Claude to Talk to Your Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle SCM for you.
-
Connect Power BI XMLA to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Power BI XMLA using the CData Python MCP Server.
-
Migrating data from Parallel to Databricks using CData SSIS Components.
Easily push Parallel to Databricks using the CData SSIS Tasks for Parallel and Databricks.
-
Connect to Planio Data in DBeaver
Use the CData ODBC Driver to connect to Planio in DBeaver.
-
Getting Started with the CData Connect AI Python SDK for FHIR
Install the CData Connect AI Python SDK to read and write live FHIR with standard DB-API 2.0 Python code.
-
ETL ConstantContact in Oracle Data Integrator
This article shows how to transfer ConstantContact into a data warehouse using Oracle Data Integrator.
-
Integrating LangChain with Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Databricks within automated workflows.
-
Integrating OpenCode Terminal with Missive 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.
-
LINQ to Mouseflow 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 Mouseflow Data Provider.
-
Visualize Twilio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Twilio.
-
Access Live Jira Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Atlassian Jira in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Customer.io Reporting in OBIEE with the Customer.io JDBC Driver
Deploy the Customer.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live BigCommerce 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 BigCommerce for you.
-
Build Semantic Layer Views for Sage Intacct Data in APOS Live Data Gateway
Use the CData Connector for Sage Intacct in APOS Live Data Gateway to build Semantic Layer Views for Sage Intacct.
-
Access Live Airtable Data in TIBCO Data Virtualization
Use the Airtable Tibco DV Adapter to create a Airtable data source in TIBCO Data Virtualization Studio and gain access to live Airtable from your TDV Server.
-
A PostgreSQL Interface for ZohoDesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZohoDesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Azure Data Lake Storage Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure Data Lake Storage for self-service data analytics.
-
Create Power BI Reports on Real-Time Harvest Data
Use the CData ODBC Driver for Harvest to visualize Harvest in Power BI Desktop.
-
Build Data Flows from Campaigner to SQL Server using SSIS
Easily back up Campaigner to SQL Server using the SSIS components for Campaigner.
-
Visualize Invoiced Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Invoiced into TIBCO Spotfire.
-
Build Charts with Jumpseller Data in Clear Analytics
Create dynamic charts and perform analytics based on Jumpseller in Clear Analytics.
-
Connect to Oracle Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Database in Google Apps Script.
-
How to integrate Microsoft Exchange with Apache Airflow
Access and process Microsoft Exchange in Apache Airflow using the CData JDBC Driver.
-
How to create Visio diagrams from MYOB AccountRight Data
Automatically update MYOB AccountRight with the changes you make to Visio master shapes.