CData Software - Knowledge Base
Recent Articles
-
Automated Continuous FHIR Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FHIR data replication to OneLake in Microsoft Fabric.
-
Import and Visualize Act CRM Data in Power View
Create data visualizations based on Act CRM data in Excel.
-
Getting Started with the CData Power BI Connector for Outreach.io
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Outreach.io.
-
Integrating LlamaIndex with Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Office 365 data in real time.
-
Access Live Google Spanner 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 Google Spanner data through MCP integration.
-
Integrating Boomi Agentstudio with Azure Analysis Services Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Analysis Services data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Strava Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Strava and work with Strava data in your FileMaker applications.
-
Query Live MongoDB Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live MongoDB data through a conversational interface.
-
Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy Web
Connect to Amazon Athena data in MicroStrategy Web using the CData Software JDBC Driver for Amazon Athena.
-
Create Data Visualizations in Cognos BI with SAP ByDesign Data
Access SAP ByDesign data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create FHIR Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FHIR from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Grok to Talk to Your Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Cloudant data for you.
-
Integrating GitHub Copilot with Hugging Face 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.
-
Automated Continuous Presto Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Presto replication to IBM DB2.
-
Updating a Column from Another Column with CData Drivers
Learn how to use SQL statements, such as the UPDATE statement, with CData Drivers to copy values from one column to another.
-
Visualize Live SFTP Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SFTP data.
-
Create Typeform Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Typeform data access from reports, embedded analytics, and more.
-
Use the CData Software ODBC Driver for Zoho Inventory in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoho Inventory data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho Inventory.
-
Automated Continuous Reply.io Replication to MongoDB
Use CData Sync for automated, continuous, customizable Reply.io replication to MongoDB.
-
Query Google Translate Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Translate data from Node.js.
-
Use CData Connect AI to Access Timely Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Timely data in the Power Pivot business intelligence tool.
-
Using the CData Software ODBC Driver for Workday in PyCharm
Connect to Workday as an ODBC data source in PyCharm using the CData Software ODBC Driver for Workday.
-
Automated Continuous IBM Cloud Object Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Azure SQL Database.
-
Build Pipedrive-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Pipedrive Data and create custom apps in Mendix.
-
Build Data Flows from SQL Server to WordPress through SSIS
Easily push SQL Server data to WordPress using the CData SSIS Tasks for WordPress.
-
Integrate Cursor with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Greenplum data from within the editor.
-
Klipfolio Reporting in OBIEE with the Klipfolio JDBC Driver
Deploy the Klipfolio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live Twilio 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 Twilio data for you.
-
Getting Started with the CData SSIS Components for Marketo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Marketo.
-
Automated Continuous Cloudflare Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cloudflare replication to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate SAP Fieldglass Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Fieldglass data to SQL Server.
-
Automated Continuous SAP HANA Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP HANA replication to Vertica.
-
Write a Simple Go Application to work with Xero Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Xero data.
-
Object-Relational Mapping (ORM) with Apify 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 Apify data into a Java-based ORM framework, Hibernate.
-
How to Connect Testmonitor Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Testmonitor data in real time using natural language.
-
How to publish and share Microsoft Exchange Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Exchange enables you integrate Microsoft Exchange data into Tableau dashboards.
-
Connect to and Query SAP HANA XS Advanced Data in QlikView over ODBC
Create data visualizations with SAP HANA XS Advanced data in QlikView.
-
Use the CData Software JDBC Driver for Nuclia in MicroStrategy Web
Connect to Nuclia data in MicroStrategy Web using the CData Software JDBC Driver for Nuclia.
-
Integrate Devin with Live ADP Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live ADP data.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy
Connect to MariaDB data in MicroStrategy Developer using the CData Software ODBC Driver for MariaDB.
-
Analyze Avalara AvaTax Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Avalara AvaTax data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
LINQ to Copper 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 Copper Data Provider.
-
Model, Search, and Visualize Live Authorize.Net Data in ThoughtSpot
Use CData Connect AI to connect to live Authorize.Net data for modeling, searching, and visualizing.
-
How to connect and process Contentful data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Contentful data.
-
Publish Crystal Reports on Templated Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Templated data.
-
Access Zoho Recruit Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Recruit data from your Oracle system.
-
Process & Analyze HCL Domino Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HCL Domino Data.
-
Visualize Live Google Calendar Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Calendar data into custom reports in Power BI.
-
Getting Started with the CData SSIS Components for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ServiceDesk Plus.
-
Access Live PingOne Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live PingOne data through MCP integration.
-
Validate FreshBooks Data with QuerySurge
Access and validate FreshBooks data in QuerySurge using the CData JDBC Driver.
-
Process & Analyze RSS Feeds in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live RSS Feeds.
-
Use JayDeBeApi to access SAP SuccessFactors Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP SuccessFactors data.
-
How to connect and process Apify data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apify data.
-
Getting Started with the CData ODBC Driver for Shopify
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Shopify.
-
How to Connect Flowise AI Agents to Live Jira Assets Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Jira Assets data without replication.
-
Connect to SAP Netweaver Gateway Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Netweaver Gateway data using standard SQL.
-
Access Live Amazon Athena Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon Athena data into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon Athena data in the Graph Builder and Query Builder.
-
Prepare, Blend, and Analyze Act CRM Data in Alteryx Designer (Connect AI)
Build workflows to access live Act CRM data for self-service data analytics.
-
Connect to Dynamics 365 Business Central Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics 365 Business Central and the SQL Gateway to access Dynamics 365 Business Central data from Google Apps Script.
-
Build MVC Applications with Connectivity to Oracle Eloqua Reporting Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Eloqua Reporting from an ASP.NET MVC application.
-
How to Connect to Live Office 365 Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Office 365 data for you.
-
Connect and Query Live Figshare Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Figshare data into Databricks and enable direct, live querying and analysis without replication.
-
Operational Reporting on Notion Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Notion data.
-
DataBind Charts to CockroachDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to CockroachDB data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Connect DBeaver to Insightly via a JDBC Driver
Manage Insightly data with visual tools in DBeaver like the query browser.
-
Operational Reporting on Copper Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Copper data.
-
Connect to Google Calendar Data in HULFT Integrate
Connect to Google Calendar as a JDBC data source in HULFT Integrate
-
Use Databricks Agent Bricks to Talk to Your GitLab Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your GitLab data for you.
-
Create Apps from Anaplan Data in Qlik Sense Cloud
Use CData Connect AI to connect to Anaplan Data and build apps from live Anaplan data in Qlik Sense Cloud.
-
Query Google Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Google Analytics data from Node.js.
-
Automated Continuous ScrapingBee Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Apache Cassandra.
-
Visualize Zoho CRM 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 Zoho CRM data into TIBCO Spotfire.
-
Access Live ServiceNow Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ServiceNow data from your Excel spreadsheets.
-
Integrate Attio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Attio data from Informatica Cloud.
-
How to connect to Paymo Data from IntelliJ
Integrate connectivity to Paymo data with wizards in IntelliJ.
-
Build a PostgreSQL Interface for Autopilot Data using the CData JDBC Driver
Use the Remoting features of the Autopilot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from Strava to Databricks using CData SSIS Components.
Easily push Strava data to Databricks using the CData SSIS Tasks for Strava and Databricks.
-
Integrate Adobe Experience Manager Data in the Pentaho Report Designer
Publish reports based on Adobe Experience Manager data in the Pentaho BI tool.
-
Excel Spreadsheet Automation on Facebook Ads Data with the QUERY Formula
Pull data from Facebook Ads, automate spreadsheets, and more with the QUERY formula.
-
Connect to Short.io Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Short.io and work with Short.io data in your FileMaker applications.
-
How to import SingleStore Data into Apache Solr
Use the CData Software JDBC Driver for SingleStore in Data Import Handler and create an automated import of SingleStore data to Apache Solr Enterprise Search platform.
-
Connect to Office 365 Data in DBeaver
Use the CData ODBC Driver to connect to Office 365 data in DBeaver.
-
Build Google Spanner-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Spanner Data from Zoho Analytics and import live Google Spanner data.
-
How to Connect to Live Snowflake Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Snowflake data through natural language.
-
ETL XML in Oracle Data Integrator
This article shows how to transfer XML data into a data warehouse using Oracle Data Integrator.
-
Create Dynamic Cosmos DB Grids Using the Infragistics XamDataGrid
Learn how you can connect Cosmos DB to Infragistics XamDataGrid to build dynamic grids.
-
Create SAP SuccessFactors LMS-Connected Dashboards in Grafana
Connect to SAP SuccessFactors LMS Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP SuccessFactors LMS data.
-
Build Semantic Layer Views for Sage Intacct Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage Intacct data.
-
Automated Continuous RSS Replication to MySQL
Use CData Sync for automated, continuous, customizable RSS replication to MySQL.
-
Use the CData Software ODBC Driver for Egnyte in MicroStrategy Desktop
Connect to Egnyte data in MicroStrategy Desktop using the CData Software ODBC Driver for Egnyte.
-
Integrating Cursor with Instantly 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 Hive Data in Looker
Use CData Connect AI to connect to Hive Data from Looker and build custom apps using live Hive data.
-
Analyze Quaderno Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Quaderno from Power Pivot. You will use the Table Import Wizard to load Quaderno data. You can visually build the import query or use any SQL supported by the driver.
-
Create ConvertKit Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ConvertKit data access from reports, embedded analytics, and more.
-
How to load Billsby data into Elasticsearch via Logstash
Introducing a simple method to load Billsby data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect DBeaver to Freshservice via a JDBC Driver
Manage Freshservice data with visual tools in DBeaver like the query browser.
-
Stream Apify Data into Apache Kafka Topics
Access and stream Apify data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build GetResponse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live GetResponse data and build visualizations in Tableau Cloud.
-
Connect to ChartMogul from Asprova with CData Software ODBC Driver for ChartMogul
This article shows how to connect faster to ChartMogul data from Asprova.