CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to GetResponse Data in Delphi
DataBind to GetResponse in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Power BI XMLA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Power BI XMLA in Excel.
-
Connect and Query Live SQL Server Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft SQL Server into Databricks
-
Analyze SAS Data Sets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAS Data Sets and visualize live SAS Data Sets in Infragistics Reveal.
-
Create SSAS Tabular Models from FreeAgent Data
How to build a SQL Server Analysis Service Tabular Model from FreeAgent using CData drivers.
-
How to Easily Query FormSite Data in OpenOffice Base
Connect to FormSite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Edit and Search External Exact Online Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Exact Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Exact Online Data objects that you can access from apps and the dashboard.
-
Automated Continuous Salesforce Marketing Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Oracle.
-
Getting Started with the CData JDBC Driver for Asana
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Asana.
-
Automated Continuous Google Directory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Directory replication to Google BigQuery.
-
Build Vault CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Vault CRM to explore live Vault CRM Data in GitHub Copilot to assist with building Vault CRM-powered applications.
-
Connect to Freshservice in SpagoBI
Create reports featuring live Freshservice in SpagoBI Studio. Host Freshservice reports on SpagoBI Server.
-
Connect to Okta Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Okta Data and connect to Okta in Akorbi Digital RunMyProcess.
-
Visualize ClickTime 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 ClickTime into TIBCO Spotfire.
-
Connect to Omnisend Data in HULFT Integrate
Connect to Omnisend as a JDBC data source in HULFT Integrate
-
How to Query Live Neo4J Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Neo4J data in natural language using Python.
-
Connect to FTP Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for FTP and the Script function in FileMaker Pro to connect to FTP and work with FTP Servers in your FileMaker application.
-
Integrating Codex CLI with Typeform 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.
-
How to connect to MarkLogic Data in DBVisualizer
Integrate MarkLogic with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Oracle Eloqua Data to Multiple Databases
Replicate Oracle Eloqua to disparate databases with a point-and-click configuration.
-
Extract, Transform, and Load Marketo Data in Informatica PowerCenter
Create a simple Workflow for Marketo in Informatica PowerCenter.
-
Connect to WordPress Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for WordPress and the Script function in FileMaker Pro to connect to WordPress and work with WordPress in your FileMaker application.
-
Connect to Simplesat Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Simplesat to connect to Simplesat and execute queries in PowerBuilder.
-
Analyze Teamgate Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Teamgate with the CData JDBC Driver for Teamgate.
-
Create Data Visualizations in Cognos BI with Azure Analysis Services Data
Access Azure Analysis Services as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Monday.com in SpagoBI
Create reports featuring live Monday.com in SpagoBI Studio. Host Monday.com reports on SpagoBI Server.
-
Object-Relational Mapping (ORM) with Microsoft Teams 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 Microsoft Teams into a Java-based ORM framework, Hibernate.
-
How to Connect Flowise AI Agents to Live Square Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Square without replication.
-
Build Automated Workflows with Live Google Spanner Data in Workato
Use CData Connect AI to connect to live Google Spanner and build automated workflows in Workato.
-
Using the CData Software ODBC Driver for SageHR in PyCharm
Connect to SageHR as an ODBC data source in PyCharm using the CData Software ODBC Driver for SageHR.
-
Load Dotmailer Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dotmailer to a database.
-
Getting Started with the CData ODBC Driver for Retently
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Retently.
-
Automated Continuous Gorgias Replication to MySQL
Use CData Sync for automated, continuous, customizable Gorgias replication to MySQL.
-
Visualize Salesforce CRM Analytics 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 Salesforce CRM Analytics into TIBCO Spotfire.
-
Integrate Theia IDE with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Salesforce CRM Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce CRM Analytics Data and create custom apps in Mendix.
-
Integrate Live SurveyMonkey Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SurveyMonkey from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SurveyMonkey.
-
How to Query Teamgate Data in MySQL Workbench
Execute MySQL queries against live Teamgate from MySQL Workbench.
-
Connect to Codat Data in DBArtisan
Use wizards in DBArtisan to configure Codat as a data source.
-
Bidirectional Access to Freshdesk Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshdesk in Filemaker Pro for Mac or Windows.
-
Analyze NASA Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for NASA from Power Pivot. You will use the Table Import Wizard to load NASA. You can visually build the import query or use any SQL supported by the driver.
-
Design BIRT Reports on Jira Data
Provide current Atlassian Jira to your embedded analytics.
-
Integrating Claude Code with Snapchat Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Snapchat Ads within assisted coding and automated development workflows.
-
Use Biml to Build SSIS Tasks to Replicate QuickBooks Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate QuickBooks Desktop to SQL Server.
-
Moving Data from Workday to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Workday data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Adobe Commerce Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Adobe Commerce without replication.
-
Build Freshdesk-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Freshdesk to explore live Freshdesk Data in Claude Code to assist with building Freshdesk-powered applications.
-
Integrate Theia IDE with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Using the CData Software ODBC Driver for Everhour in PyCharm
Connect to Everhour as an ODBC data source in PyCharm using the CData Software ODBC Driver for Everhour.
-
Stream Harvest Data into Apache Kafka Topics
Access and stream Harvest in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Twilio Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Twilio from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Google Cloud Storage Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Cloud Storage securely in real time.
-
Connect to RSS Feeds from a Connection Pool in Jetty
The RSS JDBC Driver supports connection pooling: This article shows how to connect faster to RSS Feeds from Web apps in Jetty.
-
Load Freshteam Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshteam to a database.
-
Integrating Antigravity CLI with iContact via CData CLI
Connect iContact to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Dynamics 365 Business Central to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dynamics 365 Business Central with IBM WebSphere for seamless data integration and connectivity.
-
How to update REST from Excel
This article explains how to transfer data from Excel to REST using the Excel Add-In for REST.
-
How to Access Office 365 Data Using Entity Framework
This article shows how to access Microsoft Office 365 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Onfleet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Onfleet to a JSON file on disk.
-
Moving Data from ChargeOver to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ChargeOver data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Certinia Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Certinia entities in PHP by modeling them as objects.
-
Connect to Splunk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Splunk and the Script function in FileMaker Pro to connect to Splunk and work with Splunk in your FileMaker application.
-
A PostgreSQL Interface for PivotalTracker Data using the CData ODBC Driver
Use the SQL Gateway and PivotalTracker ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Sage 300 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage 300 replication to MongoDB.
-
Use Biml to Build SSIS Tasks to Replicate SingleStore Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SingleStore to SQL Server.
-
Rapidly Develop Stack Exchange-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 Stack Exchange.
-
Connect to FreeAgent Data in Aqua Data Studio
Access FreeAgent from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect to Phoenix Data from IntelliJ
Integrate connectivity to Apache Phoenix with wizards in IntelliJ.
-
Visualize Microsoft Planner 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 Microsoft Planner into TIBCO Spotfire.
-
Manage Invoiced Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Invoiced.
-
Access Live Bugsnag Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bugsnag into the statistical analysis tools available in SAS JMP. This article shows how to use Bugsnag in the Graph Builder and Query Builder.
-
How to create an RPA flow for Excel Data in UiPath Studio
Use the Excel ODBC Driver to create workflows that access real-time Microsoft Excel without any coding.
-
Access Live Hugging Face Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Hugging Face in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Live CockroachDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to CockroachDB in CData Connect AI and connect to your CockroachDB from PostgreSQL.
-
Access Live SAP Fieldglass Data in Coginiti Pro
Connect to and query live SAP Fieldglass from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish Azure Table-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Table Storage.
-
Import Real-Time Azure DevOps Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Azure DevOps in ColdFusion.
-
Use the CData ODBC Driver for Outreach.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Outreach.io to connect to Outreach.io from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Outreach.io in Excel.
-
Use the CData Software ODBC Driver for Humanity in MicroStrategy Desktop
Connect to Humanity in MicroStrategy Desktop using the CData Software ODBC Driver for Humanity.
-
Bidirectional Access to Webex Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Webex in Filemaker Pro for Mac or Windows.
-
ETL Zoho Books in Oracle Data Integrator
This article shows how to transfer Zoho Books into a data warehouse using Oracle Data Integrator.
-
How to Connect Flowise AI Agents to Live ActiveCampaign Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live ActiveCampaign without replication.
-
Connect to Live SAP Concur Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Concur Data in CData Connect AI and connect to your SAP Concur from MicroStrategy.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Yelp
Provide connectivity to Yelp through an SAP BusinessObjects universe.
-
Create Datasets from Dynamics 365 Business Central in Domo Workbench and Build Visualizations of Dynamics 365 Business Central Data in Domo
Use the CData Software ODBC Driver for Dynamics 365 Business Central to create datasets from Dynamics 365 Business Central in Domo Workbench and then build visualizations in the Domo service.
-
Working with Missive Data in LINQPad
Execute LINQ queries to Missive in LINQPad.
-
Use the CData ODBC Driver for Adobe Analytics in Microsoft Power Query
You can use the CData Adobe Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Analytics into Microsoft Power Query.
-
Access Mode 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 Mode.
-
Use JayDeBeApi to access Mode Data in Python
Use standard Python scripting and the development environment of your choice to access live Mode.
-
Visualize Tanda Data in Tableau
The CData ODBC driver for Tanda enables you integrate Tanda into Tableau dashboards.
-
Access Live Timely Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Timely into the statistical analysis tools available in SAS JMP. This article shows how to use Timely in the Graph Builder and Query Builder.
-
Access Live Salesforce Pardot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Pardot into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Pardot in the Graph Builder and Query Builder.
-
How to Work with Google Spanner Data in AWS Glue Jobs Using JDBC
Connect to Google Spanner from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Import Data from Sage 300 into Google Sheets
Import Sage 300 into a Google spreadsheet that is automatically refreshed.
-
Create Power BI Reports on Real-Time Close Data
Use the CData ODBC Driver for Close to visualize Close in Power BI Desktop.
-
How to Use a Microsoft Access Database to Update XML Data in Real Time
Update XML data by creating a linked table in Microsoft Access with the CData XML ODBC Driver.
-
View Reports on Real-Time Demio Data in Power BI Report Server
Use the CData ODBC Driver for Demio to visualize Demio in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect SharePoint with ShipStation Data through external lists
Provide ShipStation to SharePoint users as an external list.
-
Access Live Bannerbear Data in Coginiti Pro
Connect to and query live Bannerbear from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Cloudant-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cloudant Data and create custom apps in Mendix.