CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for Datadog on an SSRS Report Server
Connect to Datadog 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.
-
How to connect Amazon QuickSight to Dynamics 365 Data
Create a connection to Microsoft Dynamics 365 in CData Connect AI and insert Microsoft Dynamics 365 into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Ariba Source within intelligent workflows.
-
A PostgreSQL Interface for Snapchat Ads Data using the CData ODBC Driver
Use the SQL Gateway and Snapchat Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
Viewing Google Ad Manager Data in RAD Studio Data Explorer
How to view Google Ad Manager in RAD Studio Data Explorer using the CData ODBC Driver for Google Ad Manager.
-
Connect Discord to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Discord with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to FHIR Data in DBVisualizer
Integrate FHIR with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Live Amazon Athena Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon Athena to Blue Prism using the CData ODBC Driver for Amazon Athena to create automated workflows for repetitive business tasks.
-
Integrate Open WebUI with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Dropbox from within the chat interface.
-
Integrate Live Clio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Clio to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Publish Authorize.Net-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Authorize.Net.
-
Connect to and Query Google Cloud Storage Data in QlikView over ODBC
Create data visualizations with Google Cloud Storage in QlikView.
-
Publish Crystal Reports on Sendwithus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sendwithus.
-
Use the CData ODBC Driver for Drift in Microsoft Power Query
You can use the CData Drift ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Drift into Microsoft Power Query.
-
Deploy the ADO.NET Provider for Azure Data Catalog on an SSRS Report Server
Connect to Azure Data Catalog 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.
-
How to Connect to Live Okta Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Okta for you.
-
Access Live Sugar CRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sugar CRM from your Google Sheets.
-
How to connect and process Apache HBase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache HBase.
-
Seamlessly Bring GitHub Data into Retool Using CData Connect AI
Integrate GitHub data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData Software ODBC Driver for Amazon DynamoDB in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon DynamoDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon DynamoDB.
-
Object-Relational Mapping (ORM) with Facebook Ads 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 Facebook Ads into a Java-based ORM framework, Hibernate.
-
Access Live Databricks Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Databricks in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to create ZohoPeople federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZohoPeople in MySQL .
-
Automated Continuous eBay Replication to SingleStore
Use CData Sync for automated, continuous, customizable eBay replication to SingleStore.
-
Connect to Opsgenie Data in CloverDX (formerly CloverETL)
Transfer Opsgenie using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot CLI with MarkLogic 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 JayDeBeApi to access Amazon S3 Data in Python
Use standard Python scripting and the development environment of your choice to access live Amazon S3.
-
Connect to NetSuite SuiteAnalytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live NetSuite SuiteAnalytics from Crystal Reports.
-
Build Certinia-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Certinia.
-
Integrating LangGraph with Exact Online Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Exact Online within automated workflows.
-
Integrating OpenCode Terminal with Redshift 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.
-
Query Microsoft Teams Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Teams from Node.js.
-
Building Dynamic Web Pages with Microsoft OneDrive Data Using AngularJS
Create single-page applications with live connectivity to Microsoft OneDrive using the CData API Server.
-
Replicate AdRoll Data to Multiple Databases via the CData Sync CLI
Replicate AdRoll to disparate databases with a single configuration.
-
Connect to Cohere Data from a Connection Pool in JBoss
Integrate Cohere into Java servlets: Use the Management Console in JBoss to install the Cohere JDBC Driver.
-
Prepare, Blend, and Analyze PDFMonkey Data in Alteryx Designer (ODBC)
Build workflows to access live PDFMonkey for self-service data analytics.
-
How to Connect the Power BI Service to XML: Complete Guide
Connect to the CData Software Power BI Connector for XML from PowerBI.com to provide real-time XML Files across the organization.
-
Prepare, Blend, and Analyze eBay Data in Alteryx Designer (Connect AI)
Build workflows to access live eBay for self-service data analytics.
-
Automated Continuous Keap Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Keap replication to AlloyDB.
-
Create Datasets from Gmail in Domo Workbench and Build Visualizations of Gmail Data in Domo
Use the CData Software ODBC Driver for Gmail to create datasets from Gmail in Domo Workbench and then build visualizations in the Domo service.
-
Excel Spreadsheet Automation on SAS Data Sets Data with the QUERY Formula
Pull data from SAS Data Sets, automate spreadsheets, and more with the QUERY formula.
-
Connect Authorize.Net Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Authorize.Net using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build ElevenLabs-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ElevenLabs and build web apps with connectivity to live ElevenLabs.
-
How to create Omnisend federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Omnisend in MySQL .
-
Automated Continuous MYOB AccountRight Replication to MongoDB
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to MongoDB.
-
Connect to Raisers Edge NXT Data from AWS Glue
Use CData Connect AI to gain access to live Raisers Edge NXT from your AWS Glue jobs.
-
Deploy the ADO.NET Provider for ZohoPeople on an SSRS Report Server
Connect to ZohoPeople 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.
-
Connect to Cloudflare Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Cloudflare as an External Source in Dremio.
-
Connect to Aweber Data in JRuby
Create a simple JRuby app with access to live Aweber.
-
Automated Continuous FormSite Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable FormSite replication to PostgreSQL.
-
Visualize Live Sage Intacct Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sage Intacct.
-
Query Snapchat Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to Snapchat Ads.
-
Automate Sendwithus Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sendwithus replication to Azure Data Lake.
-
Connect to REST Data in RazorSQL
Connect to REST from wizards and query REST from the GUI in the RazorSQL database management tool.
-
Automated Continuous SageHR Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SageHR replication to PostgreSQL.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Dynamics 365 actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to GitLab Data from Crystal Reports
Use CData Connect AI to connect to and report on live GitLab from Crystal Reports.
-
Analyze Live Google Directory Data in SAS Viya
Use CData Connect AI to connect to Google Directory from SAS Viya and deploy self-service analytics using live Google Directory.
-
How to Access DB2 Data Using Entity Framework
This article shows how to access IBM DB2 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Data Visualizations in Cognos BI with LionDesk Data
Access LionDesk as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
HubSpot Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to HubSpot through CData Connect AI using different applications and tools.
-
Migrating data from Outlook to Google BigQuery using CData SSIS Components.
Easily push Outlook to Google BigQuery using the CData SSIS Tasks for Outlook and Google BigQuery.
-
How to create SendPulse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SendPulse in MySQL .
-
Access Live Foursquare Data in AWS Lambda
Connect to live Foursquare in AWS Lambda using the CData JDBC Driver.
-
Connect to Spotify Data from a Connection Pool in JBoss
Integrate Spotify into Java servlets: Use the Management Console in JBoss to install the Spotify JDBC Driver.
-
View Reports on Real-Time Printify Data in Power BI Report Server
Use the CData ODBC Driver for Printify to visualize Printify in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Freshdesk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Freshdesk in the Denodo Virtual DataPort Administrator.
-
Connecting Agentforce with YouTube Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your YouTube Analytics for you.
-
Extract, Transform, and Load Confluence Data in Informatica PowerCenter
Create a simple Workflow for Atlassian Confluence in Informatica PowerCenter.
-
Building Dynamic Web Pages with Salesforce Marketing Data Using AngularJS
Create single-page applications with live connectivity to Salesforce Marketing using the CData API Server.
-
Connect to ZeroBounce Data from a Connection Pool in Jetty
The ZeroBounce JDBC Driver supports connection pooling: This article shows how to connect faster to ZeroBounce from Web apps in Jetty.
-
Use CData Connect AI to Access Highrise Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Highrise CRM in the Power Pivot business intelligence tool.
-
Prepare, Blend, and Analyze Grafana Data in Alteryx Designer (ODBC)
Build workflows to access live Grafana for self-service data analytics.
-
Natively Connect to Act-On Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Act-On. Leverage the native support for ODBC in PHP.
-
Connect FHIR Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FHIR using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to eBay Data from PowerBuilder via JDBC
This article demonstrates how to access eBay from PowerBuilder using the eBay JDBC Driver.
-
Explore Geographical Relationships in Avalara AvaTax Data with Power Map
Create data visualizations with Avalara AvaTax in Power Map.
-
Visualize Hubstaff Data in TIBCO Spotfire through ADO.NET
Integrate Hubstaff into dashboards in TIBCO Spotfire.
-
Automated Continuous Printify Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Printify replication to delimited files (CSV/TSV).
-
Use Dash to Build to Web Apps on Klaviyo Data
Create Python applications that use pandas and Dash to build Klaviyo-connected web apps.
-
How to integrate MySQL with Apache Airflow
Access and process MySQL in Apache Airflow using the CData JDBC Driver.
-
Import Real-Time Excel Online Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Excel Online in ColdFusion.
-
Integrating Antigravity CLI with ShipStation via CData CLI
Connect ShipStation to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize MySQL Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load MySQL into TIBCO Spotfire.
-
Create SSAS Tabular Models from Chargebee Data
How to build a SQL Server Analysis Service Tabular Model from Chargebee using CData drivers.
-
Connect to Real-Time Shortcut Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Shortcut in Power Apps.
-
Getting Started with the CData ADO.NET Provider for Freshservice
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to BigQuery Data in NetBeans
Connect to Google BigQuery in NetBeans with the data source configuration wizard.
-
SAP Concur Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Concur through CData Connect AI using different applications and tools.
-
Access Simplesat Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Simplesat from your Oracle system.
-
Access Oracle Eloqua Reporting 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 Eloqua Reporting.
-
Build Twilio-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Twilio Data and create custom apps in Mendix.
-
Query Oracle HCM Cloud Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle HCM Cloud entities in PHP by modeling them as objects.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for RabbitMQ
Provide connectivity to RabbitMQ through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Teradata
Create an ODBC connection to Teradata in Informatica and browse and transfer Teradata.
-
Use JayDeBeApi to access Aha! Data in Python
Use standard Python scripting and the development environment of your choice to access live Aha!.
-
How to Query Live HDFS Data in Claude Desktop
Connect to and query live HDFS Data in Claude Desktop using CData MCP Server.
-
Visualize Hugging Face Data in Tableau
The CData ODBC driver for Hugging Face enables you integrate Hugging Face into Tableau dashboards.
-
How to Query Accelo Data in MySQL Workbench
Execute MySQL queries against live Accelo from MySQL Workbench.
-
Integrating REST Data in Talend Cloud Data Management Platform
Connect REST Data with Talend Cloud Data Management Platform using the CData JDBC Driver for REST.