CData Software - Knowledge Base
Recent Articles
-
Connect to PayPal Data from Crystal Reports
Use CData Connect AI to connect to and report on live PayPal data from Crystal Reports.
-
A PostgreSQL Interface for Printful Data using the CData ODBC Driver
Use the SQL Gateway and Printful ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations Based On Square Data in Mode
Use CData Connect AI to connect to Square Data from Mode and build visualizations using live Square data.
-
Getting Started with the CData SSIS Components for Monday.com
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Monday.com.
-
Getting Started with the CData ADO.NET Provider for Outlook
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Power BI Reports on Real-Time Notion Data
Use the CData ODBC Driver for Notion to visualize Notion data in Power BI Desktop.
-
Connect to Sendwithus Data from a Connection Pool in Jetty
The Sendwithus JDBC Driver supports connection pooling: This article shows how to connect faster to Sendwithus data from Web apps in Jetty.
-
Work with SQL Analysis Services Data in FoxPro
Load SQL Analysis Services data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Work with GitLab Data in ETL Validator JDBC
Connect to GitLab from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Redis Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Redis data for you.
-
Prepare, Blend, and Analyze Vimeo Data in Alteryx Designer (ODBC)
Build workflows to access live Vimeo data for self-service data analytics.
-
Use JayDeBeApi to access Mailgun Data in Python
Use standard Python scripting and the development environment of your choice to access live Mailgun data.
-
Build Automated Authorize.Net-Connected Workflows in Zapier
Use CData Connect AI to connect to live Authorize.Net data and build automated workflows in Zapier.
-
Build Visualizations of Helpscout Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Helpscout data in Birst.
-
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.
-
LINQ to Mistral AI 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 Mistral AI Data Provider.
-
Create Data Visualizations in Cognos BI with Databricks Data
Access Databricks data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect Amazon QuickSight to Testmonitor Data
Create a connection to Testmonitor data in CData Connect AI and insert Testmonitor data into Amazon QuickSight SPICE to build interactive dashboards.
-
GraphQL Reporting in OBIEE with the GraphQL JDBC Driver
Deploy the GraphQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Access Replication to Oracle
Use CData Sync for automated, continuous, customizable Access replication to Oracle.
-
Automated Continuous Raisers Edge NXT Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Raisers Edge NXT data replication to OneLake in Microsoft Fabric.
-
Visualize Facebook Data in TIBCO Spotfire through ADO.NET
Integrate Facebook data into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To a JDBC Data Source for Amazon S3
Create Amazon S3 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to ZohoMarketingHub Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoMarketingHub to connect to ZohoMarketingHub data and execute queries in PowerBuilder.
-
Connect to Gorgias Data in CloverDX (formerly CloverETL)
Transfer Gorgias data using the visual workflow in the CloverDX data integration tool.
-
Use Microsoft Copilot Studio to talk to your Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Shippo data for you.
-
Integrating Oracle Data in Talend Cloud Data Management Platform
Connect Oracle Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle.
-
How to Query Microsoft Entra ID Data in MySQL Workbench
Execute MySQL queries against live Microsoft Entra ID data from MySQL Workbench.
-
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.
-
Analyze Samanage Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Samanage data with the CData JDBC Driver for Samanage.
-
Build Charts with Timely Data in Clear Analytics
Create dynamic charts and perform analytics based on Timely data in Clear Analytics.
-
Connect to Okta Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Okta data in Airbyte.
-
Connect to Couchbase Data in HULFT Integrate
Connect to Couchbase as a JDBC data source in HULFT Integrate
-
How to integrate Metabase with Dropbox Data
Use CData Connect AI to connect to live Dropbox data and create an interactive dashboard in Metabase from Dropbox data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Asana
Provide connectivity to Asana data through an SAP BusinessObjects universe.
-
Automate Accelo Data Replication to Azure Synapse
Use CData Sync to customize and automate Accelo data replication to Azure Synapse.
-
Use Biml to Build SSIS Tasks to Replicate SurveyMonkey Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SurveyMonkey data to SQL Server.
-
LINQ to Access 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 Access Data Provider.
-
Use Manus AI to Talk to Your SAP HANA 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 SAP HANA data.
-
Access Live QuickBooks Time 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 QuickBooks Time data through MCP integration.
-
Integrate Todoist Data in the Pentaho Report Designer
Publish reports based on Todoist data in the Pentaho BI tool.
-
Integrating GitHub Copilot with Adobe Commerce 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 to Planio Data from IntelliJ
Integrate connectivity to Planio data with wizards in IntelliJ.
-
Create SSAS Tabular Models from Clio Data
How to build a SQL Server Analysis Service Tabular Model from Clio data using CData drivers.
-
Connect to Tally Data in CloverDX (formerly CloverETL)
Transfer Tally data using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot with Zoho Projects 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.
-
Publish Neo4J-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Neo4J data.
-
Connect to Reckon Accounts Hosted Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon Accounts Hosted data.
-
Integrate Live Zoho Creator Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Creator from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Creator data.
-
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.
-
Automated Continuous ZohoInvoice Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to SQLite.
-
Viewing Templated Data in RAD Studio Data Explorer
How to view Templated data in RAD Studio Data Explorer using the CData ODBC Driver for Templated.
-
Connect to SageHR from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SageHR data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Databricks Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Databricks data in Microsoft R Open.
-
Automated Continuous MySQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MySQL replication to Google BigQuery.
-
Integrate Devin with Live AgileCRM Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live AgileCRM data.
-
Access Live Adobe Commerce 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 Adobe Commerce data through MCP integration.
-
How to Connect Flowise AI Agents to Live Guru 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 Guru data without replication.
-
Connect to Discourse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Discourse.
-
Automated Continuous Omnisend Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Omnisend replication to Amazon S3.
-
Integrate Google's Vertex AI Agent with Live Redshift 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 Redshift data within intelligent workflows.
-
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.
-
Create Power BI Reports on Real-Time Okta Data
Use the CData ODBC Driver for Okta to visualize Okta data in Power BI Desktop.
-
Rapidly Develop Azure Analysis Services-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 Azure Analysis Services.
-
Connect Front to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Front with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Eventbrite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Eventbrite replication to Amazon Redshift.
-
Automated Continuous Mailgun Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mailgun replication to Google BigQuery.
-
How to work with Retently Data in Apache Spark using SQL
Access and process Retently Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Authorize.Net Data in DBxtra
Create dynamic dashboards and perform analytics based on Authorize.Net data in DBxtra.
-
How to Visualize Couchbase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Couchbase data in Python.
-
How to connect to YouTube Analytics Data from Spring Boot
Connect to YouTube Analytics in a Spring Boot Application using the CData JDBC Driver for YouTube Analytics
-
Integrating GitHub Copilot 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.
-
DataBind Charts to BigQuery Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to BigQuery 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.
-
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.
-
Analyze PostgreSQL Data in Cognos Analytics
Use CData Connect AI to connect to PostgreSQL Data from Cognos Analytics and analyze live PostgreSQL data.
-
Create Dynamic Adobe Experience Manager Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Experience Manager to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Nethunt with Apache Airflow
Access and process Nethunt data in Apache Airflow using the CData JDBC Driver.
-
Connect to CouchDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CouchDB and the SQL Gateway to access CouchDB data from Google Apps Script.
-
Access SAP BusinessObjects BI Data from MySQL in PHP
Connect to SAP BusinessObjects BI through the standard MySQL libraries in PHP.
-
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.
-
Stream ConvertAPI Data into Apache Kafka Topics
Access and stream ConvertAPI data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
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.
-
Connect and Query Live Presto Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Presto data into Databricks and enable direct, live querying and analysis without replication.
-
Sugar CRM Reporting in OBIEE with the Sugar CRM JDBC Driver
Deploy the Sugar CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate SAP Business Warehouse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Business Warehouse with External Services.
-
Automated Continuous AdRoll Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AdRoll replication to IBM DB2.
-
Integrating Azure Analysis Services Data in Talend Cloud Data Management Platform
Connect Azure Analysis Services Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure Analysis Services.
-
Query Slack Data as a SQL Server Database in Node.js
Execute SQL Server queries against Slack data from Node.js.
-
Viewing PostgreSQL Data in RAD Studio Data Explorer
How to view PostgreSQL data in RAD Studio Data Explorer using the CData ODBC Driver for PostgreSQL.
-
Replicate Microsoft Ads Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Ads data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Add Moosend Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Moosend with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect and Visualize Live Oracle HCM Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle HCM Cloud data into the Databricks platform and create visualization dashboards with real-time Oracle HCM Cloud data.
-
How to Work with Testmonitor Data in ETL Validator JDBC
Connect to Testmonitor from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Insightly Data in Jaspersoft Studio
Execute SQL to remote Insightly data in Jaspersoft Studio.
-
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.
-
Build Apps with Live Vimeo Data Using the Low-Code Development Platform of Mendix
Connect Vimeo data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Live HCL Domino Data in PostGresSQL Interface through CData Connect AI
Create a live connection to HCL Domino in CData Connect AI and connect to your HCL Domino data from PostgreSQL.
-
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.