CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to Salesforce Marketing via a JDBC Driver
Manage Salesforce Marketing data with visual tools in DBeaver like the query browser.
-
ETL Auth0 in Oracle Data Integrator
This article shows how to transfer Auth0 data into a data warehouse using Oracle Data Integrator.
-
How to load Strava data into Elasticsearch via Logstash
Introducing a simple method to load Strava data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Intercom Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Intercom data with the CData JDBC Driver for Intercom.
-
Access Live Cohere Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Cohere data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for MYOB AccountRight in MicroStrategy Desktop
Connect to MYOB AccountRight data in MicroStrategy Desktop using the CData Software JDBC Driver for MYOB AccountRight.
-
Integrate Google's Vertex AI Agent with Live Perplexity 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 Perplexity data within intelligent workflows.
-
Publish Crystal Reports on Excel Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Excel data.
-
DataBind Charts to FormSite Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FormSite 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.
-
Create Apps from GitLab Data in Qlik Sense Cloud
Use CData Connect AI to connect to GitLab Data and build apps from live GitLab data in Qlik Sense Cloud.
-
Access Live Google Directory Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Directory data from your Excel spreadsheets.
-
Connect to HCL Domino Data in NetBeans
Connect to HCL Domino data in NetBeans with the data source configuration wizard.
-
Query Confluence Data in ColdFusion
Write standard ColdFusion data access code to connect to Confluence data.
-
Access Live Outreach.io Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Outreach.io data from your Google Sheets.
-
Edit and Search External Amazon DynamoDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon DynamoDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon DynamoDB Data objects that you can access from apps and the dashboard.
-
Access Live Adobe Analytics Data in AWS Lambda
Connect to live Adobe Analytics data in AWS Lambda using the CData JDBC Driver.
-
Building Dynamic Web Pages with eBay Analytics Data Using AngularJS
Create single-page applications with live connectivity to eBay Analytics using the CData API Server.
-
Getting Started with the CData Python Connector for Office 365
Learn to install and license the CData Python Connector and configure a connection to live Office 365 data.
-
Enable the EmailOctopus JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with EmailOctopus data.
-
Automate Greenhouse Data Replication to SAP HANA
Use CData Sync to customize and automate Greenhouse data replication to SAP HANA.
-
How to Connect Flowise AI Agents to Live Grafana 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 Grafana data without replication.
-
How to Connect to Live Amazon DynamoDB Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Amazon DynamoDB data for you.
-
ETL Zoho Creator in Oracle Data Integrator
This article shows how to transfer Zoho Creator data into a data warehouse using Oracle Data Integrator.
-
Query Salesforce Marketing Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce Marketing data.
-
Analyze Jumpseller Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Jumpseller data with the CData JDBC Driver for Jumpseller.
-
Provide OData Services of Qualaroo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Qualaroo data by developing a WCF Service Application.
-
Integrating GitHub Copilot with Trello 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 Devin with Live Guru 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 Guru data.
-
Publish Hubstaff-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Hubstaff data.
-
Perform Batch Operations with Redis Data in Apache NiFi
Connect to Redis data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Browserless Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Browserless replication to AlloyDB.
-
Seamlessly Bring Oracle Eloqua Data into Retool Using CData Connect AI
Integrate Oracle Eloqua data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
DataBind Controls to Gumroad Data in C++Builder
DataBind to Gumroad data in C++Builder with standard components and controls.
-
Integrate Live Typeform Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Typeform data and integrate live Typeform data into apps built in Microsoft Power Apps.
-
Build Google Drive Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Drive data and build visualizations in Tableau Cloud.
-
Excel Spreadsheet Automation on Simplesat Data with the QUERY Formula
Pull data from Simplesat, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Live MarkLogic Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MarkLogic from the MuleSoft Anypoint Platform to integrate live MarkLogic data into custom reports and dashboards.
-
Query Sage 200 Data in DataGrip
Create a Data Source for Sage 200 in DataGrip and use SQL to query live Sage 200 data.
-
Automate Elorus Data Replication to Azure Data Lake
Use CData Sync to customize and automate Elorus data replication to Azure Data Lake.
-
Build Miro-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Miro data and build web apps with connectivity to live Miro data.
-
How to Connect to Live Shopify 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 Shopify data for you.
-
Build Google Ads-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Ads data.
-
Use the CData Software ODBC Driver for Oracle Eloqua in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Eloqua data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Eloqua.
-
Build an OLAP Cube in SSAS from Excel Online Data
Establish a connection to Excel Online data data from SQL Server Analysis Services, and use the Excel Online Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Semantic Layer Views for ZohoSubscriptions Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoSubscriptions data.
-
Create Apps from Toggl Data in Qlik Sense Cloud
Use CData Connect AI to connect to Toggl Data and build apps from live Toggl data in Qlik Sense Cloud.
-
Access Live Dynamics 365 Business Central Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Dynamics 365 Business Central data from your Excel spreadsheets.
-
Automated Continuous Shopify Replication to MySQL
Use CData Sync for automated, continuous, customizable Shopify replication to MySQL.
-
Integrate with Microsoft Teams Data in JReport Designer
Create charts and reports based on Microsoft Teams data in JReport Designer.
-
Automated Continuous Freshservice Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Freshservice data replication to OneLake in Microsoft Fabric.
-
Build ZohoPeople-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ZohoPeople Data from Zoho Analytics and import live ZohoPeople data.
-
Automated Continuous Recurly Replication to MySQL
Use CData Sync for automated, continuous, customizable Recurly replication to MySQL.
-
Import and Visualize Workday Data in Power View
Create data visualizations based on Workday data in Excel.
-
Build MySQL Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MySQL data and build visualizations in Tableau.
-
How to Query Vimeo Data in MySQL Workbench
Execute MySQL queries against live Vimeo data from MySQL Workbench.
-
Connect Pipedrive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pipedrive with IBM WebSphere for seamless data integration and connectivity.
-
Automate QuickBooks Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access QuickBooks Online data from PowerShell? This article demonstrates how to utilize the QuickBooks Online Cmdlets for tasks like connecting to QuickBooks Online data, automating operations, downloading data, and more.
-
Automated Continuous ZohoPeople Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZohoPeople replication to PostgreSQL.
-
How to Connect to Live SAP HANA XS Advanced Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP HANA XS Advanced data for you.
-
Query Mailgun Data in DataGrip
Create a Data Source for Mailgun in DataGrip and use SQL to query live Mailgun data.
-
ETL Box in Oracle Data Integrator
This article shows how to transfer Box data into a data warehouse using Oracle Data Integrator.
-
Integrate Live Onfleet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Onfleet data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect Oracle Financials Cloud Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Financials Cloud data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Testmonitor Data as a MySQL Database in Node.js
Execute MySQL queries against Testmonitor data from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for Workday
Create Workday data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Dify with Live Highrise Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Highrise data.
-
Integrate Clari Data in Pentaho Data Integration
Build ETL pipelines based on Clari data in the Pentaho Data Integration tool.
-
Connect to and Visualize Live Miro Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Miro data.
-
Integrating OpenCode with Templated 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 QuickBooks Time-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to QuickBooks Time Data from Zoho Analytics and import live QuickBooks Time data.
-
Connect to Google Drive Data in Ruby
Connect to Google Drive data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Microsoft Planner Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to delimited files (CSV/TSV).
-
Connect to Google Ads Data in CloverDX (formerly CloverETL)
Transfer Google Ads data using the visual workflow in the CloverDX data integration tool.
-
Use JayDeBeApi to access Bullhorn CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Bullhorn CRM data.
-
How to work with ElevenLabs Data in Apache Spark using SQL
Access and process ElevenLabs Data in Apache Spark using the CData Software JDBC Driver.
-
Access Anaplan Data from MySQL in Amazon QuickSight
Connect to Anaplan and build visualizations of Anaplan data using a MySQL Connection in Amazon QuickSight.
-
Import Real-Time Rootly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Rootly data in ColdFusion.
-
DataBind Controls to SAP Ariba Source Data in C++Builder
DataBind to SAP Ariba Source data in C++Builder with standard components and controls.
-
Integrate Recurly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Recurly with External Services.
-
Choosing the Best Method to Connect Spark to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Spark data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Agents in Relevance AI with Access to Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon Marketplace data within intelligent agent workflows.
-
Connect to Excel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Excel data.
-
DataBind Controls to SAP ByDesign Data in C++Builder
DataBind to SAP ByDesign data in C++Builder with standard components and controls.
-
Analyze Greenplum Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Greenplum from Power Pivot. You will use the Table Import Wizard to load Greenplum data. You can visually build the import query or use any SQL supported by the driver.
-
LINQ to Nethunt 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 Nethunt Data Provider.
-
Integrate Amazon Athena with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon Athena with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon Athena data.
-
Integrate Cohere Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Cohere data from Informatica Cloud.
-
Connect to Clio Data in JRuby
Create a simple JRuby app with access to live Clio data.
-
Access Live SendGrid Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SendGrid data from your Excel spreadsheets.
-
Connect to SendInBlue Data in RazorSQL
Connect to SendInBlue from wizards and query SendInBlue data from the GUI in the RazorSQL database management tool.
-
Automated Continuous DB2 for i Replication to Snowflake
Use CData Sync for automated, continuous, customizable DB2 for i replication to Snowflake.
-
Trigger Adobe Commerce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Adobe Commerce with standard wizards in Logic Apps.
-
Connect to QuickBooks Data in NetBeans
Connect to QuickBooks data in NetBeans with the data source configuration wizard.
-
Connect to Google Search Results from AWS Glue
Use CData Connect AI to gain access to live Google Search results from your AWS Glue jobs.
-
Connecting Pipedream with GetResponse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on GetResponse data in real time.
-
Integrate Google's Antigravity Agent with Live ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ZohoDesk data using the Model Context Protocol.
-
Build Zoho CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho CRM data and build Zoho CRM-connected web apps with Axios.
-
Connect to Mixpanel Data in RazorSQL
Connect to Mixpanel from wizards and query Mixpanel data from the GUI in the RazorSQL database management tool.
-
Analyze Reckon Accounts Hosted Data in Cognos Analytics
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Cognos Analytics and analyze live Reckon Accounts Hosted data.
-
Connect to Sage 200 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage 200 as an External Source in Dremio.