CData Software - Knowledge Base
Recent Articles
-
Analyze Databricks Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Databricks and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Data Visualizations in Cognos BI with Microsoft Dataverse Data
Access Microsoft Dataverse (CDS) as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live AlloyDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google AlloyDB into the statistical analysis tools available in SAS JMP. This article shows how to use Google AlloyDB in the Graph Builder and Query Builder.
-
Connect Hacker News to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Hacker News using the CData Python MCP Server.
-
Load Jira Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Atlassian Jira to a database.
-
DataBind Controls to Sage Intacct Data in C++Builder
DataBind to Sage Intacct in C++Builder with standard components and controls.
-
Build Google Search Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Search and build visualizations in Tableau.
-
Build Automated Workflows with Live Twitter Ads Data in Workato
Use CData Connect AI to connect to live Twitter Ads and build automated workflows in Workato.
-
Getting Started with the CData Power BI Connector for Gumroad
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Power BI Reports on Real-Time BenchmarkEmail Data
Use the CData ODBC Driver for BenchmarkEmail to visualize BenchmarkEmail in Power BI Desktop.
-
How to Connect to Live Jira Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Atlassian Jira securely in real time.
-
How to Access Live Vimeo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Vimeo enables you to integrate Vimeo into workflows built using Microsoft Power Automate Desktop.
-
Connect to Dotmailer Data in Aqua Data Studio
Access Dotmailer from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Dynamics 365 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Google Cloud SQL.
-
Import and Visualize MongoDB Data in Power View
Create data visualizations based on MongoDB in Excel.
-
Work with Hubstaff Data in FoxPro
Load Hubstaff into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Data Flows from Pipedrive to SQL Server using SSIS
Easily back up Pipedrive to SQL Server using the SSIS components for Pipedrive.
-
Integrating Cursor CLI with LinkedIn 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.
-
Trigger Zoho Creator IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zoho Creator with standard wizards in Logic Apps.
-
Import Real-Time Figshare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Figshare in ColdFusion.
-
Connect to Okta Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Okta in the Denodo Virtual DataPort Administrator.
-
Query Toggl Data in ColdFusion
Write standard ColdFusion data access code to connect to Toggl.
-
Back Up Google Analytics to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Analytics. In this article, we will employ an SSIS workflow to populate a database with Google Analytics data.
-
Visualize Amazon S3 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 Amazon S3 into TIBCO Spotfire.
-
Bridge Dropbox Connectivity with Apache NiFi
Access and process Dropbox in Apache NiFi using the CData JDBC Driver.
-
Automated Flowlu Data Replication to Teradata
Use CData Sync to Customize and automate Flowlu replication to Teradata.
-
Analyze HelloSign Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HelloSign in Microsoft R Open.
-
Natively Connect to TigerGraph Data in PHP
The CData ODBC driver for TigerGraph enables you to create PHP applications with connectivity to TigerGraph. Leverage the native support for ODBC in PHP.
-
Analyze Live Tally Data in SAS Viya
Use CData Connect AI to connect to Tally ERP from SAS Viya and deploy self-service analytics using live Tally ERP.
-
Visualize Calendly Data in TIBCO Spotfire through ADO.NET
Integrate Calendly into dashboards in TIBCO Spotfire.
-
Build SAP SuccessFactors-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP SuccessFactors Data and create custom apps in Mendix.
-
Stream Act CRM Data into Apache Kafka Topics
Access and stream Act CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Vercel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Vercel.
-
Integrate with ADP Data in JReport Designer
Create charts and reports based on ADP in JReport Designer.
-
Create Power BI Reports on Real-Time Testmonitor Data
Use the CData ODBC Driver for Testmonitor to visualize Testmonitor in Power BI Desktop.
-
Integrating Claude Code CLI with Sybase 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.
-
Build Dashboards with OData Services in Dundas BI
Create dynamic dashboards and perform analytics based on OData in Dundas BI.
-
Integrating Antigravity CLI with ZohoPeople via CData CLI
Connect ZohoPeople to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Bannerbear Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bannerbear from HeidiSQL.
-
How to Access Landbot Data Using Entity Framework
This article shows how to access Landbot using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Validate Kafka Data with QuerySurge
Access and validate Apache Kafka in QuerySurge using the CData JDBC Driver.
-
Publish Reports with Microsoft Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Exchange.
-
Integrate Live Confluence Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Atlassian Confluence to Blue Prism using the CData ODBC Driver for Confluence to create automated workflows for repetitive business tasks.
-
Analyze Harvest Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Harvest with the CData JDBC Driver for Harvest.
-
Use the CData Software ODBC Driver for Sage 300 in SAS for Real-Time Reporting and Analytics
Connect to real-time Sage 300 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sage 300.
-
Deploy the ADO.NET Provider for Oracle on an SSRS Report Server
Connect to Oracle Database 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.
-
Integrate Cline with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Slack from within your IDE.
-
Automate Nethunt Data Replication to Azure Synapse
Use CData Sync to customize and automate Nethunt replication to Azure Synapse.
-
Build Apps with Live Cloudant Data Using the Low-Code Development Platform of Mendix
Connect IBM Cloudant with Mendix to build apps using the CData JDBC Driver for Cloudant.
-
Access Live Square Data in Coginiti Pro
Connect to and query live Square from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Active Directory Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Active Directory.
-
Integrate with Discourse Data in JReport Designer
Create charts and reports based on Discourse in JReport Designer.
-
Create SAP SuccessFactors-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP SuccessFactors Data from Klipfolio and build custom visualizations using live SAP SuccessFactors.
-
Integrate with Live Oracle Service Cloud Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Service Cloud from the MuleSoft Anypoint Platform to integrate live Oracle Service Cloud into custom reports and dashboards.
-
Publish Calendly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Calendly.
-
Connect to DB2 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live IBM DB2 from Filemaker Pro on Mac.
-
Access Live Zoom Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoom from your Excel spreadsheets.
-
Consume SharePoint Excel Services OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SharePoint Excel Services feeds that reflect any changes in SAP Lumira.
-
Integrate LaunchDarkly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LaunchDarkly with External Services.
-
Build Pipelines with Live Asana Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Asana from Google Cloud Data Fusion, enabling the integration of live Asana into the building and management of effective data pipelines.
-
Access Live Gmail Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Gmail from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Real-Time LDAP Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for LDAP and Dataflow to import and use LDAP in Power Apps.
-
Migrating data from HBase to Snowflake using CData SSIS Components.
Easily push Apache HBase to Snowflake using the CData SSIS Tasks for HBase and Snowflake.
-
How to Query Shippo Data in MySQL Workbench
Execute MySQL queries against live Shippo from MySQL Workbench.
-
Build Dashboards with SurveyMonkey Data in Dundas BI
Create dynamic dashboards and perform analytics based on SurveyMonkey in Dundas BI.
-
Build Visualizations of Trello Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Trello in Birst.
-
Query, Visualize, and Share live QuickBooks Time Data in Redash
Use CData Connect AI to connect to live QuickBooks Time in Redash for querying, visualizing, and sharing.
-
Visualize SAP SuccessFactors LMS Data in TIBCO Spotfire through ADO.NET
Integrate SAP SuccessFactors LMS into dashboards in TIBCO Spotfire.
-
Access Live Discord Data in Coginiti Pro
Connect to and query live Discord from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to CouchDB Data from AWS Glue
Use CData Connect AI to gain access to live Apache CouchDB from your AWS Glue jobs.
-
Work with Typeform Data in FoxPro
Load Typeform into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Deel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Deel using standard SQL.
-
Access Presto Data from MySQL in Amazon QuickSight
Connect to Presto and build visualizations of Presto using a MySQL Connection in Amazon QuickSight.
-
Connect to Real-Time Spark Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Spark and Dataflow to import and use Apache Spark SQL in Power Apps.
-
How to Connect to Live Active Directory 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 Active Directory for you.
-
Build MVC Applications with Connectivity to Klaviyo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Klaviyo from an ASP.NET MVC application.
-
How to Use a Microsoft Access Database to Update Amazon Athena Data in Real Time
Update Amazon Athena data by creating a linked table in Microsoft Access with the CData Amazon Athena ODBC Driver.
-
Natively Connect to Tickspot Data in PHP
The CData ODBC driver for Tickspot enables you to create PHP applications with connectivity to Tickspot. Leverage the native support for ODBC in PHP.
-
Connect to Live HCL Domino Data in MicroStrategy through CData Connect AI
Create a live connection to HCL Domino Data in CData Connect AI and connect to your HCL Domino from MicroStrategy.
-
Connect to SharePoint Data in Aqua Data Studio
Access Microsoft SharePoint from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Stream AfterShip Data into Apache Kafka Topics
Access and stream AfterShip in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automate Bannerbear Data Replication to Azure Data Lake
Use CData Sync to customize and automate Bannerbear replication to Azure Data Lake.
-
Connect to Teamwork Data in NetBeans
Connect to Teamwork in NetBeans with the data source configuration wizard.
-
How to connect to SAP HANA XS Advanced Data from IntelliJ
Integrate connectivity to SAP HANA XS Advanced with wizards in IntelliJ.
-
Connect Sybase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sybase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume Trello OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Trello feeds that reflect any changes in SAP Lumira.
-
Build a PostgreSQL Interface for Google Analytics Data using the CData JDBC Driver
Use the Remoting features of the Google Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for ZeroBounce Data using JDBI
A brief overview of creating a SQL Object API for ZeroBounce in JDBI.
-
Connect to Gumroad Data in DBeaver
Use the CData ODBC Driver to connect to Gumroad in DBeaver.
-
Integrate with Dynamics 365 Data in JReport Designer
Create charts and reports based on Microsoft Dynamics 365 in JReport Designer.
-
Object-Relational Mapping (ORM) with Grafana 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 Grafana into a Java-based ORM framework, Hibernate.
-
Connect to and Query Adobe Target Data in QlikView over ODBC
Create data visualizations with Adobe Target in QlikView.
-
Integrating Boomi Agentstudio with BambooHR Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to BambooHR, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate PayPal Data in Heroku for Use in Salesforce Connect
Replicate PayPal to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Live ActiveCampaign Data in SAS Viya
Use CData Connect AI to connect to ActiveCampaign from SAS Viya and deploy self-service analytics using live ActiveCampaign.
-
Use Manus AI to Talk to Your SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SAS XPORT.
-
Visualize Simplesat Data in Sisense
Create an ElastiCube in Sisense app with access to Simplesat.
-
Access Live Bright Data Data in AWS Lambda
Connect to live Bright Data in AWS Lambda using the CData JDBC Driver.
-
Connect to Adobe Analytics Data in Aqua Data Studio
Access Adobe Analytics from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData JDBC Driver for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Entra ID.