CData Software - Knowledge Base
Recent Articles
-
Query, Visualize, and Share live Acumatica Data in Redash
Use CData Connect AI to connect to live Acumatica data in Redash for querying, visualizing, and sharing.
-
Integrating LangGraph with Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Freshdesk data within automated workflows.
-
Use the CData ODBC Driver for NetSuite in MicroStrategy
Connect to NetSuite data in MicroStrategy Developer using the CData ODBC Driver for NetSuite.
-
Connect to SAP Ariba Procurement Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Ariba Procurement data from PowerBuilder using the SAP Ariba Procurement JDBC Driver.
-
How to Build an ETL App for Sendwithus Data in Python with CData Connect AI
Extract and transform live Sendwithus data in Python with petl and the CData Connect AI Python SDK.
-
Connect and Query Live Bitly Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Bitly data into Databricks and enable direct, live querying and analysis without replication.
-
Extract, Transform, and Load Telegram Data in Informatica PowerCenter
Create a simple Workflow for Telegram data in Informatica PowerCenter.
-
Create Power BI Reports on Real-Time Copper Data
Use the CData ODBC Driver for Copper to visualize Copper data in Power BI Desktop.
-
Using the CData Software ODBC Driver for Autopilot in PyCharm
Connect to Autopilot as an ODBC data source in PyCharm using the CData Software ODBC Driver for Autopilot.
-
Connect to Office 365 Data in DBArtisan
Use wizards in DBArtisan to configure Office 365 data as a data source.
-
Easily Integrate HDFS Data in Lazarus Pascal IDE
Learn how to easily integrate live HDFS data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Python Connector for Dynamics NAV
Learn to install and license the CData Python Connector and configure a connection to live Dynamics NAV data.
-
Visualize Live SAP Ariba Procurement Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Ariba Procurement data into custom reports in Power BI.
-
How to connect PolyBase to LeadDesk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LeadDesk data.
-
Use Grok to Talk to Your Act-On 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 Act-On data for you.
-
Use the CData Software ODBC Driver for MarkLogic in SAS for Real-Time Reporting and Analytics
Connect to real-time MarkLogic data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MarkLogic.
-
How to Build an ETL App for Excel Online Data in Python with CData Connect AI
Build ETL pipelines that read and write live Excel Online data in Python with petl and the CData Connect AI Python SDK.
-
Analyze SAP Business Warehouse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Business Warehouse data with the CData JDBC Driver for SAP Business Warehouse.
-
Viewing Yelp Data in RAD Studio Data Explorer
How to view Yelp data in RAD Studio Data Explorer using the CData ODBC Driver for Yelp.
-
Migrating data from Aircall to Snowflake using CData SSIS Components.
Easily push Aircall data to Snowflake using the CData SSIS Tasks for Aircall and Snowflake.
-
Connect to QuickBooks Data from PowerBuilder via ADO.NET
This article demonstrates how to access QuickBooks data from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks.
-
Create Tally Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tally from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Supabase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Supabase replication to IBM DB2.
-
Integrating GitHub Copilot with Perigon 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.
-
How to Connect to Short.io Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Short.io data. Leverage the pyodbc module for ODBC in Python.
-
Build Data Flows from AfterShip to SQL Server using SSIS
Easily back up AfterShip data to SQL Server using the SSIS components for AfterShip.
-
How to Connect to & Open ZohoMarketingHub Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoMarketingHub to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Exact Online Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon S3.
-
Analyze SAP BusinessObjects BI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP BusinessObjects BI data with the CData JDBC Driver for SAP BusinessObjects BI.
-
Explore Geographical Relationships in Nuclia Data with Power Map
Create data visualizations with Nuclia data in Power Map.
-
DataBind Salesloft Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesloft with the DevExpress Windows Forms and Web controls to provide Salesloft data to a chart.
-
Integrating Antigravity CLI with Paddle data via CData CLI
Connect Paddle data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Operational Reporting on Salesforce Marketing Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce Marketing data.
-
Use the CData ODBC Driver for Gorgias from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Gorgias to connect to Gorgias data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Gorgias data in Excel.
-
Build MVC Applications with Connectivity to Instantly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Instantly from an ASP.NET MVC application.
-
Integrate Live Act CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Act CRM data from within the IDE.
-
How to Build an ETL App for Mocean Data in Python with CData
Create ETL applications and real-time data pipelines for Mocean data in Python with petl.
-
Publish Paymo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Paymo data.
-
Automated Salesforce Data Replication to Teradata
Use CData Sync to Customize and automate Salesforce data replication to Teradata.
-
Connect to Google Sheets Data in ACL Analytics
Connect to Google Sheets data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Sheets data.
-
Build SAP Ariba Source Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Ariba Source data and build visualizations in Tableau Cloud.
-
How to load MongoDB data into Elasticsearch via Logstash
Introducing a simple method to load MongoDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous ZohoPeople Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Vertica.
-
Use the CData ODBC Driver for Eventbrite in Microsoft Power Query
You can use the CData Eventbrite ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Eventbrite data into Microsoft Power Query.
-
Build Charts with Strava Data in Clear Analytics
Create dynamic charts and perform analytics based on Strava data in Clear Analytics.
-
Bridge Oracle HCM Cloud Connectivity with Apache NiFi
Access and process Oracle HCM Cloud data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous DB2 for i Replication to SQLite
Use CData Sync for automated, continuous, customizable DB2 for i replication to SQLite.
-
Access Live Phoenix Data in TIBCO Data Virtualization
Use the Phoenix Tibco DV Adapter to create a Phoenix data data source in TIBCO Data Virtualization Studio and gain access to live Phoenix data from your TDV Server.
-
Publish Jira-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Jira data.
-
How to use SQLAlchemy ORM to access Active Directory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Active Directory data.
-
Object-Relational Mapping (ORM) with JDBC-ODBC Bridge 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 JDBC-ODBC Bridge data into a Java-based ORM framework, Hibernate.
-
Connect to ConstantContact Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ConstantContact Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to and Visualize Live Templated Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Templated data.
-
How to Connect DBeaver to Recurly via a JDBC Driver
Manage Recurly data with visual tools in DBeaver like the query browser.
-
Natively Connect to Freshteam Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Freshteam data. Leverage the native support for ODBC in PHP.
-
Stream Phoenix Data into Apache Kafka Topics
Access and stream Phoenix data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous GitHub Replication to MongoDB
Use CData Sync for automated, continuous, customizable GitHub replication to MongoDB.
-
Integrating Cursor with Pipeliner CRM 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.
-
Automated Continuous Sugar CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Azure SQL Database.
-
Create Dynamic Autopilot Grids Using the Infragistics XamDataGrid
Learn how you can connect Autopilot to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live Workday Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Workday from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Workday data.
-
Integrate Live Dynamics CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dynamics CRM data.
-
Connect to Omnisend Data from a Connection Pool in JBoss
Integrate Omnisend data into Java servlets: Use the Management Console in JBoss to install the Omnisend JDBC Driver.
-
Explore Geographical Relationships in Aircall Data with Power Map
Create data visualizations with Aircall data in Power Map.
-
Query MySQL Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MySQL data from Node.js.
-
Back Up Timely data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Timely data data.
-
Bridge ConvertAPI Connectivity with Apache NiFi
Access and process ConvertAPI data in Apache NiFi using the CData JDBC Driver.
-
Visualize WooCommerce Data in Tableau
The CData ODBC driver for WooCommerce enables you integrate WooCommerce data into Tableau dashboards.
-
Connect to Zoho Creator in SpagoBI
Create reports featuring live Zoho Creator data in SpagoBI Studio. Host Zoho Creator reports on SpagoBI Server.
-
Create a Data Access Object for Bannerbear Data using JDBI
A brief overview of creating a SQL Object API for Bannerbear data in JDBI.
-
Excel Spreadsheet Automation on SageHR Data with the QUERY Formula
Pull data from SageHR, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from ClickUp to Snowflake using CData SSIS Components.
Easily push ClickUp data to Snowflake using the CData SSIS Tasks for ClickUp and Snowflake.
-
Build a Simple VCL Application for ConstantContact Data
How to build a simple VCL Application to view ConstantContact data in RAD Studio using the CData ODBC Driver for ConstantContact.
-
How to Connect the Power BI Service to Deel: Complete Guide
Connect to the CData Software Power BI Connector for Deel from PowerBI.com to provide real-time Deel data across the organization.
-
Visualize Live Amazon S3 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon S3 data.
-
Create Oracle SCM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle SCM Data from Klipfolio and build custom visualizations using live Oracle SCM data.
-
Getting Started with the CData SSIS Components for Miro
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Miro.
-
Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy
Connect to ScrapingBee data in MicroStrategy Developer using the CData Software JDBC Driver for ScrapingBee.
-
Create Power BI Reports on Real-Time Jodoo Data
Use the CData ODBC Driver for Jodoo to visualize Jodoo data in Power BI Desktop.
-
Access Kafka 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 Kafka data.
-
Analyze Wave Financial Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Wave Financial data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Moving Data from Microsoft Ads to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Instantly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Instantly replication to Google BigQuery.
-
Integrate Live Microsoft Ads Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Ads data.
-
Visualize Sugar CRM Data in Tableau
The CData ODBC driver for Sugar CRM enables you integrate Sugar CRM data into Tableau dashboards.
-
Use JayDeBeApi to access Zoho Projects Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Projects data.
-
Use the CData Software JDBC Driver for Jumpseller in MicroStrategy Desktop
Connect to Jumpseller data in MicroStrategy Desktop using the CData Software JDBC Driver for Jumpseller.
-
Manage Klipfolio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Klipfolio.
-
Build a PostgreSQL Interface for Elasticsearch Data using the CData JDBC Driver
Use the Remoting features of the Elasticsearch JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for Supabase
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
View Reports on Real-Time Instantly Data in Power BI Report Server
Use the CData ODBC Driver for Instantly to visualize Instantly data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to TaxJar Data in Google Apps Script via Connect AI
Use CData Connect AI to access TaxJar data in Google Apps Script.
-
Create Data Visualizations in Cognos BI with Simplesat Data
Access Simplesat data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Egnyte Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Egnyte from Power Pivot. You will use the Table Import Wizard to load Egnyte data. You can visually build the import query or use any SQL supported by the driver.
-
Build an OLAP Cube in SSAS from Twitter Ads Data
Establish a connection to Twitter Ads data data from SQL Server Analysis Services, and use the Twitter Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Nethunt Data in DataGrip
Create a Data Source for Nethunt in DataGrip and use SQL to query live Nethunt data.
-
Connect Amazon S3 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon S3 data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Confluence-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Confluence data and build Confluence-connected web apps with Axios.
-
Integrate with Live ZohoSubscriptions Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ZohoSubscriptions from the MuleSoft Anypoint Platform to integrate live ZohoSubscriptions data into custom reports and dashboards.
-
Create ClickUp-Connected Nintex Workflows
Use CData Connect AI to connect to ClickUp Data from Nintex Workflow Cloud and build custom workflows using live ClickUp data.