CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live ADP Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your ADP for you.
-
Automated Continuous Greenplum Replication to Vertica
Use CData Sync for automated, continuous, customizable Greenplum replication to Vertica.
-
Import Monday.com Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Monday.com. In this article, you will use the OData format to import Monday.com into Microsoft Power Query.
-
Visualize Live Paddle Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Paddle.
-
Working with Teradata Data in LINQPad
Execute LINQ queries to Teradata in LINQPad.
-
Build Paylocity-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Paylocity Data from Zoho Analytics and import live Paylocity.
-
Create Data Visualizations in Cognos BI with Apollo Data
Access Apollo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Write a Simple Go Application to work with Drift Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Drift.
-
Build an OLAP Cube in SSAS from Oracle HCM Cloud Data
Establish a connection to Oracle HCM Cloud data from SQL Server Analysis Services, and use the Oracle HCM Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Sage Intacct in SpagoBI
Create reports featuring live Sage Intacct in SpagoBI Studio. Host Sage Intacct reports on SpagoBI Server.
-
Integrating Kiro CLI with CouchDB 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 connect and process Elorus from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Elorus.
-
How to connect PolyBase to Splunk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Splunk.
-
Build Teradata-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Teradata and build web apps with connectivity to live Teradata.
-
Analyze Redis Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Redis in Microsoft R Open.
-
A PostgreSQL Interface for REST Data (MySQL Remoting via JDBC)
Use the Remoting features of the REST JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access Slack Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Slack.
-
Integrating Claude Code CLI with Planio 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 SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SingleStore within intelligent agent workflows.
-
Operational Reporting on Insightly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Insightly.
-
Using the CData Software ODBC Driver for SAP in PyCharm
Connect to SAP as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP.
-
Publish Front-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Front.
-
Consume BigQuery OData Feeds in SAP Lumira
Use the API Server to create data visualizations on BigQuery feeds that reflect any changes in SAP Lumira.
-
Integrating Antigravity CLI with MariaDB via CData CLI
Connect MariaDB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with live Klaviyo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Klaviyo in Jitterbit.
-
Add Google Cloud Storage Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Cloud Storage with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live Google Directory Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Directory through natural language.
-
Connect to Quickbase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Quickbase from Appeon PowerBuilder using the CData ADO.NET Provider for Quickbase.
-
Analyze Live Sage Intacct Data in SAS Viya
Use CData Connect AI to connect to Sage Intacct from SAS Viya and deploy self-service analytics using live Sage Intacct.
-
Prepare, Blend, and Analyze Retently Data in Alteryx Designer (ODBC)
Build workflows to access live Retently for self-service data analytics.
-
Create Data Visualizations Based On Tally Data in Mode
Use CData Connect AI to connect to Tally Data from Mode and build visualizations using live
-
Configure the CData JDBC Driver for Freshsales in a Connection Pool in Tomcat
Connect to Freshsales from a connection pool in Tomcat.
-
Connect to Cassandra Data in Jaspersoft Studio
Execute SQL to remote Apache Cassandra in Jaspersoft Studio.
-
Build Pipelines with Live Epicor Kinetic Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Epicor Kinetic from Google Cloud Data Fusion, enabling the integration of live Epicor Kinetic into the building and management of effective data pipelines.
-
Getting Started with the CData ADO.NET Provider for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Blackbaud FE NXT.
-
Explore Geographical Relationships in MarkLogic Data with Power Map
Create data visualizations with MarkLogic in Power Map.
-
How to import Insightly Data into Apache Solr
Use the CData Software JDBC Driver for Insightly in Data Import Handler and create an automated import of Insightly to Apache Solr Enterprise Search platform.
-
Analyze HCL Domino Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HCL Domino from Power Pivot. You will use the Table Import Wizard to load HCL Domino. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Azure Analysis Services Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Analysis Services.
-
Automated Continuous Stripe Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Stripe replication to Apache Kafka.
-
Write a Simple Go Application to work with Aweber Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Aweber.
-
How to Import Data from Cassandra into Google Sheets
Import Apache Cassandra into a Google spreadsheet that is automatically refreshed.
-
Automate Avro Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache Avro replication to Azure Data Lake.
-
Publish SAP Hybris C4C-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Hybris C4C.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ActiveCampaign
Provide connectivity to ActiveCampaign through an SAP BusinessObjects universe.
-
Connect to PostgreSQL Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with PostgreSQL Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Validate PDFMonkey Data with QuerySurge
Access and validate PDFMonkey in QuerySurge using the CData JDBC Driver.
-
Integrating Cursor CLI with Basecamp 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.
-
Use the CData Software ODBC Driver for MailerSend in MicroStrategy Desktop
Connect to MailerSend in MicroStrategy Desktop using the CData Software ODBC Driver for MailerSend.
-
Use CData Connect AI to Access PostgreSQL Data in Microsoft Power Pivot
Use CData Connect AI to connect to live PostgreSQL in the Power Pivot business intelligence tool.
-
Integrating GitHub Copilot CLI with Apache Hive 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.
-
Extract, Transform, and Load Hubstaff Data in Informatica PowerCenter
Create a simple Workflow for Hubstaff in Informatica PowerCenter.
-
Integrating Kiro CLI with Qualaroo 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.
-
Integrating GitHub Copilot CLI with Google Search 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 Live WordPress Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live WordPress securely in real time.
-
DataBind Controls to Auth0 Data in C++Builder
DataBind to Auth0 in C++Builder with standard components and controls.
-
Connect to Timely Data in DBArtisan
Use wizards in DBArtisan to configure Timely as a data source.
-
Integrate Wrike Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Wrike from Informatica Cloud.
-
Connect to Humanity Data in CloverDX (formerly CloverETL)
Transfer Humanity using the visual workflow in the CloverDX data integration tool.
-
Analyze Basecamp Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Basecamp and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Live Excel Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Excel Online and integrate live Microsoft Excel Online into apps built in Microsoft Power Apps.
-
Build Apps with Live NASA Data Using the Low-Code Development Platform of Mendix
Connect NASA with Mendix to build apps using the CData API Driver for JDBC.
-
Access Outreach.io Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Outreach.io from your Oracle system.
-
Connect to Perigon Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Publish SendPulse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SendPulse.
-
How to Access Mouseflow Data Using Entity Framework
This article shows how to access Mouseflow using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build an OLAP Cube in SSAS from Templated Data
Establish a connection to Templated data from SQL Server Analysis Services, and use the Templated Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate LibreChat with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon S3 from within the chat interface.
-
Access Live MySQL Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MySQL from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Pipeline CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Pipeline CRM and work with Pipeline CRM in your FileMaker application.
-
Create SSAS Tabular Models from HCL Domino Data
How to build a SQL Server Analysis Service Tabular Model from HCL Domino using CData drivers.
-
How to Work with SharePoint Excel Services Data in AWS Glue Jobs Using JDBC
Connect to SharePoint Excel Services from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Zoho Creator Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zoho Creator with the DevExpress Windows Forms and Web controls to provide Zoho Creator to a chart.
-
Build a PostgreSQL Interface for Email Data using the CData JDBC Driver
Use the Remoting features of the Email JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from Instantly to SQL Server using SSIS
Easily back up Instantly to SQL Server using the SSIS components for Instantly.
-
Create a Data Access Object for NASA Data using JDBI
A brief overview of creating a SQL Object API for NASA in JDBI.
-
Connect to Clio Data in RapidMiner
Integrate Clio with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Theia IDE with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Natively Connect to MessageBird Data in PHP
The CData ODBC driver for MessageBird enables you to create PHP applications with connectivity to MessageBird. Leverage the native support for ODBC in PHP.
-
Use Grok to Talk to Your Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache Impala for you.
-
Connect to Timely Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Timely in the Denodo Virtual DataPort Administrator.
-
Access Live Smartsheet Data in AWS Lambda
Connect to live Smartsheet in AWS Lambda using the CData JDBC Driver.
-
Natively Connect to NetSuite Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to NetSuite CRM & ERP. Leverage the native support for ODBC in PHP.
-
Automated Continuous EnterpriseDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Google Cloud SQL.
-
Design BIRT Reports on Salesforce CRM Analytics Data
Provide current Salesforce CRM Analytics to your embedded analytics.
-
Automated Continuous GitHub Replication to Oracle
Use CData Sync for automated, continuous, customizable GitHub replication to Oracle.
-
Connect to eBay Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for eBay and the Script function in FileMaker Pro to connect to eBay and work with eBay in your FileMaker application.
-
Visualize Google Analytics Data in TIBCO Spotfire through OData
Integrate Google Analytics into dashboards in TIBCO Spotfire.
-
Connect to Retently Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Tableau Connector for eBay
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for eBay.
-
A PostgreSQL Interface for CloudConvert Data (MySQL Remoting via JDBC)
Use the Remoting features of the CloudConvert JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Mastra with Microsoft OneDrive 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 Microsoft OneDrive, no replication required.
-
Integrate LibreChat with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Dynamics 365 Business Central from within the chat interface.
-
Use CData Connect AI to Access SurveyMonkey Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SurveyMonkey in the Power Pivot business intelligence tool.
-
Deploy the ADO.NET Provider for Elorus on an SSRS Report Server
Connect to Elorus 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.
-
Access SuiteCRM 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 SuiteCRM.
-
Replicate Moosend Data to Multiple Databases via the CData Sync CLI
Replicate Moosend to disparate databases with a single configuration.
-
Connect to SharePoint Excel Services Data in Claris FileMaker Pro
Use the CData ODBC Driver for SharePoint Excel Services in FileMaker Pro to connect to SharePoint Excel Services and work with SharePoint Excel Services in your FileMaker applications.
-
Integrating OpenCode Terminal with Clio 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 Connect to Live Apollo Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Apollo for you.