CData Software - Knowledge Base
Recent Articles
-
Integrating LangChain with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sugar CRM data within automated workflows.
-
Integrate Sybase Data into Power Automate Desktop using CData Connect
CData Connect for Sybase Data enables you to integrate Sybase data into workflows built using Microsoft Power Automate Desktop.
-
Enable the Bugsnag JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bugsnag data.
-
Integrate Cursor with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce Pardot data from within the editor.
-
Work with Google Forms Data in FoxPro
Load Google Forms data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to and Query ZendeskSell Data in QlikView over ODBC
Create data visualizations with ZendeskSell data in QlikView.
-
Connect to Oracle Service Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle Service Cloud data in Jaspersoft Studio.
-
How to use SQLAlchemy ORM to access VWO Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of VWO data.
-
Use Biml to Build SSIS Tasks to Replicate Bitbucket Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bitbucket data to SQL Server.
-
Build AI Agents with Toggl 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 Toggl data through CData Connect AI.
-
How to use SQLAlchemy ORM to access Splunk Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Splunk data.
-
Write a Simple Go Application to work with Azure Table Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Table data.
-
Connect to Gorgias Data in CloverDX (formerly CloverETL)
Transfer Gorgias data using the visual workflow in the CloverDX data integration tool.
-
Connect to Google Spanner Data in RapidMiner
Integrate Google Spanner data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live ActiveCampaign Data in TIBCO Data Virtualization
Use the ActiveCampaign Tibco DV Adapter to create a ActiveCampaign data data source in TIBCO Data Virtualization Studio and gain access to live ActiveCampaign data from your TDV Server.
-
Query Rootly Data in DataGrip
Create a Data Source for Rootly in DataGrip and use SQL to query live Rootly data.
-
Connect to Typeform Data in DBArtisan
Use wizards in DBArtisan to configure Typeform data as a data source.
-
Connect to Couchbase Data in HULFT Integrate
Connect to Couchbase as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Tableau Connector for HubSpot
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HubSpot.
-
Connect to Email Data in ACL Analytics
Connect to Email data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Email data.
-
Integrate Live PayPal Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PayPal data to Blue Prism using the CData ODBC Driver for PayPal to create automated workflows for repetitive business tasks.
-
Integrate Live Active Directory Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Active Directory from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Active Directory data.
-
Bugsnag Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bugsnag facts in real time.
-
Getting Started with the CData SSIS Components for AlloyDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AlloyDB.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy
Connect to Google Sheets data in MicroStrategy Developer using the CData Software JDBC Driver for Google Sheets.
-
Integrate Todoist Data in the Pentaho Report Designer
Publish reports based on Todoist data in the Pentaho BI tool.
-
Work with Mistral AI Data in FoxPro
Load Mistral AI data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Float Data from IntelliJ
Integrate connectivity to Float data with wizards in IntelliJ.
-
Automated Continuous QuickBooks Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks replication to MongoDB.
-
Connect to ClickUp Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ClickUp data.
-
Access Live Twitter Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twitter Ads data from your Excel spreadsheets.
-
Integrating GitHub Copilot with GitHub 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.
-
Provide OData Services of Sugar CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sugar CRM data by developing a WCF Service Application.
-
Moving Data from Power BI XMLA to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Power BI XMLA data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Operational Reporting on Facebook Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Facebook Ads data.
-
Automate HelloSign Data Replication to Azure Data Lake
Use CData Sync to customize and automate HelloSign data replication to Azure Data Lake.
-
Access Live PolarTeamPro Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PolarTeamPro data into the statistical analysis tools available in SAS JMP. This article shows how to use PolarTeamPro data in the Graph Builder and Query Builder.
-
Connect to Sage 300 Data in CloverDX (formerly CloverETL)
Transfer Sage 300 data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous MySQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MySQL replication to Google BigQuery.
-
Build Humanity-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Humanity data and build web apps with connectivity to live Humanity data.
-
Use Dash to Build to Web Apps on HubSpot Data
Create Python applications that use pandas and Dash to build HubSpot-connected web apps.
-
Access Live CockroachDB 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 CockroachDB data through MCP integration.
-
Visualize Power BI XMLA Data in Sisense
Create an ElastiCube in Sisense app with access to Power BI XMLA data.
-
Build PolarTeamPro-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PolarTeamPro data.
-
Integrating Dataiku with Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Exa data.
-
Connect to Oracle Sales Data in Jaspersoft Studio
Execute SQL to remote Oracle Sales data in Jaspersoft Studio.
-
Visualize Twitter Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Twitter Ads data.
-
Visualize Live Optimizely Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Optimizely data into custom reports in Power BI.
-
Connect to Landbot Data in DBeaver
Use the CData ODBC Driver to connect to Landbot data in DBeaver.
-
Seamlessly Bring ZohoPeople Data into Retool Using CData Connect AI
Integrate ZohoPeople data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Automated Workflows with Live Quickbase Data in Workato
Use CData Connect AI to connect to live Quickbase data and build automated workflows in Workato.
-
Integrating Claude Code with Cloudant Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Cloudant data within assisted coding and automated development workflows.
-
Create Adobe Experience Manager-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Experience Manager Data from OutSystems and build custom enterprise apps using live Adobe Experience Manager data.
-
Use Dash to Build to Web Apps on Stack Exchange Data
Create Python applications that use pandas and Dash to build Stack Exchange-connected web apps.
-
Connect to ActiveCampaign Data from a Connection Pool in Jetty
The ActiveCampaign JDBC Driver supports connection pooling: This article shows how to connect faster to ActiveCampaign data from Web apps in Jetty.
-
Connect to Avaza Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Avaza.
-
Create Data Visualizations in Cognos BI with XML Data
Access XML data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Salesforce Marketing Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Databricks.
-
Connect to Avalara AvaTax Data from a Connection Pool in JBoss
Integrate Avalara AvaTax data into Java servlets: Use the Management Console in JBoss to install the Avalara AvaTax JDBC Driver.
-
How to Easily Query Redshift Data in OpenOffice Base
Connect to Redshift data in OpenOffice Base using the CData ODBC Driver for Redshift and generate reports with live data insights.
-
Validate Dynamics 365 Data with QuerySurge
Access and validate Dynamics 365 data in QuerySurge using the CData JDBC Driver.
-
How to update Kintone from Excel
This article explains how to transfer data from Excel to Kintone using the Excel Add-In for Kintone.
-
Connect to and Query Invoiced Data in QlikView over ODBC
Create data visualizations with Invoiced data in QlikView.
-
Connect to QuickBooks Data from PowerBuilder
This article demonstrates how to access QuickBooks data from PowerBuilder using the CData ADO.NET Provider for QuickBooks.
-
Migrating data from Workable to Snowflake using CData SSIS Components.
Easily push Workable data to Snowflake using the CData SSIS Tasks for Workable and Snowflake.
-
Object-Relational Mapping (ORM) with SAP Ariba Procurement 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 SAP Ariba Procurement data into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Google Sheets Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Sheets data for you.
-
Build Apps with Live Google Spanner data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Spanner data into the Adalo platform and build custom mobile and web applications with real-time Google Spanner data.
-
Choosing the Best Method to Connect Office 365 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Office 365 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to work with Office 365 Data in Apache Spark using SQL
Access and process Office 365 Data in Apache Spark using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time SuiteCRM Data
Use the CData ODBC Driver for SuiteCRM to visualize SuiteCRM data in Power BI Desktop.
-
Use Manus AI to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Outreach.io data.
-
Replicate Microsoft Ads Data to Multiple Databases
Replicate Microsoft Ads data to disparate databases with a point-and-click configuration.
-
Connect to Datadog Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Datadog.
-
How to Connect to & Open Snowflake Data in Microsoft Excel
This article uses the CData ODBC driver for Snowflake to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate with ElevenLabs Data in JReport Designer
Create charts and reports based on ElevenLabs data in JReport Designer.
-
Model, Search, and Visualize Live SAP Fieldglass Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Fieldglass data for modeling, searching, and visualizing.
-
Create Apps from Freshteam Data in Qlik Sense Cloud
Use CData Connect AI to connect to Freshteam Data and build apps from live Freshteam data in Qlik Sense Cloud.
-
Getting Started with the CData Power BI Connector for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MYOB AccountRight.
-
Integrating Claude Code CLI with Google Directory 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.
-
Integrate ChargeOver Data in Pentaho Data Integration
Build ETL pipelines based on ChargeOver data in the Pentaho Data Integration tool.
-
How to Access Live Google Spanner Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Spanner enables you to integrate Google Spanner data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ODBC Driver for Printify
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Printify.
-
How to integrate Helpscout with Apache Airflow
Access and process Helpscout data in Apache Airflow using the CData JDBC Driver.
-
Build PolarTeamPro-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live PolarTeamPro data and build PolarTeamPro-connected web apps with Axios.
-
Automated Continuous SparkPost Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SparkPost replication to Azure SQL Database.
-
Analyze Twilio Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Twilio data and visualize live Twilio data in Infragistics Reveal.
-
Replicate Oracle Eloqua Reporting Data in Heroku for Use in Salesforce Connect
Replicate Oracle Eloqua Reporting data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous MailerLite Replication to Vertica
Use CData Sync for automated, continuous, customizable MailerLite replication to Vertica.
-
Publish Crystal Reports on Teamgate Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teamgate data.
-
How to Connect to & Open Instantly Data in Microsoft Excel
This article uses the CData ODBC driver for Instantly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect and process Kafka data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Kafka data.
-
Viewing Confluence Data in RAD Studio Data Explorer
How to view Confluence data in RAD Studio Data Explorer using the CData ODBC Driver for Confluence.
-
Natively Connect to Jira Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Jira data. Leverage the native support for ODBC in PHP.
-
How to connect and process ZohoSubscriptions data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZohoSubscriptions data.
-
Automated Continuous OData Replication to Snowflake
Use CData Sync for automated, continuous, customizable OData replication to Snowflake.
-
Connect to Live Sugar CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Sugar CRM Data in CData Connect AI and connect to your Sugar CRM data from MicroStrategy.
-
Connect Egnyte Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Egnyte data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize SAP Data in Sisense
Create an ElastiCube in Sisense app with access to SAP data.
-
Use Biml to Build SSIS Tasks to Replicate Templated Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Templated data to SQL Server.