CData Software - Knowledge Base
Recent Articles
-
Integrate HelloSign Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HelloSign data from Informatica Cloud.
-
How to create Visio diagrams from Act-On Data
Automatically update Act-On data with the changes you make to Visio master shapes.
-
Automated Continuous Slack Replication to Databricks
Use CData Sync for automated, continuous, customizable Slack replication to Databricks.
-
Query MYOB AccountRight Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MYOB AccountRight entities in PHP by modeling them as objects.
-
Migrating data from Salesforce CRM Analytics to Snowflake using CData SSIS Components.
Easily push Salesforce CRM Analytics data to Snowflake using the CData SSIS Tasks for Salesforce CRM Analytics and Snowflake.
-
Getting Started with the CData ODBC Driver for Dotmailer
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dotmailer.
-
Access Live BigCommerce 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 BigCommerce data through MCP integration.
-
Create a Data Access Object for ZohoMarketingHub Data using JDBI
A brief overview of creating a SQL Object API for ZohoMarketingHub data in JDBI.
-
Visualize Salesforce Data 360 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 Salesforce Data 360 data into TIBCO Spotfire.
-
Access Pushbullet 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 Pushbullet data.
-
Build AlloyDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for AlloyDB Data and create custom apps in Bubble.
-
Connect to Perplexity Data in NetBeans
Connect to Perplexity data in NetBeans with the data source configuration wizard.
-
How to Connect Flowise AI Agents to Live Greenplum 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 Greenplum data without replication.
-
Connect to Omnisend in SpagoBI
Create reports featuring live Omnisend data in SpagoBI Studio. Host Omnisend reports on SpagoBI Server.
-
Analyze Oracle Financials Cloud Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Financials Cloud from Power Pivot. You will use the Table Import Wizard to load Oracle Financials Cloud data. You can visually build the import query or use any SQL supported by the driver.
-
Build SharePoint-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SharePoint Data from Zoho Analytics and import live SharePoint data.
-
Use Databricks Agent Bricks to Talk to Your Adobe Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Adobe Analytics data for you.
-
Create Instagram-Connected Nintex Workflows
Use CData Connect AI to connect to Instagram Data from Nintex Workflow Cloud and build custom workflows using live Instagram data.
-
Create Informatica Mappings From/To an ODBC Data Source for Miro
Create an ODBC connection to Miro in Informatica and browse and transfer Miro data.
-
Establish a Live Connection with Front Data using Tableau Bridge
The CData ODBC Driver for Front enables you to integrate live Front data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to SAP HANA Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP HANA data.
-
Integrate Dify with Live Twilio Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Twilio data.
-
Integrate Microsoft Entra ID Data in the Pentaho Report Designer
Publish reports based on Microsoft Entra ID data in the Pentaho BI tool.
-
Connect to Oracle Eloqua Reporting Data in RapidMiner
Integrate Oracle Eloqua Reporting data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to DB2 Data from IntelliJ
Integrate connectivity to DB2 data with wizards in IntelliJ.
-
Query SAP ByDesign Data as a MySQL Database in Node.js
Execute MySQL queries against SAP ByDesign data from Node.js.
-
How to work with Reckon Data in Apache Spark using SQL
Access and process Reckon Data in Apache Spark using the CData Software JDBC Driver.
-
How to create Codat federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Codat data in MySQL .
-
How to Connect Typeform 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 Typeform data in real time using natural language.
-
How to Connect to Live SAP Hybris C4C 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 SAP Hybris C4C data without replication.
-
Automated Continuous Bannerbear Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bannerbear replication to MongoDB.
-
Create Productboard Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Productboard data access from reports, embedded analytics, and more.
-
Import Real-Time ServiceNow Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ServiceNow data in ColdFusion.
-
Use the CData Software ODBC Driver for Shortcut in MicroStrategy Web
Connect to Shortcut data in MicroStrategy Web using the CData Software ODBC Driver for Shortcut.
-
How to Connect to Live Egnyte Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Egnyte data securely in real time.
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy
Connect to Greenplum data in MicroStrategy Developer using the CData Software JDBC Driver for Greenplum.
-
Create MarkLogic-Connected Dashboards in Grafana
Connect to MarkLogic Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MarkLogic data.
-
Integrating Boomi Agentstudio with Amazon S3 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Amazon S3 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Apify Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apify data from your Google Sheets.
-
Query Google Ad Manager Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Ad Manager data from Node.js.
-
How to connect to Apollo Data with Squirrel SQL client
Connect to Apollo data and execute queries in the Squirrel SQL Client.
-
Create Datasets from Billsby in Domo Workbench and Build Visualizations of Billsby Data in Domo
Use the CData Software ODBC Driver for Billsby to create datasets from Billsby data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live ADP Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ADP data from your Excel spreadsheets.
-
How to Connect to Live Microsoft Ads 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 Microsoft Ads data without replication.
-
Build Automated BigQuery-Connected Workflows in Zapier
Use CData Connect AI to connect to live BigQuery data and build automated workflows in Zapier.
-
How to connect SharePoint with Act CRM Data through external lists
Provide Act CRM data to SharePoint users as an external list.
-
Automated Continuous Acumatica Replication to SQL Server
Use CData Sync for automated, continuous, customizable Acumatica replication to SQL Server.
-
Automated Continuous SageHR Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SageHR data replication to OneLake in Microsoft Fabric.
-
Automated Continuous QuickBooks Time Replication to MySQL
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to MySQL.
-
Working with BenchmarkEmail Data in LINQPad
Execute LINQ queries to BenchmarkEmail data in LINQPad.
-
Connecting Agentforce with Twilio 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 Twilio data for you.
-
Create Printify-Connected Nintex Workflows
Use CData Connect AI to connect to Printify Data from Nintex Workflow Cloud and build custom workflows using live Printify data.
-
Access Live Tally Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tally data into the statistical analysis tools available in SAS JMP. This article shows how to use Tally data in the Graph Builder and Query Builder.
-
Query ZohoExpense Data in DataGrip
Create a Data Source for ZohoExpense in DataGrip and use SQL to query live ZohoExpense data.
-
A PostgreSQL Interface for Freshteam Data using the CData ODBC Driver
Use the SQL Gateway and Freshteam ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to load Marketo data into Elasticsearch via Logstash
Introducing a simple method to load Marketo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect and Query Live Dynamics CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Dynamics CRM data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to and Query Toggl Data in QlikView over ODBC
Create data visualizations with Toggl data in QlikView.
-
Analyze Discord Data in Cognos Analytics
Use CData Connect AI to connect to Discord Data from Cognos Analytics and analyze live Discord data.
-
Automated Continuous Airtable Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Airtable replication to Google BigQuery.
-
How to Query Live Helpscout Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Helpscout data data in natural language using Python.
-
How to connect PolyBase to Oracle SCM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle SCM data.
-
Build Dashboards with Mocean Data in DBxtra
Create dynamic dashboards and perform analytics based on Mocean data in DBxtra.
-
Automated Continuous ZohoPeople Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Azure SQL Database.
-
How to connect to SFTP Data from IntelliJ
Integrate connectivity to SFTP data with wizards in IntelliJ.
-
Migrating data from Scrapfly to Snowflake using CData SSIS Components.
Easily push Scrapfly data to Snowflake using the CData SSIS Tasks for Scrapfly and Snowflake.
-
Connect to Power BI XMLA in SpagoBI
Create reports featuring live Power BI XMLA data in SpagoBI Studio. Host Power BI XMLA reports on SpagoBI Server.
-
Build Dashboards with Confluence Data in Dundas BI
Create dynamic dashboards and perform analytics based on Confluence data in Dundas BI.
-
Connect to Sybase IQ Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sybase IQ data from Filemaker Pro on Mac.
-
Write a Simple Go Application to work with Mode Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mode data.
-
Automated Continuous Timely Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Timely replication to delimited files (CSV/TSV).
-
Connect to Aircall Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Aircall to connect to Aircall data and execute queries in PowerBuilder.
-
LINQ to Azure DevOps 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 Azure DevOps Data Provider.
-
Use the CData Software ODBC Driver for Retently in MicroStrategy
Connect to Retently data in MicroStrategy Developer using the CData Software ODBC Driver for Retently.
-
Build BambooHR-Connected Apps in Choreo
Use CData Connect AI to connect to BambooHR Data from Choreo and build custom apps using live BambooHR data.
-
Create Datasets from Twitter Ads in Domo Workbench and Build Visualizations of Twitter Ads Data in Domo
Use the CData Software ODBC Driver for Twitter Ads to create datasets from Twitter Ads data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to ZohoExpense Data in DBVisualizer
Integrate ZohoExpense data with visual data analysis tools and data connection wizards in DBVisualizer
-
Stream FHIR Data into Apache Kafka Topics
Access and stream FHIR data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to MailerLite Data from PowerBuilder via JDBC
This article demonstrates how to access MailerLite data from PowerBuilder using the MailerLite JDBC Driver.
-
Connect to Zoom Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoom data.
-
Use the CData ODBC Driver for Airtable from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Airtable to connect to Airtable data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Airtable data in Excel.
-
Connecting Mastra with Reckon Accounts Hosted 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 Reckon Accounts Hosted data, no replication required.
-
Integrate Live Apify Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apify data and integrate live Apify data into apps built in Microsoft Power Apps.
-
Replicate Shopify Data to Multiple Databases
Replicate Shopify data to disparate databases with a point-and-click configuration.
-
Connecting GenSpark with SQL Server Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SQL Server data without any replication or custom integration required.
-
Integrate Instantly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Instantly data from Informatica Cloud.
-
Visualize Live Dynamics 365 Business Central Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Dynamics 365 Business Central data into custom reports in Power BI.
-
Migrating data from Contentful to Snowflake using CData SSIS Components.
Easily push Contentful data to Snowflake using the CData SSIS Tasks for Contentful and Snowflake.
-
Query Customer.io Data in ColdFusion
Write standard ColdFusion data access code to connect to Customer.io data.
-
Integrate Cursor with Live MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MariaDB data from within the editor.
-
Replicate Oracle Eloqua Data in Heroku for Use in Salesforce Connect
Replicate Oracle Eloqua data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Tableau Connector for Google Spanner
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Spanner.
-
Replicate Multiple Exact Online Accounts
Replicate multiple Exact Online accounts to one or many databases.
-
Build Automated Workflows with Live Google Forms Data in Workato
Use CData Connect AI to connect to live Google Forms data and build automated workflows in Workato.
-
Automated Continuous Tickspot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Tickspot replication to Snowflake.
-
Visualize Pinecone Data in TIBCO Spotfire through ADO.NET
Integrate Pinecone data into dashboards in TIBCO Spotfire.
-
Connect to iContact Data in RazorSQL
Connect to iContact from wizards and query iContact data from the GUI in the RazorSQL database management tool.
-
Creating SendGrid-Connected Applications in Unqork
You can use CData Connect AI to feed SendGrid data to Unqork and build custom business apps.
-
Moving Data from Wrike to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Wrike data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Working with Vercel Data in LINQPad
Execute LINQ queries to Vercel data in LINQPad.