CData Software - Knowledge Base
Recent Articles
-
Rootly Reporting in OBIEE with the Rootly JDBC Driver
Deploy the Rootly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SuiteCRM Data in Aqua Data Studio
Access SuiteCRM data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for SAP Ariba Source Data using the CData ODBC Driver
Use the SQL Gateway and SAP Ariba Source ODBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Wave Financial Data in PHP
The CData ODBC driver for Wave Financial enables you to create PHP applications with connectivity to Wave Financial data. Leverage the native support for ODBC in PHP.
-
Query Facebook Data in DataGrip
Create a Data Source for Facebook in DataGrip and use SQL to query live Facebook data.
-
Feed FreeAgent Data into FineReport
How to set FreeAgent data as a JDBC data source in FineReport.
-
How to Visualize Office 365 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Office 365 data in Python.
-
Access Amplitude Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amplitude data from HeidiSQL.
-
ETL Microsoft Dataverse in Oracle Data Integrator
This article shows how to transfer Microsoft Dataverse data into a data warehouse using Oracle Data Integrator.
-
Build Zoho Creator-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho Creator data and build Zoho Creator-connected web apps with Axios.
-
Build Apps with Live HDFS Data Using the Low-Code Development Platform of Mendix
Connect HDFS data with Mendix to build apps using the CData JDBC Driver for HDFS.
-
Integrate Goose with Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Aweber data from within the local AI agent.
-
Integrating GitHub Copilot with Google Calendar 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.
-
DataBind Controls to Wrike Data in Delphi
DataBind to Wrike data in Delphi with standard data access components and controls.
-
How to Access Omnisend Data Using Entity Framework
This article shows how to access Omnisend data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to ServiceDesk Plus Data in ACL Analytics
Connect to ServiceDesk Plus data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ServiceDesk Plus data.
-
Automate Excel Data Replication to Couchbase
Use CData Sync to Customize and automate Excel data replication to Couchbase.
-
Deploy the ADO.NET Provider for ClickTime on an SSRS Report Server
Connect to ClickTime data 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 Hugging Face Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Hugging Face data. Leverage the pyodbc module for ODBC in Python.
-
Access Live SAP Business One 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 SAP Business One data through MCP integration.
-
How to work with Exa Data in Apache Spark using SQL
Access and process Exa Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Dynamics NAV.
-
Integrating Claude Code with Aweber Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Aweber data within assisted coding and automated development workflows.
-
Load Wave Financial Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Wave Financial data to a database.
-
Working with Short.io Data in LINQPad
Execute LINQ queries to Short.io data in LINQPad.
-
A PostgreSQL Interface for Discourse Data using the CData ODBC Driver
Use the SQL Gateway and Discourse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Office 365
Provide connectivity to Office 365 data through an SAP BusinessObjects universe.
-
Automated Continuous Mode Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mode replication to MongoDB.
-
Connect to Planio Data in RazorSQL
Connect to Planio from wizards and query Planio data from the GUI in the RazorSQL database management tool.
-
Visualize Keap Data in Tableau
The CData ODBC driver for Keap enables you integrate Keap data into Tableau dashboards.
-
Analyze MailerLite Data in Cognos Analytics
Use CData Connect AI to connect to MailerLite Data from Cognos Analytics and analyze live MailerLite data.
-
Build MVC Applications with Connectivity to Exa Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Exa from an ASP.NET MVC application.
-
How to connect to Sage Intacct Data from IntelliJ
Integrate connectivity to Sage Intacct data with wizards in IntelliJ.
-
Build Semantic Layer Views for Smartsheet Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Smartsheet data.
-
Connect to SageHR Data in Aqua Data Studio
Access SageHR data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate with live RSS Feeds in Jitterbit
Use CData Connect AI to connect to and integrate live RSS feeds in Jitterbit.
-
A PostgreSQL Interface for JotForm Data (MySQL Remoting via JDBC)
Use the Remoting features of the JotForm JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish TaxJar-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live TaxJar data.
-
Automated Continuous Codat Replication to MongoDB
Use CData Sync for automated, continuous, customizable Codat replication to MongoDB.
-
Connect to Outlook Data in DBArtisan
Use wizards in DBArtisan to configure Outlook data as a data source.
-
Integrating Antigravity CLI with SFTP data via CData CLI
Connect SFTP data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Pipedrive Reporting in OBIEE with the Pipedrive JDBC Driver
Deploy the Pipedrive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a PostgreSQL Interface for Basecamp Data using the CData JDBC Driver
Use the Remoting features of the Basecamp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to PagerDuty Data in DBeaver
Use the CData ODBC Driver to connect to PagerDuty data in DBeaver.
-
Access Live Azure Data Lake Storage Data in AWS Lambda
Connect to live Azure Data Lake Storage data in AWS Lambda using the CData JDBC Driver.
-
How to publish and share Dynamics 365 Data dashboards with Tableau Server
The CData ODBC driver for Dynamics 365 enables you integrate Dynamics 365 data into Tableau dashboards.
-
Use CData Connect AI to Access Kintone Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Kintone data in the Power Pivot business intelligence tool.
-
Use Agno to Talk to Your BigQuery 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 BigQuery data for you.
-
Load Invoiced Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Invoiced data to a database.
-
Connect to Stripe Data in HULFT Integrate
Connect to Stripe as a JDBC data source in HULFT Integrate
-
Automated Continuous MarkLogic Replication to Vertica
Use CData Sync for automated, continuous, customizable MarkLogic replication to Vertica.
-
Getting Started with the CData Power BI Connector for Monday.com
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Monday.com.
-
How to publish and share Cohere Data dashboards with Tableau Server
The CData ODBC driver for Cohere enables you integrate Cohere data into Tableau dashboards.
-
Connect to MailerSend Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MailerSend data using standard SQL.
-
Integrate with Microsoft Dataverse Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Dataverse data in SnapLogic.
-
Integrate Google's Vertex AI Agent with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Sendwithus data within intelligent workflows.
-
Analyze Zoho Creator Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Creator data in Microsoft R Open.
-
View Reports on Real-Time EmailOctopus Data in Power BI Report Server
Use the CData ODBC Driver for EmailOctopus to visualize EmailOctopus data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Codex with Zoho Projects 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.
-
Connect to Jira Data in DBArtisan
Use wizards in DBArtisan to configure Jira data as a data source.
-
Replicate ZohoExpense Data to Multiple Databases via the CData Sync CLI
Replicate ZohoExpense data to disparate databases with a single configuration.
-
Object-Relational Mapping (ORM) with Scrapfly 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 Scrapfly data into a Java-based ORM framework, Hibernate.
-
Integrating Dataiku with Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage Cloud Accounting data.
-
Prepare, Blend, and Analyze Close Data in Alteryx Designer (ODBC)
Build workflows to access live Close data for self-service data analytics.
-
Getting Started with the CData Tableau Connector for Impala
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Impala.
-
Connect to Adobe Target Data from AWS Glue
Use CData Connect AI to gain access to live Adobe Target data from your AWS Glue jobs.
-
Connect to HDFS Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HDFS data from Filemaker Pro on Mac.
-
Visualize Factorial Data in Sisense
Create an ElastiCube in Sisense app with access to Factorial data.
-
Create LDAP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LDAP data access from reports, embedded analytics, and more.
-
Connect to ShipEngine Data from HeidiSQL
Use CData Connect AI to connect to and query live ShipEngine data from HeidiSQL.
-
Build Charts with Scrapfly Data in Clear Analytics
Create dynamic charts and perform analytics based on Scrapfly data in Clear Analytics.
-
Use Microsoft Copilot Studio to talk to your Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Entra ID data for you.
-
Visualize Live Sybase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sybase data.
-
Choosing the Best Method to Connect ServiceNow to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ServiceNow data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Supabase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Supabase data.
-
Build Dashboards with HelloSign Data in Dundas BI
Create dynamic dashboards and perform analytics based on HelloSign data in Dundas BI.
-
Natively Connect to Notion Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Notion data. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Sybase IQ Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sybase IQ data without replication.
-
Query Google Calendar Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Calendar data from Node.js.
-
Use Dash to Build to Web Apps on Optimizely Data
Create Python applications that use pandas and Dash to build Optimizely-connected web apps.
-
Connect to Zoom Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoom data in Airbyte.
-
Create Reports with FormSite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FormSite data.
-
Automated Continuous ScrapingBee Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ScrapingBee replication to AlloyDB.
-
Analyze Live Oracle SCM Data in SAS Viya
Use CData Connect AI to connect to Oracle SCM data from SAS Viya and deploy self-service analytics using live Oracle SCM data.
-
Query Google Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Ads data from Node.js.
-
How to Connect DBeaver to SAP Hybris C4C via a JDBC Driver
Manage SAP Hybris C4C data with visual tools in DBeaver like the query browser.
-
How to use SQLAlchemy ORM to access Hacker News Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Hacker News data.
-
Automated Continuous xBase Replication to Oracle
Use CData Sync for automated, continuous, customizable xBase replication to Oracle.
-
Natively Connect to AgileCRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to AgileCRM data. Leverage the native support for ODBC in PHP.
-
Build Visualizations of SurveyMonkey Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SurveyMonkey data in Birst.
-
Analyze Splunk Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Splunk data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate OpenCode with Live Tally Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Tally data from within your AI coding agent.
-
Visualize Live Dropbox Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dropbox data.
-
Automated Continuous Gorgias Replication to Vertica
Use CData Sync for automated, continuous, customizable Gorgias replication to Vertica.
-
Viewing Outreach.io Data in RAD Studio Data Explorer
How to view Outreach.io data in RAD Studio Data Explorer using the CData ODBC Driver for Outreach.io.
-
Easily Integrate FreshBooks Data in Lazarus Pascal IDE
Learn how to easily integrate live FreshBooks data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Design BIRT Reports on Adobe Target Data
Provide current Adobe Target data to your embedded analytics.
-
Integrating LangGraph with Klipfolio Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Klipfolio data within automated workflows.
-
Analyze Bannerbear Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bannerbear data in Microsoft R Open.
-
Operational Reporting on ZohoSubscriptions Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoSubscriptions data.