CData Software - Knowledge Base
Recent Articles
-
Link AgileCRM with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AgileCRM data in Filemaker Pro for Mac or Windows.
-
Build Agents in Relevance AI with Access to Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Cloudant data within intelligent agent workflows.
-
ETL ShipStation in Oracle Data Integrator
This article shows how to transfer ShipStation data into a data warehouse using Oracle Data Integrator.
-
How to Connect to & Open SAP Business Warehouse Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Business Warehouse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Provide OData Services of Access Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Access data by developing a WCF Service Application.
-
How to connect Amazon QuickSight to Amazon S3 Data
Create a connection to Amazon S3 data in CData Connect AI and insert Amazon S3 data into Amazon QuickSight SPICE to build interactive dashboards.
-
Model MongoDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MongoDB, enabling the direct import of real-time MongoDB data.
-
Build ServiceNow-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ServiceNow data and build ServiceNow-connected web apps with Axios.
-
Use the CData Software JDBC Driver for Klipfolio in MicroStrategy Desktop
Connect to Klipfolio data in MicroStrategy Desktop using the CData Software JDBC Driver for Klipfolio.
-
How to connect PolyBase to Cassandra
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Cassandra data.
-
How to Connect to Live Neo4J Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Neo4J data for you.
-
How to Query Live Discourse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Discourse data data in natural language using Python.
-
How to create Testmonitor federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Testmonitor data in MySQL .
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy Web
Connect to Greenplum data in MicroStrategy Web using the CData Software JDBC Driver for Greenplum.
-
Enable the Vault CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Vault CRM data.
-
Build Apps with Live Typeform data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Typeform data into the Adalo platform and build custom mobile and web applications with real-time Typeform data.
-
Getting Started with the CData Python Connector for WordPress
Learn to install and license the CData Python Connector and configure a connection to live WordPress data.
-
Build Egnyte-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Egnyte Data and create custom apps in Bubble.
-
Use JayDeBeApi to access Trello Data in Python
Use standard Python scripting and the development environment of your choice to access live Trello data.
-
Integrating LangChain with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Elasticsearch data within automated workflows.
-
Replicate Front Data in Heroku for Use in Salesforce Connect
Replicate Front data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Salesloft Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesloft Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Google's Vertex AI Agent with Live Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Sage 300 data within intelligent workflows.
-
Integrate CloudConvert with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CloudConvert with External Services.
-
Use the CData ODBC Driver for MessageBird from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MessageBird to connect to MessageBird data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MessageBird data in Excel.
-
Create SAS Data Sets-Connected Nintex Workflows
Use CData Connect AI to connect to SAS Data Sets Data from Nintex Workflow Cloud and build custom workflows using live SAS Data Sets data.
-
Build MVC Applications with Connectivity to Pipeline CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pipeline CRM from an ASP.NET MVC application.
-
Build Apps with Live Xero Data Using the Low-Code Development Platform of Mendix
Connect Xero data with Mendix to build apps using the CData JDBC Driver for Xero.
-
Automated Continuous Twitter Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Twitter Ads replication to SQLite.
-
Back Up Jira data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Jira. In this article, we will employ an SSIS workflow to populate a database with Jira data data.
-
How to Visualize SQL Analysis Services Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SQL Analysis Services data in Python.
-
Create Data Visualizations Based On Excel Online Data in Mode
Use CData Connect AI to connect to Excel Online Data from Mode and build visualizations using live Excel Online data.
-
Integrating Codex with Hubstaff 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.
-
Create HubSpot-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to HubSpot Data from OutSystems and build custom enterprise apps using live HubSpot data.
-
Deploy the ADO.NET Provider for Egnyte on an SSRS Report Server
Connect to Egnyte 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.
-
Integrate Azure Synapse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure Synapse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Synapse data.
-
Automated Continuous SAP Concur Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Concur replication to SingleStore.
-
dbt Core Transformations with CData Sync
CData Sync supports integration with dbt Core, allowing users to develop, control, and run transformations in a supported destination database.
-
Query Salesforce Data in DataGrip
Create a Data Source for Salesforce in DataGrip and use SQL to query live Salesforce data.
-
Create Dashboards and Visualize Live SharePoint Data in Geckoboard
Use CData Connect AI to connect to live SharePoint data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous OneNote Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable OneNote replication to Apache Kafka.
-
Build Pipelines with Live Avalara AvaTax Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Avalara AvaTax from Google Cloud Data Fusion, enabling the integration of live Avalara AvaTax data into the building and management of effective data pipelines.
-
How to integrate Metabase with MarkLogic Data
Use CData Connect AI to connect to live MarkLogic data and create an interactive dashboard in Metabase from MarkLogic data.
-
Integrate Cursor with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Smartsheet data from within the editor.
-
Integrate Quickbase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Quickbase with External Services.
-
Build a Simple VCL Application for ServiceNow Data
How to build a simple VCL Application to view ServiceNow data in RAD Studio using the CData ODBC Driver for ServiceNow.
-
Integrating Cursor with Google Sheets 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 LDAP Objects in NetBeans
Connect to LDAP objects in NetBeans with the data source configuration wizard.
-
Connect to Okta in SpagoBI
Create reports featuring live Okta data in SpagoBI Studio. Host Okta reports on SpagoBI Server.
-
Automated Continuous HCL Domino Replication to SingleStore
Use CData Sync for automated, continuous, customizable HCL Domino replication to SingleStore.
-
Visualize Live SQL Analysis Services Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SQL Analysis Services data into custom reports in Power BI.
-
Use the CData Software ODBC Driver for Dropbox in MicroStrategy Web
Connect to Dropbox data in MicroStrategy Web using the CData Software ODBC Driver for Dropbox.
-
Integrating Codex with Authorize.Net 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 Gmail in SpagoBI
Create reports featuring live Gmail data in SpagoBI Studio. Host Gmail reports on SpagoBI Server.
-
Bridge Greenhouse Connectivity with Apache NiFi
Access and process Greenhouse data in Apache NiFi using the CData JDBC Driver.
-
How to Build an ETL App for RabbitMQ Data in Python with CData
Create ETL applications and real-time data pipelines for RabbitMQ data in Python with petl.
-
Connect to Microsoft Planner Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Planner data.
-
Build VWO-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for VWO Data and create custom apps in Mendix.
-
Prepare, Blend, and Analyze LinkedIn Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live LinkedIn Ads data for self-service data analytics.
-
Automated Continuous Todoist Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Todoist replication to Amazon Redshift.
-
Getting Started with the CData ODBC Driver for Presto
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Presto.
-
Query Wistia Data in ColdFusion
Write standard ColdFusion data access code to connect to Wistia data.
-
Connect to Browserless Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Browserless and the SQL Gateway to access Browserless data from Google Apps Script.
-
Access Live CSV Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate CSV data into the statistical analysis tools available in SAS JMP. This article shows how to use CSV data in the Graph Builder and Query Builder.
-
DataBind Charts to FreeAgent Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FreeAgent 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.
-
Automated Continuous PolarTeamPro Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Amazon S3.
-
Query Basecamp Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Basecamp data from Node.js.
-
Visualize Oracle Financials Cloud Data in Tableau
The CData ODBC driver for Oracle Financials Cloud enables you integrate Oracle Financials Cloud data into Tableau dashboards.
-
Create Dynamic EmailOctopus Grids Using the Infragistics XamDataGrid
Learn how you can connect EmailOctopus to Infragistics XamDataGrid to build dynamic grids.
-
How to Visualize Apollo Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Apollo data in Python.
-
Publish Reports with Procore Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Procore data.
-
Integrating LlamaIndex with BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on BenchmarkEmail data in real time.
-
Create SSAS Tabular Models from SQL Analysis Services Data
How to build a SQL Server Analysis Service Tabular Model from SQL Analysis Services data using CData drivers.
-
Use Databricks Agent Bricks to Talk to Your Dynamics 365 Business Central Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dynamics 365 Business Central data for you.
-
Connect to Freshteam Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshteam data.
-
Automated Continuous Testmonitor Replication to Snowflake
Use CData Sync for automated, continuous, customizable Testmonitor replication to Snowflake.
-
How to connect to Confluence Data in DBVisualizer
Integrate Confluence data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Wrike Replication to Oracle
Use CData Sync for automated, continuous, customizable Wrike replication to Oracle.
-
Create Egnyte-Connected Business Apps in AppSheet
Connect to Egnyte Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Egnyte data.
-
How to Connect to Live HubSpot 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 HubSpot data through natural language.
-
Connect to Redis in SpagoBI
Create reports featuring live Redis data in SpagoBI Studio. Host Redis reports on SpagoBI Server.
-
How to create an RPA flow for Azure Synapse Data in UiPath Studio
Use the Azure Synapse ODBC Driver to create workflows that access real-time Azure Synapse data without any coding.
-
Automated ChartMogul Data Replication to Teradata
Use CData Sync to Customize and automate ChartMogul data replication to Teradata.
-
Automated Continuous Exa Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Exa replication to Google BigQuery.
-
Integrate LibreChat with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Act CRM data from within the chat interface.
-
How to Query Flowlu Data in MySQL Workbench
Execute MySQL queries against live Flowlu data from MySQL Workbench.
-
Manage HubDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HubDB.
-
Access Live Outreach.io Data in AWS Lambda
Connect to live Outreach.io data in AWS Lambda using the CData JDBC Driver.
-
Build Agents in Relevance AI with Access to Live ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ServiceDesk Plus data within intelligent agent workflows.
-
Create Mailgun-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Mailgun Data from Klipfolio and build custom visualizations using live Mailgun data.
-
Connect to Zoho Inventory Data in Jaspersoft Studio
Execute SQL to remote Zoho Inventory data in Jaspersoft Studio.
-
Analyze Live Aweber Data in SAS Viya
Use CData Connect AI to connect to Aweber data from SAS Viya and deploy self-service analytics using live Aweber data.
-
Access Live LinkedIn Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn data from your Google Sheets.
-
Build AI Agents with Anaplan Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Anaplan data through CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Snowflake
Provide connectivity to Snowflake data through an SAP BusinessObjects universe.
-
Create Reports from Square Data in Looker Studio
Use CData Connect AI to gain access to live Square data and create custom reports in Looker Studio.
-
Getting Started with the CData Python Connector for Mocean
Learn to install and license the CData Python Connector and configure a connection to live Mocean data.
-
Connect to SparkPost Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SparkPost data.
-
Access Live Shortcut Data in Coginiti Pro
Connect to and query live Shortcut data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live MariaDB 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 MariaDB data through MCP integration.