CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for OData Services in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for OData services.
-
How to connect to QuickBooks Time Data with Squirrel SQL client
Connect to QuickBooks Time data and execute queries in the Squirrel SQL Client.
-
Excel Spreadsheet Automation on Zoho Recruit Data with the QUERY Formula
Pull data from Zoho Recruit, automate spreadsheets, and more with the QUERY formula.
-
Integrate Real-Time Access to Presto in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Presto data in real time.
-
Integrate with Dropbox Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dropbox data to a JSON file on disk.
-
Build Agents in Relevance AI with Access to Live Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Contacts data within intelligent agent workflows.
-
Bridge Mocean Connectivity with Apache NiFi
Access and process Mocean data in Apache NiFi using the CData JDBC Driver.
-
Access Mailjet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mailjet data from HeidiSQL.
-
Integrating LangChain with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SendGrid data within automated workflows.
-
Query SAP Hybris C4C Data in DataGrip
Create a Data Source for SAP Hybris C4C in DataGrip and use SQL to query live SAP Hybris C4C data.
-
Create Datasets from SurveyMonkey in Domo Workbench and Build Visualizations of SurveyMonkey Data in Domo
Use the CData Software ODBC Driver for SurveyMonkey to create datasets from SurveyMonkey data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Azure Data Lake Storage Data to Multiple Databases via the CData Sync CLI
Replicate Azure Data Lake Storage data to disparate databases with a single configuration.
-
Connect to SharePoint Excel Services Data in NetBeans
Connect to SharePoint Excel Services data in NetBeans with the data source configuration wizard.
-
Connect to JDBC-ODBC Bridge Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to JDBC-ODBC Bridge.
-
Replicate Gorgias Data to Multiple Databases via the CData Sync CLI
Replicate Gorgias data to disparate databases with a single configuration.
-
Use Microsoft Copilot Studio to talk to your Amazon S3 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 Amazon S3 data for you.
-
Build a Singer.io Tap for Bitbucket With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bitbucket data using the CData Python Connector.
-
Replicate Kintone Data in Heroku for Use in Salesforce Connect
Replicate Kintone data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a PostgreSQL Interface for IBM Informix Data using the CData JDBC Driver
Use the Remoting features of the IBM Informix JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import RabbitMQ Data into Apache Solr
Use the CData Software JDBC Driver for RabbitMQ in Data Import Handler and create an automated import of RabbitMQ data to Apache Solr Enterprise Search platform.
-
Visualize Bugsnag Data in TIBCO Spotfire through ADO.NET
Integrate Bugsnag data into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access LeadDesk Data in Python
Use standard Python scripting and the development environment of your choice to access live LeadDesk data.
-
Enable the Postmark JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Postmark data.
-
How to connect and process SAP Hybris C4C data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Hybris C4C data.
-
Feed Azure Synapse Data into FineReport
How to set Azure Synapse data as a JDBC data source in FineReport.
-
How to Connect DBeaver to SendInBlue via a JDBC Driver
Manage SendInBlue data with visual tools in DBeaver like the query browser.
-
How to update Act CRM from Excel
This article explains how to transfer data from Excel to Act CRM using the Excel Add-In for Act CRM.
-
Access Live Marketo Data in TIBCO Data Virtualization
Use the Marketo Tibco DV Adapter to create a Marketo data data source in TIBCO Data Virtualization Studio and gain access to live Marketo data from your TDV Server.
-
Connect to Toggl from Asprova with CData Software ODBC Driver for Toggl
This article shows how to connect faster to Toggl data from Asprova.
-
Integrate OpenCode with Live SingleStore Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SingleStore data from within your AI coding agent.
-
Connect to Reply.io Data from PowerBuilder via ADO.NET
This article demonstrates how to access Reply.io data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to import Gmail Data into Apache Solr
Use the CData Software JDBC Driver for Gmail in Data Import Handler and create an automated import of Gmail data to Apache Solr Enterprise Search platform.
-
Automated Continuous Oracle HCM Cloud Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to PostgreSQL.
-
Manage EnterpriseDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for EnterpriseDB.
-
Viewing Pipeline CRM Data in RAD Studio Data Explorer
How to view Pipeline CRM data in RAD Studio Data Explorer using the CData ODBC Driver for Pipeline CRM.
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors data for you.
-
Validate Adobe Target Data with QuerySurge
Access and validate Adobe Target data in QuerySurge using the CData JDBC Driver.
-
Query Azure Synapse Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Synapse entities in PHP by modeling them as objects.
-
Create Reports with TigerGraph Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date TigerGraph data.
-
Build MVC Applications with Connectivity to Cloudant Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cloudant from an ASP.NET MVC application.
-
How to Connect to Live Samanage Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Samanage data for you.
-
Connect Facebook Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Facebook Ads with IBM WebSphere for seamless data integration and connectivity.
-
Create Datasets from Jumpseller in Domo Workbench and Build Visualizations of Jumpseller Data in Domo
Use the CData Software ODBC Driver for Jumpseller to create datasets from Jumpseller data in Domo Workbench and then build visualizations in the Domo service.
-
Build Azure Analysis Services-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure Analysis Services Data and create custom apps in Bubble.
-
LINQ to PingOne 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 PingOne Data Provider.
-
How to Connect to Live MongoDB 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 MongoDB data for you.
-
Connect Todoist to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Todoist data using the CData Python MCP Server.
-
Automated Continuous SAP SuccessFactors Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Amazon S3.
-
Analyze Reply.io Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Reply.io data with the CData JDBC Driver for Reply.io.
-
Create Power BI Reports on Real-Time Outlook Data
Use the CData ODBC Driver for Outlook to visualize Outlook data in Power BI Desktop.
-
Automated Continuous NetSuite Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable NetSuite replication to Google BigQuery.
-
Connect to Raisers Edge NXT from a Connection Pool in WebLogic
Use the CData JDBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT data from Web applications running on WebLogic.
-
Connect to and Query Oracle HCM Cloud Data in QlikView over ODBC
Create data visualizations with Oracle HCM Cloud data in QlikView.
-
How to integrate Metabase with Sage 300 Data
Use CData Connect AI to connect to live Sage 300 data and create an interactive dashboard in Metabase from Sage 300 data.
-
Replicate PabblySubscriptions Data to Multiple Databases via the CData Sync CLI
Replicate PabblySubscriptions data to disparate databases with a single configuration.
-
DataBind Controls to Trello Data in Delphi
DataBind to Trello data in Delphi with standard data access components and controls.
-
Write a Simple Go Application to work with Dynamics 365 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Dynamics 365 data.
-
Build Data Flows from SQL Server to SuiteCRM through SSIS
Easily push SQL Server data to SuiteCRM using the CData SSIS Tasks for SuiteCRM.
-
Build Freshservice-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Freshservice Data from Zoho Analytics and import live Freshservice data.
-
Visualize Live PayPal Data in the Power BI Service
Use CData Connect AI to connect to live PayPal data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData ODBC Driver for Blackbaud FE NXT from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Blackbaud FE NXT data in Excel.
-
Pinterest Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Pinterest data through CData Connect AI using different applications and tools.
-
Integrate Live Exa Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Exa from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Exa data.
-
Build a PostgreSQL Interface for WordPress Data using the CData JDBC Driver
Use the Remoting features of the WordPress JDBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with Azure Data Catalog Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Catalog data.
-
How to Connect to Live ActiveCampaign Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your ActiveCampaign data for you.
-
Connect to Azure Data Lake Storage in SpagoBI
Create reports featuring live Azure Data Lake Storage data in SpagoBI Studio. Host Azure Data Lake Storage reports on SpagoBI Server.
-
Integrating Claude Code with Greenhouse Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Greenhouse data within assisted coding and automated development workflows.
-
Back Up Wrike data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Wrike data data.
-
Automated Continuous Databricks Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Databricks replication to Amazon S3.
-
Build Dashboards with Facebook Data in DBxtra
Create dynamic dashboards and perform analytics based on Facebook data in DBxtra.
-
Connect to Google Tasks 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 Google Tasks and work with Google Tasks data in your FileMaker application.
-
Manage Klaviyo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Klaviyo.
-
Azure Analysis Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Analysis Services facts in real time.
-
Integrate with Live SQL Analysis Services Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SQL Analysis Services from the MuleSoft Anypoint Platform to integrate live SQL Analysis Services data into custom reports and dashboards.
-
How to Work with Google Search Results in AWS Glue Jobs Using JDBC
Connect to Google Search from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Google Forms Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Forms Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Dynamic Snowflake Grids Using the Infragistics XamDataGrid
Learn how you can connect Snowflake to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Cursor with Freshdesk 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.
-
Build a Simple VCL Application for Highrise Data
How to build a simple VCL Application to view Highrise data in RAD Studio using the CData ODBC Driver for Highrise.
-
Publish Trello-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Trello data.
-
Migrating data from Front to Databricks using CData SSIS Components.
Easily push Front data to Databricks using the CData SSIS Tasks for Front and Databricks.
-
Connect to ZohoExpense from Asprova with CData Software ODBC Driver for ZohoExpense
This article shows how to connect faster to ZohoExpense data from Asprova.
-
Automate Pipeline CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Pipeline CRM data replication to Couchbase.
-
DataBind OpenWeatherMap Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide OpenWeatherMap data to a chart.
-
Process & Analyze ZendeskSell Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZendeskSell Data.
-
How to Work with Sage 300 Data in AWS Glue Jobs Using JDBC
Connect to Sage 300 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Google Cloud Storage Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Amazon Redshift.
-
Automated Continuous ServiceNow Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ServiceNow replication to Apache Kafka.
-
Query, Visualize, and Share live Salesforce Data in Redash
Use CData Connect AI to connect to live Salesforce data in Redash for querying, visualizing, and sharing.
-
Query Pipeliner CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pipeliner CRM data from Node.js.
-
Integrate Cline with Live Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Optimizely data from within your IDE.
-
Connect to Bitbucket Data from a Connection Pool in Jetty
The Bitbucket JDBC Driver supports connection pooling: This article shows how to connect faster to Bitbucket data from Web apps in Jetty.
-
Viewing Google Spanner Data in RAD Studio Data Explorer
How to view Google Spanner data in RAD Studio Data Explorer using the CData ODBC Driver for Google Spanner.
-
Analyze GitLab Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze GitLab data with the CData JDBC Driver for GitLab.
-
How to Manage Multiple Attachments in Kintone Using the CData Kintone JDBC Driver
Easily add, update, and delete multiple attachments in Kintone using the CData Kintone JDBC Driver for efficient file management.
-
Create Data Visualizations in Cognos BI with SendInBlue Data
Access SendInBlue data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize SQL Analysis Services Data in Tableau
The CData ODBC driver for SQL Analysis Services enables you integrate SQL Analysis Services data into Tableau dashboards.
-
Query Pipeline CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pipeline CRM data from Node.js.
-
Use the CData Software ODBC Driver for Outlook in MicroStrategy
Connect to Outlook data in MicroStrategy Developer using the CData Software ODBC Driver for Outlook.