CData Software - Knowledge Base
Recent Articles
-
Establish a Live Connection with FHIR Data using Tableau Bridge
The CData ODBC Driver for FHIR enables you to integrate live FHIR into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Opsgenie Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Opsgenie from your Oracle system.
-
DataBind Avalara AvaTax Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Avalara AvaTax with the DevExpress Windows Forms and Web controls to provide Avalara AvaTax to a chart.
-
Establish a Live Connection with Nuclia Data using Tableau Bridge
The CData ODBC Driver for Nuclia enables you to integrate live Nuclia into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous BambooHR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable BambooHR replication to IBM DB2.
-
Connect to Nuclia Data from a Connection Pool in Jetty
The Nuclia JDBC Driver supports connection pooling: This article shows how to connect faster to Nuclia from Web apps in Jetty.
-
Create NetSuite SuiteAnalytics-Connected Applications in Appsmith
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to NetSuite SuiteAnalytics.
-
Rapidly Develop LeadDesk-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 LeadDesk.
-
Integrate RabbitMQ Data in Pentaho Data Integration
Build ETL pipelines based on RabbitMQ in the Pentaho Data Integration tool.
-
Build a Simple VCL Application for Access Data
How to build a simple VCL Application to view Microsoft Access in RAD Studio using the CData ODBC Driver for Access.
-
Use Dash to Build to Web Apps on MariaDB Data
Create Python applications that use pandas and Dash to build MariaDB-connected web apps.
-
Access HubDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HubDB from your Oracle system.
-
Automated Continuous SAP ByDesign Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SQL Server.
-
Create Data Visualizations in Cognos BI with Anaplan Data
Access Anaplan as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build an OLAP Cube in SSAS from Recurly Data
Establish a connection to Recurly data from SQL Server Analysis Services, and use the Recurly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Prepare, Blend, and Analyze NetSuite Data in Alteryx Designer (Connect AI)
Build workflows to access live NetSuite CRM & ERP for self-service data analytics.
-
Viewing Microsoft Teams Data in RAD Studio Data Explorer
How to view Microsoft Teams in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Teams.
-
Build Automated Workflows with Live Klaviyo Data in Workato
Use CData Connect AI to connect to live Klaviyo and build automated workflows in Workato.
-
Integrating Cursor CLI with Short.io 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.
-
Edit and Search Stripe External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Stripe to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Stripe objects that you can access from apps and the dashboard.
-
Explore Geographical Relationships in Shopify Data with Power Map
Create data visualizations with Shopify in Power Map.
-
Connect to Live Exact Online Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Exact Online in CData Connect AI and connect to your Exact Online from PostgreSQL.
-
Operational Reporting on Bitly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bitly.
-
Build MarkLogic-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for MarkLogic to explore live MarkLogic Data in GitHub Copilot to assist with building MarkLogic-powered applications.
-
Create Data Visualizations in Cognos BI with Zoho Projects Data
Access Zoho Projects as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apache Spark SQL within intelligent workflows.
-
Connect to Exact Online Data in CloverDX (formerly CloverETL)
Transfer Exact Online using the visual workflow in the CloverDX data integration tool.
-
A PostgreSQL Interface for Apollo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Apollo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Gumloop with WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on WordPress within automated workflows.
-
Integrating Claude Code with Workday Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Workday within assisted coding and automated development workflows.
-
Integrating GitHub Copilot 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.
-
Migrating data from Oracle Financials Cloud to Databricks using CData SSIS Components.
Easily push Oracle Financials Cloud to Databricks using the CData SSIS Tasks for Oracle Financials Cloud and Databricks.
-
Automated Continuous Sage Intacct Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sage Intacct replication to SQL Server.
-
Connect to Oracle Eloqua Data in HULFT Integrate
Connect to Oracle Eloqua as a JDBC data source in HULFT Integrate
-
Integrate with LinkedIn Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LinkedIn Ads to a JSON file on disk.
-
How to integrate Tickspot with Apache Airflow
Access and process Tickspot in Apache Airflow using the CData JDBC Driver.
-
Process & Analyze Toggl Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Toggl Data.
-
Access Live DB2 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live DB2 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use ChatGPT to Talk to Your Box 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 Box for you.
-
Build HDFS-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for HDFS to explore live HDFS Data in Cursor to assist with building HDFS-powered applications.
-
Create LinkedIn Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LinkedIn Ads data access from reports, embedded analytics, and more.
-
Analyze Outreach.io Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Outreach.io in Microsoft R Open.
-
Build Semantic Layer Views for Pushbullet Data in APOS Live Data Gateway
Use the CData Connector for Pushbullet in APOS Live Data Gateway to build Semantic Layer Views for Pushbullet.
-
Connect Google Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Analytics using the CData Python MCP Server.
-
Analyze GraphQL Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GraphQL in Microsoft R Open.
-
Connect to Raisers Edge NXT Data from a Connection Pool in JBoss
Integrate Raisers Edge NXT into Java servlets: Use the Management Console in JBoss to install the Raisers Edge NXT JDBC Driver.
-
Build Automated Workflows with Live Oracle SCM Data in Workato
Use CData Connect AI to connect to live Oracle SCM and build automated workflows in Workato.
-
Automate Cloudant Integration Tasks from PowerShell
Are you in search of a quick and easy way to access IBM Cloudant from PowerShell? This article demonstrates how to utilize the Cloudant Cmdlets for tasks like connecting to IBM Cloudant, automating operations, downloading data, and more.
-
Publish Crystal Reports on Workday Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Workday.
-
How to Query Live PivotalTracker Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PivotalTracker data in natural language using Python.
-
Extract, Transform, and Load Wrike Data in Informatica PowerCenter
Create a simple Workflow for Wrike in Informatica PowerCenter.
-
Automated Continuous Cloudflare Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Cloudflare replication to AlloyDB.
-
Operational Reporting on OpenWeatherMap Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote OpenWeatherMap.
-
Migrating data from Raisers Edge NXT to Google BigQuery using CData SSIS Components.
Easily push Raisers Edge NXT to Google BigQuery using the CData SSIS Tasks for Raisers Edge NXT and Google BigQuery.
-
Stream Invoiced Data into Apache Kafka Topics
Access and stream Invoiced in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Microsoft Entra ID Data in ETL Validator JDBC
Connect to Microsoft Entra ID from ETL Validator jobs using the CData Software JDBC Driver.
-
Bind Live Google Search Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Search data
-
Build Apps with Live QuickBooks Online Data Using the Low-Code Development Platform of Mendix
Connect QuickBooks Online with Mendix to build apps using the CData JDBC Driver for QuickBooks Online.
-
Integrate Attio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Attio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Attio.
-
How to Connect to Live Monday.com Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Monday.com securely in real time.
-
Getting Started with the CData ODBC Driver for Mailjet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mailjet.
-
How to Use a Microsoft Access Database to Update Google Ad Manager Data in Real Time
Update Google Ad Manager data by creating a linked table in Microsoft Access with the CData Google Ad Manager ODBC Driver.
-
Build ServiceNow-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for ServiceNow to explore live ServiceNow Data in Gemini Code Assist to assist with building ServiceNow-powered applications.
-
LINQ to Bitbucket 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 Bitbucket Data Provider.
-
Build MySQL Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MySQL and build visualizations in Tableau Cloud.
-
Process & Analyze Pipedrive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pipedrive Data.
-
Use the CData Software ODBC Driver for Notion in SAS for Real-Time Reporting and Analytics
Connect to real-time Notion in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Notion.
-
Query JobNimbus Data as a MySQL Database in Node.js
Execute MySQL queries against JobNimbus from Node.js.
-
How to create an RPA flow for JSON Services in UiPath Studio
Use the JSON ODBC Driver to create workflows that access real-time JSON without any coding.
-
How to Create Power BI Visual Reports with Real-Time Beeminder Data
Use CData Power BI Connectors to visualize Beeminder in Power BI.
-
Connect to Tally Data from PowerBuilder via JDBC
This article demonstrates how to access Tally ERP from PowerBuilder using the Tally JDBC Driver.
-
Integrate Twitter Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Twitter Ads and integrate live Twitter Ads into your Power Automate tasks.
-
Add Zoho Inventory Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Inventory with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to GraphQL Data in RazorSQL
Connect to GraphQL from wizards and query GraphQL from the GUI in the RazorSQL database management tool.
-
Extend Google Sheets with AlloyDB Data
Make calls to AlloyDB from Google Apps Script via the API Server.
-
Publish Freshdesk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshdesk.
-
How to Query Live PolarTeamPro Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PolarTeamPro data in natural language using Python.
-
Add Pipeliner CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pipeliner CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to OData Services as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OData.
-
Build Apps with Live Datadog Data Using the Low-Code Development Platform of Mendix
Connect Datadog with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze Cassandra Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Cassandra with the CData JDBC Driver for Cassandra.
-
Automated Continuous Reckon Replication to SQLite
Use CData Sync for automated, continuous, customizable Reckon replication to SQLite.
-
Easily Integrate Dynamics 365 Business Central Data in Lazarus Pascal IDE
Learn how to easily integrate live Dynamics 365 Business Central in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Datadog with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Datadog with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Datadog.
-
How to Work with Google Ad Manager Data in AWS Glue Jobs Using JDBC
Connect to Google Ad Manager from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate AdRoll with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AdRoll with External Services.
-
Access Live Square Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Square from your Google Sheets.
-
Natively Connect to Greenplum Data in PHP
The CData ODBC driver for Greenplum enables you to create PHP applications with connectivity to Pivotal GreenPlum. Leverage the native support for ODBC in PHP.
-
Replicate SurveyMonkey Data to Multiple Databases
Replicate SurveyMonkey to disparate databases with a point-and-click configuration.
-
Create Reports from Raisers Edge NXT Data in Looker Studio
Use CData Connect AI to gain access to live Raisers Edge NXT and create custom reports in Looker Studio.
-
Analyze Twilio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Twilio from Power Pivot. You will use the Table Import Wizard to load Twilio. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Asana Replication to Databricks
Use CData Sync for automated, continuous, customizable Asana replication to Databricks.
-
Query Microsoft Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Ads.
-
Build Semantic Layer Views for FreshBooks Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for FreshBooks.
-
View Reports on Real-Time Lakebase Data in Power BI Report Server
Use the CData ODBC Driver for Lakebase to visualize Lakebase in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous SendPulse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SendPulse replication to Amazon S3.
-
Access Live WooCommerce Data in AWS Lambda
Connect to live WooCommerce in AWS Lambda using the CData JDBC Driver.
-
Access Live Typeform Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Typeform into the statistical analysis tools available in SAS JMP. This article shows how to use Typeform in the Graph Builder and Query Builder.
-
Getting Started with the CData Power BI Connector for Sage 300
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage 300.
-
Create Informatica Mappings From/To an ODBC Data Source for PayPal
Create an ODBC connection to PayPal in Informatica and browse and transfer PayPal.