CData Software - Knowledge Base
Recent Articles
-
Connecting Pipedream with Dynamics 365 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Dynamics 365 data in real time.
-
Excel Spreadsheet Automation on Basecamp Data with the QUERY Formula
Pull data from Basecamp, automate spreadsheets, and more with the QUERY formula.
-
Consume Oracle Sales OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Sales feeds that reflect any changes in SAP Lumira.
-
Connect to Bugsnag Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bugsnag and the SQL Gateway to access Bugsnag data from Google Apps Script.
-
Creating Wave Financial-Connected Applications in Unqork
You can use CData Connect AI to feed Wave Financial data to Unqork and build custom business apps.
-
Prepare, Blend, and Analyze Impala Data in Alteryx Designer (Connect AI)
Build workflows to access live Impala data for self-service data analytics.
-
Using the CData Software ODBC Driver for Mistral AI in PyCharm
Connect to Mistral AI as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mistral AI.
-
Connect Figshare to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Figshare data using the CData Python MCP Server.
-
Use Agno to Talk to Your Snapchat Ads 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 Snapchat Ads data for you.
-
How to Easily Query FormSite Data in OpenOffice Base
Connect to FormSite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Replicate Multiple ZohoExpense Accounts via the CData Sync CLI
Replicate multiple ZohoExpense accounts to one or many databases.
-
Rootly Reporting in OBIEE with the Rootly JDBC Driver
Deploy the Rootly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize ClickTime 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 ClickTime data into TIBCO Spotfire.
-
Getting Started with the CData Excel Add-In for Vercel
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vercel.
-
Connect to Omnisend Data in HULFT Integrate
Connect to Omnisend as a JDBC data source in HULFT Integrate
-
Connect to Google Cloud Storage Data in RapidMiner
Integrate Google Cloud Storage data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live Google Drive Data in AWS Lambda
Connect to live Google Drive data in AWS Lambda using the CData JDBC Driver.
-
How to Query Live Neo4J Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Neo4J data data in natural language using Python.
-
How to create Presto federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Presto data in MySQL .
-
Automate Oracle HCM Cloud Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle HCM Cloud data from PowerShell? This article demonstrates how to utilize the Oracle HCM Cloud Cmdlets for tasks like connecting to Oracle HCM Cloud data, automating operations, downloading data, and more.
-
Access Live Salesforce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce data from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for Reply.io in MicroStrategy
Connect to Reply.io data in MicroStrategy Developer using the CData Software JDBC Driver for Reply.io.
-
Connect to Qualaroo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Qualaroo data in the Denodo Virtual DataPort Administrator.
-
Analyze Teamgate Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Teamgate data with the CData JDBC Driver for Teamgate.
-
Connect to Pinterest Data from AWS Glue
Use CData Connect AI to gain access to live Pinterest data from your AWS Glue jobs.
-
Integrating Antigravity CLI with Facebook Ads data via CData CLI
Connect Facebook Ads data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Nethunt-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Nethunt data and build web apps with connectivity to live Nethunt data.
-
How to Connect to Live Dynamics NAV 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 Dynamics NAV data through natural language.
-
Bidirectional Access to Certinia Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Certinia data in Filemaker Pro for Mac or Windows.
-
Object-Relational Mapping (ORM) with Microsoft Teams 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 Microsoft Teams data into a Java-based ORM framework, Hibernate.
-
How to work with JobNimbus Data in Apache Spark using SQL
Access and process JobNimbus Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Gorgias Replication to MySQL
Use CData Sync for automated, continuous, customizable Gorgias replication to MySQL.
-
Create Google Drive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Drive from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind SAP Fieldglass Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Fieldglass with the DevExpress Windows Forms and Web controls to provide SAP Fieldglass data to a chart.
-
Connect to Blackbaud FE NXT Data in Google Apps Script via Connect AI
Use CData Connect AI to access Blackbaud FE NXT data in Google Apps Script.
-
Connect to Codat Data in DBArtisan
Use wizards in DBArtisan to configure Codat data as a data source.
-
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.
-
Build Voice Agents in ElevenLabs with access to Live Freshservice Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Freshservice data.
-
Bridge Coda Connectivity with Apache NiFi
Access and process Coda data in Apache NiFi using the CData JDBC Driver.
-
Pinecone Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pinecone facts in real time.
-
Integrate with Box Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Box data to a JSON file on disk.
-
Access Live Twilio Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Twilio data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to ShipEngine from a Connection Pool in WebLogic
Use the CData JDBC Driver for ShipEngine to connect to ShipEngine data from Web applications running on WebLogic.
-
How to work with Zoho CRM Data in Apache Spark using SQL
Access and process Zoho CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Build Semantic Layer Views for Missive Data in APOS Live Data Gateway
Use the CData Connector for Missive in APOS Live Data Gateway to build Semantic Layer Views for Missive data.
-
Connect to Humanity Data from PowerBuilder via JDBC
This article demonstrates how to access Humanity data from PowerBuilder using the Humanity JDBC Driver.
-
How to Access Office 365 Data Using Entity Framework
This article shows how to access Office 365 data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Service Cloud Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Service Cloud data to SQL Server.
-
How to Connect to Templated Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Templated data. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Onfleet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Onfleet data to a JSON file on disk.
-
Build Voice Agents in ElevenLabs with access to Live Act-On Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Act-On data.
-
Integrating Kiro with Presto 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 Apps with Live JSON services in Adalo using CData Connect AI
Use CData Connect AI to integrate live JSON services into the Adalo platform and build custom mobile and web applications with real-time JSON services.
-
Build a Singer.io Tap for Spotify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Spotify data using the CData Python Connector.
-
Connect to Planio Data in RazorSQL
Connect to Planio from wizards and query Planio data from the GUI in the RazorSQL database management tool.
-
Connect to and Visualize Live Teamgate Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Teamgate data.
-
Use Dash to Build to Web Apps on Salesforce Marketing Data
Create Python applications that use pandas and Dash to build Salesforce Marketing-connected web apps.
-
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 SAP Hybris C4C in SpagoBI
Create reports featuring live SAP Hybris C4C data in SpagoBI Studio. Host SAP Hybris C4C reports on SpagoBI Server.
-
Build Data Flows from Salesforce Marketing to SQL Server using SSIS
Easily back up Salesforce Marketing data to SQL Server using the SSIS components for Salesforce Marketing.
-
Analyze Live Redis Data in SAS Viya
Use CData Connect AI to connect to Redis data from SAS Viya and deploy self-service analytics using live Redis data.
-
Working with Missive Data in LINQPad
Execute LINQ queries to Missive data in LINQPad.
-
Integrating LangGraph with RSS Feeds via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on RSS feeds within automated workflows.
-
Access Live Timely Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Timely data into the statistical analysis tools available in SAS JMP. This article shows how to use Timely data in the Graph Builder and Query Builder.
-
How to Connect DBeaver to HubSpot via a JDBC Driver
Manage HubSpot data with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Landbot
Provide connectivity to Landbot data through an SAP BusinessObjects universe.
-
Automated Continuous MarkLogic Replication to Vertica
Use CData Sync for automated, continuous, customizable MarkLogic replication to Vertica.
-
Connect to MailerSend Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MailerSend data using standard SQL.
-
Create Power BI Reports on Real-Time Close Data
Use the CData ODBC Driver for Close to visualize Close data in Power BI Desktop.
-
Build MVC Applications with Connectivity to Salesforce CRM Analytics Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesforce CRM Analytics from an ASP.NET MVC application.
-
Publish Crystal Reports on ServiceDesk Plus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ServiceDesk Plus data.
-
Access Live Bannerbear Data in Coginiti Pro
Connect to and query live Bannerbear data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Google Directory Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Directory replication to Snowflake.
-
DataBind Controls to SFTP Data in C++Builder
DataBind to SFTP data in C++Builder with standard components and controls.
-
Visualize Onfleet Data in TIBCO Spotfire through ADO.NET
Integrate Onfleet data into dashboards in TIBCO Spotfire.
-
ETL RSS in Oracle Data Integrator
This article shows how to transfer RSS feeds into a data warehouse using Oracle Data Integrator.
-
Build MVC Applications with Connectivity to Billsby Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Billsby from an ASP.NET MVC application.
-
Stream ShipStation Data into Apache Kafka Topics
Access and stream ShipStation data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Factorial Data in Sisense
Create an ElastiCube in Sisense app with access to Factorial data.
-
Connect Salesforce Marketing Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesforce Marketing data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Coda Data as a MySQL Database in Node.js
Execute MySQL queries against Coda data from Node.js.
-
Automated Continuous Ontraport Replication to SQLite
Use CData Sync for automated, continuous, customizable Ontraport replication to SQLite.
-
ETL Bannerbear in Oracle Data Integrator
This article shows how to transfer Bannerbear data into a data warehouse using Oracle Data Integrator.
-
How to Work with GraphQL Data in AWS Glue Jobs Using JDBC
Connect to GraphQL from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Dashboards with HelloSign Data in Dundas BI
Create dynamic dashboards and perform analytics based on HelloSign data in Dundas BI.
-
Migrating data from Google Ad Manager to Databricks using CData SSIS Components.
Easily push Google Ad Manager data to Databricks using the CData SSIS Tasks for Google Ad Manager and Databricks.
-
Connect to xBase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for xBase to connect to xBase data and execute queries in PowerBuilder.
-
Create Reports from Slack Data in Looker Studio
Use CData Connect AI to gain access to live Slack data and create custom reports in Looker Studio.
-
Connect RSS to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect RSS with IBM WebSphere for seamless data integration and connectivity.
-
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 integrate Azure Analysis Services with Apache Airflow
Access and process Azure Analysis Services data in Apache Airflow using the CData JDBC Driver.
-
Visualize ConvertKit Data in Tableau
The CData ODBC driver for ConvertKit enables you integrate ConvertKit data into Tableau dashboards.
-
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.
-
Use Databricks Agent Bricks to Talk to Your AgileCRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your AgileCRM data for you.
-
Access Live Salesforce Data 360 Data in Coginiti Pro
Connect to and query live Salesforce Data 360 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Exa Data Using Azure Data Factory
Use CData Connect AI to connect to Exa Data from Azure Data Factory and import live Exa data.
-
Publish Guru-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Guru data.
-
Integrating Kiro with Coinbase 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 Google Calendar Data in NetBeans
Connect to Google Calendar data in NetBeans with the data source configuration wizard.