CData Software - Knowledge Base
Recent Articles
-
Publish Deel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Deel.
-
Create Apps from Redshift Data in Qlik Sense Cloud
Use CData Connect AI to connect to Redshift Data and build apps from live Amazon Redshift in Qlik Sense Cloud.
-
Integrate Elorus Data in the Pentaho Report Designer
Publish reports based on Elorus in the Pentaho BI tool.
-
How to load Office 365 data into Elasticsearch via Logstash
Introducing a simple method to load Office 365 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect ZohoPeople to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoPeople with IBM WebSphere for seamless data integration and connectivity.
-
Process & Analyze SAP BusinessObjects BI Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP BusinessObjects BI Data.
-
Moving Data from Moosend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Moosend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate Access Data to Multiple Databases
Replicate Microsoft Access to disparate databases with a point-and-click configuration.
-
Import Lakebase Data Using Azure Data Factory
Use CData Connect AI to connect to Lakebase Data from Azure Data Factory and import live Lakebase.
-
How to create an RPA flow for Workable Data in UiPath Studio
Use the Workable ODBC Driver to create workflows that access real-time Workable without any coding.
-
Create Apps from Cloudant Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cloudant Data and build apps from live IBM Cloudant in Qlik Sense Cloud.
-
Import Real-Time Instantly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Instantly in ColdFusion.
-
Provide OData Services of Sybase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sybase by developing a WCF Service Application.
-
Configure the CData JDBC Driver for Codat in a Connection Pool in Tomcat
Connect to Codat from a connection pool in Tomcat.
-
Access Teamwork Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teamwork from your Oracle system.
-
Moving Data from Cosmos DB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cosmos DB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Dataiku with Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon S3.
-
Smartsheet Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Smartsheet through CData Connect AI using different applications and tools.
-
Connect and Visualize Live Facebook Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Facebook into the Databricks platform and create visualization dashboards with real-time Facebook.
-
Build Voice Agents in ElevenLabs with access to Live Tally Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Tally ERP.
-
How to Access Zuora Data Using Entity Framework
This article shows how to access Zuora using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Jumpseller Data in Talend Cloud Data Management Platform
Connect Jumpseller Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automate Google Sheets Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Sheets replication to Azure Data Lake.
-
Integrating Claude Code CLI with Clari 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.
-
Integrating Claude Code CLI with Accelo 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 MVC Applications with Connectivity to Outreach.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Outreach.io from an ASP.NET MVC application.
-
Query Notion Data in DataGrip
Create a Data Source for Notion in DataGrip and use SQL to query live Notion.
-
Replicate Multiple Trello Accounts via the CData Sync CLI
Replicate multiple Trello accounts to one or many databases.
-
Load HCL Domino Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HCL Domino to a database.
-
Use Databricks Agent Bricks to Talk to Your Sybase IQ Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sybase IQ for you.
-
Viewing QuickBooks Time Data in RAD Studio Data Explorer
How to view QuickBooks Time in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks Time.
-
How to use SQLAlchemy ORM to access Notion Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Notion.
-
Create a Data Access Object for eBay Data using JDBI
A brief overview of creating a SQL Object API for eBay in JDBI.
-
Publish Monday.com-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Monday.com.
-
Use the CData Software JDBC Driver for Cohere in MicroStrategy
Connect to Cohere in MicroStrategy Developer using the CData Software JDBC Driver for Cohere.
-
Connect to Billsby Data in RapidMiner
Integrate Billsby with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Okta from a Connection Pool in WebLogic
Use the CData JDBC Driver for Okta to connect to Okta from Web applications running on WebLogic.
-
Access Sage Cloud Accounting Data from MySQL in PHP
Connect to Sage Cloud Accounting through the standard MySQL libraries in PHP.
-
AlloyDB Reporting in OBIEE with the AlloyDB JDBC Driver
Deploy the AlloyDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
View Reports on Real-Time Adobe Commerce Data in Power BI Report Server
Use the CData ODBC Driver for Adobe Commerce to visualize Adobe Commerce in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Mistral AI 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 Mistral AI into TIBCO Spotfire.
-
Integrate with live Twilio Data in Jitterbit
Use CData Connect AI to connect to and integrate live Twilio in Jitterbit.
-
DataBind Controls to Oracle Sales Data in Delphi
DataBind to Oracle Sales in Delphi with standard data access components and controls.
-
Replicate NetSuite Data in Heroku for Use in Salesforce Connect
Replicate NetSuite CRM & ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Design Spark Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Spark from mobile and tablet Power Apps.
-
Integrate Open WebUI with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MongoDB from within the chat interface.
-
Connect to Square Data from a Connection Pool in JBoss
Integrate Square into Java servlets: Use the Management Console in JBoss to install the Square JDBC Driver.
-
Use Manus AI to Talk to Your Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle HCM Cloud.
-
Use Microsoft Copilot Studio to talk to your Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Facebook for you.
-
Connect to Avalara AvaTax Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Avalara AvaTax Data and connect to Avalara AvaTax in Akorbi Digital RunMyProcess.
-
Create Power BI Reports on Real-Time Yelp Data
Use the CData ODBC Driver for Yelp to visualize Yelp in Power BI Desktop.
-
Build Visualizations of Sugar CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sugar CRM in Birst.
-
Automate Salesloft Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesloft from PowerShell? This article demonstrates how to utilize the Salesloft Cmdlets for tasks like connecting to Salesloft, automating operations, downloading data, and more.
-
Import and Visualize Mixpanel Data in Power View
Create data visualizations based on Mixpanel in Excel.
-
Access Live Box 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 Box through MCP integration.
-
Getting Started with the CData Excel Add-In for SQLite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SQLite.
-
Use the CData Software JDBC Driver for Zoho Recruit in MicroStrategy
Connect to Zoho Recruit in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Recruit.
-
Build Automated SendGrid-Connected Workflows in Zapier
Use CData Connect AI to connect to live SendGrid and build automated workflows in Zapier.
-
Connect to Rootly Data in JRuby
Create a simple JRuby app with access to live Rootly.
-
Build a Simple VCL Application for Demio Data
How to build a simple VCL Application to view Demio in RAD Studio using the CData ODBC Driver for Demio.
-
How to Access Live ElevenLabs Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ElevenLabs enables you to integrate ElevenLabs into workflows built using Microsoft Power Automate Desktop.
-
Connect to Apollo Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apollo from Filemaker Pro on Mac.
-
Connect to Teamwork Data in Aqua Data Studio
Access Teamwork from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Edit and Search External Facebook Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Facebook to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Facebook Data objects that you can access from apps and the dashboard.
-
Analyze ZohoInvoice Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoInvoice with the CData JDBC Driver for ZohoInvoice.
-
Natively Connect to Landbot Data in PHP
The CData ODBC driver for Landbot enables you to create PHP applications with connectivity to Landbot. Leverage the native support for ODBC in PHP.
-
Import Azure Synapse Data Using Azure Data Factory
Use CData Connect AI to connect to Azure Synapse Data from Azure Data Factory and import live Azure Synapse.
-
Getting Started with the CData JDBC Driver for Short.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Short.io.
-
Migrating data from iContact to Google BigQuery using CData SSIS Components.
Easily push iContact to Google BigQuery using the CData SSIS Tasks for iContact and Google BigQuery.
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Eloqua Reporting from PowerBuilder using the Oracle Eloqua Reporting JDBC Driver.
-
Access Live Everhour Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Everhour into the statistical analysis tools available in SAS JMP. This article shows how to use Everhour in the Graph Builder and Query Builder.
-
Create Power BI Reports on Real-Time Superchat Data
Use the CData ODBC Driver for Superchat to visualize Superchat in Power BI Desktop.
-
Create Data Visualizations in Cognos BI with Amazon DynamoDB Data
Access Amazon DynamoDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Tickspot
Create Tickspot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Eventbrite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Eventbrite replication to Amazon S3.
-
Connect to Codat Data in RazorSQL
Connect to Codat from wizards and query Codat from the GUI in the RazorSQL database management tool.
-
Connect to Square Data in DBArtisan
Use wizards in DBArtisan to configure Square as a data source.
-
Connect to Azure Data Catalog Data in Ruby
Connect to Azure Data Catalog in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Sendwithus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sendwithus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sendwithus.
-
Connect to Webflow Data in Jaspersoft Studio
Execute SQL to remote Webflow in Jaspersoft Studio.
-
Automated Continuous Kafka Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Kafka replication to AlloyDB.
-
Query ConstantContact Data in ColdFusion
Write standard ColdFusion data access code to connect to ConstantContact.
-
Prepare, Blend, and Analyze Microsoft Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Ads for self-service data analytics.
-
Automated Continuous SAP Hybris C4C Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to SingleStore.
-
Connect to Apify Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Apify and work with Apify in your FileMaker applications.
-
Connect to MarkLogic Data in NetBeans
Connect to MarkLogic in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Azure DevOps in MicroStrategy Web
Connect to Azure DevOps in MicroStrategy Web using the CData Software ODBC Driver for Azure DevOps.
-
Deploy the ADO.NET Provider for ZohoMarketingHub on an SSRS Report Server
Connect to ZohoMarketingHub 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 connect to Okta Data with Squirrel SQL client
Connect to Okta and execute queries in the Squirrel SQL Client.
-
Establish a Live Connection with Guru Data using Tableau Bridge
The CData ODBC Driver for Guru enables you to integrate live Guru into Tableau Cloud dashboards using the Tableau Bridge.
-
Prepare, Blend, and Analyze Google Ad Manager Data in Alteryx Designer (ODBC)
Build workflows to access live Google Ad Manager for self-service data analytics.
-
Working with LightSpeedRetail Data in LINQPad
Execute LINQ queries to LightSpeedRetail in LINQPad.
-
Use CData Connect AI to Access Oracle Financials Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Financials Cloud in the Power Pivot business intelligence tool.
-
Connect to FTP Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FTP as an External Source in Dremio.
-
How to Visualize Amazon Athena 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 Amazon Athena in Python.
-
Viewing Greenhouse Data in RAD Studio Data Explorer
How to view Greenhouse in RAD Studio Data Explorer using the CData ODBC Driver for Greenhouse.
-
Integrate Live Apollo Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apollo and integrate live Apollo into apps built in Microsoft Power Apps.
-
Build a Simple VCL Application for MariaDB Data
How to build a simple VCL Application to view MariaDB in RAD Studio using the CData ODBC Driver for MariaDB.
-
Use the CData Software ODBC Driver for Jodoo in MicroStrategy
Connect to Jodoo in MicroStrategy Developer using the CData Software ODBC Driver for Jodoo.
-
How to Connect to & Open WordPress Data in Microsoft Excel
This article uses the CData ODBC driver for WordPress to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.