CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode Terminal with DB2 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.
-
ETL Microsoft OneDrive in Oracle Data Integrator
This article shows how to transfer Microsoft OneDrive into a data warehouse using Oracle Data Integrator.
-
Use Manus AI to Talk to Your Microsoft OneDrive 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 Microsoft OneDrive.
-
Create Power BI Reports on Real-Time Exa Data
Use the CData ODBC Driver for Exa to visualize Exa in Power BI Desktop.
-
Access Act CRM 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 Act CRM.
-
How to Build an ETL App for Amazon S3 Data in Python with CData Connect AI
Build ETL pipelines that read and write live Amazon S3 in Python with petl and the CData Connect AI Python SDK.
-
Analyze Superchat Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Superchat with the CData JDBC Driver for Superchat.
-
Connect to Lakebase Data from AWS Glue
Use CData Connect AI to gain access to live Lakebase from your AWS Glue jobs.
-
Connect to Toggl Data in JRuby
Create a simple JRuby app with access to live Toggl.
-
How to use SQLAlchemy ORM to access Superchat Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Superchat.
-
Use Grok to Talk to Your Snapchat Ads 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 Snapchat Ads for you.
-
Integrate Amazon Athena Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Amazon Athena and integrate live Amazon Athena into your Power Automate tasks.
-
Use Dash to Build to Web Apps on Exa Data
Create Python applications that use pandas and Dash to build Exa-connected web apps.
-
Visualize Cvent Data in Sisense
Create an ElastiCube in Sisense app with access to Cvent.
-
Validate ConvertKit Data with QuerySurge
Access and validate ConvertKit in QuerySurge using the CData JDBC Driver.
-
Working with Sugar CRM Data in LINQPad
Execute LINQ queries to Sugar CRM in LINQPad.
-
Connect to Live SAP SuccessFactors LMS Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP SuccessFactors LMS in CData Connect AI and connect to your SAP SuccessFactors LMS from PostgreSQL.
-
Use the CData Software JDBC Driver for ZohoInvoice in MicroStrategy Web
Connect to ZohoInvoice in MicroStrategy Web using the CData Software JDBC Driver for ZohoInvoice.
-
Build a Simple VCL Application for Bitbucket Data
How to build a simple VCL Application to view Bitbucket in RAD Studio using the CData ODBC Driver for Bitbucket.
-
Automated Continuous Google Campaign Manager 360 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Amazon Redshift.
-
How to Connect to Live Epicor Kinetic Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Epicor Kinetic for you.
-
Working with Recurly Data in LINQPad
Execute LINQ queries to Recurly in LINQPad.
-
Build Elorus-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Elorus.
-
Access Planio Data from MySQL in Amazon QuickSight
Connect to Planio and build visualizations of Planio using a MySQL Connection in Amazon QuickSight.
-
Visualize Live Landbot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Landbot using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous NetSuite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable NetSuite replication to Apache Cassandra.
-
Integrating Antigravity CLI with Elorus via CData CLI
Connect Elorus to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live HBase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache HBase from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Mode Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mode to connect to Mode and execute queries in PowerBuilder.
-
Extract, Transform, and Load HDFS Data in Informatica PowerCenter
Create a simple Workflow for Apache HDFS in Informatica PowerCenter.
-
How to integrate Sage Intacct with Apache Airflow
Access and process Sage Intacct in Apache Airflow using the CData JDBC Driver.
-
Visualize LionDesk Data in Tableau
The CData ODBC driver for LionDesk enables you integrate LionDesk into Tableau dashboards.
-
Operational Reporting on GitLab Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote GitLab.
-
Use CData Connect AI to Access WooCommerce Data in Microsoft Power Pivot
Use CData Connect AI to connect to live WooCommerce in the Power Pivot business intelligence tool.
-
Configure the CData JDBC Driver for Box in a Connection Pool in Tomcat
Connect to Box from a connection pool in Tomcat.
-
Build Visualizations of xBase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of xBase in Birst.
-
Add Teradata Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Teradata with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to create Visio diagrams from Google Calendar Data
Automatically update Google Calendar with the changes you make to Visio master shapes.
-
How to work with LDAP Objects in Apache Spark using SQL
Access and process LDAP Objects in Apache Spark using the CData Software JDBC Driver.
-
Build Visualizations of Kintone Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Kintone in Birst.
-
Google Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Ads facts in real time.
-
Connect to Elasticsearch Data in NetBeans
Connect to Elasticsearch in NetBeans with the data source configuration wizard.
-
How to integrate SAP Ariba Procurement with Apache Airflow
Access and process SAP Ariba Procurement in Apache Airflow using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Adobe Experience Manager Data using the CData JDBC Driver
Use the Remoting features of the Adobe Experience Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Hybris C4C
Provide connectivity to SAP Hybris C4C through an SAP BusinessObjects universe.
-
Choosing the Best Method to Connect Omnisend to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Omnisend from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating GitHub Copilot CLI with Reply.io 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.
-
Migrating data from Google Forms to Snowflake using CData SSIS Components.
Easily push Google Forms to Snowflake using the CData SSIS Tasks for Google Forms and Snowflake.
-
Automated Continuous SendPulse Replication to SingleStore
Use CData Sync for automated, continuous, customizable SendPulse replication to SingleStore.
-
Connect to BenchmarkEmail Data in HULFT Integrate
Connect to BenchmarkEmail as a JDBC data source in HULFT Integrate
-
Access PDFMonkey 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 PDFMonkey.
-
Connect to and Query JotForm Data in QlikView over ODBC
Create data visualizations with JotForm in QlikView.
-
Use CData Connect AI to Access Smartsheet Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Smartsheet in the Power Pivot business intelligence tool.
-
Provide OData Services of Bullhorn CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Bullhorn CRM by developing a WCF Service Application.
-
DataBind Charts to Cloudflare Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cloudflare from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Getting Started with the CData Power BI Connector for Superchat
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Kiro CLI with Optimizely 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.
-
Connect to Customer.io Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Customer.io as an External Source in Dremio.
-
Build a PostgreSQL Interface for Flowlu Data using the CData JDBC Driver
Use the Remoting features of the Flowlu JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to WordPress Data from a Connection Pool in JBoss
Integrate WordPress into Java servlets: Use the Management Console in JBoss to install the WordPress JDBC Driver.
-
Integrate with live Shopify Data in Jitterbit
Use CData Connect AI to connect to and integrate live Shopify in Jitterbit.
-
Manage Browserless Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Browserless.
-
Use the CData ODBC Driver for Neo4J in Microsoft Power Query
You can use the CData Neo4J ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Neo4J into Microsoft Power Query.
-
Automated Continuous Zendesk Replication to Vertica
Use CData Sync for automated, continuous, customizable Zendesk replication to Vertica.
-
Visualize GitLab Data in TIBCO Spotfire through ADO.NET
Integrate GitLab into dashboards in TIBCO Spotfire.
-
Analyze ZeroBounce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZeroBounce from Power Pivot. You will use the Table Import Wizard to load ZeroBounce. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Sybase Data in the Pentaho Report Designer
Publish reports based on Sybase in the Pentaho BI tool.
-
Automated Continuous Dynamics NAV Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Google BigQuery.
-
Connect to Chargebee Data in HULFT Integrate
Connect to Chargebee as a JDBC data source in HULFT Integrate
-
Automated NetSuite SuiteAnalytics Data Replication to Teradata
Use CData Sync to Customize and automate NetSuite SuiteAnalytics replication to Teradata.
-
Establish a Live Connection with Oracle Sales Data using Tableau Bridge
The CData ODBC Driver for Oracle Sales enables you to integrate live Oracle Sales into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live PayPal Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PayPal using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Dash to Build Web Apps on BambooHR Data via CData Connect AI
Build interactive Dash web apps on live BambooHR using pandas and the CData Connect AI Python SDK.
-
Using the CData Software ODBC Driver for Zoom in PyCharm
Connect to Zoom as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoom.
-
Building Dynamic Web Pages with SharePoint Excel Services Data Using AngularJS
Create single-page applications with live connectivity to SharePoint Excel Services using the CData API Server.
-
Integrating OpenCode Terminal with Couchbase 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.
-
Integrate with Scrapfly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Scrapfly to a JSON file on disk.
-
Connect to and Visualize Live Oracle SCM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle SCM.
-
Automated Continuous Dotmailer Replication to SQLite
Use CData Sync for automated, continuous, customizable Dotmailer replication to SQLite.
-
Connect to Notion Data in RapidMiner
Integrate Notion with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated LinkedIn Ads Data Replication to Teradata
Use CData Sync to Customize and automate LinkedIn Ads replication to Teradata.
-
Create a Data Access Object for SFTP Data using JDBI
A brief overview of creating a SQL Object API for SFTP in JDBI.
-
Choosing the Best Method to Connect Reckon to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Reckon from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Write a Simple Go Application to work with LaunchDarkly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LaunchDarkly.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Epicor Kinetic using the Model Context Protocol.
-
Getting Started with the CData Power BI Connector for Shopify
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Shopify.
-
ETL Epicor Kinetic in Oracle Data Integrator
This article shows how to transfer Epicor Kinetic into a data warehouse using Oracle Data Integrator.
-
Connect to Oracle Service Cloud Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Service Cloud as an External Source in Dremio.
-
DataBind Charts to Raisers Edge NXT Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Raisers Edge NXT from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Natively Connect to Gmail Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Gmail. Leverage the native support for ODBC in PHP.
-
Integrate ShipStation with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ShipStation with External Services.
-
Connect Exa to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Exa with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for LightSpeedRetail in SAS for Real-Time Reporting and Analytics
Connect to real-time LightSpeedRetail in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LightSpeedRetail.
-
Build Automated Workflows with Live Kintone Data in Workato
Use CData Connect AI to connect to live Kintone and build automated workflows in Workato.
-
Consume SAS Data Sets OData Feeds in PowerBuilder
This article demonstrates how to consume SAS Data Sets as OData feeds from PowerBuilder using the API Server.
-
Design BIRT Reports on Notion Data
Provide current Notion to your embedded analytics.
-
Automated Continuous Autopilot Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Autopilot replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy Web
Connect to SAS XPORT in MicroStrategy Web using the CData Software ODBC Driver for SAS xpt.
-
Build an OLAP Cube in SSAS from Stripe Data
Establish a connection to Stripe data from SQL Server Analysis Services, and use the Stripe Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to HCL Domino Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HCL Domino in the Denodo Virtual DataPort Administrator.