CData Software - Knowledge Base
Recent Articles
-
Connect AlloyDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google AlloyDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Dashboards and Visualize Live Snapchat Ads Data in Geckoboard
Use CData Connect AI to connect to live Snapchat Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to work with ZohoMarketingHub Data in Apache Spark using SQL
Access and process ZohoMarketingHub Data in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Aha! Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Aha! in ColdFusion.
-
Automated Continuous Freshdesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Freshdesk replication to Snowflake.
-
Access Live BenchmarkEmail Data in Coginiti Pro
Connect to and query live BenchmarkEmail from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Oracle HCM Cloud 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 Oracle HCM Cloud.
-
How to Connect to Live Adobe Analytics 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 Analytics without replication.
-
Automated Continuous EnterpriseDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to delimited files (CSV/TSV).
-
Automated Continuous Amazon Athena Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Google BigQuery.
-
Access Aircall Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aircall from HeidiSQL.
-
Build an OLAP Cube in SSAS from Todoist Data
Establish a connection to Todoist data from SQL Server Analysis Services, and use the Todoist Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Phoenix Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Phoenix into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Phoenix in the Graph Builder and Query Builder.
-
Building Dynamic Web Pages with Odoo Data Using AngularJS
Create single-page applications with live connectivity to Odoo using the CData API Server.
-
Create ConstantContact Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ConstantContact from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData SSIS Components for Reckon
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Reckon.
-
Automated Continuous Typeform Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Typeform replication to Azure SQL Database.
-
Build Charts with Jira Data in Clear Analytics
Create dynamic charts and perform analytics based on Atlassian Jira in Clear Analytics.
-
Access Oracle Sales Data from MySQL in Amazon QuickSight
Connect to Oracle Sales and build visualizations of Oracle Sales using a MySQL Connection in Amazon QuickSight.
-
Connect and Query Live OData Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live OData into Databricks
-
Query Live Exact Online Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Exact Online directly from the development environment.
-
How to Query Live Typeform Data in Claude Desktop
Connect to and query live Typeform Data in Claude Desktop using CData MCP Server.
-
Visualize AdRoll Data in Sisense
Create an ElastiCube in Sisense app with access to AdRoll.
-
Integrate Bitly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bitly with External Services.
-
How to import Azure Synapse Data into Apache Solr
Use the CData Software JDBC Driver for Azure Synapse in Data Import Handler and create an automated import of Azure Synapse to Apache Solr Enterprise Search platform.
-
How to connect Amazon QuickSight to CSV Data
Create a connection to CSV/TSV Files in CData Connect AI and insert CSV/TSV Files into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy Desktop
Connect to PagerDuty in MicroStrategy Desktop using the CData Software ODBC Driver for PagerDuty.
-
Build Voice Agents in ElevenLabs with access to Live API Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live API.
-
Integrate TigerGraph Data in the Pentaho Report Designer
Publish reports based on TigerGraph in the Pentaho BI tool.
-
Analyze Pipedrive Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Pipedrive and visualize Pipedrive in SAP Analytics Cloud.
-
View Reports on Real-Time SendGrid Data in Power BI Report Server
Use the CData ODBC Driver for SendGrid to visualize SendGrid in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Cassandra Data in ACL Analytics
Connect to Apache Cassandra via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Cassandra.
-
Analyze Lakebase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Lakebase and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Blackbaud FE NXT-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Blackbaud FE NXT and build web apps with connectivity to live Blackbaud FE NXT.
-
Natively Connect to Trello Data in PHP
The CData ODBC driver for Trello enables you to create PHP applications with connectivity to Trello. Leverage the native support for ODBC in PHP.
-
How to Access Live eBay Data in Visual Studio Code via Cline
Run CData MCP Server for eBay on Windows Subsytem for Linux (WSL) and connect to live eBay from the Cline extension in Visual Studio Code.
-
Connect to Marketo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Marketo in FileMaker Pro to connect to Marketo and work with Marketo in your FileMaker applications.
-
Integrating Boomi Agentstudio with Acumatica Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Acumatica ERP, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ConstantContact
Provide connectivity to ConstantContact through an SAP BusinessObjects universe.
-
Use JayDeBeApi to access SendPulse Data in Python
Use standard Python scripting and the development environment of your choice to access live SendPulse.
-
Connect to Asana Data from a Connection Pool in Jetty
The Asana JDBC Driver supports connection pooling: This article shows how to connect faster to Asana from Web apps in Jetty.
-
LINQ to Sentry 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 Sentry Data Provider.
-
How to connect to PayPal Data from IntelliJ
Integrate connectivity to PayPal with wizards in IntelliJ.
-
Build Charts with Adobe Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Analytics in Clear Analytics.
-
Edit and Search Paylocity External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Paylocity to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Paylocity objects that you can access from apps and the dashboard.
-
Use Agno to Talk to Your Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Square for you.
-
Visualize Nuclia Data in Sisense
Create an ElastiCube in Sisense app with access to Nuclia.
-
Connect to YouTube Analytics Data in DBeaver
Use the CData ODBC Driver to connect to YouTube Analytics in DBeaver.
-
Connect to Quickbase Data from AWS Glue
Use CData Connect AI to gain access to live Quickbase from your AWS Glue jobs.
-
DataBind Controls to Outreach.io Data in Delphi
DataBind to Outreach.io in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time ConvertAPI Data
Use CData Power BI Connectors to visualize ConvertAPI in Power BI.
-
Connect to Zoho CRM Data from a Connection Pool in Jetty
The Zoho CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho CRM from Web apps in Jetty.
-
Create Informatica Mappings From/To an ODBC Data Source for Discourse
Create an ODBC connection to Discourse in Informatica and browse and transfer Discourse.
-
Import Opsgenie Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Opsgenie. In this article, you will use the OData format to import Opsgenie into Microsoft Power Query.
-
Query LinkedIn Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume LinkedIn entities in PHP by modeling them as objects.
-
Automated Continuous Snapchat Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Productboard
Provide connectivity to Productboard through an SAP BusinessObjects universe.
-
Integrating GitHub Copilot CLI with Aweber 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.
-
Object-Relational Mapping (ORM) with SparkPost 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 SparkPost into a Java-based ORM framework, Hibernate.
-
Analyze Dynamics NAV Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dynamics NAV in Microsoft R Open.
-
Query Splunk Data as a MySQL Database in Node.js
Execute MySQL queries against Splunk from Node.js.
-
Add ChargeOver Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ChargeOver with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build a PostgreSQL Interface for Pushbullet Data using the CData JDBC Driver
Use the Remoting features of the Pushbullet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create TaxJar Dataflows on PowerBI.com
Connect to the CData Power BI Connector for TaxJar from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Gumroad Data with Squirrel SQL client
Connect to Gumroad and execute queries in the Squirrel SQL Client.
-
Create Power BI Reports on Real-Time Rebilly Data
Use the CData ODBC Driver for Rebilly to visualize Rebilly in Power BI Desktop.
-
Connect to PagerDuty Data in DBArtisan
Use wizards in DBArtisan to configure PagerDuty as a data source.
-
Access Live Azure Table Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Table Storage from your Excel spreadsheets.
-
Build Apps with Live Unbounce Data Using the Low-Code Development Platform of Mendix
Connect Unbounce with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Twilio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Twilio replication to OneLake in Microsoft Fabric.
-
Connect to Omnisend Data in DBArtisan
Use wizards in DBArtisan to configure Omnisend as a data source.
-
Integrate Theia IDE with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Dataiku with Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho CRM.
-
Build ConvertKit-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live ConvertKit Data in Cursor to assist with building ConvertKit-powered applications.
-
Access Live QuickBooks Time Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to QuickBooks Time from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to integrate Metabase with Acumatica Data
Use CData Connect AI to connect to live Acumatica ERP and create an interactive dashboard in Metabase from Acumatica ERP.
-
Automated Continuous Couchbase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Couchbase replication to SQL Server.
-
DataBind Spark Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Apache Spark with the DevExpress Windows Forms and Web controls to provide Apache Spark SQL to a chart.
-
Import Real-Time Factorial Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Factorial in ColdFusion.
-
Automated Continuous Recurly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Recurly replication to Amazon S3.
-
How to Query SAP SuccessFactors LMS Data in MySQL Workbench
Execute MySQL queries against live SAP SuccessFactors LMS from MySQL Workbench.
-
Automated Continuous AfterShip Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable AfterShip replication to PostgreSQL.
-
Integrate with ZarMoney Data in JReport Designer
Create charts and reports based on ZarMoney in JReport Designer.
-
Build MVC Applications with Connectivity to ZohoPeople Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoPeople from an ASP.NET MVC application.
-
Integrating Antigravity CLI with ConstantContact via CData CLI
Connect ConstantContact to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Enable the Hubstaff JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hubstaff.
-
How to connect to Onfleet Data with Squirrel SQL client
Connect to Onfleet and execute queries in the Squirrel SQL Client.
-
Edit and Search External Elasticsearch Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Elasticsearch to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Elasticsearch Data objects that you can access from apps and the dashboard.
-
Access Live SharePoint Data in TIBCO Data Virtualization
Use the SharePoint Tibco DV Adapter to create a Microsoft SharePoint data source in TIBCO Data Virtualization Studio and gain access to live Microsoft SharePoint from your TDV Server.
-
How to Access Live Guru Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Guru from the Cline extension in Visual Studio Code.
-
Process & Analyze Rebilly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Rebilly Data.
-
Load SharePoint Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft SharePoint to a database.
-
Import Real-Time Procore Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Procore in ColdFusion.
-
A PostgreSQL Interface for Yelp Data using the CData ODBC Driver
Use the SQL Gateway and Yelp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Reckon Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Reckon and visualize live Reckon in Infragistics Reveal.
-
Build Epicor Kinetic-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Epicor Kinetic to explore live Epicor Kinetic Data in Gemini Code Assist to assist with building Epicor Kinetic-powered applications.
-
Connect GitHub Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GitHub using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Validate Google Campaign Manager 360 Data with QuerySurge
Access and validate Google Campaign Manager 360 in QuerySurge using the CData JDBC Driver.
-
How to Query Live ClickTime Data in Claude Desktop
Connect to and query live ClickTime Data in Claude Desktop using CData MCP Server.
-
Build a Simple VCL Application for Microsoft Ads Data
How to build a simple VCL Application to view Microsoft Ads in RAD Studio using the CData ODBC Driver for Microsoft Ads.