CData Software - Knowledge Base
Recent Articles
-
Viewing Chargebee Data in RAD Studio Data Explorer
How to view Chargebee in RAD Studio Data Explorer using the CData ODBC Driver for Chargebee.
-
How to Query Clio Data in MySQL Workbench
Execute MySQL queries against live Clio from MySQL Workbench.
-
Connecting Mastra with Gong Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Gong, no replication required.
-
Connecting Pipedream with Redis 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 Redis data in real time.
-
Use JayDeBeApi to access Zoho Inventory Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Inventory.
-
Getting Started with the CData JDBC Driver for Google Translate
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Translate.
-
Connect to Avro Data in ACL Analytics
Connect to Apache Avro via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Avro.
-
Build DocuSign-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for DocuSign Data and create custom apps in Bubble.
-
Connect to Square Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Square Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Natively Connect to Salesloft Data in PHP
The CData ODBC driver for Salesloft enables you to create PHP applications with connectivity to Salesloft. Leverage the native support for ODBC in PHP.
-
Create Dynamic Opsgenie Grids Using the Infragistics XamDataGrid
Learn how you can connect Opsgenie to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Live GitLab Data in MicroStrategy through CData Connect AI
Create a live connection to GitLab Data in CData Connect AI and connect to your GitLab from MicroStrategy.
-
Create Datasets from Paymo in Domo Workbench and Build Visualizations of Paymo Data in Domo
Use the CData Software ODBC Driver for Paymo to create datasets from Paymo in Domo Workbench and then build visualizations in the Domo service.
-
How to Access Live Avalara AvaTax Data in Visual Studio Code via Cline
Run CData MCP Server for Avalara AvaTax on Windows Subsytem for Linux (WSL) and connect to live Avalara AvaTax from the Cline extension in Visual Studio Code.
-
How to Query Live BigQuery Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google BigQuery data in natural language using Python.
-
Connect to Oracle Service Cloud Data in ACL Analytics
Connect to Oracle Service Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Service Cloud.
-
Connect to and Visualize Live Billsby Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Billsby.
-
Connect to Real-Time ChartMogul Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ChartMogul in Power Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for JobNimbus
Create an ODBC connection to JobNimbus in Informatica and browse and transfer JobNimbus.
-
Build Dashboards with ZohoPeople Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoPeople in DBxtra.
-
Viewing SAP ByDesign Data in RAD Studio Data Explorer
How to view SAP Business ByDesign in RAD Studio Data Explorer using the CData ODBC Driver for SAP ByDesign.
-
Connect to SAP Netweaver Gateway Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Netweaver Gateway Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Bridge Vault CRM Connectivity with Apache NiFi
Access and process Veeva Vault & Vault CRM in Apache NiFi using the CData JDBC Driver.
-
Visualize Live SAP Ariba Source Data in the Power BI Service
Use CData Connect AI to connect to live SAP Ariba Source and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Teradata Data in Power View
Create data visualizations based on Teradata in Excel.
-
Use Grok to Talk to Your Epicor Kinetic 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 Epicor Kinetic for you.
-
How to Design Marketo Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Marketo from mobile and tablet Power Apps.
-
Access Live Splunk Data in Excel 365 Online (Excel for the web)
Connect to Splunk from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Invoiced Data in Jaspersoft Studio
Execute SQL to remote Invoiced in Jaspersoft Studio.
-
Manage ChartMogul Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ChartMogul.
-
Automated Continuous Printful Replication to SQLite
Use CData Sync for automated, continuous, customizable Printful replication to SQLite.
-
Connect to LightSpeedRetail Data in Jaspersoft Studio
Execute SQL to remote LightSpeedRetail in Jaspersoft Studio.
-
Connect to Act CRM Data from a Connection Pool in JBoss
Integrate Act CRM into Java servlets: Use the Management Console in JBoss to install the Act CRM JDBC Driver.
-
Automated Continuous Trello Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Trello replication to Google BigQuery.
-
Visualize Live WordPress Data in the Power BI Service
Use CData Connect AI to connect to live WordPress and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate SendGrid Data to Multiple Databases
Replicate SendGrid to disparate databases with a point-and-click configuration.
-
Integrate with GitLab Data in JReport Designer
Create charts and reports based on GitLab in JReport Designer.
-
Create a Data Access Object for CloudConvert Data using JDBI
A brief overview of creating a SQL Object API for CloudConvert in JDBI.
-
Visualize Salesforce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce & Force.com.
-
Connect to and Visualize Live PayPal Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PayPal.
-
Write a Simple Go Application to work with Sybase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sybase.
-
Connect to VWO Data in NetBeans
Connect to VWO in NetBeans with the data source configuration wizard.
-
Easily Integrate Cvent Data in Lazarus Pascal IDE
Learn how to easily integrate live Cvent in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to and Query Strava Data in QlikView over ODBC
Create data visualizations with Strava in QlikView.
-
Publish Crystal Reports on Google Drive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Drive.
-
How to import Intercom Data into Apache Solr
Use the CData Software JDBC Driver for Intercom in Data Import Handler and create an automated import of Intercom to Apache Solr Enterprise Search platform.
-
Analyze Smartsheet Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Smartsheet and visualize Smartsheet in SAP Analytics Cloud.
-
Easily Integrate Oracle Eloqua Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Eloqua in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query HubDB Data in ColdFusion
Write standard ColdFusion data access code to connect to HubDB.
-
Analyze Gong Data in Cognos Analytics
Use CData Connect AI to connect to Gong Data from Cognos Analytics and analyze live Gong.
-
How to Connect Flowise AI Agents to Live IBM Informix Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live IBM Informix without replication.
-
Connect to Freshdesk Data in JRuby
Create a simple JRuby app with access to live Freshdesk.
-
Migrating data from Coda to Databricks using CData SSIS Components.
Easily push Coda to Databricks using the CData SSIS Tasks for Coda and Databricks.
-
Use Dash to Build to Web Apps on ZohoInvoice Data
Create Python applications that use pandas and Dash to build ZohoInvoice-connected web apps.
-
Integrating Claude Code CLI with Elasticsearch 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.
-
Use the CData ODBC Driver for SAP ByDesign in Microsoft Power Query
You can use the CData SAP ByDesign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Business ByDesign into Microsoft Power Query.
-
Create Data Visualizations in Cognos BI with Attio Data
Access Attio as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Box Data from PowerBuilder via ADO.NET
This article demonstrates how to access Box from Appeon PowerBuilder using the CData ADO.NET Provider for Box.
-
Use the CData ODBC Driver for Paylocity in Microsoft Power Query
You can use the CData Paylocity ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Paylocity into Microsoft Power Query.
-
Edit and Search External Snapchat Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Snapchat Ads to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Snapchat Ads Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData Python Connector for Instantly
Learn to install and license the CData Python Connector
-
DataBind Controls to Exa Data in Delphi
DataBind to Exa in Delphi with standard data access components and controls.
-
Build a Simple VCL Application for Zoho Creator Data
How to build a simple VCL Application to view Zoho Creator in RAD Studio using the CData ODBC Driver for Zoho Creator.
-
Visualize Chargebee 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 Chargebee into TIBCO Spotfire.
-
Visualize Live ActiveCampaign Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ActiveCampaign.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Business Warehouse
Create SAP Business Warehouse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Salesforce CRM Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate Salesforce CRM Analytics replication to SAP HANA.
-
Build Apps with Live Facebook Ads Data Using the Low-Code Development Platform of Mendix
Connect Facebook Ads with Mendix to build apps using the CData JDBC Driver for Facebook Ads.
-
Connect to Billsby Data in DBArtisan
Use wizards in DBArtisan to configure Billsby as a data source.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Databricks within intelligent workflows.
-
How to Connect DBeaver to PabblySubscriptions via a JDBC Driver
Manage PabblySubscriptions with visual tools in DBeaver like the query browser.
-
Add ADP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ADP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load Miro Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Miro to a database.
-
Enable the GraphQL JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with GraphQL.
-
How to Access Live Deel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Deel enables you to integrate Deel into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoho Recruit Data in NetBeans
Connect to Zoho Recruit in NetBeans with the data source configuration wizard.
-
Build Apps with Live ScrapingBee Data Using the Low-Code Development Platform of Mendix
Connect ScrapingBee with Mendix to build apps using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze Act-On Data in Alteryx Designer (ODBC)
Build workflows to access live Act-On for self-service data analytics.
-
Getting Started with the CData Tableau Connector for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesforce CRM Analytics.
-
Migrating data from AlloyDB to Snowflake using CData SSIS Components.
Easily push Google AlloyDB to Snowflake using the CData SSIS Tasks for AlloyDB and Snowflake.
-
Connect to ZohoSubscriptions Data in RazorSQL
Connect to ZohoSubscriptions from wizards and query ZohoSubscriptions from the GUI in the RazorSQL database management tool.
-
How to Seamlessly Import Sage Cloud Accounting Data into IBM SPSS Modeler
Integrate Sage Cloud Accounting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live ShipStation Data in Excel 365 Online (Excel for the web)
Connect to ShipStation from Excel 365 Online (Excel for the web) with CData Connect AI.
-
LINQ to Eventbrite 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 Eventbrite Data Provider.
-
Build Suadeo-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Suadeo to explore live Suadeo Data in GitHub Copilot to assist with building Suadeo-powered applications.
-
Visualize PingOne Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PingOne.
-
Automate Lakebase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Lakebase from PowerShell? This article demonstrates how to utilize the Lakebase Cmdlets for tasks like connecting to Lakebase, automating operations, downloading data, and more.
-
Automated Continuous JSON Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable JSON replication to Azure SQL Database.
-
Connect to MailChimp Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Automated Workflows with Live SurveyMonkey Data in Workato
Use CData Connect AI to connect to live SurveyMonkey and build automated workflows in Workato.
-
Prepare, Blend, and Analyze Jira Assets Data in Alteryx Designer (ODBC)
Build workflows to access live Jira Assets for self-service data analytics.
-
Publish Crystal Reports on Sage Intacct Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage Intacct.
-
Easily Integrate Gong Data in Lazarus Pascal IDE
Learn how to easily integrate live Gong in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect the Power BI Service to Bannerbear: Complete Guide
Connect to the CData Software Power BI Connector for Bannerbear from PowerBI.com to provide real-time Bannerbear across the organization.
-
Integrating Antigravity CLI with Toggl via CData CLI
Connect Toggl to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Excel Add-In for Tanda
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tanda.
-
Create Reports with Procore Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Procore.
-
Build Automated Paylocity-Connected Workflows in Zapier
Use CData Connect AI to connect to live Paylocity and build automated workflows in Zapier.
-
Use the CData Software ODBC Driver for Trello in SAS for Real-Time Reporting and Analytics
Connect to real-time Trello in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Trello.
-
Automated Continuous ADP Replication to SingleStore
Use CData Sync for automated, continuous, customizable ADP replication to SingleStore.