CData Software - Knowledge Base
Recent Articles
-
Connect SageHR Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SageHR data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Vercel Data in Jaspersoft Studio
Execute SQL to remote Vercel data in Jaspersoft Studio.
-
Connect to Neo4J Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Neo4J data using standard SQL.
-
Create FreeAgent Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FreeAgent from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating LangGraph with Wistia Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Wistia data within automated workflows.
-
Create a Data Access Object for Rebilly Data using JDBI
A brief overview of creating a SQL Object API for Rebilly data in JDBI.
-
Integrate LibreChat with Live Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Wistia data from within the chat interface.
-
How to connect and process Marketo data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Marketo data.
-
How to integrate Oracle Service Cloud with Apache Airflow
Access and process Oracle Service Cloud data in Apache Airflow using the CData JDBC Driver.
-
Replicate Contentful Data in Heroku for Use in Salesforce Connect
Replicate Contentful data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Object-Relational Mapping (ORM) with HDFS 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 HDFS data into a Java-based ORM framework, Hibernate.
-
Integrating LangGraph with SAS xpt Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAS xpt data within automated workflows.
-
Write a Simple Go Application to work with Sugar CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sugar CRM data.
-
Build Charts with Cloudflare Data in Clear Analytics
Create dynamic charts and perform analytics based on Cloudflare data in Clear Analytics.
-
Connect to Salesforce Data 360 Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce Data 360 data from your AWS Glue jobs.
-
Create Datasets from Odoo in Domo Workbench and Build Visualizations of Odoo Data in Domo
Use the CData Software ODBC Driver for Odoo to create datasets from Odoo data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Ontraport Replication to Snowflake
Use CData Sync for automated, continuous, customizable Ontraport replication to Snowflake.
-
How to Connect Acumatica Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Acumatica data in real time using natural language.
-
Build Voice Agents in ElevenLabs with access to Live Apify Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apify data.
-
Automated Continuous Dotmailer Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dotmailer replication to Google BigQuery.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle Service Cloud
Create an ODBC connection to Oracle Service Cloud in Informatica and browse and transfer Oracle Service Cloud data.
-
Viewing MySQL Data in RAD Studio Data Explorer
How to view MySQL data in RAD Studio Data Explorer using the CData ODBC Driver for MySQL.
-
Build a Simple VCL Application for LeadDesk Data
How to build a simple VCL Application to view LeadDesk data in RAD Studio using the CData ODBC Driver for LeadDesk.
-
Integrate Live GraphQL Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to GraphQL from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live GraphQL data.
-
Integrate Live Hive Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Hive data and integrate live Hive data into apps built in Microsoft Power Apps.
-
Connect to ZohoExpense Data from a Connection Pool in Jetty
The ZohoExpense JDBC Driver supports connection pooling: This article shows how to connect faster to ZohoExpense data from Web apps in Jetty.
-
Analyze Salesforce Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce data and visualize Salesforce data in SAP Analytics Cloud.
-
How to Access Workday Data Using Entity Framework
This article shows how to access Workday data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Zoho Books-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 Zoho Books data without replication.
-
Use CData Connect AI to Access XML Data in Microsoft Power Pivot
Use CData Connect AI to connect to live XML data in the Power Pivot business intelligence tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Insightly
Provide connectivity to Insightly data through an SAP BusinessObjects universe.
-
How to Connect to Live HDFS 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 HDFS data for you.
-
Automated Continuous Sugar CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Google Cloud SQL.
-
Creating Facebook-Connected Applications in Unqork
You can use CData Connect AI to feed Facebook data to Unqork and build custom business apps.
-
Publish Reports with Azure Analysis Services Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Analysis Services data.
-
Automated Continuous Hugging Face Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Hugging Face replication to Apache Cassandra.
-
Build Azure Data Catalog Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Data Catalog data and build visualizations in Tableau Cloud.
-
Automated Continuous AlloyDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable AlloyDB replication to Snowflake.
-
Moving Data from Clio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Clio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Coda Data in Google Apps Script via Connect AI
Use CData Connect AI to access Coda data in Google Apps Script.
-
Build Dashboards with Browserless Data in DBxtra
Create dynamic dashboards and perform analytics based on Browserless data in DBxtra.
-
Excel Spreadsheet Automation on Pinterest Data with the QUERY Formula
Pull data from Pinterest, automate spreadsheets, and more with the QUERY formula.
-
Build Toggl Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Toggl data and build visualizations in Tableau Cloud.
-
Automated Continuous ZohoPeople Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Snowflake.
-
Build Data Flows from EmailOctopus to SQL Server using SSIS
Easily back up EmailOctopus data to SQL Server using the SSIS components for EmailOctopus.
-
Create Power BI Reports on Real-Time Tavily Data
Use the CData ODBC Driver for Tavily to visualize Tavily data in Power BI Desktop.
-
Choosing the Best Method to Connect NetSuite to SQL Server: 5 Options Explained
Discover multiple ways to connect and use NetSuite data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Airtable Data in Coginiti Pro
Connect to and query live Airtable data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Rebilly Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Rebilly data replication to OneLake in Microsoft Fabric.
-
Connect to Teradata Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Teradata Data and connect to Teradata data in Akorbi Digital RunMyProcess.
-
Create Informatica Mappings From/To an ODBC Data Source for Mailjet
Create an ODBC connection to Mailjet in Informatica and browse and transfer Mailjet data.
-
Use the CData Software ODBC Driver for Ontraport in MicroStrategy Web
Connect to Ontraport data in MicroStrategy Web using the CData Software ODBC Driver for Ontraport.
-
Publish Quaderno-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Quaderno data.
-
Automated Continuous Float Replication to MongoDB
Use CData Sync for automated, continuous, customizable Float replication to MongoDB.
-
Connect to Scrapfly Data in DBArtisan
Use wizards in DBArtisan to configure Scrapfly data as a data source.
-
Build Jumpseller Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Jumpseller data and build visualizations in Tableau Cloud.
-
Automated Continuous Mocean Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mocean replication to Google BigQuery.
-
Integrating Claude Code CLI with Zoho Inventory 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.
-
Connecting Mastra with Azure Analysis Services 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 Azure Analysis Services data, no replication required.
-
Configure the CData JDBC Driver for SharePoint in a Connection Pool in Tomcat
Connect to SharePoint data from a connection pool in Tomcat.
-
How to integrate Epicor Kinetic with Apache Airflow
Access and process Epicor Kinetic data in Apache Airflow using the CData JDBC Driver.
-
Access Live NetSuite SuiteAnalytics Data in Excel 365 Online (Excel for the web)
Connect to NetSuite SuiteAnalytics data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build PagerDuty-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PagerDuty data and build web apps with connectivity to live PagerDuty data.
-
Replicate SurveyMonkey Data from PowerShell
Write a quick PowerShell script to query SurveyMonkey data. Use connectivity to the live data to replicate SurveyMonkey data to SQL Server.
-
Connect to Slack Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Slack and the Script function in FileMaker Pro to connect to Slack and work with Slack data in your FileMaker application.
-
Automated Shortcut Data Replication to Teradata
Use CData Sync to Customize and automate Shortcut data replication to Teradata.
-
Use the CData Software JDBC Driver for Float in MicroStrategy Desktop
Connect to Float data in MicroStrategy Desktop using the CData Software JDBC Driver for Float.
-
Analyze Procore Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Procore data and visualize live Procore data in Infragistics Reveal.
-
How to connect and process GraphQL data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live GraphQL data.
-
Klipfolio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Klipfolio facts in real time.
-
Build AgileCRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live AgileCRM data and build visualizations in Tableau.
-
Operational Reporting on ChartMogul Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ChartMogul data.
-
Connect to Notion Data in Google Apps Script via Connect AI
Use CData Connect AI to access Notion data in Google Apps Script.
-
Automated Continuous TaxJar Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable TaxJar replication to Apache Cassandra.
-
How to Seamlessly Import Datadog Data into IBM SPSS Modeler
Integrate Datadog data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with Oracle Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle data in SnapLogic.
-
How to Connect DBeaver to PDFMonkey via a JDBC Driver
Manage PDFMonkey data with visual tools in DBeaver like the query browser.
-
Bridge Azure Data Catalog Connectivity with Apache NiFi
Access and process Azure Data Catalog data in Apache NiFi using the CData JDBC Driver.
-
Integrate Zoho Projects Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Projects Data enables you to integrate Zoho Projects data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Google Ad Manager Data in DBeaver
Use the CData ODBC Driver to connect to Google Ad Manager data in DBeaver.
-
Visualize Live Odoo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Odoo data into custom reports in Power BI.
-
How to Easily Query Clockify Data in OpenOffice Base
Connect to Clockify data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Trae with Live Microsoft Teams Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Microsoft Teams data from within the AI-powered IDE.
-
Replicate Zoho Projects Data in Heroku for Use in Salesforce Connect
Replicate Zoho Projects data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Klipfolio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Klipfolio data to a chart.
-
Integrating Claude Code with Facebook Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Facebook data within assisted coding and automated development workflows.
-
Create Reports with Slack Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Slack data.
-
Visualize Billsby 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 Billsby data into TIBCO Spotfire.
-
How to load Zoho CRM data into Elasticsearch via Logstash
Introducing a simple method to load Zoho CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Azure Synapse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse data and execute queries in PowerBuilder.
-
Create Zoho Books-Connected Applications in Appsmith
Connect to Zoho Books Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoho Books data.
-
Query Sentry Data in DataGrip
Create a Data Source for Sentry in DataGrip and use SQL to query live Sentry data.
-
How to Connect Dynamics NAV Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Dynamics NAV data in real time using natural language.
-
Analyze Live Bullhorn CRM Data in SAS Viya
Use CData Connect AI to connect to Bullhorn CRM data from SAS Viya and deploy self-service analytics using live Bullhorn CRM data.
-
Connect to SAP SuccessFactors Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP SuccessFactors data from Filemaker Pro on Mac.
-
Replicate Multiple EnterpriseDB Accounts
Replicate multiple EnterpriseDB accounts to one or many databases.
-
DataBind iContact Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide iContact data to a chart.
-
Integrate Trae with Live Google Drive Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Drive data from within the AI-powered IDE.
-
Load Databricks Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Databricks data to a database.
-
How to Connect to Live Lakebase 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 Lakebase data for you.