CData Software - Knowledge Base
Recent Articles
-
Connect to and Query Calendly Data in QlikView over ODBC
Create data visualizations with Calendly data in QlikView.
-
Replicate Tavily Data in Heroku for Use in Salesforce Connect
Replicate Tavily data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Informatica Mappings From/To a JDBC Data Source for Grafana
Create Grafana data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect SharePoint with Phoenix Data through external lists
Provide Phoenix data to SharePoint users as an external list.
-
SAS Data Sets Reporting in OBIEE with the SAS Data Sets JDBC Driver
Deploy the SAS Data Sets JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to OneNote Data from IntelliJ
Integrate connectivity to OneNote data with wizards in IntelliJ.
-
Model WordPress Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and WordPress, enabling the direct import of real-time WordPress data.
-
Replicate Planio Data in Heroku for Use in Salesforce Connect
Replicate Planio data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query ServiceNow Data in QlikView over ODBC
Create data visualizations with ServiceNow data in QlikView.
-
How to Build an ETL App for Avaza Data in Python with CData
Create ETL applications and real-time data pipelines for Avaza data in Python with petl.
-
Integrate QuickBooks Time with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks Time with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Time data.
-
How to connect to OpenWeatherMap Data from Spring Boot
Connect to OpenWeatherMap in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize Live Microsoft OneDrive Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft OneDrive data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bridge Instantly Connectivity with Apache NiFi
Access and process Instantly data in Apache NiFi using the CData JDBC Driver.
-
Access Live Printify Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Printify data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Data Visualizations Based On Grafana Data in Mode
Use CData Connect AI to connect to Grafana Data from Mode and build visualizations using live Grafana data.
-
Replicate Elorus Data in Heroku for Use in Salesforce Connect
Replicate Elorus data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Build an ETL App for SuiteCRM Data in Python with CData
Create ETL applications and real-time data pipelines for SuiteCRM data in Python with petl.
-
Automated Continuous Workday Replication to Vertica
Use CData Sync for automated, continuous, customizable Workday replication to Vertica.
-
How to connect PolyBase to Raisers Edge NXT
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Raisers Edge NXT data.
-
Integrate Live Instagram Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Instagram from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Instagram data.
-
Automated Continuous Sendwithus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sendwithus replication to PostgreSQL.
-
Seamlessly Bring Moosend Data into Retool Using CData Connect AI
Integrate Moosend 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 Wrike Data
Use the CData ODBC Driver for Wrike to visualize Wrike data in Power BI Desktop.
-
How to Connect to Live OneNote 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 OneNote data for you.
-
How to Connect Flowise AI Agents to Live Power BI XMLA 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 Power BI XMLA data without replication.
-
Automated Continuous Exact Online Replication to MySQL
Use CData Sync for automated, continuous, customizable Exact Online replication to MySQL.
-
Use the CData Software ODBC Driver for Clockify in SAS for Real-Time Reporting and Analytics
Connect to real-time Clockify data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Clockify.
-
Use Biml to Build SSIS Tasks to Replicate HubDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HubDB data to SQL Server.
-
Integrate Helpscout Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Helpscout data from Informatica Cloud.
-
Use Dash to Build to Web Apps on Quaderno Data
Create Python applications that use pandas and Dash to build Quaderno-connected web apps.
-
Manage Sage 200 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sage 200.
-
Automated Continuous Azure DevOps Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Amazon Redshift.
-
DataBind Controls to Attio Data in C++Builder
DataBind to Attio data in C++Builder with standard components and controls.
-
Bind Live SAP Concur Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Concur data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to connect to Splunk Data with Squirrel SQL client
Connect to Splunk data and execute queries in the Squirrel SQL Client.
-
How to Connect to Live HubSpot 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 HubSpot data for you.
-
Write a Simple Go Application to work with Elorus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Elorus data.
-
Integrate Live Shortcut Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Shortcut data and integrate live Shortcut data into apps built in Microsoft Power Apps.
-
Integrate with live Printify Data in Jitterbit
Use CData Connect AI to connect to and integrate live Printify data in Jitterbit.
-
Connect to ConvertAPI Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ConvertAPI as an External Source in Dremio.
-
Building Dynamic Web Pages with Google Contacts Data Using AngularJS
Create single-page applications with live connectivity to Google Contacts using the CData API Server.
-
Explore Geographical Relationships in FHIR Data with Power Map
Create data visualizations with FHIR data in Power Map.
-
How to integrate Shortcut with Apache Airflow
Access and process Shortcut data in Apache Airflow using the CData JDBC Driver.
-
Connecting Agentforce with HubSpot 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 HubSpot data for you.
-
Integrate Oracle Sales Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Sales data in the Pentaho Data Integration tool.
-
Integrate Live Deel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Deel data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Mocean Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mocean and work with Mocean data in your FileMaker applications.
-
Build ZohoPeople-Connected Apps in Choreo
Use CData Connect AI to connect to ZohoPeople Data from Choreo and build custom apps using live ZohoPeople data.
-
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy Web
Connect to Google Spanner data in MicroStrategy Web using the CData Software JDBC Driver for Google Spanner.
-
How to Access NASA Data Using Entity Framework
This article shows how to access NASA data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Azure Data Catalog Data from MySQL in PHP
Connect to Azure Data Catalog through the standard MySQL libraries in PHP.
-
Automated Continuous NASA Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable NASA replication to delimited files (CSV/TSV).
-
Link Unbounce with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Unbounce data in Filemaker Pro for Mac or Windows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Superchat
Provide connectivity to Superchat data through an SAP BusinessObjects universe.
-
Integrate with Azure Data Lake Storage Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Lake Storage data to a JSON file on disk.
-
How to work with Sugar CRM Data in Apache Spark using SQL
Access and process Sugar CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Access SAP SuccessFactors Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP SuccessFactors data from HeidiSQL.
-
Connect to Oracle Financials Cloud from Asprova with CData Software ODBC Driver for Oracle Financials Cloud
This article shows how to connect faster to Oracle Financials Cloud data from Asprova.
-
Replicate LinkedIn Ads Data to Multiple Databases via the CData Sync CLI
Replicate LinkedIn Ads data to disparate databases with a single configuration.
-
Visualize Live Mailjet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mailjet data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData ODBC Driver for Google Search from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Search to connect to Google Search results from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Search results in Excel.
-
Getting Started with the CData SSIS Components for Mailgun
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mailgun.
-
Connect to OpenWeatherMap Data in Ruby
Connect to OpenWeatherMap data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data through a conversational interface.
-
Natively Connect to Phoenix Data in PHP
The CData ODBC driver for Phoenix enables you to create PHP applications with connectivity to Phoenix data. Leverage the native support for ODBC in PHP.
-
Seamlessly Bring ZohoSubscriptions Data into Retool Using CData Connect AI
Integrate ZohoSubscriptions data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Quaderno Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Quaderno data from your Oracle system.
-
Getting Started with the CData ADO.NET Provider for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Data Lake Storage.
-
Build Apps with Live Cassandra data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Cassandra data into the Adalo platform and build custom mobile and web applications with real-time Cassandra data.
-
Configure the CData JDBC Driver for Paymo in a Connection Pool in Tomcat
Connect to Paymo data from a connection pool in Tomcat.
-
How to Build an ETL App for Keap Data in Python with CData
Create ETL applications and real-time data pipelines for Keap data in Python with petl.
-
Build a Singer.io Tap for Egnyte With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Egnyte data using the CData Python Connector.
-
Build AI/ML Models with Live Rootly Data using Dataiku
Connect Rootly Data with Dataiku using the CData API Driver for JDBC.
-
How to create GitLab federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GitLab data in MySQL .
-
Getting Started with the CData SSIS Components for SendGrid
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SendGrid.
-
Query Google Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Google Ads data from Node.js.
-
Integrate Gorgias Data in the Pentaho Report Designer
Publish reports based on Gorgias data in the Pentaho BI tool.
-
Integrating Boomi Agentstudio with Zoho Projects Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho Projects data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Moving Data from Excel Online to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Excel Online data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to HBase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HBase data from Filemaker Pro on Mac.
-
Create ClickUp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ClickUp data access from reports, embedded analytics, and more.
-
How to connect to Amazon Marketplace Data from IntelliJ
Integrate connectivity to Amazon Marketplace data with wizards in IntelliJ.
-
How to integrate Clockify with Apache Airflow
Access and process Clockify data in Apache Airflow using the CData JDBC Driver.
-
How to Access Live PhantomBuster Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PhantomBuster enables you to integrate PhantomBuster data into workflows built using Microsoft Power Automate Desktop.
-
Use Azure AI Foundry to Talk to Your Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Acumatica data for you.
-
Build AI Agents with RSS Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live RSS feeds through CData Connect AI.
-
Connect to Google Search Results in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Search results in Airbyte.
-
Integrate Live MarkLogic Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MarkLogic data and integrate live MarkLogic data into apps built in Microsoft Power Apps.
-
Connect to SQL Server from a Connection Pool in WebLogic
Use the CData JDBC Driver for SQL Server to connect to SQL Server data from Web applications running on WebLogic.
-
Access Live Dropbox Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dropbox data into the statistical analysis tools available in SAS JMP. This article shows how to use Dropbox data in the Graph Builder and Query Builder.
-
Use Agno to Talk to Your Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Drive data for you.
-
Integrate Goose with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Hive data from within the local AI agent.
-
Connect to Sybase IQ in SpagoBI
Create reports featuring live Sybase IQ data in SpagoBI Studio. Host Sybase IQ reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for ServiceDesk Plus in MicroStrategy Desktop
Connect to ServiceDesk Plus data in MicroStrategy Desktop using the CData Software ODBC Driver for ServiceDesk Plus.
-
Integrating Cursor with Dotmailer 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.
-
Getting Started with the CData SSIS Components for Google Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Ads.
-
How to Connect to Live Avro 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 Avro data for you.
-
Integrating GitHub Copilot with Keap 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.
-
Connect to Salesforce CRM Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesforce CRM Analytics data in Airbyte.