CData Software - Knowledge Base
Recent Articles
-
How to Query Live Teradata Data in Claude Desktop
Connect to and query live Teradata Data in Claude Desktop using CData MCP Server.
-
Connect to GitHub Data in Aqua Data Studio
Access GitHub from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Excel Spreadsheet Automation on Oracle Sales Data with the QUERY Formula
Pull data from Oracle Sales, automate spreadsheets, and more with the QUERY formula.
-
How to publish and share Retently Data dashboards with Tableau Server
The CData ODBC driver for Retently enables you integrate Retently into Tableau dashboards.
-
How to Connect the Power BI Service to Cloudant: Complete Guide
Connect to the CData Software Power BI Connector for Cloudant from PowerBI.com to provide real-time IBM Cloudant across the organization.
-
Import Real-Time Reckon Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Reckon in ColdFusion.
-
Connect to Tickspot Data from a Connection Pool in Jetty
The Tickspot JDBC Driver supports connection pooling: This article shows how to connect faster to Tickspot from Web apps in Jetty.
-
How to Connect to Live Stripe Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Stripe for you.
-
Build an OLAP Cube in SSAS from SAP SuccessFactors Data
Establish a connection to SAP SuccessFactors data from SQL Server Analysis Services, and use the SAP SuccessFactors Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Crystal Reports on Salesforce Marketing Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce Marketing Cloud.
-
Load ConvertAPI Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ConvertAPI to a database.
-
Automated Continuous SharePoint Excel Services Replication to SQL Server
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SQL Server.
-
Integrate Adobe Target with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Adobe Target with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Adobe Target.
-
Automated Avaza Data Replication to Teradata
Use CData Sync to Customize and automate Avaza replication to Teradata.
-
Access Live Avro Data in Coginiti Pro
Connect to and query live Apache Avro from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Natively Connect to Blackbaud FE NXT Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Blackbaud FE NXT. Leverage the native support for ODBC in PHP.
-
Automated Continuous Attio Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Attio replication to Google Cloud SQL.
-
Use the CData ODBC Driver for SendGrid from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SendGrid to connect to SendGrid from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SendGrid in Excel.
-
Replicate Multiple Paymo Accounts
Replicate multiple Paymo accounts to one or many databases.
-
LINQ to CloudConvert 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 CloudConvert Data Provider.
-
Integrate GitHub Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live GitHub from Informatica Cloud.
-
Connect to Billsby Data from PowerBuilder via JDBC
This article demonstrates how to access Billsby from PowerBuilder using the Billsby JDBC Driver.
-
Connect Twilio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Twilio using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from MYOB AccountRight to Snowflake using CData SSIS Components.
Easily push MYOB AccountRight to Snowflake using the CData SSIS Tasks for MYOB AccountRight and Snowflake.
-
Use the CData Software ODBC Driver for Databricks in MicroStrategy
Connect to Databricks in MicroStrategy Developer using the CData Software ODBC Driver for Databricks.
-
How to Build an ETL App for ServiceNow Data in Python with CData Connect AI
Build ETL pipelines that read and write live ServiceNow in Python with petl and the CData Connect AI Python SDK.
-
LINQ to Shortcut 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 Shortcut Data Provider.
-
Publish Crystal Reports on Beeminder Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Beeminder.
-
Build Voice Agents in ElevenLabs with access to Live Email Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Email.
-
Integrating Dataiku with Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Freshdesk.
-
Integrating Parallel Data in Talend Cloud Data Management Platform
Connect Parallel Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Simplesat Data in Aqua Data Studio
Access Simplesat from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Deploy the ADO.NET Provider for Guru on an SSRS Report Server
Connect to Guru 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.
-
JSON Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on JSON facts in real time.
-
Connect to Gorgias Data in RazorSQL
Connect to Gorgias from wizards and query Gorgias from the GUI in the RazorSQL database management tool.
-
Automated Continuous Basecamp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Basecamp replication to Apache Kafka.
-
How to Connect to Live ShipStation 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 ShipStation through natural language.
-
How to Design Facebook Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Facebook from mobile and tablet Power Apps.
-
Automated Continuous Aircall Replication to Snowflake
Use CData Sync for automated, continuous, customizable Aircall replication to Snowflake.
-
Connect to Excel Online in SpagoBI
Create reports featuring live Microsoft Excel Online in SpagoBI Studio. Host Excel Online reports on SpagoBI Server.
-
Integrate LibreChat with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Outreach.io from within the chat interface.
-
Connect to Vault CRM Data in RapidMiner
Integrate Veeva Vault & Vault CRM with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Jira Data in DBVisualizer
Integrate Atlassian Jira with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Facebook Data from AWS Glue
Use CData Connect AI to gain access to live Facebook from your AWS Glue jobs.
-
How to Connect to Live FHIR 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 FHIR without replication.
-
Natively Connect to Okta Data in PHP
The CData ODBC driver for Okta enables you to create PHP applications with connectivity to Okta. Leverage the native support for ODBC in PHP.
-
Visualize DocuSign Data in TIBCO Spotfire through ADO.NET
Integrate DocuSign into dashboards in TIBCO Spotfire.
-
Connect to Asana Data in Ruby
Connect to Asana in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live MarkLogic 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 MarkLogic for you.
-
Use Claude to Talk to Your SAP Fieldglass 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 SAP Fieldglass for you.
-
Create Data Visualizations Based On Microsoft Ads Data in Mode
Use CData Connect AI to connect to Microsoft Ads Data from Mode and build visualizations using live
-
Design BIRT Reports on SQL Server Data
Provide current Microsoft SQL Server to your embedded analytics.
-
Connect to Billsby Data from a Connection Pool in Jetty
The Billsby JDBC Driver supports connection pooling: This article shows how to connect faster to Billsby from Web apps in Jetty.
-
How to Query Live SendInBlue Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SendInBlue data in natural language using Python.
-
Enable the QuickBooks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with QuickBooks Desktop.
-
Create Aweber Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Aweber data access from reports, embedded analytics, and more.
-
Automate Bitbucket Data Replication to Azure Data Lake
Use CData Sync to customize and automate Bitbucket replication to Azure Data Lake.
-
Configure the CData JDBC Driver for Todoist in a Connection Pool in Tomcat
Connect to Todoist from a connection pool in Tomcat.
-
Consume SAP Ariba Source OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Ariba Source as OData feeds from PowerBuilder using the API Server.
-
Import BigCommerce Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access BigCommerce. In this article, you will use the OData format to import BigCommerce into Microsoft Power Query.
-
Integrating Claude Code with Oracle Financials Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Financials Cloud within assisted coding and automated development workflows.
-
Connect to Yelp Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Yelp using standard SQL.
-
Bidirectional Access to ServiceNow Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ServiceNow in Filemaker Pro for Mac or Windows.
-
Build Clio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Clio.
-
Connect to Clari Data in RazorSQL
Connect to Clari from wizards and query Clari from the GUI in the RazorSQL database management tool.
-
Build Data Flows from Perigon to SQL Server using SSIS
Easily back up Perigon to SQL Server using the SSIS components for Perigon.
-
Build a Simple VCL Application for Autopilot Data
How to build a simple VCL Application to view Autopilot in RAD Studio using the CData ODBC Driver for Autopilot.
-
Integrate with SuiteCRM Data in JReport Designer
Create charts and reports based on SuiteCRM in JReport Designer.
-
Integrate with Epicor Kinetic Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Epicor Kinetic to a JSON file on disk.
-
Connect to HubSpot Data in RazorSQL
Connect to HubSpot from wizards and query HubSpot from the GUI in the RazorSQL database management tool.
-
Query Raisers Edge NXT Data in ColdFusion
Write standard ColdFusion data access code to connect to Raisers Edge NXT.
-
Migrating data from Google Translate to Databricks using CData SSIS Components.
Easily push Google Translate to Databricks using the CData SSIS Tasks for Google Translate and Databricks.
-
Build Snowflake-Connected Apps in Choreo
Use CData Connect AI to connect to Snowflake Data from Choreo and build custom apps using live Snowflake.
-
Use the CData Software ODBC Driver for Short.io in MicroStrategy
Connect to Short.io in MicroStrategy Developer using the CData Software ODBC Driver for Short.io.
-
Access Live Vault CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Veeva Vault & Vault CRM from your Excel spreadsheets.
-
Automated Continuous Sage 300 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sage 300 replication to Google BigQuery.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure DevOps to Power BI dashboards. Simply drag and drop Azure DevOps into data visuals on the Power BI canvas.
-
How to Connect to Live SurveyMonkey 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 SurveyMonkey for you.
-
Connect and Visualize Live Blackbaud FE NXT Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Blackbaud FE NXT into the Databricks platform and create visualization dashboards with real-time Blackbaud FE NXT.
-
Analyze Dropbox Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Dropbox and visualize live Dropbox in Infragistics Reveal.
-
A PostgreSQL Interface for Zoho Creator Data using the CData ODBC Driver
Use the SQL Gateway and Zoho Creator ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Klipfolio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Klipfolio from PowerShell? This article demonstrates how to utilize the Klipfolio Cmdlets for tasks like connecting to Klipfolio, automating operations, downloading data, and more.
-
Create Datasets from QuickBooks in Domo Workbench and Build Visualizations of QuickBooks Data in Domo
Use the CData Software ODBC Driver for QuickBooks to create datasets from QuickBooks Desktop in Domo Workbench and then build visualizations in the Domo service.
-
Build Bugsnag-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Bugsnag.
-
Access Live LinkedIn Ads Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live LinkedIn Ads through MCP integration.
-
Natively Connect to Salesforce Marketing Data in PHP
The CData ODBC driver for Salesforce Marketing enables you to create PHP applications with connectivity to Salesforce Marketing Cloud. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy
Connect to Acumatica ERP in MicroStrategy Developer using the CData Software JDBC Driver for Acumatica.
-
Create SAP HANA-Connected Applications in Appsmith
Connect to SAP HANA Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP HANA.
-
How to Query Live Pinterest Data in Perplexity MacOS Desktop
Connect to and query live Pinterest Data in Perplexity Desktop using CData MCP Server.
-
Integrating Codex CLI with SAS XPORT 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.
-
Integrate Live Freshdesk Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Freshdesk and integrate live Freshdesk into apps built in Microsoft Power Apps.
-
Automated Continuous Monday.com Replication to Oracle
Use CData Sync for automated, continuous, customizable Monday.com replication to Oracle.
-
Connect to and Query QuickBooks Time Data in QlikView over ODBC
Create data visualizations with QuickBooks Time in QlikView.
-
Use the CData Software ODBC Driver for Gmail in MicroStrategy
Connect to Gmail in MicroStrategy Developer using the CData Software ODBC Driver for Gmail.
-
Create Act-On Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Act-On data access from reports, embedded analytics, and more.
-
How to Connect to Quaderno Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Quaderno. Leverage the pyodbc module for ODBC in Python.
-
Build Charts with Sage Cloud Accounting Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage Business Cloud Accounting in Clear Analytics.
-
Access Live Cosmos DB Data in Coginiti Pro
Connect to and query live Azure Cosmos DB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to publish and share Copper Data dashboards with Tableau Server
The CData ODBC driver for Copper enables you integrate Copper into Tableau dashboards.
-
Access Live Wistia Data in Coginiti Pro
Connect to and query live Wistia from the GUI in the Coginiti Pro: SQL Analytics Tool.