CData Software - Knowledge Base
Recent Articles
-
Integrate with Live Shortcut Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Shortcut from the MuleSoft Anypoint Platform to integrate live Shortcut data into custom reports and dashboards.
-
Import Real-Time Google Ad Manager Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Ad Manager data in ColdFusion.
-
Use the CData Software JDBC Driver for HCL Domino in MicroStrategy
Connect to HCL Domino data in MicroStrategy Developer using the CData Software JDBC Driver for HCL Domino.
-
Build a PostgreSQL Interface for FHIR Data using the CData JDBC Driver
Use the Remoting features of the FHIR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with VWO Data in Clear Analytics
Create dynamic charts and perform analytics based on VWO data in Clear Analytics.
-
Publish Billsby-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Billsby data.
-
Create Salesforce CRM Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce CRM Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
Feed Teamgate Data into FineReport
How to set Teamgate data as a JDBC data source in FineReport.
-
Feed Google Spanner Data into FineReport
How to set Google Spanner data as a JDBC data source in FineReport.
-
Build Semantic Layer Views for Hubstaff Data in APOS Live Data Gateway
Use the CData Connector for Hubstaff in APOS Live Data Gateway to build Semantic Layer Views for Hubstaff data.
-
How to connect PolyBase to Klaviyo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Klaviyo data.
-
Use the CData Software ODBC Driver for Mode in SAS for Real-Time Reporting and Analytics
Connect to real-time Mode data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mode.
-
Databricks Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Databricks data through CData Connect AI using different applications and tools.
-
How to Connect to Live Freshteam 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 Freshteam data for you.
-
A PostgreSQL Interface for Workday Data using the CData ODBC Driver
Use the SQL Gateway and Workday ODBC Driver to create a PostgreSQL entry-point for data access.
-
Deploy the ADO.NET Provider for Splunk on an SSRS Report Server
Connect to Splunk 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.
-
Automate Oracle Financials Cloud Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Financials Cloud data from PowerShell? This article demonstrates how to utilize the Oracle Financials Cloud Cmdlets for tasks like connecting to Oracle Financials Cloud data, automating operations, downloading data, and more.
-
Query Perigon Data in DataGrip
Create a Data Source for Perigon in DataGrip and use SQL to query live Perigon data.
-
Create Informatica Mappings From/To a JDBC Data Source for Aha!
Create Aha! data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Dash to Build to Web Apps on Templated Data
Create Python applications that use pandas and Dash to build Templated-connected web apps.
-
Feed GraphQL Data into FineReport
How to set GraphQL data as a JDBC data source in FineReport.
-
Seamlessly Bring Basecamp Data into Retool Using CData Connect AI
Integrate Basecamp data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData ODBC Driver for SendPulse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SendPulse to connect to SendPulse data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SendPulse data in Excel.
-
Use Agno to Talk to Your Zoho Projects 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 Zoho Projects data for you.
-
Write a Simple Go Application to work with Basecamp Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Basecamp data.
-
Automate Superchat Data Replication to SAP HANA
Use CData Sync to customize and automate Superchat data replication to SAP HANA.
-
Connect to Zoho Recruit Data from a Connection Pool in Jetty
The Zoho Recruit JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho Recruit data from Web apps in Jetty.
-
Build MVC Applications with Connectivity to SAP Business One Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Business One from an ASP.NET MVC application.
-
Integrate Theia IDE with Live Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Wistia data from within the development environment.
-
Automate Oracle SCM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle SCM data replication to Azure Data Lake.
-
Build Dynamics 365 Business Central Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Dynamics 365 Business Central data and build visualizations in Tableau.
-
Operational Reporting on IBM Informix Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote IBM Informix data.
-
Query MariaDB Data in ColdFusion
Write standard ColdFusion data access code to connect to MariaDB data.
-
Build Voice Agents in ElevenLabs with access to Live Active Directory Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Active Directory data.
-
Viewing Google Translate Data in RAD Studio Data Explorer
How to view Google Translate data in RAD Studio Data Explorer using the CData ODBC Driver for Google Translate.
-
Use the CData Software ODBC Driver for Scrapfly in MicroStrategy
Connect to Scrapfly data in MicroStrategy Developer using the CData Software ODBC Driver for Scrapfly.
-
Natively Connect to Pipeliner CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pipeliner CRM data. Leverage the native support for ODBC in PHP.
-
Query ZohoExpense Data as a MySQL Database in Node.js
Execute MySQL queries against ZohoExpense data from Node.js.
-
Automated Continuous MailerLite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MailerLite replication to Amazon S3.
-
Manage Redis Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Redis.
-
Using the CData Software ODBC Driver for Qualaroo in PyCharm
Connect to Qualaroo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Qualaroo.
-
Work with Live SAP Netweaver Gateway Data in Power Query
Use CData Connect AI to connect to SAP Netweaver Gateway data and work with live SAP Netweaver Gateway data in Microsoft Power Query.
-
Integrating Cursor with Smartsheet 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.
-
Analyze SQL Analysis Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SQL Analysis Services data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Write a Simple Go Application to work with Tavily Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Tavily data.
-
Build Apps with Live CapsuleCRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live CapsuleCRM data into the Adalo platform and build custom mobile and web applications with real-time CapsuleCRM data.
-
How to integrate Metabase with SAS xpt Data
Use CData Connect AI to connect to live SAS xpt data and create an interactive dashboard in Metabase from SAS xpt data.
-
Connect to Mode Data in Google Apps Script via Connect AI
Use CData Connect AI to access Mode data in Google Apps Script.
-
Replicate ServiceDesk Plus Data to Multiple Databases
Replicate ServiceDesk Plus data to disparate databases with a point-and-click configuration.
-
How to Work with Zoho Inventory Data in AWS Glue Jobs Using JDBC
Connect to Zoho Inventory from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Figshare
Provide connectivity to Figshare data through an SAP BusinessObjects universe.
-
Process & Analyze Email Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Email Data.
-
LINQ to Oracle Eloqua 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 Oracle Eloqua Data Provider.
-
Access Zoho Projects Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Projects data from your Oracle system.
-
How to connect to Quaderno Data from Spring Boot
Connect to Quaderno in a Spring Boot Application using the CData API Driver for JDBC
-
Create Reports with Productboard Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Productboard data.
-
Import Active Directory Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Active Directory Data and provide access to live Active Directory data for custom reports in the Power BI Service.
-
Connect to Gmail Data in Jaspersoft Studio
Execute SQL to remote Gmail data in Jaspersoft Studio.
-
Connecting Agentforce with LinkedIn Ads 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 LinkedIn Ads data for you.
-
Automated Continuous Basecamp Replication to SQLite
Use CData Sync for automated, continuous, customizable Basecamp replication to SQLite.
-
Create Mocean Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mocean data access from reports, embedded analytics, and more.
-
Viewing Slack Data in RAD Studio Data Explorer
How to view Slack data in RAD Studio Data Explorer using the CData ODBC Driver for Slack.
-
Integrating Kiro with Paddle 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.
-
How to load SendPulse data into Elasticsearch via Logstash
Introducing a simple method to load SendPulse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Data Visualizations in Cognos BI with Cloudflare Data
Access Cloudflare data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Google Ads Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Ads data with the CData JDBC Driver for Google Ads.
-
Automate Monday.com Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Monday.com data from PowerShell? This article demonstrates how to utilize the Monday.com Cmdlets for tasks like connecting to Monday.com data, automating operations, downloading data, and more.
-
Build Automated SAS xpt-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAS xpt data and build automated workflows in Zapier.
-
Automated Continuous Close Replication to MongoDB
Use CData Sync for automated, continuous, customizable Close replication to MongoDB.
-
Access ClickTime Data from MySQL in Amazon QuickSight
Connect to ClickTime and build visualizations of ClickTime data using a MySQL Connection in Amazon QuickSight.
-
Replicate Bannerbear Data from PowerShell
Write a quick PowerShell script to query Bannerbear data. Use connectivity to the live data to replicate Bannerbear data to SQL Server.
-
Automated Continuous Authorize.Net Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Google BigQuery.
-
Replicate Missive Data to Multiple Databases
Replicate Missive data to disparate databases with a point-and-click configuration.
-
How to Connect to Live Procore Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Procore data for you.
-
Getting Started with the CData Tableau Connector for Placid
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Migrating data from Rootly to Google BigQuery using CData SSIS Components.
Easily push Rootly data to Google BigQuery using the CData SSIS Tasks for Rootly and Google BigQuery.
-
How to Connect to Live Impala 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 Impala data for you.
-
Build MVC Applications with Connectivity to Monday.com Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Monday.com from an ASP.NET MVC application.
-
Migrating data from Moosend to Databricks using CData SSIS Components.
Easily push Moosend data to Databricks using the CData SSIS Tasks for Moosend and Databricks.
-
How to connect PolyBase to PolarTeamPro
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PolarTeamPro data.
-
Choosing the Best Method to Connect Retently to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Retently data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous OneNote Replication to Oracle
Use CData Sync for automated, continuous, customizable OneNote replication to Oracle.
-
Getting Started with the CData Power BI Connector for LeadDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ActiveCampaign
Provide connectivity to ActiveCampaign data through an SAP BusinessObjects universe.
-
Connect to Vimeo in SpagoBI
Create reports featuring live Vimeo data in SpagoBI Studio. Host Vimeo reports on SpagoBI Server.
-
Visualize Live ScrapingBee Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ScrapingBee data.
-
Create Data Visualizations in Cognos BI with Harvest Data
Access Harvest data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Paylocity Data from HeidiSQL
Use CData Connect AI to connect to and query live Paylocity data from HeidiSQL.
-
Use the CData Software JDBC Driver for Demio in MicroStrategy
Connect to Demio data in MicroStrategy Developer using the CData Software JDBC Driver for Demio.
-
Integrating LangGraph with Exa Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Exa data within automated workflows.
-
Connect to Superchat Data from a Connection Pool in Jetty
The Superchat JDBC Driver supports connection pooling: This article shows how to connect faster to Superchat data from Web apps in Jetty.
-
Build Planio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Planio data and build web apps with connectivity to live Planio data.
-
Getting Started with the CData Connect AI Python SDK for Pinterest
Install the CData Connect AI Python SDK to read live Pinterest data with standard DB-API 2.0 Python code.
-
How to Visualize Autopilot Data in Python with pandas
Use pandas and other modules to analyze and visualize live Autopilot data in Python.
-
Connect to Google Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Analytics data in Airbyte.
-
Connect to Mailgun Data in RazorSQL
Connect to Mailgun from wizards and query Mailgun data from the GUI in the RazorSQL database management tool.
-
Provide OData Services of Power BI XMLA Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Power BI XMLA data by developing a WCF Service Application.
-
Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage 300 to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Beeminder from a Connection Pool in WebLogic
Use the CData JDBC Driver for Beeminder to connect to Beeminder data from Web applications running on WebLogic.
-
Create Dynamic GetResponse Grids Using the Infragistics XamDataGrid
Learn how you can connect GetResponse to Infragistics XamDataGrid to build dynamic grids.