CData Software - Knowledge Base
Recent Articles
-
Connect to Salesforce CRM Analytics Data from a Connection Pool in JBoss
Integrate Salesforce CRM Analytics data into Java servlets: Use the Management Console in JBoss to install the Salesforce CRM Analytics JDBC Driver.
-
ETL Zuora in Oracle Data Integrator
This article shows how to transfer Zuora data into a data warehouse using Oracle Data Integrator.
-
Use the CData ODBC Driver for PDFMonkey in Microsoft Power Query
You can use the CData PDFMonkey ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PDFMonkey data into Microsoft Power Query.
-
Automated Continuous Onfleet Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Onfleet replication to Google Cloud SQL.
-
Use ChatGPT to Talk to Your Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Grafana data for you.
-
Connecting Pipedream with Neo4J 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 Neo4J data in real time.
-
Build Freshteam-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Freshteam Data and create custom apps in Bubble.
-
Access Live GraphQL Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live GraphQL data from your Excel spreadsheets.
-
Import and Visualize Browserless Data in Power View
Create data visualizations based on Browserless data in Excel.
-
Integrate OpenCode with Live Salesloft Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Salesloft data from within your AI coding agent.
-
How to Connect to Live YouTube Analytics 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 YouTube Analytics data for you.
-
Connect to GraphQL Data in DBeaver
Use the CData ODBC Driver to connect to GraphQL data in DBeaver.
-
Build Azure Synapse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Synapse data.
-
Automated Continuous Gumroad Replication to Snowflake
Use CData Sync for automated, continuous, customizable Gumroad replication to Snowflake.
-
Replicate Odoo Data from PowerShell
Write a quick PowerShell script to query Odoo data. Use connectivity to the live data to replicate Odoo data to SQL Server.
-
Getting Started with the CData Tableau Connector for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Dropbox Data in NetBeans
Connect to Dropbox data in NetBeans with the data source configuration wizard.
-
Automate Power BI XMLA Data Replication to Azure Synapse
Use CData Sync to customize and automate Power BI XMLA data replication to Azure Synapse.
-
Automated Continuous Hugging Face Replication to Oracle
Use CData Sync for automated, continuous, customizable Hugging Face replication to Oracle.
-
How to create an RPA flow for Pinterest Data in UiPath Studio
Use the Pinterest ODBC Driver to create workflows that access real-time Pinterest data without any coding.
-
Access MongoDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MongoDB data from HeidiSQL.
-
Import Cvent Data Using Azure Data Factory
Use CData Connect AI to connect to Cvent Data from Azure Data Factory and import live Cvent data.
-
Integrate Google's Vertex AI Agent with Live SFTP 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 SFTP data within intelligent workflows.
-
Use the CData Software JDBC Driver for Bannerbear in MicroStrategy
Connect to Bannerbear data in MicroStrategy Developer using the CData Software JDBC Driver for Bannerbear.
-
How to connect and process MailerSend data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MailerSend data.
-
Integrating Dataiku with SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Netweaver Gateway data.
-
Query Cloudflare Data in DataGrip
Create a Data Source for Cloudflare in DataGrip and use SQL to query live Cloudflare data.
-
Connecting GenSpark with Exact Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Exact Online data without any replication or custom integration required.
-
Use Biml to Build SSIS Tasks to Replicate Tally Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tally data to SQL Server.
-
Object-Relational Mapping (ORM) with QuickBooks Time 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 QuickBooks Time data into a Java-based ORM framework, Hibernate.
-
Create Data Visualizations in Cognos BI with OpenWeatherMap Data
Access OpenWeatherMap data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish MessageBird-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MessageBird data.
-
Visualize Live Pingdom Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pingdom data.
-
How to Connect DBeaver to SAP via a JDBC Driver
Manage SAP data with visual tools in DBeaver like the query browser.
-
Operational Reporting on GetResponse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote GetResponse data.
-
Analyze Monday.com Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Monday.com data and visualize Monday.com data in SAP Analytics Cloud.
-
Build Dropbox-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dropbox Data from Zoho Analytics and import live Dropbox data.
-
Integrate SAP Business Warehouse Data in Pentaho Data Integration
Build ETL pipelines based on SAP Business Warehouse data in the Pentaho Data Integration tool.
-
Getting Started with the CData Tableau Connector for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Multiple Shopify Accounts via the CData Sync CLI
Replicate multiple Shopify accounts to one or many databases.
-
Model XML Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and XML, enabling the direct import of real-time XML data.
-
Connect to Real-Time Gong Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Gong data in Power Apps.
-
Replicate Multiple Postmark Accounts
Replicate multiple Postmark accounts to one or many databases.
-
Create SAP BusinessObjects BI-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP BusinessObjects BI Data from OutSystems and build custom enterprise apps using live SAP BusinessObjects BI data.
-
Validate Auth0 Data with QuerySurge
Access and validate Auth0 data in QuerySurge using the CData JDBC Driver.
-
Create SSAS Tabular Models from Oracle Eloqua Reporting Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Eloqua Reporting data using CData drivers.
-
Connect to Mocean Data in JRuby
Create a simple JRuby app with access to live Mocean data.
-
Visualize Recurly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Recurly data.
-
Connect to OData Services from Crystal Reports
Use CData Connect AI to connect to and report on live OData services from Crystal Reports.
-
How to Connect to Live Adobe Analytics Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Adobe Analytics data for you.
-
DataBind Controls to Zendesk Data in Delphi
DataBind to Zendesk data in Delphi with standard data access components and controls.
-
Integrate Open WebUI with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Ad Manager data from within the chat interface.
-
Automated Continuous Sage Intacct Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Google BigQuery.
-
Using the CData Software ODBC Driver for Google Directory in PyCharm
Connect to Google Directory as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Directory.
-
Replicate Multiple SendGrid Accounts
Replicate multiple SendGrid accounts to one or many databases.
-
Create JSON-Connected Business Apps in AppSheet
Connect to JSON Services via CData Connect AI in Google AppSheet and create custom business applications with real-time access to JSON services.
-
Building Dynamic Web Pages with Teradata Data Using AngularJS
Create single-page applications with live connectivity to Teradata using the CData API Server.
-
How to Connect to Live DB2 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 DB2 data for you.
-
Integrate Trae with Live Splunk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Splunk data from within the AI-powered IDE.
-
Access QuickBooks Data from MySQL in Amazon QuickSight
Connect to QuickBooks and build visualizations of QuickBooks data using a MySQL Connection in Amazon QuickSight.
-
Publish Strava-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Strava data.
-
Integrate Live Google Spanner Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Google Spanner data from within the IDE.
-
Connect to CockroachDB Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live CockroachDB data.
-
Build Coinbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Coinbase data and build web apps with connectivity to live Coinbase data.
-
How to Access Live BigQuery Data in Power Automate Desktop via ODBC
The CData ODBC Driver for BigQuery enables you to integrate BigQuery data into workflows built using Microsoft Power Automate Desktop.
-
Create Power BI Reports on Real-Time Typeform Data
Use the CData ODBC Driver for Typeform to visualize Typeform data in Power BI Desktop.
-
Provide OData Services of Impala Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Impala data by developing a WCF Service Application.
-
Choosing the Best Method to Connect SAP ByDesign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP ByDesign data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query ClickTime Data in DataGrip
Create a Data Source for ClickTime in DataGrip and use SQL to query live ClickTime data.
-
Access FTP Data from MySQL in Amazon QuickSight
Connect to FTP and build visualizations of FTP data using a MySQL Connection in Amazon QuickSight.
-
Connect to Oracle Data in DBeaver
Use the CData ODBC Driver to connect to Oracle data in DBeaver.
-
Validate Tally Data with QuerySurge
Access and validate Tally data in QuerySurge using the CData JDBC Driver.
-
Connect to SurveyMonkey Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SurveyMonkey.
-
Getting Started with the CData ODBC Driver for Everhour
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Everhour.
-
Use Biml to Build SSIS Tasks to Replicate SharePoint Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SharePoint data to SQL Server.
-
Automated Continuous Reckon Accounts Hosted Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Amazon S3.
-
Object-Relational Mapping (ORM) with Presto 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 Presto data into a Java-based ORM framework, Hibernate.
-
Object-Relational Mapping (ORM) with RabbitMQ 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 RabbitMQ data into a Java-based ORM framework, Hibernate.
-
View Reports on Real-Time ZeroBounce Data in Power BI Report Server
Use the CData ODBC Driver for ZeroBounce to visualize ZeroBounce data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Live ShipStation 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 ShipStation data through a conversational interface.
-
Replicate Phoenix Data to Multiple Databases
Replicate Phoenix data to disparate databases with a point-and-click configuration.
-
Automated Continuous eBay Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to MySQL.
-
Connect to Redshift Data from a Connection Pool in JBoss
Integrate Redshift data into Java servlets: Use the Management Console in JBoss to install the Redshift JDBC Driver.
-
Explore Geographical Relationships in Parallel Data with Power Map
Create data visualizations with Parallel data in Power Map.
-
Replicate Multiple Amazon Marketplace Accounts via the CData Sync CLI
Replicate multiple Amazon Marketplace accounts to one or many databases.
-
Connect to ConstantContact Data from AWS Glue
Use CData Connect AI to gain access to live ConstantContact data from your AWS Glue jobs.
-
Access Live HubSpot Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live HubSpot data from your Excel spreadsheets.
-
Integrating Kiro with Bullhorn CRM 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 Yelp Data from Spring Boot
Connect to Yelp in a Spring Boot Application using the CData API Driver for JDBC
-
How to create an RPA flow for eBay Analytics Data in UiPath Studio
Use the eBay Analytics ODBC Driver to create workflows that access real-time eBay Analytics data without any coding.
-
Visualize ZohoExpense Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoExpense data.
-
Connect to Basecamp Data in Aqua Data Studio
Access Basecamp data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Explore Geographical Relationships in Instagram Data with Power Map
Create data visualizations with Instagram data in Power Map.
-
How to connect Amazon QuickSight to Omnisend Data
Create a connection to Omnisend data in CData Connect AI and insert Omnisend data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Mailjet Data from PowerShell
Write a quick PowerShell script to query Mailjet data. Use connectivity to the live data to replicate Mailjet data to SQL Server.
-
Use the CData Software ODBC Driver for HubDB in SAS for Real-Time Reporting and Analytics
Connect to real-time HubDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HubDB.
-
Access Live MongoDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MongoDB data from your Excel spreadsheets.
-
Automated Continuous Google Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ads replication to SQLite.
-
How to Access Live Epicor Kinetic Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Epicor Kinetic enables you to integrate Epicor Kinetic data into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with Hubstaff Data in Dundas BI
Create dynamic dashboards and perform analytics based on Hubstaff data in Dundas BI.