CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Business One Data in TIBCO Data Virtualization
Use the SAP Business One Tibco DV Adapter to create a SAP Business One data source in TIBCO Data Virtualization Studio and gain access to live SAP Business One from your TDV Server.
-
Create Sybase-Connected Dashboards in Grafana
Connect to Sybase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sybase.
-
DataBind Controls to Facebook Data in Delphi
DataBind to Facebook in Delphi with standard data access components and controls.
-
Visualize Mailjet 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 Mailjet into TIBCO Spotfire.
-
Access Customer.io Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Customer.io from your Oracle system.
-
Automate Smartsheet Data Replication to Azure Data Lake
Use CData Sync to customize and automate Smartsheet replication to Azure Data Lake.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Box actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Live SAP HANA Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP HANA in CData Connect AI and connect to your SAP HANA from PostgreSQL.
-
Access Live SAP Ariba Procurement Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Ariba Procurement from your Excel spreadsheets.
-
Getting Started with the CData ODBC Driver for Microsoft Exchange
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Exchange.
-
How to load Qualaroo data into Elasticsearch via Logstash
Introducing a simple method to load Qualaroo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Provide OData Services of Google Spanner Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Spanner by developing a WCF Service Application.
-
Automate Raisers Edge NXT Data Replication to Azure Data Lake
Use CData Sync to customize and automate Raisers Edge NXT replication to Azure Data Lake.
-
Build IBM Informix-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for IBM Informix Data and create custom apps in Bubble.
-
Create a Data Access Object for Shopify Data using JDBI
A brief overview of creating a SQL Object API for Shopify in JDBI.
-
Slack Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Slack through CData Connect AI using different applications and tools.
-
Integrating LangChain with Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Spanner within automated workflows.
-
Publish ADP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ADP.
-
Visualize ChartMogul Data in Tableau
The CData ODBC driver for ChartMogul enables you integrate ChartMogul into Tableau dashboards.
-
Replicate Multiple Microsoft Planner Accounts via the CData Sync CLI
Replicate multiple Microsoft Planner accounts to one or many databases.
-
Import Real-Time Freshdesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Freshdesk in ColdFusion.
-
Bridge ScrapingBee Connectivity with Apache NiFi
Access and process ScrapingBee in Apache NiFi using the CData JDBC Driver.
-
Analyze Flowlu Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Flowlu in Microsoft R Open.
-
Connect Pinecone to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pinecone with IBM WebSphere for seamless data integration and connectivity.
-
Choosing the Best Method to Connect Tavily to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tavily from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Charts with ShipEngine Data in Clear Analytics
Create dynamic charts and perform analytics based on ShipEngine in Clear Analytics.
-
Moving Data from Box to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Box data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Rapidly Develop Vercel-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Vercel.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SageHR
Provide connectivity to SageHR through an SAP BusinessObjects universe.
-
Access Live Okta Data in AWS Lambda
Connect to live Okta in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous SAP HANA XS Advanced Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Oracle.
-
Connect to Pipeliner CRM Data in Jaspersoft Studio
Execute SQL to remote Pipeliner CRM in Jaspersoft Studio.
-
Integrating Claude Code with Gmail Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Gmail within assisted coding and automated development workflows.
-
Automated Continuous Microsoft Teams Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Amazon Redshift.
-
Build Dynamics 365-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Dynamics 365 to explore live Dynamics 365 Data in Claude Code to assist with building Dynamics 365-powered applications.
-
Use Databricks Agent Bricks to Talk to Your Jira Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Atlassian Jira for you.
-
How to Create Power BI Visual Reports with Real-Time SharePoint Data
Use CData Power BI Connectors to visualize Microsoft SharePoint in Power BI.
-
Visualize Live Twilio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Twilio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Xero Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Xero Accounting using standard SQL.
-
Access Live NetSuite SuiteAnalytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live NetSuite SuiteAnalytics from your Excel spreadsheets.
-
How to connect PolyBase to Elasticsearch
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Elasticsearch.
-
Analyze Snowflake Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Snowflake and visualize live Snowflake in Infragistics Reveal.
-
Moving Data from Oracle Sales to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle Sales data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Oracle Eloqua Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Eloqua.
-
Connect to Outreach.io Data from PowerBuilder via JDBC
This article demonstrates how to access Outreach.io from PowerBuilder using the Outreach.io JDBC Driver.
-
Configure the CData JDBC Driver for Amplitude in a Connection Pool in Tomcat
Connect to Amplitude from a connection pool in Tomcat.
-
How to use SQLAlchemy ORM to access ConstantContact Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ConstantContact.
-
Automated Continuous MailChimp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MailChimp replication to Apache Cassandra.
-
Use JayDeBeApi to access Acumatica Data in Python
Use standard Python scripting and the development environment of your choice to access live Acumatica ERP.
-
How to load Attio data into Elasticsearch via Logstash
Introducing a simple method to load Attio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Using the CData Software ODBC Driver for Hugging Face in PyCharm
Connect to Hugging Face as an ODBC data source in PyCharm using the CData Software ODBC Driver for Hugging Face.
-
Query SAP Hybris C4C Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Hybris C4C from Node.js.
-
Connect to Oracle Data in Aqua Data Studio
Access Oracle Database from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Certinia Data in Python with pandas
Use pandas and other modules to analyze and visualize live Certinia in Python.
-
Query Pinecone Data as a MySQL Database in Node.js
Execute MySQL queries against Pinecone from Node.js.
-
Create Reports from Microsoft Exchange Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Exchange and create custom reports in Looker Studio.
-
Visualize Live WooCommerce Data in the Power BI Service
Use CData Connect AI to connect to live WooCommerce and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate SAP Business One Data in Heroku for Use in Salesforce Connect
Replicate SAP Business One to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automate Greenplum Data Replication to Couchbase
Use CData Sync to Customize and automate Pivotal GreenPlum replication to Couchbase.
-
Automated Continuous AlloyDB Replication to MySQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to MySQL.
-
Connect to Azure Synapse Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Synapse from Crystal Reports.
-
How to Connect DBeaver to Freshteam via a JDBC Driver
Manage Freshteam with visual tools in DBeaver like the query browser.
-
Connect to RSS Feeds from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for RSS to connect to RSS Feeds and execute queries in PowerBuilder.
-
Natively Connect to SAP Business Warehouse Data in PHP
The CData ODBC driver for SAP Business Warehouse enables you to create PHP applications with connectivity to SAP Business Warehouse. Leverage the native support for ODBC in PHP.
-
Build MVC Applications with Connectivity to Nuclia Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Nuclia from an ASP.NET MVC application.
-
Integrating OpenCode Terminal with REST 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 Create Power BI Visual Reports with Real-Time SageHR Data
Use CData Power BI Connectors to visualize SageHR in Power BI.
-
Deploy the ADO.NET Provider for Power BI XMLA on an SSRS Report Server
Connect to Power BI XMLA 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.
-
Work with Live Greenhouse Data in Power Query
Use CData Connect AI to connect to Greenhouse and work with live Greenhouse in Microsoft Power Query.
-
How to connect to Sage Cloud Accounting Data from IntelliJ
Integrate connectivity to Sage Business Cloud Accounting with wizards in IntelliJ.
-
How to Connect OData Services to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live OData data in real time using natural language.
-
Create Power BI Reports on Real-Time Teamwork Data
Use the CData ODBC Driver for Teamwork to visualize Teamwork in Power BI Desktop.
-
Access Live Contentful Data in AWS Lambda
Connect to live Contentful in AWS Lambda using the CData JDBC Driver.
-
Build Automated Dynamics 365 Business Central-Connected Workflows in Zapier
Use CData Connect AI to connect to live Dynamics 365 Business Central and build automated workflows in Zapier.
-
Connect to MailerSend Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MailerSend as an External Source in Dremio.
-
Use Microsoft Copilot Studio to talk to your SAP BusinessObjects BI 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 SAP BusinessObjects BI for you.
-
Connect to Timely in SpagoBI
Create reports featuring live Timely in SpagoBI Studio. Host Timely reports on SpagoBI Server.
-
Process & Analyze Gmail Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gmail Data.
-
Query Oracle Sales Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Sales from Node.js.
-
Publish Reports with Hugging Face Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hugging Face.
-
Access ZendeskSell 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 ZendeskSell.
-
Connect to Unbounce Data from a Connection Pool in JBoss
Integrate Unbounce into Java servlets: Use the Management Console in JBoss to install the Unbounce JDBC Driver.
-
Perform Batch Operations with MYOB AccountRight Data in Apache NiFi
Connect to MYOB AccountRight and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to API Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live API.
-
Automate Google Ad Manager Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Ad Manager replication to Azure Synapse.
-
How to Easily Query eBay Analytics Data in OpenOffice Base
Connect to eBay Analytics data in OpenOffice Base using the CData ODBC Driver for eBay Analytics and generate reports with live data insights.
-
Build Semantic Layer Views for Airtable Data in APOS Live Data Gateway
Use the CData Connector for Airtable in APOS Live Data Gateway to build Semantic Layer Views for Airtable.
-
Automated Continuous Sugar CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Apache Kafka.
-
View Reports on Real-Time Twitter Ads Data in Power BI Report Server
Use the CData ODBC Driver for Twitter Ads to visualize Twitter Ads in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Live SAP BusinessObjects BI Data in Perplexity MacOS Desktop
Connect to and query live SAP BusinessObjects BI Data in Perplexity Desktop using CData MCP Server.
-
How to Query Live Oracle Eloqua Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Eloqua data in natural language using Python.
-
Create Apollo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Apollo data access from reports, embedded analytics, and more.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory for you.
-
Connect to Guru from Asprova with CData Software ODBC Driver for Guru
This article shows how to connect faster to Guru data from Asprova.
-
Analyze Greenplum Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Pivotal GreenPlum and visualize live Pivotal GreenPlum in Infragistics Reveal.
-
Access Live Slack Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Slack in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Samanage Replication to Vertica
Use CData Sync for automated, continuous, customizable Samanage replication to Vertica.
-
Connect to Real-Time Impala Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Impala and Dataflow to import and use Apache Impala in Power Apps.
-
Use Agno to Talk to Your FHIR 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 FHIR for you.
-
Integrate Cursor with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Cvent from within the editor.