CData Software - Knowledge Base
Recent Articles
-
Access Omnisend Data from MySQL in PHP
Connect to Omnisend through the standard MySQL libraries in PHP.
-
Connect to Close Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Close as an External Source in Dremio.
-
How to Connect to Live Google Ads Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Ads data through natural language.
-
Replicate Multiple Onfleet Accounts via the CData Sync CLI
Replicate multiple Onfleet accounts to one or many databases.
-
Create XML-Connected Business Apps in AppSheet
Connect to XML Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to XML data.
-
Automated Continuous Confluence Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Confluence replication to Amazon Redshift.
-
Connect to RabbitMQ Data in RapidMiner
Integrate RabbitMQ data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Theia IDE with Live Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Moosend data from within the development environment.
-
How to Query Live Reply.io Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Reply.io data data in natural language using Python.
-
Analyze HDFS Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of HDFS data and visualize live HDFS data in Infragistics Reveal.
-
Use the CData Software ODBC Driver for SageHR in MicroStrategy
Connect to SageHR data in MicroStrategy Developer using the CData Software ODBC Driver for SageHR.
-
How to create AfterShip federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for AfterShip data in MySQL .
-
How to connect Amazon QuickSight to MailerLite Data
Create a connection to MailerLite data in CData Connect AI and insert MailerLite data into Amazon QuickSight SPICE to build interactive dashboards.
-
Bridge JDBC-ODBC Bridge Connectivity with Apache NiFi
Access and process JDBC-ODBC Bridge data in Apache NiFi using the CData JDBC Driver.
-
Analyze ConvertKit Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ConvertKit data with the CData JDBC Driver for ConvertKit.
-
DataBind Controls to Impala Data in Delphi
DataBind to Impala data in Delphi with standard data access components and controls.
-
Configure the CData JDBC Driver for PagerDuty in a Connection Pool in Tomcat
Connect to PagerDuty data from a connection pool in Tomcat.
-
Replicate Multiple SAP ByDesign Accounts
Replicate multiple SAP ByDesign accounts to one or many databases.
-
Use JayDeBeApi to access Zendesk Data in Python
Use standard Python scripting and the development environment of your choice to access live Zendesk data.
-
Integrating Kiro with QuickBooks Online 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 Oracle Eloqua Reporting Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Eloqua Reporting data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Rebilly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Rebilly replication to Azure SQL Database.
-
Model AlloyDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and AlloyDB, enabling the direct import of real-time AlloyDB data.
-
Integrate Goose with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live WordPress data from within the local AI agent.
-
Provide OData Services of Brex Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Brex data by developing a WCF Service Application.
-
LINQ to Wrike 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 Wrike Data Provider.
-
Connect to Impala Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Impala Data and connect to Impala data in Akorbi Digital RunMyProcess.
-
Integrate with Live SAP Hybris C4C Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Hybris C4C from the MuleSoft Anypoint Platform to integrate live SAP Hybris C4C data into custom reports and dashboards.
-
Automate Bannerbear Data Replication to SAP HANA
Use CData Sync to customize and automate Bannerbear data replication to SAP HANA.
-
Using the CData Software ODBC Driver for Okta in PyCharm
Connect to Okta as an ODBC data source in PyCharm using the CData Software ODBC Driver for Okta.
-
Build a PostgreSQL Interface for Highrise Data using the CData JDBC Driver
Use the Remoting features of the Highrise JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Oracle Sales Data in HULFT Integrate
Connect to Oracle Sales as a JDBC data source in HULFT Integrate
-
Connect to Adobe Experience Manager Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Experience Manager data using standard SQL.
-
Connect to EmailOctopus Data in RapidMiner
Integrate EmailOctopus data with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of Redis Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Redis data by developing a WCF Service Application.
-
How to integrate Metabase with HDFS Data
Use CData Connect AI to connect to live HDFS data and create an interactive dashboard in Metabase from HDFS data.
-
Connect to ConvertAPI Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ConvertAPI to connect to ConvertAPI data and execute queries in PowerBuilder.
-
Migrating data from SharePoint Excel Services to Snowflake using CData SSIS Components.
Easily push SharePoint Excel Services data to Snowflake using the CData SSIS Tasks for SharePoint Excel Services and Snowflake.
-
Use Biml to Build SSIS Tasks to Replicate SAP ByDesign Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP ByDesign data to SQL Server.
-
How to Connect the Power BI Service to PDFMonkey: Complete Guide
Connect to the CData Software Power BI Connector for PDFMonkey from PowerBI.com to provide real-time PDFMonkey data across the organization.
-
Build a Simple VCL Application for Wave Financial Data
How to build a simple VCL Application to view Wave Financial data in RAD Studio using the CData ODBC Driver for Wave Financial.
-
Automated Continuous Mistral AI Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mistral AI replication to MongoDB.
-
Connect to Reckon Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Reckon and the Script function in FileMaker Pro to connect to Reckon and work with Reckon data in your FileMaker application.
-
Visualize Demio Data in Sisense
Create an ElastiCube in Sisense app with access to Demio data.
-
Access Live Sage 300 Data in TIBCO Data Virtualization
Use the Sage 300 Tibco DV Adapter to create a Sage 300 data data source in TIBCO Data Virtualization Studio and gain access to live Sage 300 data from your TDV Server.
-
Connect to Dynamics NAV Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Dynamics NAV data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Azure Synapse Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Databricks.
-
Object-Relational Mapping (ORM) with Twilio 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 Twilio data into a Java-based ORM framework, Hibernate.
-
Build Dashboards with AlloyDB Data in DBxtra
Create dynamic dashboards and perform analytics based on AlloyDB data in DBxtra.
-
Feed Intercom Data into FineReport
How to set Intercom data as a JDBC data source in FineReport.
-
Connect to Drip Data from PowerBuilder via ADO.NET
This article demonstrates how to access Drip data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Agno to Talk to Your Samanage 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 Samanage data for you.
-
Connect to DocuSign 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 DocuSign data.
-
Connect to Live MongoDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MongoDB in CData Connect AI and connect to your MongoDB data from PostgreSQL.
-
Connect to Mode Data from a Connection Pool in JBoss
Integrate Mode data into Java servlets: Use the Management Console in JBoss to install the Mode JDBC Driver.
-
How to connect SharePoint with SAP BusinessObjects BI Data through external lists
Provide SAP BusinessObjects BI data to SharePoint users as an external list.
-
Query Live Exa Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Exa data directly from the development environment.
-
Bind Live Okta Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Okta data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automate Jira Data Replication to Azure Synapse
Use CData Sync to customize and automate Jira data replication to Azure Synapse.
-
Connect to SharePoint Excel Services Data from a Connection Pool in JBoss
Integrate SharePoint Excel Services data into Java servlets: Use the Management Console in JBoss to install the SharePoint Excel Services JDBC Driver.
-
Connect to Facebook Data from Crystal Reports
Use CData Connect AI to connect to and report on live Facebook data from Crystal Reports.
-
Build Data Flows from SQL Server to SAP HANA through SSIS
Easily push SQL Server data to SAP HANA using the CData SSIS Tasks for SAP HANA.
-
Connect to SingleStore Data in Google Apps Script via Connect AI
Use CData Connect AI to access SingleStore data in Google Apps Script.
-
Migrating data from SAP Business Warehouse to Databricks using CData SSIS Components.
Easily push SAP Business Warehouse data to Databricks using the CData SSIS Tasks for SAP Business Warehouse and Databricks.
-
Configure the CData JDBC Driver for Odoo in a Connection Pool in Tomcat
Connect to Odoo data from a connection pool in Tomcat.
-
Integrate Goose with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Entra ID data from within the local AI agent.
-
Automate Active Directory Data Replication to Azure Synapse
Use CData Sync to customize and automate Active Directory data replication to Azure Synapse.
-
Automated Continuous MYOB AccountRight Replication to SingleStore
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SingleStore.
-
Edit and Search External Google Contacts Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Contacts data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Contacts Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData Connect AI Python SDK for Snowflake
Install the CData Connect AI Python SDK to read and write live Snowflake data with standard DB-API 2.0 Python code.
-
Build an OLAP Cube in SSAS from Sybase IQ Data
Establish a connection to Sybase IQ data data from SQL Server Analysis Services, and use the Sybase IQ Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate PagerDuty with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PagerDuty with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PagerDuty data.
-
Stream Gorgias Data into Apache Kafka Topics
Access and stream Gorgias data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Business Warehouse
Create an ODBC connection to SAP Business Warehouse in Informatica and browse and transfer SAP Business Warehouse data.
-
Natively Connect to Superchat Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Superchat data. Leverage the native support for ODBC in PHP.
-
How to integrate Retently with Apache Airflow
Access and process Retently data in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for OData Services (MySQL Remoting via JDBC)
Use the Remoting features of the OData JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from QuickBooks Data in Qlik Sense Cloud
Use CData Connect AI to connect to QuickBooks Data and build apps from live QuickBooks data in Qlik Sense Cloud.
-
Build Dashboards with Access Data in DBxtra
Create dynamic dashboards and perform analytics based on Access data in DBxtra.
-
Use Microsoft Copilot Studio to talk to your Google Analytics 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 Google Analytics data for you.
-
Explore Geographical Relationships in JobNimbus Data with Power Map
Create data visualizations with JobNimbus data in Power Map.
-
Replicate Multiple Parallel Accounts
Replicate multiple Parallel accounts to one or many databases.
-
Getting Started with the CData Power BI Connector for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP SuccessFactors LMS.
-
Migrating data from Workday to Snowflake using CData SSIS Components.
Easily push Workday data to Snowflake using the CData SSIS Tasks for Workday and Snowflake.
-
Automated Continuous Pipedrive Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pipedrive replication to Google BigQuery.
-
Automated Continuous Power BI XMLA Replication to Snowflake
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Snowflake.
-
How to Connect to Live Samanage Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Samanage data securely in real time.
-
Access Excel 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 Excel data.
-
Build Apps with Live Presto Data Using the Low-Code Development Platform of Mendix
Connect Presto data with Mendix to build apps using the CData JDBC Driver for Presto.
-
Analyze Amazon DynamoDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon DynamoDB data with the CData JDBC Driver for Amazon DynamoDB.
-
How to connect to SendGrid Data from Spring Boot
Connect to SendGrid in a Spring Boot Application using the CData JDBC Driver for SendGrid
-
Use the CData SSIS Components to Insert New or Update Existing Instagram Records from SQL Server
Easily push SQL Server data to Instagram using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Instagram or update existing records with data from a SQL Server database.
-
Choosing the Best Method to Connect Float to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Float data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Establish a Live Connection with PhantomBuster Data using Tableau Bridge
The CData ODBC Driver for PhantomBuster enables you to integrate live PhantomBuster data into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Multiple Freshdesk Accounts
Replicate multiple Freshdesk accounts to one or many databases.
-
Automated Continuous NASA Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable NASA replication to Amazon Redshift.
-
Build Semantic Layer Views for Vault CRM Data in APOS Live Data Gateway
Use the CData Connector for Vault CRM in APOS Live Data Gateway to build Semantic Layer Views for Vault CRM data.
-
Manage Telegram Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Telegram.
-
Back Up Raisers Edge NXT data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Raisers Edge NXT. In this article, we will employ an SSIS workflow to populate a database with Raisers Edge NXT data data.
-
Connect to Presto Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Presto Data and connect to Presto data in Akorbi Digital RunMyProcess.