CData Software - Knowledge Base
Recent Articles
-
Automated Continuous QuickBooks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks replication to IBM DB2.
-
Connect to Facebook Ads Data in JRuby
Create a simple JRuby app with access to live Facebook Ads data.
-
Access Live Trello Data in Excel 365 Online (Excel for the web)
Connect to Trello data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build a PostgreSQL Interface for Google Sheets Data using the CData JDBC Driver
Use the Remoting features of the Google Sheets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP Ariba Procurement Data in JRuby
Create a simple JRuby app with access to live SAP Ariba Procurement data.
-
DataBind Controls to Procore Data in Delphi
DataBind to Procore data in Delphi with standard data access components and controls.
-
Replicate JSON Services from PowerShell
Write a quick PowerShell script to query JSON services. Use connectivity to the live data to replicate JSON services to SQL Server.
-
Automated Continuous Simplesat Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Simplesat replication to Amazon Redshift.
-
Connecting GenSpark with Freshdesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Freshdesk data without any replication or custom integration required.
-
Create Dynamic Pipeliner CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Pipeliner CRM to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for HubDB in MicroStrategy
Connect to HubDB data in MicroStrategy Developer using the CData Software ODBC Driver for HubDB.
-
Migrating data from SendPulse to Databricks using CData SSIS Components.
Easily push SendPulse data to Databricks using the CData SSIS Tasks for SendPulse and Databricks.
-
Bind Live Oracle Financials Cloud Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Financials Cloud data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automated Continuous Google Calendar Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Calendar data replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for VWO
Provide connectivity to VWO data through an SAP BusinessObjects universe.
-
How to Query MailChimp Data in MySQL Workbench
Execute MySQL queries against live MailChimp data from MySQL Workbench.
-
Integrate Reckon Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Reckon data from Informatica Cloud.
-
Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy
Connect to QuickBooks Time data in MicroStrategy Developer using the CData Software JDBC Driver for QuickBooks Time.
-
How to Connect to Live MariaDB 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 MariaDB data for you.
-
Excel Spreadsheet Automation on Oracle Eloqua Data with the QUERY Formula
Pull data from Oracle Eloqua, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous GitLab Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GitLab replication to Google Cloud SQL.
-
Integrating OpenCode with HelloSign 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.
-
Easily Integrate Webflow Data in Lazarus Pascal IDE
Learn how to easily integrate live Webflow data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Apps with Live Slack data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Slack data into the Adalo platform and build custom mobile and web applications with real-time Slack data.
-
Automate Microsoft Entra ID Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Entra ID data from PowerShell? This article demonstrates how to utilize the Microsoft Entra ID Cmdlets for tasks like connecting to Microsoft Entra ID data, automating operations, downloading data, and more.
-
Getting Started with the CData Excel Add-In for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP ByDesign.
-
Migrating data from LinkedIn to Snowflake using CData SSIS Components.
Easily push LinkedIn data to Snowflake using the CData SSIS Tasks for LinkedIn and Snowflake.
-
Access Live Oracle HCM Cloud Data in Coginiti Pro
Connect to and query live Oracle HCM Cloud data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Trae with Live Workday Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Workday data from within the AI-powered IDE.
-
Feed OData Services into FineReport
How to set OData services as a JDBC data source in FineReport.
-
Visualize PostgreSQL Data in TIBCO Spotfire through OData
Integrate PostgreSQL data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Office 365 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Office 365 data securely in real time.
-
Build MVC Applications with Connectivity to Aircall Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aircall from an ASP.NET MVC application.
-
Connect to Rootly 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 Rootly and work with Rootly data in your FileMaker application.
-
How to Connect DBeaver to CouchDB via a JDBC Driver
Manage CouchDB data with visual tools in DBeaver like the query browser.
-
Integrate Devin with Live Spark 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 Spark data.
-
Use JayDeBeApi to access Oracle HCM Cloud Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle HCM Cloud data.
-
Access Live Bannerbear Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bannerbear data into the statistical analysis tools available in SAS JMP. This article shows how to use Bannerbear data in the Graph Builder and Query Builder.
-
A PostgreSQL Interface for Hive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Hive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time SAP SuccessFactors LMS Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP SuccessFactors LMS data in ColdFusion.
-
Connect Twilio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Twilio with IBM WebSphere for seamless data integration and connectivity.
-
Design BIRT Reports on Zoho Recruit Data
Provide current Zoho Recruit data to your embedded analytics.
-
Access Live Cloudant Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Cloudant data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Basecamp Data Replication to Azure Data Lake
Use CData Sync to customize and automate Basecamp data replication to Azure Data Lake.
-
Build AI/ML Models with Live HubSpot Data using Dataiku
Connect HubSpot Data with Dataiku using the CData JDBC Driver for HubSpot.
-
Automated Continuous eBay Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Amazon Redshift.
-
Build a Singer.io Tap for Pinecone With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pinecone data using the CData Python Connector.
-
Import Real-Time Printify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Printify data in ColdFusion.
-
Connecting Agentforce with Pinterest 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 Pinterest data for you.
-
Build SAP SuccessFactors LMS-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP SuccessFactors LMS data and build web apps with connectivity to live SAP SuccessFactors LMS data.
-
How to connect and process eBay data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live eBay data.
-
Prepare, Blend, and Analyze Office 365 Data in Alteryx Designer (Connect AI)
Build workflows to access live Office 365 data for self-service data analytics.
-
Connect to Amplitude Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Amplitude.
-
How to Easily Query SharePoint Excel Services Data in OpenOffice Base
Connect to SharePoint Excel Services data in OpenOffice Base using the CData ODBC Driver for SharePoint Excel Services and generate reports with live data insights.
-
Bind Live Google Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Analytics data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate Cursor with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Synapse data from within the editor.
-
Automated Continuous Samanage Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Samanage replication to Google Cloud SQL.
-
Integrating Cursor with Pushbullet 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.
-
Using the CData Software ODBC Driver for EmailOctopus in PyCharm
Connect to EmailOctopus as an ODBC data source in PyCharm using the CData Software ODBC Driver for EmailOctopus.
-
Connect to JobNimbus Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time JobNimbus data using standard SQL.
-
Access Nuclia Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Nuclia data from HeidiSQL.
-
Connect to GraphQL Data from AWS Glue
Use CData Connect AI to gain access to live GraphQL data from your AWS Glue jobs.
-
Query, Visualize, and Share live Avro Data in Redash
Use CData Connect AI to connect to live Avro data in Redash for querying, visualizing, and sharing.
-
Build Cloudflare-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cloudflare Data from Zoho Analytics and import live Cloudflare data.
-
Create Datasets from HubSpot in Domo Workbench and Build Visualizations of HubSpot Data in Domo
Use the CData Software ODBC Driver for HubSpot to create datasets from HubSpot data in Domo Workbench and then build visualizations in the Domo service.
-
Stream Superchat Data into Apache Kafka Topics
Access and stream Superchat data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Couchbase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Couchbase data.
-
Connect to GitLab Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time GitLab data using standard SQL.
-
Getting Started with the CData Tableau Connector for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for PostgreSQL.
-
Use the CData ODBC Driver for Bright Data from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bright Data to connect to Bright Data data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bright Data data in Excel.
-
Integrating Dataiku with Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Twilio data.
-
Analyze Elasticsearch Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Elasticsearch data and visualize live Elasticsearch data in Infragistics Reveal.
-
Analyze SendGrid Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SendGrid data and visualize live SendGrid data in Infragistics Reveal.
-
How to connect Amazon QuickSight to Dynamics 365 Data
Create a connection to Dynamics 365 data in CData Connect AI and insert Dynamics 365 data into Amazon QuickSight SPICE to build interactive dashboards.
-
Validate CampaignMonitor Data with QuerySurge
Access and validate CampaignMonitor data in QuerySurge using the CData JDBC Driver.
-
SQL Analysis Services Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SQL Analysis Services data through CData Connect AI using different applications and tools.
-
Automated Continuous Certinia Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Certinia replication to Apache Cassandra.
-
How to Use a Microsoft Access Database to Update Sage Intacct Data in Real Time
Update Sage Intacct data by creating a linked table in Microsoft Access with the CData Sage Intacct ODBC Driver.
-
Integrate with AlloyDB Data in JReport Designer
Create charts and reports based on AlloyDB data in JReport Designer.
-
Query Live HCL Domino Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live HCL Domino data through a conversational interface.
-
Publish Crystal Reports on Sendwithus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sendwithus data.
-
Automated Continuous Confluence Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Confluence replication to Amazon Redshift.
-
Integrate Teradata with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Teradata with External Services.
-
Access Live Sugar CRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sugar CRM data from your Google Sheets.
-
Operational Reporting on Google Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Ads data.
-
Easily Integrate Authorize.Net Data in Lazarus Pascal IDE
Learn how to easily integrate live Authorize.Net data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData ADO.NET Provider for Spark
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Spark.
-
Operational Reporting on Wrike Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Wrike data.
-
Perform Batch Operations with Snowflake Data in Apache NiFi
Connect to Snowflake data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
DataBind Controls to Impala Data in Delphi
DataBind to Impala data in Delphi with standard data access components and controls.
-
Connect to Testmonitor Data from AWS Glue
Use CData Connect AI to gain access to live Testmonitor data from your AWS Glue jobs.
-
Build Visualizations of ZohoInvoice Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoInvoice data in Birst.
-
Query Grafana Data as a SQL Server Database in Node.js
Execute SQL Server queries against Grafana data from Node.js.
-
Build Zoho Projects-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho Projects data and build Zoho Projects-connected web apps with Axios.
-
How to connect to Placid Data from IntelliJ
Integrate connectivity to Placid data with wizards in IntelliJ.
-
Connect to NetSuite SuiteAnalytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live NetSuite SuiteAnalytics data from Crystal Reports.
-
Access Mouseflow Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mouseflow data from your Oracle system.
-
Natively Connect to Quaderno Data in PHP
The CData ODBC driver for Quaderno enables you to create PHP applications with connectivity to Quaderno data. Leverage the native support for ODBC in PHP.
-
Query Authorize.Net Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Authorize.Net entities in PHP by modeling them as objects.
-
Using the CData Software ODBC Driver for FHIR in PyCharm
Connect to FHIR as an ODBC data source in PyCharm using the CData Software ODBC Driver for FHIR.