CData Software - Knowledge Base
Recent Articles
-
Access Live Parallel Data in Coginiti Pro
Connect to and query live Parallel data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Salesforce CRM Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Google Cloud SQL.
-
How to create Square federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Square data in MySQL .
-
Getting Started with the CData ADO.NET Provider for Redis
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Redis.
-
Use ChatGPT to Talk to Your SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SparkPost data for you.
-
Create SurveyMonkey-Connected Nintex Workflows
Use CData Connect AI to connect to SurveyMonkey Data from Nintex Workflow Cloud and build custom workflows using live SurveyMonkey data.
-
Operational Reporting on Phoenix Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Phoenix data.
-
Create Adobe Commerce-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Adobe Commerce Data from Klipfolio and build custom visualizations using live Adobe Commerce data.
-
Automate Acumatica Data Replication to Couchbase
Use CData Sync to Customize and automate Acumatica data replication to Couchbase.
-
Validate SpaceX Data with QuerySurge
Access and validate SpaceX data in QuerySurge using the CData JDBC Driver.
-
Access Freshsales 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 Freshsales data.
-
Automated Continuous MarkLogic Replication to SQLite
Use CData Sync for automated, continuous, customizable MarkLogic replication to SQLite.
-
Integrating Codex with HCL Domino 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 Agents in Relevance AI with Access to Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Freshdesk data within intelligent agent workflows.
-
Connect to Redshift Data in Claris FileMaker Pro
Use the CData ODBC Driver for Redshift in FileMaker Pro to connect to Redshift and work with Redshift data in your FileMaker applications.
-
Build Voice Agents in ElevenLabs with access to Live Mode Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Mode data.
-
Automate OData Integration Tasks from PowerShell
Are you in search of a quick and easy way to access OData services from PowerShell? This article demonstrates how to utilize the OData Cmdlets for tasks like connecting to OData services, automating operations, downloading data, and more.
-
Build Data Flows from ServiceDesk Plus to SQL Server using SSIS
Easily back up ServiceDesk Plus data to SQL Server using the SSIS components for ServiceDesk Plus.
-
Use the CData Software JDBC Driver for Printful in MicroStrategy Desktop
Connect to Printful data in MicroStrategy Desktop using the CData Software JDBC Driver for Printful.
-
Access Live QuickBooks Time Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks Time data from your Google Sheets.
-
Build Dashboards with Codat Data in DBxtra
Create dynamic dashboards and perform analytics based on Codat data in DBxtra.
-
Connect to eBay Analytics Data in Claris FileMaker Pro
Use the CData ODBC Driver for eBay Analytics in FileMaker Pro to connect to eBay Analytics and work with eBay Analytics data in your FileMaker applications.
-
Work with Google Campaign Manager 360 Data in FoxPro
Load Google Campaign Manager 360 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Quaderno Data in AWS Lambda
Connect to live Quaderno data in AWS Lambda using the CData JDBC Driver.
-
Import Real-Time Square Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Square data in ColdFusion.
-
Easily Integrate Wrike Data in Lazarus Pascal IDE
Learn how to easily integrate live Wrike data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Replicate Salesforce Pardot Data to Multiple Databases
Replicate Salesforce Pardot data to disparate databases with a point-and-click configuration.
-
Integrate OpenCode with Live Airtable Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Airtable data from within your AI coding agent.
-
Easily Integrate Sybase IQ Data in Lazarus Pascal IDE
Learn how to easily integrate live Sybase IQ data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Active Directory-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Active Directory Data from Zoho Analytics and import live Active Directory data.
-
Search External AfterShip Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of AfterShip data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create AfterShip Data objects that you can access from apps and the dashboard.
-
Visualize Figshare Data in Sisense
Create an ElastiCube in Sisense app with access to Figshare data.
-
Automated Continuous Microsoft Entra ID Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to SingleStore.
-
Connect to WordPress Data in HULFT Integrate
Connect to WordPress as a JDBC data source in HULFT Integrate
-
Import Real-Time Chargebee Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Chargebee data in ColdFusion.
-
Operational Reporting on MailerLite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MailerLite data.
-
Use Claude to Talk to Your ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your ConstantContact data for you.
-
Work with Stripe Data in FoxPro
Load Stripe data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Oracle Financials Cloud Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Financials Cloud entities in PHP by modeling them as objects.
-
Google Cloud Storage Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Cloud Storage data through CData Connect AI using different applications and tools.
-
Create a Data Access Object for Scrapfly Data using JDBI
A brief overview of creating a SQL Object API for Scrapfly data in JDBI.
-
How to publish and share Rebilly Data dashboards with Tableau Server
The CData ODBC driver for Rebilly enables you integrate Rebilly data into Tableau dashboards.
-
Integrate CloudConvert Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CloudConvert data from Informatica Cloud.
-
Create SSAS Tabular Models from Shortcut Data
How to build a SQL Server Analysis Service Tabular Model from Shortcut data using CData drivers.
-
Access LeadDesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LeadDesk data from HeidiSQL.
-
Integrating Kiro with Sugar CRM 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.
-
Access Live Epicor Kinetic Data in Excel 365 Online (Excel for the web)
Connect to Epicor Kinetic data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData SSIS Components for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Data Catalog.
-
Prepare, Blend, and Analyze Greenhouse Data in Alteryx Designer (Connect AI)
Build workflows to access live Greenhouse data for self-service data analytics.
-
Creating Procore-Connected Applications in Unqork
You can use CData Connect AI to feed Procore data to Unqork and build custom business apps.
-
Connect to Live Dynamics NAV Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Dynamics NAV in CData Connect AI and connect to your Dynamics NAV data from PostgreSQL.
-
Connect to Simplesat Data in Ruby
Connect to Simplesat data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Reports with Amazon Athena Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon Athena data.
-
Getting Started with Xamarin
A guide on using the CData Xamarin Providers
-
Build Visualizations of Active Directory Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Active Directory data in Birst.
-
Connect to Snowflake Data in DBArtisan
Use wizards in DBArtisan to configure Snowflake data as a data source.
-
Using the CData Software ODBC Driver for Egnyte in PyCharm
Connect to Egnyte as an ODBC data source in PyCharm using the CData Software ODBC Driver for Egnyte.
-
Integrating LangGraph with ShipStation Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ShipStation data within automated workflows.
-
Use the CData ODBC Driver for Teradata from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Teradata to connect to Teradata data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Teradata data in Excel.
-
Accessing a Google Cloud Platform Virtual Machine with SCP/SFTP: WinSCP, FileZilla, and the CData SFTP Driver
Step-by-step guide to transferring files to a Google Cloud VM instance using SCP/SFTP with WinSCP, FileZilla, or the CData SFTP Driver.
-
Provide OData Services of PingOne Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PingOne data by developing a WCF Service Application.
-
Integrate Real-Time Access to Pipedrive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Pipedrive data in real time.
-
Access Datadog Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Datadog data from your Oracle system.
-
Create SSAS Tabular Models from PolarTeamPro Data
How to build a SQL Server Analysis Service Tabular Model from PolarTeamPro data using CData drivers.
-
Query Databricks Data in DataGrip
Create a Data Source for Databricks in DataGrip and use SQL to query live Databricks data.
-
Use the CData ODBC Driver for ChargeOver from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ChargeOver to connect to ChargeOver data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ChargeOver data in Excel.
-
Use JayDeBeApi to access ActiveCampaign Data in Python
Use standard Python scripting and the development environment of your choice to access live ActiveCampaign data.
-
Build Automated ServiceDesk Plus-Connected Workflows in Zapier
Use CData Connect AI to connect to live ServiceDesk Plus data and build automated workflows in Zapier.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Entra ID data for you.
-
Getting Started with the CData Python Connector for Twitter Ads
Learn to install and license the CData Python Connector and configure a connection to live Twitter Ads data.
-
Connect to Customer.io Data in DBeaver
Use the CData ODBC Driver to connect to Customer.io data in DBeaver.
-
Getting Started with the CData Power BI Connector for Slack
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Slack.
-
Integrate with Brex Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Brex data to a JSON file on disk.
-
Analyze GetResponse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of GetResponse data and visualize live GetResponse data in Infragistics Reveal.
-
Access Live Act CRM Data in Excel 365 Online (Excel for the web)
Connect to Act CRM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Import and Visualize Azure DevOps Data in Power View
Create data visualizations based on Azure DevOps data in Excel.
-
How to connect PolyBase to Wrike
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Wrike data.
-
How to publish and share Gmail Data dashboards with Tableau Server
The CData ODBC driver for Gmail enables you integrate Gmail data into Tableau dashboards.
-
Integrate LibreChat with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle HCM Cloud data from within the chat interface.
-
How to Query Zoho Inventory Data in MySQL Workbench
Execute MySQL queries against live Zoho Inventory data from MySQL Workbench.
-
Explore Geographical Relationships in Everhour Data with Power Map
Create data visualizations with Everhour data in Power Map.
-
Integrate Open WebUI with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Facebook data from within the chat interface.
-
Create SSAS Tabular Models from MongoDB Data
How to build a SQL Server Analysis Service Tabular Model from MongoDB data using CData drivers.
-
Integrating LlamaIndex with SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SageHR data in real time.
-
Automated Continuous Paymo Replication to SQLite
Use CData Sync for automated, continuous, customizable Paymo replication to SQLite.
-
How to Connect to & Open Templated Data in Microsoft Excel
This article uses the CData ODBC driver for Templated to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Ontraport Data from MySQL in PHP
Connect to Ontraport through the standard MySQL libraries in PHP.
-
Query, Visualize, and Share live Zoho Books Data in Redash
Use CData Connect AI to connect to live Zoho Books data in Redash for querying, visualizing, and sharing.
-
Query PayPal Data as a MySQL Database in Node.js
Execute MySQL queries against PayPal data from Node.js.
-
Integrating OpenCode with Salesforce CRM Analytics 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.
-
How to create Azure Table federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Table data in MySQL .
-
Import and Visualize Avalara AvaTax Data in Power View
Create data visualizations based on Avalara AvaTax data in Excel.
-
Connect Tavily to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Tavily with IBM WebSphere for seamless data integration and connectivity.
-
Integrating LlamaIndex with Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Analysis Services data in real time.
-
LINQ to Parallel 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 Parallel Data Provider.
-
Use Biml to Build SSIS Tasks to Replicate Mocean Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mocean data to SQL Server.
-
Connect to Microsoft Planner Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Planner data from Crystal Reports.
-
How to Connect Flowise AI Agents to Live Office 365 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 Office 365 data without replication.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Databricks
Provide connectivity to Databricks data through an SAP BusinessObjects universe.
-
HubDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HubDB facts in real time.