CData Software - Knowledge Base
Recent Articles
-
Integrating LangGraph with Zoho Inventory Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho Inventory data within automated workflows.
-
Automate Office 365 Data Replication to Azure Synapse
Use CData Sync to customize and automate Office 365 data replication to Azure Synapse.
-
How to Connect to Live Excel Online Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Excel Online data without replication.
-
Migrating data from EmailOctopus to Snowflake using CData SSIS Components.
Easily push EmailOctopus data to Snowflake using the CData SSIS Tasks for EmailOctopus and Snowflake.
-
Create Data Visualizations in Cognos BI with Short.io Data
Access Short.io data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to use SQLAlchemy ORM to access Raisers Edge NXT Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Raisers Edge NXT data.
-
Migrating data from Access to Google BigQuery using CData SSIS Components.
Easily push Access data to Google BigQuery using the CData SSIS Tasks for Access and Google BigQuery.
-
Demo: Migrate Data from Salesforce to SharePoint
CData Data Providers offer a wide range of uses, including the ability to migrate data between sources quickly. Download this demo that helps you transfer Salesforce.com data into SharePoint.
-
How to publish and share PDFMonkey Data dashboards with Tableau Server
The CData ODBC driver for PDFMonkey enables you integrate PDFMonkey data into Tableau dashboards.
-
Access Live Bannerbear Data in Excel 365 Online (Excel for the web)
Connect to Bannerbear data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Prepare, Blend, and Analyze Highrise Data in Alteryx Designer (Connect AI)
Build workflows to access live Highrise data for self-service data analytics.
-
Migrating data from CSV to Google BigQuery using CData SSIS Components.
Easily push CSV data to Google BigQuery using the CData SSIS Tasks for CSV and Google BigQuery.
-
Connect to Real-Time Confluence Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Confluence and Dataflow to import and use Confluence data in Power Apps.
-
Connect to Sendwithus Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sendwithus data from Crystal Reports.
-
Access Live Zoho Recruit Data in Coginiti Pro
Connect to and query live Zoho Recruit data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Snowflake Data in Coginiti Pro
Connect to and query live Snowflake data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Zoho Books-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoho Books Data from Zoho Analytics and import live Zoho Books data.
-
How to Query Live ZohoPeople Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoPeople data data in natural language using Python.
-
Getting Started with the CData Python Connector for Qualaroo
Learn to install and license the CData Python Connector and configure a connection to live Qualaroo data.
-
Getting Started with the CData Tableau Connector for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Box Data in JRuby
Create a simple JRuby app with access to live Box data.
-
Bridge Quaderno Connectivity with Apache NiFi
Access and process Quaderno data in Apache NiFi using the CData JDBC Driver.
-
Replicate Optimizely Data in Heroku for Use in Salesforce Connect
Replicate Optimizely data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Databricks Replication to SQLite
Use CData Sync for automated, continuous, customizable Databricks replication to SQLite.
-
Migrating data from Certinia to Snowflake using CData SSIS Components.
Easily push Certinia data to Snowflake using the CData SSIS Tasks for Certinia and Snowflake.
-
How to connect to Pipeline CRM Data in DBVisualizer
Integrate Pipeline CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Webex Replication to SingleStore
Use CData Sync for automated, continuous, customizable Webex replication to SingleStore.
-
Build Gmail-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Gmail data without replication.
-
Create ServiceNow-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ServiceNow Data from Klipfolio and build custom visualizations using live ServiceNow data.
-
Operational Reporting on Jumpseller Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Jumpseller data.
-
Query Live Microsoft OneDrive 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 Microsoft OneDrive data through a conversational interface.
-
Connect to SingleStore Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SingleStore Data and connect to SingleStore data in Akorbi Digital RunMyProcess.
-
Build Semantic Layer Views for Timely Data in APOS Live Data Gateway
Use the CData Connector for Timely in APOS Live Data Gateway to build Semantic Layer Views for Timely data.
-
Access SurveyMonkey Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SurveyMonkey data from HeidiSQL.
-
Perform Batch Operations with SAP SuccessFactors Data in Apache NiFi
Connect to SAP SuccessFactors data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating GitHub Copilot with Procore 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 connect Amazon QuickSight to Campaigner Data
Create a connection to Campaigner data in CData Connect AI and insert Campaigner data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Act-On-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Act-On Data and create custom apps in Mendix.
-
Connect to Discourse Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Discourse and work with Discourse data in your FileMaker application.
-
Connect to Acumatica Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Acumatica Data and connect to Acumatica data in Akorbi Digital RunMyProcess.
-
Connect to QuickBooks Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for QuickBooks Data and connect to QuickBooks data in Akorbi Digital RunMyProcess.
-
Automated Continuous RSS Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable RSS replication to PostgreSQL.
-
Rapidly Develop ZohoExpense-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 ZohoExpense.
-
Validate SAP Ariba Procurement Data with QuerySurge
Access and validate SAP Ariba Procurement data in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Couchbase 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 Couchbase data for you.
-
Integrate Campaigner with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Campaigner with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Campaigner data.
-
Query, Visualize, and Share live SQL Analysis Services Data in Redash
Use CData Connect AI to connect to live SQL Analysis Services data in Redash for querying, visualizing, and sharing.
-
Connect to Dropbox Data in Jaspersoft Studio
Execute SQL to remote Dropbox data in Jaspersoft Studio.
-
Access Live SAP ByDesign Data in Excel 365 Online (Excel for the web)
Connect to SAP ByDesign data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for Mistral AI in MicroStrategy Desktop
Connect to Mistral AI data in MicroStrategy Desktop using the CData Software ODBC Driver for Mistral AI.
-
Connect to ZohoPeople from Asprova with CData Software ODBC Driver for ZohoPeople
This article shows how to connect faster to ZohoPeople data from Asprova.
-
Create Data Visualizations Based On Salesforce Pardot Data in Mode
Use CData Connect AI to connect to Salesforce Pardot Data from Mode and build visualizations using live Salesforce Pardot data.
-
Connect to GitHub Data in HULFT Integrate
Connect to GitHub as a JDBC data source in HULFT Integrate
-
Connect to and Visualize Live Avaza Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Avaza data.
-
Import and Visualize TigerGraph Data in Power View
Create data visualizations based on TigerGraph data in Excel.
-
Connect to Avalara AvaTax Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Avalara AvaTax.
-
Rapidly Develop Oracle SCM-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 Oracle SCM.
-
Access Live HBase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate HBase data into the statistical analysis tools available in SAS JMP. This article shows how to use HBase data in the Graph Builder and Query Builder.
-
Create SAP Fieldglass Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Fieldglass from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating LlamaIndex with Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Greenhouse data in real time.
-
Access Live OnePageCrm Data in AWS Lambda
Connect to live OnePageCrm data in AWS Lambda using the CData JDBC Driver.
-
Consume Jira OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Jira feeds that reflect any changes in SAP Lumira.
-
Access Live Planio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Planio data into the statistical analysis tools available in SAS JMP. This article shows how to use Planio data in the Graph Builder and Query Builder.
-
Visualize Close Data in TIBCO Spotfire through ADO.NET
Integrate Close data into dashboards in TIBCO Spotfire.
-
Analyze Live Odoo Data in SAS Viya
Use CData Connect AI to connect to Odoo data from SAS Viya and deploy self-service analytics using live Odoo data.
-
Explore Geographical Relationships in Smartsheet Data with Power Map
Create data visualizations with Smartsheet data in Power Map.
-
Automated Continuous MarkLogic Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MarkLogic replication to Google BigQuery.
-
Configure the CData JDBC Driver for AdRoll in a Connection Pool in Tomcat
Connect to AdRoll data from a connection pool in Tomcat.
-
Build MVC Applications with Connectivity to Avro Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Avro from an ASP.NET MVC application.
-
Integrate Mocean Data in the Pentaho Report Designer
Publish reports based on Mocean data in the Pentaho BI tool.
-
Connect to Customer.io Data in NetBeans
Connect to Customer.io data in NetBeans with the data source configuration wizard.
-
Connect to SuiteCRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SuiteCRM data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build a Simple VCL Application for Avaza Data
How to build a simple VCL Application to view Avaza data in RAD Studio using the CData ODBC Driver for Avaza.
-
Analyze MongoDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MongoDB data and visualize live MongoDB data in Infragistics Reveal.
-
Build Agents in Relevance AI with Access to Live OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on OData services within intelligent agent workflows.
-
Connect to SAS xpt Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAS xpt.
-
Build Data Flows from CampaignMonitor to SQL Server using SSIS
Easily back up CampaignMonitor data to SQL Server using the SSIS components for CampaignMonitor.
-
Connecting Pipedream with Microsoft Exchange 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 Microsoft Exchange data in real time.
-
Write a Simple Go Application to work with SAP Ariba Procurement Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Ariba Procurement data.
-
Interact with Live Cosmos DB Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Cosmos DB data.
-
Analyze Shortcut Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Shortcut data and visualize live Shortcut data in Infragistics Reveal.
-
Integrating Kiro with CSV 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 Exact Online Data from a Connection Pool in JBoss
Integrate Exact Online data into Java servlets: Use the Management Console in JBoss to install the Exact Online JDBC Driver.
-
Connect to and Visualize Live Azure Synapse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Synapse data.
-
Create AgileCRM-Connected Applications in Appsmith
Connect to AgileCRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to AgileCRM data.
-
Replicate Marketo Data to Multiple Databases via the CData Sync CLI
Replicate Marketo data to disparate databases with a single configuration.
-
A PostgreSQL Interface for Cosmos DB Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect and Query Live Bitbucket Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Bitbucket data into Databricks and enable direct, live querying and analysis without replication.
-
LINQ to LaunchDarkly 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 LaunchDarkly Data Provider.
-
How to create Teradata federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Teradata data in MySQL .
-
Access Live Reply.io Data in Coginiti Pro
Connect to and query live Reply.io data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Kafka Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Kafka data in Airbyte.
-
Connect to Oracle Financials Cloud Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Financials Cloud data from Filemaker Pro on Mac.
-
Connect to CapsuleCRM Data from a Connection Pool in Jetty
The CapsuleCRM JDBC Driver supports connection pooling: This article shows how to connect faster to CapsuleCRM data from Web apps in Jetty.
-
Integrating LangChain with Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Presto data within automated workflows.
-
Connecting Mastra with Salesforce Data 360 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Salesforce Data 360 data, no replication required.
-
Connect to and Visualize Live Marketo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Marketo data.
-
Build Sage Cloud Accounting-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage Cloud Accounting data.
-
Analyze eBay Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of eBay Analytics data and visualize live eBay Analytics data in Infragistics Reveal.