CData Software - Knowledge Base
Recent Articles
-
Natively Connect to LDAP Objects in PHP
The CData ODBC driver for LDAP enables you to create PHP applications with connectivity to LDAP objects. Leverage the native support for ODBC in PHP.
-
Access Live Google Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Ads data from your Excel spreadsheets.
-
Automated Continuous Opsgenie Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Opsgenie replication to Google BigQuery.
-
Integrate Samanage Data in the Pentaho Report Designer
Publish reports based on Samanage data in the Pentaho BI tool.
-
Getting Started with the CData JDBC Driver for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for EnterpriseDB.
-
Build Pipelines with Live Greenplum Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Greenplum from Google Cloud Data Fusion, enabling the integration of live Greenplum data into the building and management of effective data pipelines.
-
How to create Avaza federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Avaza data in MySQL .
-
Connect and Visualize Live Microsoft Dataverse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Dataverse data into the Databricks platform and create visualization dashboards with real-time Microsoft Dataverse data.
-
Automated Continuous Auth0 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Auth0 replication to Google Cloud SQL.
-
Access SharePoint Excel Services Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SharePoint Excel Services data from your Oracle system.
-
Automated Continuous Instagram Replication to SingleStore
Use CData Sync for automated, continuous, customizable Instagram replication to SingleStore.
-
Replicate Multiple Wave Financial Accounts via the CData Sync CLI
Replicate multiple Wave Financial accounts to one or many databases.
-
Build Apps with Live Azure DevOps data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure DevOps data into the Adalo platform and build custom mobile and web applications with real-time Azure DevOps data.
-
View Reports on Real-Time Phoenix Data in Power BI Report Server
Use the CData ODBC Driver for Phoenix to visualize Phoenix data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to publish and share Odoo Data dashboards with Tableau Server
The CData ODBC driver for Odoo enables you integrate Odoo data into Tableau dashboards.
-
Connect to TaxJar Data in Aqua Data Studio
Access TaxJar data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Procore-Connected Apps in Choreo
Use CData Connect AI to connect to Procore Data from Choreo and build custom apps using live Procore data.
-
Migrating data from Close to Snowflake using CData SSIS Components.
Easily push Close data to Snowflake using the CData SSIS Tasks for Close and Snowflake.
-
DataBind ChartMogul Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ChartMogul data to a chart.
-
Access Excel Files within Sub-Folders Using CData Excel Drivers
A step-by-step guide on retrieving data from Excel files within sub-folders of a root folder using CData Excel Drivers for seamless data access and integration.
-
Connect CouchDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CouchDB with IBM WebSphere for seamless data integration and connectivity.
-
Explore Geographical Relationships in Mixpanel Data with Power Map
Create data visualizations with Mixpanel data in Power Map.
-
Use Biml to Build SSIS Tasks to Replicate VWO Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate VWO data to SQL Server.
-
Connect to Mailjet Data in JRuby
Create a simple JRuby app with access to live Mailjet data.
-
Access Live VWO Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live VWO data from your Excel spreadsheets.
-
Access Hubstaff 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 Hubstaff data.
-
Connecting Pipedream with Oracle SCM 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 Oracle SCM data in real time.
-
Object-Relational Mapping (ORM) with Cohere 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 Cohere data into a Java-based ORM framework, Hibernate.
-
Connect to SQL Analysis Services Data in Jaspersoft Studio
Execute SQL to remote SQL Analysis Services data in Jaspersoft Studio.
-
Integrating Claude Code with Teradata Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Teradata data within assisted coding and automated development workflows.
-
Visualize Excel 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 Excel data into TIBCO Spotfire.
-
Write a Simple Go Application to work with BigCommerce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to BigCommerce data.
-
Extract, Transform, and Load Superchat Data in Informatica PowerCenter
Create a simple Workflow for Superchat data in Informatica PowerCenter.
-
Query SuiteCRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SuiteCRM data from Node.js.
-
Access Live Billsby Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Billsby data into the statistical analysis tools available in SAS JMP. This article shows how to use Billsby data in the Graph Builder and Query Builder.
-
Connecting Mastra with Adobe Analytics 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 Adobe Analytics data, no replication required.
-
Build AI/ML Models with Live CircleCI Data using Dataiku
Connect CircleCI Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Grafana 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 Grafana data.
-
Build Dashboards with Cvent Data in DBxtra
Create dynamic dashboards and perform analytics based on Cvent data in DBxtra.
-
Build Cvent-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Cvent data without replication.
-
SQL Gateway Overview
A detailed overview of the SQL Gateway, its function, and its features.
-
How to create Oracle Financials Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Financials Cloud data in MySQL .
-
Build a Simple VCL Application for Smartsheet Data
How to build a simple VCL Application to view Smartsheet data in RAD Studio using the CData ODBC Driver for Smartsheet.
-
Getting Started with the CData Connect AI Python SDK for IBM Informix
Install the CData Connect AI Python SDK to read and write live IBM Informix data with standard DB-API 2.0 Python code.
-
How to connect Amazon QuickSight to Teradata Data
Create a connection to Teradata data in CData Connect AI and insert Teradata data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous HubSpot Replication to Oracle
Use CData Sync for automated, continuous, customizable HubSpot replication to Oracle.
-
How to work with Salesforce Data 360 Data in Apache Spark using SQL
Access and process Salesforce Data 360 Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect SharePoint with SQL Server Data through external lists
Provide SQL Server data to SharePoint users as an external list.
-
How to connect to Oracle Service Cloud Data from IntelliJ
Integrate connectivity to Oracle Service Cloud data with wizards in IntelliJ.
-
Connect to ZohoDesk Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoDesk data from PowerBuilder using the ZohoDesk JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Vercel
Create Vercel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Query Live Azure DevOps Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure DevOps data data in natural language using Python.
-
Connect to and Query Smartsheet Data in QlikView over ODBC
Create data visualizations with Smartsheet data in QlikView.
-
View Reports on Real-Time Klipfolio Data in Power BI Report Server
Use the CData ODBC Driver for Klipfolio to visualize Klipfolio data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect Klaviyo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Klaviyo data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Azure DevOps Data (MySQL Remoting via JDBC)
Use the Remoting features of the Azure DevOps JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Jira Assets Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Jira Assets data.
-
Edit and Search External Google Drive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Drive data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Drive Data objects that you can access from apps and the dashboard.
-
Automated Continuous Scrapfly Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Scrapfly data replication to OneLake in Microsoft Fabric.
-
Operational Reporting on Epicor Kinetic Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Epicor Kinetic data.
-
Connect to Timely Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Timely as an External Source in Dremio.
-
Integrating LangGraph with Twitter Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Twitter Ads data within automated workflows.
-
Replicate Auth0 Data to Multiple Databases via the CData Sync CLI
Replicate Auth0 data to disparate databases with a single configuration.
-
Migrating data from Bullhorn CRM to Snowflake using CData SSIS Components.
Easily push Bullhorn CRM data to Snowflake using the CData SSIS Tasks for Bullhorn CRM and Snowflake.
-
How to connect to Outlook Data in DBVisualizer
Integrate Outlook data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Brex Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Brex data from HeidiSQL.
-
DataBind EmailOctopus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide EmailOctopus data to a chart.
-
Connect to ServiceDesk Plus 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 ServiceDesk Plus data.
-
Use Claude to Talk to Your Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Search results for you.
-
Create a Data Access Object for Gong Data using JDBI
A brief overview of creating a SQL Object API for Gong data in JDBI.
-
Create Data Visualizations in Cognos BI with AdRoll Data
Access AdRoll data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Moving Data from Microsoft Planner to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Planner data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI/ML Models with Live Aircall Data using Dataiku
Connect Aircall Data with Dataiku using the CData API Driver for JDBC.
-
How to Query Invoiced Data in MySQL Workbench
Execute MySQL queries against live Invoiced data from MySQL Workbench.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy
Connect to SAP SuccessFactors LMS data in MicroStrategy Developer using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
Publish Wrike-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Wrike data.
-
Integrate Opsgenie with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Opsgenie with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Opsgenie data.
-
How to Create Power BI Visual Reports with Real-Time Moosend Data
Use CData Power BI Connectors to visualize Moosend data in Power BI.
-
Automated Continuous Nuclia Replication to Databricks
Use CData Sync for automated, continuous, customizable Nuclia replication to Databricks.
-
How to connect to Workday Data from IntelliJ
Integrate connectivity to Workday data with wizards in IntelliJ.
-
Rapidly Develop Recurly-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Recurly.
-
Enable the IBM Cloud Object Storage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with IBM Cloud Object Storage data.
-
Automated Continuous Google Forms Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Forms replication to IBM DB2.
-
Build Google Ad Manager-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Ad Manager Data and create custom apps in Bubble.
-
Connect to Splunk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Splunk data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous LeadDesk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LeadDesk replication to Amazon Redshift.
-
Build Pipelines with Live Microsoft OneDrive Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft OneDrive from Google Cloud Data Fusion, enabling the integration of live Microsoft OneDrive data into the building and management of effective data pipelines.
-
How to Connect to Live PayPal Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live PayPal data securely in real time.
-
Access Live Acumatica Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Acumatica data from your Excel spreadsheets.
-
Provide OData Services of Tavily Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Tavily data by developing a WCF Service Application.
-
Process & Analyze SQL Analysis Services Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SQL Analysis Services Data.
-
Access DB2 Data from MySQL in PHP
Connect to DB2 through the standard MySQL libraries in PHP.
-
Migrating data from Databricks to Databricks using CData SSIS Components.
Easily push Databricks data to Databricks using the CData SSIS Tasks for Databricks and Databricks.
-
How to Access EmailOctopus Data Using Entity Framework
This article shows how to access EmailOctopus data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to integrate Campaigner with Apache Airflow
Access and process Campaigner data in Apache Airflow using the CData JDBC Driver.
-
Connecting Moonlit Workflow with DB2 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your DB2 data in real time.
-
Connect to Campaigner Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Campaigner data in Airbyte.
-
Access Live Active Directory Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Active Directory data into the statistical analysis tools available in SAS JMP. This article shows how to use Active Directory data in the Graph Builder and Query Builder.
-
Access Live HDFS Data in AWS Lambda
Connect to live HDFS data in AWS Lambda using the CData JDBC Driver.
-
Create Dashboards and Visualize Live OneNote Data in Geckoboard
Use CData Connect AI to connect to live OneNote data and create dashboards for real-time monitoring and visualization in Geckoboard.