CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of WordPress Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of WordPress in Birst.
-
Publish Crystal Reports on Wistia Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Wistia.
-
How to connect PolyBase to Snapchat Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Snapchat Ads.
-
Use the CData Software ODBC Driver for IBM Cloud Object Storage in MicroStrategy Web
Connect to IBM Cloud Object Storage in MicroStrategy Web using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
Seamlessly Bring Asana Data into Retool Using CData Connect AI
Integrate Asana data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to integrate ChargeOver with Apache Airflow
Access and process ChargeOver in Apache Airflow using the CData JDBC Driver.
-
Access SAP Hybris C4C Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Hybris C4C from your Oracle system.
-
Object-Relational Mapping (ORM) with Azure DevOps Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Azure DevOps into a Java-based ORM framework, Hibernate.
-
How to Query Live LinkedIn Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LinkedIn Ads data in natural language using Python.
-
Viewing Outlook Data in RAD Studio Data Explorer
How to view Outlook in RAD Studio Data Explorer using the CData ODBC Driver for Outlook.
-
Use JayDeBeApi to access Azure Data Catalog Data in Python
Use standard Python scripting and the development environment of your choice to access live Azure Data Catalog.
-
Use Biml to Build SSIS Tasks to Replicate Vimeo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Vimeo to SQL Server.
-
Replicate Airtable Data to Multiple Databases
Replicate Airtable to disparate databases with a point-and-click configuration.
-
Automate SAP HANA Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP HANA from PowerShell? This article demonstrates how to utilize the SAP HANA Cmdlets for tasks like connecting to SAP HANA, automating operations, downloading data, and more.
-
Publish Discourse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Discourse.
-
Connect to Impala Data in RazorSQL
Connect to Impala from wizards and query Apache Impala from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Tableau Connector for AlloyDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for AlloyDB.
-
Build a Simple VCL Application for Outlook Data
How to build a simple VCL Application to view Outlook in RAD Studio using the CData ODBC Driver for Outlook.
-
Integrating Claude Code with Avalara AvaTax Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Avalara AvaTax within assisted coding and automated development workflows.
-
Automated Continuous Wistia Replication to SingleStore
Use CData Sync for automated, continuous, customizable Wistia replication to SingleStore.
-
Access SAS xpt Data from MySQL in Amazon QuickSight
Connect to SAS xpt and build visualizations of SAS XPORT using a MySQL Connection in Amazon QuickSight.
-
Access Live Omnisend Data in Coginiti Pro
Connect to and query live Omnisend from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Avalara AvaTax Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Avalara AvaTax and build visualizations in Tableau.
-
Use the CData Software JDBC Driver for Parquet in MicroStrategy
Connect to Apache Parquet in MicroStrategy Developer using the CData Software JDBC Driver for Parquet.
-
Connect to ZohoMarketingHub Data in JRuby
Create a simple JRuby app with access to live ZohoMarketingHub.
-
Connect to and Visualize Live PagerDuty Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PagerDuty.
-
Integrating OpenCode Terminal with Cloudant 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 an SAP BusinessObjects Universe on the CData ODBC Driver for ServiceDesk Plus
Provide connectivity to ServiceDesk Plus through an SAP BusinessObjects universe.
-
Integrate Live Basecamp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Basecamp to Blue Prism using the CData ODBC Driver for Basecamp to create automated workflows for repetitive business tasks.
-
How to Design MarkLogic Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to MarkLogic from mobile and tablet Power Apps.
-
Access Live YouTube Analytics Data in Coginiti Pro
Connect to and query live YouTube Analytics from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Power BI Connector for Miro
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to connect to LionDesk Data with Squirrel SQL client
Connect to LionDesk and execute queries in the Squirrel SQL Client.
-
Automated Continuous Discord Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Discord replication to Google Cloud SQL.
-
Access Live LaunchDarkly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live LaunchDarkly in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create LionDesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LionDesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Semantic Layer Views for Excel Data in APOS Live Data Gateway
Use the CData Connector for Excel in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Excel.
-
Create Power BI Reports on Real-Time Teradata Data
Use the CData ODBC Driver for Teradata to visualize Teradata in Power BI Desktop.
-
Connect to RabbitMQ Data in NetBeans
Connect to RabbitMQ in NetBeans with the data source configuration wizard.
-
Publish Reports with Jira Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Atlassian Jira.
-
Integrate Goose with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft SharePoint from within the local AI agent.
-
Build MVC Applications with Connectivity to SFTP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SFTP from an ASP.NET MVC application.
-
How to Build an ETL App for Slack Data in Python with CData
Create ETL applications and real-time data pipelines for Slack in Python with petl.
-
Connect to Reckon Data from PowerBuilder via JDBC
This article demonstrates how to access Reckon from PowerBuilder using the Reckon JDBC Driver.
-
Use the CData Software JDBC Driver for Cassandra in MicroStrategy Web
Connect to Apache Cassandra in MicroStrategy Web using the CData Software JDBC Driver for Cassandra.
-
Connect Cloudant to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Cloudant with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Aha! in SAS for Real-Time Reporting and Analytics
Connect to real-time Aha! in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Aha!.
-
How to Query Live Monday.com Data in Perplexity MacOS Desktop
Connect to and query live Monday.com Data in Perplexity Desktop using CData MCP Server.
-
Bidirectional Access to ActiveCampaign Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ActiveCampaign in Filemaker Pro for Mac or Windows.
-
How to integrate Clio with Apache Airflow
Access and process Clio in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous PabblySubscriptions Replication to Snowflake
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Snowflake.
-
Work with Live SAP Concur Data in Power Query
Use CData Connect AI to connect to SAP Concur and work with live SAP Concur in Microsoft Power Query.
-
Automated Continuous GraphQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable GraphQL replication to IBM DB2.
-
Automated Continuous ZohoInvoice Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Snowflake.
-
Getting Started with the CData Python Connector for Delighted
Learn to install and license the CData Python Connector
-
How to Seamlessly Import ZohoMarketingHub Data into IBM SPSS Modeler
Integrate ZohoMarketingHub data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Sage 200-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sage 200 Data from Klipfolio and build custom visualizations using live Sage 200.
-
Automated Continuous Billsby Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Billsby replication to AlloyDB.
-
How to Query Live PayPal Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PayPal data in natural language using Python.
-
Design BIRT Reports on Oracle Financials Cloud Data
Provide current Oracle Financials Cloud to your embedded analytics.
-
Visualize Sage 200 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage 200.
-
Connecting Pipedream with Amazon Marketplace Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Amazon Marketplace data in real time.
-
DataBind Controls to Ontraport Data in C++Builder
DataBind to Ontraport in C++Builder with standard components and controls.
-
How to Connect DBeaver to Google Search via a JDBC Driver
Manage Google Search with visual tools in DBeaver like the query browser.
-
Integrate SAP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP with External Services.
-
How to Query Live Typeform Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Typeform data in natural language using Python.
-
Connect to SAP Fieldglass Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Fieldglass from HeidiSQL.
-
Automate Blackbaud FE NXT Data Replication to Couchbase
Use CData Sync to Customize and automate Blackbaud FE NXT replication to Couchbase.
-
How to connect and process Google BigQuery from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google BigQuery.
-
Build Charts with Egnyte Data in Clear Analytics
Create dynamic charts and perform analytics based on Egnyte in Clear Analytics.
-
Connect to Salesforce Marketing Data in DBArtisan
Use wizards in DBArtisan to configure Salesforce Marketing Cloud as a data source.
-
Query MailerSend Data in DataGrip
Create a Data Source for MailerSend in DataGrip and use SQL to query live MailerSend.
-
Visualize OneNote Data in Tableau
The CData ODBC driver for OneNote enables you integrate Microsoft OneNote into Tableau dashboards.
-
Integrating Antigravity CLI with ConvertAPI via CData CLI
Connect ConvertAPI to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Mailjet Data in Aqua Data Studio
Access Mailjet from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData ODBC Driver for Adobe Experience Manager from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Experience Manager to connect to Adobe Experience Manager from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Experience Manager in Excel.
-
Establish a Live Connection with Scrapfly Data using Tableau Bridge
The CData ODBC Driver for Scrapfly enables you to integrate live Scrapfly into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Grok to Talk to Your Active Directory 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 Active Directory for you.
-
Analyze Azure Data Lake Storage Data in Looker
Use CData Connect AI to connect to Azure Data Lake Storage Data from Looker and build custom apps using live Azure Data Lake Storage.
-
Connect to GitLab Data in JRuby
Create a simple JRuby app with access to live GitLab.
-
Connect to SharePoint Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft SharePoint from your AWS Glue jobs.
-
Getting Started with the CData JDBC Driver for Perigon
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Perigon.
-
Connect to Workable in SpagoBI
Create reports featuring live Workable in SpagoBI Studio. Host Workable reports on SpagoBI Server.
-
Automated Continuous BambooHR Replication to SingleStore
Use CData Sync for automated, continuous, customizable BambooHR replication to SingleStore.
-
Use the CData Software ODBC Driver for Harvest in SAS for Real-Time Reporting and Analytics
Connect to real-time Harvest in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Harvest.
-
How to Query JotForm Data in MySQL Workbench
Execute MySQL queries against live JotForm from MySQL Workbench.
-
Create Google Ads-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Ads Data from OutSystems and build custom enterprise apps using live Google Ads.
-
Use Dash to Build to Web Apps on Stripe Data
Create Python applications that use pandas and Dash to build Stripe-connected web apps.
-
A PostgreSQL Interface for Certinia Data (MySQL Remoting via JDBC)
Use the Remoting features of the Certinia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Avro Data from MySQL in PHP
Connect to Avro through the standard MySQL libraries in PHP.
-
Replicate Facebook Data in Heroku for Use in Salesforce Connect
Replicate Facebook to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Add SQL Server Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SQL Server with the Informatica Enterprise Data Catalog to classify and organize data.
-
Migrating data from SendPulse to Google BigQuery using CData SSIS Components.
Easily push SendPulse to Google BigQuery using the CData SSIS Tasks for SendPulse and Google BigQuery.
-
Visualize ZohoMarketingHub Data in Tableau
The CData ODBC driver for ZohoMarketingHub enables you integrate ZohoMarketingHub into Tableau dashboards.
-
How to Connect to Live SAP HANA Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP HANA without replication.
-
Analyze XML Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for XML from Power Pivot. You will use the Table Import Wizard to load XML Files. You can visually build the import query or use any SQL supported by the driver.
-
How to connect and process Samanage from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Samanage.
-
Connect to Bright Data Data in HULFT Integrate
Connect to Bright Data as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Excel Add-In for Chargebee
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Chargebee.
-
Integrating Codex CLI with Cvent 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.