CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Telegram Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Telegram data. Leverage the native support for ODBC in PHP.
-
How to connect to EmailOctopus Data from Spring Boot
Connect to EmailOctopus in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Facebook Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Facebook Ads data in Microsoft R Open.
-
Connect ZohoExpense to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoExpense with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SQL Server Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SQL Server.
-
Connect to Microsoft Ads Data in RazorSQL
Connect to Microsoft Ads from wizards and query Microsoft Ads data from the GUI in the RazorSQL database management tool.
-
How to Query Splunk Data in MySQL Workbench
Execute MySQL queries against live Splunk data from MySQL Workbench.
-
Query Pingdom Data in DataGrip
Create a Data Source for Pingdom in DataGrip and use SQL to query live Pingdom data.
-
Access Azure Data Lake Storage Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Data Lake Storage data from your Oracle system.
-
Rapidly Develop Gumroad-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 Gumroad.
-
Consume ActiveCampaign OData Feeds in PowerBuilder
This article demonstrates how to consume ActiveCampaign data as OData feeds from PowerBuilder using the API Server.
-
Model Salesforce CRM Analytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce CRM Analytics, enabling the direct import of real-time Salesforce CRM Analytics data.
-
Automated Continuous Notion Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Notion replication to Google Cloud SQL.
-
How to create Visio diagrams from Paylocity Data
Automatically update Paylocity data with the changes you make to Visio master shapes.
-
Create SSAS Tabular Models from Azure DevOps Data
How to build a SQL Server Analysis Service Tabular Model from Azure DevOps data using CData drivers.
-
Create Power BI Reports on Real-Time WooCommerce Data
Use the CData ODBC Driver for WooCommerce to visualize WooCommerce data in Power BI Desktop.
-
Query Chargebee Data as a MySQL Database in Node.js
Execute MySQL queries against Chargebee data from Node.js.
-
Automate MYOB AccountRight Data Replication to Couchbase
Use CData Sync to Customize and automate MYOB AccountRight data replication to Couchbase.
-
Establish a Live Connection with Microsoft Entra ID Data using Tableau Bridge
The CData ODBC Driver for Microsoft Entra ID enables you to integrate live Microsoft Entra ID data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create a Data Access Object for Google Ad Manager Data using JDBI
A brief overview of creating a SQL Object API for Google Ad Manager data in JDBI.
-
Connect to Attio Data from a Connection Pool in Jetty
The Attio JDBC Driver supports connection pooling: This article shows how to connect faster to Attio data from Web apps in Jetty.
-
Create Informatica Mappings From/To an ODBC Data Source for Optimizely
Create an ODBC connection to Optimizely in Informatica and browse and transfer Optimizely data.
-
Build AI Agents with Apify Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apify data through CData Connect AI.
-
Integrating Todoist Data in Talend Cloud Data Management Platform
Connect Todoist Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Apollo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apollo data in the Denodo Virtual DataPort Administrator.
-
Connect to Factorial Data from a Connection Pool in JBoss
Integrate Factorial data into Java servlets: Use the Management Console in JBoss to install the Factorial JDBC Driver.
-
Analyze FreshBooks Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze FreshBooks data with the CData JDBC Driver for FreshBooks.
-
Access Live Presto Data in TIBCO Data Virtualization
Use the Presto Tibco DV Adapter to create a Presto data data source in TIBCO Data Virtualization Studio and gain access to live Presto data from your TDV Server.
-
Build Agents in Relevance AI with Access to Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on PostgreSQL data within intelligent agent workflows.
-
Visualize Live Samanage Data in the Power BI Service
Use CData Connect AI to connect to live Samanage data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live iContact Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live iContact data without replication.
-
How to connect to SharePoint Data in DBVisualizer
Integrate SharePoint data with visual data analysis tools and data connection wizards in DBVisualizer
-
Choosing the Best Method to Connect Timely to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Timely data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Excel Add-In for GitHub
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GitHub.
-
Automated Continuous Adobe Commerce Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Adobe Commerce data replication to OneLake in Microsoft Fabric.
-
Search External Bannerbear Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Bannerbear data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Bannerbear Data objects that you can access from apps and the dashboard.
-
Connect to NetSuite Data from AWS Glue
Use CData Connect AI to gain access to live NetSuite data from your AWS Glue jobs.
-
DataBind Charts to Azure Synapse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Synapse data 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.
-
Create Salesforce CRM Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce CRM Analytics data access from reports, embedded analytics, and more.
-
Link Exa with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Exa data in Filemaker Pro for Mac or Windows.
-
Access Live Shippo Data in AWS Lambda
Connect to live Shippo data in AWS Lambda using the CData JDBC Driver.
-
Integrate Theia IDE with Live Adobe Analytics 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 Adobe Analytics data from within the development environment.
-
How to Connect to Live Facebook Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Facebook data for you.
-
How to create an RPA flow for Landbot Data in UiPath Studio
Use the Landbot ODBC Driver to create workflows that access real-time Landbot data without any coding.
-
Use Agno to Talk to Your Databricks 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 Databricks data for you.
-
Create Highrise Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Highrise data access from reports, embedded analytics, and more.
-
Object-Relational Mapping (ORM) with Datadog 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 Datadog data into a Java-based ORM framework, Hibernate.
-
Query, Visualize, and Share live Instagram Data in Redash
Use CData Connect AI to connect to live Instagram data in Redash for querying, visualizing, and sharing.
-
Automated Continuous Access Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Access replication to Amazon Redshift.
-
How to create QuickBooks Time federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for QuickBooks Time data in MySQL .
-
Import Real-Time Pipeliner CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pipeliner CRM data in ColdFusion.
-
Integrating OpenCode with OnePageCrm 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.
-
Build Automated Google Forms-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Forms data and build automated workflows in Zapier.
-
Use Biml to Build SSIS Tasks to Replicate Deel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Deel data to SQL Server.
-
Natively Connect to Onfleet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Onfleet data. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Exact Online Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Exact Online data for you.
-
Create a Data Access Object for Shortcut Data using JDBI
A brief overview of creating a SQL Object API for Shortcut data in JDBI.
-
Getting Started with the CData Power BI Connector for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect NASA Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your NASA data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Claude Code with IBM Informix Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on IBM Informix data within assisted coding and automated development workflows.
-
How to Connect to & Open LaunchDarkly Data in Microsoft Excel
This article uses the CData ODBC driver for LaunchDarkly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Azure Data Lake Storage Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Data Lake Storage data and visualize live Azure Data Lake Storage data in Infragistics Reveal.
-
Use the CData Software ODBC Driver for Browserless in MicroStrategy Web
Connect to Browserless data in MicroStrategy Web using the CData Software ODBC Driver for Browserless.
-
Query Live CSV Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live CSV data through a conversational interface.
-
Connect to Live Email Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Email in CData Connect AI and connect to your Email data from PostgreSQL.
-
Analyze MarkLogic Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MarkLogic data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use Biml to Build SSIS Tasks to Replicate SAP HANA Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP HANA data to SQL Server.
-
Build Voice Agents in ElevenLabs with access to Live SQL Server Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SQL Server data.
-
Operational Reporting on Pipedrive Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipedrive data.
-
Automated Continuous MarkLogic Replication to Snowflake
Use CData Sync for automated, continuous, customizable MarkLogic replication to Snowflake.
-
Getting Started with the CData Tableau Connector for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Viewing SAP Business Warehouse Data in RAD Studio Data Explorer
How to view SAP Business Warehouse data in RAD Studio Data Explorer using the CData ODBC Driver for SAP Business Warehouse.
-
Connect to Campaigner Data in Aqua Data Studio
Access Campaigner data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Prepare, Blend, and Analyze Apify Data in Alteryx Designer (ODBC)
Build workflows to access live Apify data for self-service data analytics.
-
Create Power BI Reports on Real-Time FreshBooks Data
Use the CData ODBC Driver for FreshBooks to visualize FreshBooks data in Power BI Desktop.
-
Integrate OpenCode with Live Bitbucket Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Bitbucket data from within your AI coding agent.
-
Create Apps from Amazon DynamoDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to Amazon DynamoDB Data and build apps from live Amazon DynamoDB data in Qlik Sense Cloud.
-
Visualize Live Tickspot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Tickspot data.
-
Consume SAP Ariba Source OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Ariba Source feeds that reflect any changes in SAP Lumira.
-
Integrate Freshdesk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshdesk with External Services.
-
Build Charts with Eventbrite Data in Clear Analytics
Create dynamic charts and perform analytics based on Eventbrite data in Clear Analytics.
-
Automated Continuous Harvest Replication to Databricks
Use CData Sync for automated, continuous, customizable Harvest replication to Databricks.
-
Analyze Mixpanel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mixpanel from Power Pivot. You will use the Table Import Wizard to load Mixpanel data. You can visually build the import query or use any SQL supported by the driver.
-
Access Dynamics CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Dynamics CRM data from HeidiSQL.
-
Configure the CData JDBC Driver for Tally in a Connection Pool in Tomcat
Connect to Tally data from a connection pool in Tomcat.
-
Analyze Zoho Recruit Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Recruit from Power Pivot. You will use the Table Import Wizard to load Zoho Recruit data. You can visually build the import query or use any SQL supported by the driver.
-
Working with Discord Data in LINQPad
Execute LINQ queries to Discord data in LINQPad.
-
Build Microsoft Entra ID-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Entra ID data and build web apps with connectivity to live Microsoft Entra ID data.
-
Integrating Kiro with Coda 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.
-
Analyze Live Klipfolio Data in SAS Viya
Use CData Connect AI to connect to Klipfolio data from SAS Viya and deploy self-service analytics using live Klipfolio data.
-
Visualize Optimizely Data in Tableau
The CData ODBC driver for Optimizely enables you integrate Optimizely data into Tableau dashboards.
-
Deploy the ADO.NET Provider for Spark on an SSRS Report Server
Connect to Spark data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use Biml to Build SSIS Tasks to Replicate ZeroBounce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZeroBounce data to SQL Server.
-
Integrating Dataiku with Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage 200 data.
-
Automated Continuous ZohoInvoice Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to AlloyDB.
-
How to Query Live Tickspot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tickspot data data in natural language using Python.
-
How to connect Amazon QuickSight to OneNote Data
Create a connection to OneNote data in CData Connect AI and insert OneNote data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Azure Synapse Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Synapse in FileMaker Pro to connect to Azure Synapse and work with Azure Synapse data in your FileMaker applications.
-
How to Connect to Live Klaviyo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Klaviyo data securely in real time.
-
Automate Jumpseller Data Replication to SAP HANA
Use CData Sync to customize and automate Jumpseller data replication to SAP HANA.