CData Software - Knowledge Base
Recent Articles
-
How to Visualize Humanity Data in Python with pandas
Use pandas and other modules to analyze and visualize live Humanity in Python.
-
Integrating Antigravity CLI with Apache HBase via CData CLI
Connect Apache HBase to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software JDBC Driver for Elasticsearch in MicroStrategy Web
Connect to Elasticsearch in MicroStrategy Web using the CData Software JDBC Driver for Elasticsearch.
-
Integrate Vault CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Veeva Vault & Vault CRM and integrate live Veeva Vault & Vault CRM into your Power Automate tasks.
-
Use JayDeBeApi to access Basecamp Data in Python
Use standard Python scripting and the development environment of your choice to access live Basecamp.
-
Automated Continuous Notion Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Notion replication to Amazon Redshift.
-
Moving Data from Billsby to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Billsby data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect DBeaver to CampaignMonitor via a JDBC Driver
Manage CampaignMonitor with visual tools in DBeaver like the query browser.
-
Build MVC Applications with Connectivity to Ontraport Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Ontraport from an ASP.NET MVC application.
-
Use JayDeBeApi to access ServiceDesk Plus Data in Python
Use standard Python scripting and the development environment of your choice to access live ServiceDesk Plus.
-
Access Live Hive 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 Apache Hive through MCP integration.
-
Create a Data Access Object for LightSpeedRetail Data using JDBI
A brief overview of creating a SQL Object API for LightSpeedRetail in JDBI.
-
Getting Started with the CData Tableau Connector for Factorial
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Aha! Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Aha! replication to Apache Kafka.
-
How to Connect to Printful Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Printful. Leverage the pyodbc module for ODBC in Python.
-
Connect to Real-Time Timely Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Timely in Power Apps.
-
Replicate Mode Data to Multiple Databases
Replicate Mode to disparate databases with a point-and-click configuration.
-
DataBind Controls to Webex Data in C++Builder
DataBind to Webex in C++Builder with standard components and controls.
-
Create Reports from Amazon S3 Data in Looker Studio
Use CData Connect AI to gain access to live Amazon S3 and create custom reports in Looker Studio.
-
Create Google Spanner Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Spanner data access from reports, embedded analytics, and more.
-
Integrate HubSpot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HubSpot with External Services.
-
Connect to Epicor Kinetic Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Epicor Kinetic Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData JDBC Driver for Sendwithus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sendwithus.
-
Build Charts with SpaceX Data in Clear Analytics
Create dynamic charts and perform analytics based on SpaceX in Clear Analytics.
-
Access ZohoSubscriptions Data from MySQL in PHP
Connect to ZohoSubscriptions through the standard MySQL libraries in PHP.
-
Build Apps with Live JobNimbus Data Using the Low-Code Development Platform of Mendix
Connect JobNimbus with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous AlloyDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AlloyDB replication to Amazon Redshift.
-
Feed Kafka Data into FineReport
How to set Apache Kafka as a JDBC data source in FineReport.
-
How to create Visio diagrams from Kintone Data
Automatically update Kintone with the changes you make to Visio master shapes.
-
How to create Redis federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Redis in MySQL .
-
Access Live Snapchat Ads Data in Excel 365 Online (Excel for the web)
Connect to Snapchat Ads from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Google Directory Reporting in OBIEE with the Google Directory JDBC Driver
Deploy the Google Directory JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Toggl Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Toggl replication to Apache Cassandra.
-
Use JayDeBeApi to access Perplexity Data in Python
Use standard Python scripting and the development environment of your choice to access live Perplexity.
-
Connect CouchDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache CouchDB using the CData Python MCP Server.
-
Import and Visualize ElevenLabs Data in Power View
Create data visualizations based on ElevenLabs in Excel.
-
Viewing Oracle Financials Cloud Data in RAD Studio Data Explorer
How to view Oracle Financials Cloud in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Financials Cloud.
-
How to Work with Nuclia Data in AWS Glue Jobs Using JDBC
Connect to Nuclia from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Real-Time Access to Salesforce Marketing in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Marketing Cloud in real time.
-
Automated Continuous SAP Hybris C4C Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to MySQL.
-
DataBind Controls to Snowflake Data in C++Builder
DataBind to Snowflake in C++Builder with standard components and controls.
-
Replicate Multiple Cvent Accounts
Replicate multiple Cvent accounts to one or many databases.
-
Replicate Spark Data from PowerShell
Write a quick PowerShell script to query Apache Spark SQL. Use connectivity to the live data to replicate Apache Spark SQL to SQL Server.
-
DataBind Controls to Wave Financial Data in C++Builder
DataBind to Wave Financial in C++Builder with standard components and controls.
-
How to Access Live Grafana Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Grafana enables you to integrate Grafana into workflows built using Microsoft Power Automate Desktop.
-
Integrate Theia IDE with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Query Confluence Data as a SQL Server Database in Node.js
Execute SQL Server queries against Atlassian Confluence from Node.js.
-
Create Amazon S3-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon S3 Data from OutSystems and build custom enterprise apps using live Amazon S3.
-
Visualize HBase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache HBase.
-
Object-Relational Mapping (ORM) with ChartMogul 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 ChartMogul into a Java-based ORM framework, Hibernate.
-
Create Reports with Smartsheet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Smartsheet.
-
Import Real-Time Zoho Creator Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Creator in ColdFusion.
-
A PostgreSQL Interface for Google Cloud Storage Data using the CData ODBC Driver
Use the SQL Gateway and Google Cloud Storage ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Phoenix Data in C++Builder
DataBind to Apache Phoenix in C++Builder with standard components and controls.
-
Visualize IBM Informix Data in TIBCO Spotfire through OData
Integrate IBM Informix into dashboards in TIBCO Spotfire.
-
Integrating Gumloop with SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft SQL Server within automated workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for SAS Data Sets
Create SAS Data Sets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for LDAP in MicroStrategy
Connect to LDAP in MicroStrategy Developer using the CData Software ODBC Driver for LDAP.
-
Comprehensive Workday Connectivity through Workday WQL and Reports-as-a-Service
Walk through CData’s comprehensive workday connectivity and learn to configure your Workday instance to provide access to Workday Reports-as-a-Service.
-
Connect to Microsoft Entra ID Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Entra ID.
-
DataBind Dropbox Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Dropbox with the DevExpress Windows Forms and Web controls to provide Dropbox to a chart.
-
Visualize Azure Analysis Services Data in Tableau
The CData ODBC driver for Azure Analysis Services enables you integrate Azure Analysis Services into Tableau dashboards.
-
Connect to Toggl Data in Jaspersoft Studio
Execute SQL to remote Toggl in Jaspersoft Studio.
-
Access Live Sage 200 Data in Excel 365 Online (Excel for the web)
Connect to Sage 200 from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automate Impala Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Impala from PowerShell? This article demonstrates how to utilize the Impala Cmdlets for tasks like connecting to Apache Impala, automating operations, downloading data, and more.
-
Replicate Multiple Egnyte Accounts
Replicate multiple Egnyte accounts to one or many databases.
-
Integrating Cursor CLI with SAP Ariba Source 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.
-
DataBind Controls to Rebilly Data in C++Builder
DataBind to Rebilly in C++Builder with standard components and controls.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Box to Power BI dashboards. Simply drag and drop Box into data visuals on the Power BI canvas.
-
Access Snowflake Data from MySQL in Amazon QuickSight
Connect to Snowflake and build visualizations of Snowflake using a MySQL Connection in Amazon QuickSight.
-
DataBind Controls to Phoenix Data in Delphi
DataBind to Apache Phoenix in Delphi with standard data access components and controls.
-
Design BIRT Reports on Onfleet Data
Provide current Onfleet to your embedded analytics.
-
Query ConvertAPI Data in DataGrip
Create a Data Source for ConvertAPI in DataGrip and use SQL to query live ConvertAPI.
-
Use CData Connect AI to Access Twitter Ads Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Twitter Ads in the Power Pivot business intelligence tool.
-
Use Agno to Talk to Your Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zendesk for you.
-
Replicate Mailjet Data in Heroku for Use in Salesforce Connect
Replicate Mailjet to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Edit and Search Monday.com External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Monday.com to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Monday.com objects that you can access from apps and the dashboard.
-
Use ChatGPT to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MailChimp for you.
-
Access Live Beeminder Data in Coginiti Pro
Connect to and query live Beeminder from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Controls to MYOB AccountRight Data in Delphi
DataBind to MYOB AccountRight in Delphi with standard data access components and controls.
-
Connect to Snapchat Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live Snapchat Ads from Crystal Reports.
-
How to connect to ClickTime Data from Spring Boot
Connect to ClickTime in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Cloudant Data in Pentaho Data Integration
Build ETL pipelines based on IBM Cloudant in the Pentaho Data Integration tool.
-
ETL SharePoint Excel Services in Oracle Data Integrator
This article shows how to transfer SharePoint Excel Services into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cosmos DB
Provide connectivity to Azure Cosmos DB through an SAP BusinessObjects universe.
-
Connect to SAP Ariba Procurement Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP Ariba Procurement.
-
Query Shopify Data in ColdFusion
Write standard ColdFusion data access code to connect to Shopify.
-
How to load Mode data into Elasticsearch via Logstash
Introducing a simple method to load Mode data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous PostgreSQL Replication to Databricks
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Databricks.
-
Connect to Azure Synapse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Synapse in the Denodo Virtual DataPort Administrator.
-
Connect to Adobe Target Data in DBeaver
Use the CData ODBC Driver to connect to Adobe Target in DBeaver.
-
Build a PostgreSQL Interface for Twilio Data using the CData JDBC Driver
Use the Remoting features of the Twilio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use ChatGPT to Talk to Your MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MongoDB for you.
-
How to Work with Highrise Data in AWS Glue Jobs Using JDBC
Connect to Highrise from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Manus AI to Talk to Your Procore 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 Procore.
-
Connect to Telegram Data in Jaspersoft Studio
Execute SQL to remote Telegram in Jaspersoft Studio.
-
Replicate Multiple Airtable Accounts
Replicate multiple Airtable accounts to one or many databases.
-
Integrate Real-Time Access to SQL Server in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft SQL Server in real time.
-
Build BigCommerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for BigCommerce Data and create custom apps in Bubble.
-
Visualize Deel Data in TIBCO Spotfire through ADO.NET
Integrate Deel into dashboards in TIBCO Spotfire.