CData Software - Knowledge Base
Recent Articles
-
Choosing the Best Method to Connect Amazon S3 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon S3 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Google Ad Manager Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ad Manager data from your Excel spreadsheets.
-
Getting Started with the CData Power BI Connector for Act CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Act CRM.
-
Automated Continuous Qualaroo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Qualaroo replication to Amazon Redshift.
-
Build Voice Agents in ElevenLabs with access to Live Omnisend Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Omnisend data.
-
Automated Continuous Pipeline CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Oracle.
-
Automate Helpscout Data Replication to Azure Synapse
Use CData Sync to customize and automate Helpscout data replication to Azure Synapse.
-
Natively Connect to Databricks Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Databricks data. Leverage the native support for ODBC in PHP.
-
How to integrate Suadeo with Apache Airflow
Access and process Suadeo data in Apache Airflow using the CData JDBC Driver.
-
Integrating LlamaIndex with SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP HANA XS Advanced data in real time.
-
How to Query Live Adobe Target Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Adobe Target data data in natural language using Python.
-
Access Sugar CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sugar CRM data from HeidiSQL.
-
How to Connect to Live Printify 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 Printify data for you.
-
Integrating Gumloop with XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on XML data within automated workflows.
-
Design BIRT Reports on OneNote Data
Provide current OneNote data to your embedded analytics.
-
Build Agents in Relevance AI with Access to Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on API data within intelligent agent workflows.
-
Connect to Microsoft Planner Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Microsoft Planner.
-
Automate Acumatica Data Replication to Azure Data Lake
Use CData Sync to customize and automate Acumatica data replication to Azure Data Lake.
-
Validate PolarTeamPro Data with QuerySurge
Access and validate PolarTeamPro data in QuerySurge using the CData JDBC Driver.
-
Integrate Strava with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Strava with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Strava data.
-
Automate Facebook Data Replication to Azure Synapse
Use CData Sync to customize and automate Facebook data replication to Azure Synapse.
-
Integrating Trello Data in Talend Cloud Data Management Platform
Connect Trello Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Trello.
-
Connect to Quickbase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Quickbase.
-
Visualize PolarTeamPro Data in Tableau
The CData ODBC driver for PolarTeamPro enables you integrate PolarTeamPro data into Tableau dashboards.
-
Use ChatGPT to Talk to Your Splunk 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 Splunk data for you.
-
Operational Reporting on Vercel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Vercel data.
-
Write a Simple Go Application to work with Phoenix Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Phoenix data.
-
Connect to Jira Assets 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 Jira Assets data.
-
Build Voice Agents in ElevenLabs with access to Live Azure Synapse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Synapse data.
-
Integrating Antigravity CLI with Ontraport data via CData CLI
Connect Ontraport data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Cloudflare from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cloudflare to connect to Cloudflare data from Web applications running on WebLogic.
-
How to integrate CircleCI with Apache Airflow
Access and process CircleCI data in Apache Airflow using the CData JDBC Driver.
-
Connect to Autopilot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Autopilot to connect to Autopilot data and execute queries in PowerBuilder.
-
Create Power BI Reports on Real-Time Pipedrive Data
Use the CData ODBC Driver for Pipedrive to visualize Pipedrive data in Power BI Desktop.
-
Integrating Gumloop with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on API data within automated workflows.
-
How to Access Zoho Inventory Data Using Entity Framework
This article shows how to access Zoho Inventory data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build a Singer.io Tap for HDFS With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HDFS data using the CData Python Connector.
-
Automated Continuous DB2 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable DB2 data replication to OneLake in Microsoft Fabric.
-
View Reports on Real-Time Foursquare Data in Power BI Report Server
Use the CData ODBC Driver for Foursquare to visualize Foursquare data in Power BI Desktop and then publish them to Power BI Report Server.
-
Building Dynamic Web Pages with Oracle Eloqua Data Using AngularJS
Create single-page applications with live connectivity to Oracle Eloqua using the CData API Server.
-
Publish Blackbaud FE NXT-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Blackbaud FE NXT data.
-
How to Work with Perplexity Data in AWS Glue Jobs Using JDBC
Connect to Perplexity from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect DBeaver to Microsoft Dataverse via a JDBC Driver
Manage Microsoft Dataverse data with visual tools in DBeaver like the query browser.
-
Integrate HBase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HBase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to HBase data.
-
Connecting Agentforce with IBM Cloud Object Storage 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 IBM Cloud Object Storage data for you.
-
Analyze Exa Data in Cognos Analytics
Use CData Connect AI to connect to Exa Data from Cognos Analytics and analyze live Exa data.
-
Add PhantomBuster Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PhantomBuster with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Build an ETL App for Coinbase Data in Python with CData
Create ETL applications and real-time data pipelines for Coinbase data in Python with petl.
-
Publish Twitter Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Twitter Ads data.
-
How to create an RPA flow for Email Data in UiPath Studio
Use the Email ODBC Driver to create workflows that access real-time Email data without any coding.
-
Visualize Live Impala Data in the Power BI Service
Use CData Connect AI to connect to live Impala data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Boomi Agentstudio with Sage Intacct Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage Intacct data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect to Email Data with Squirrel SQL client
Connect to Email data and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Tally 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 Tally data for you.
-
Getting Started with the CData JDBC Driver for SQL Analysis Services
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SQL Analysis Services.
-
Replicate Vimeo Data from PowerShell
Write a quick PowerShell script to query Vimeo data. Use connectivity to the live data to replicate Vimeo data to SQL Server.
-
Object-Relational Mapping (ORM) with Spark 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 Spark data into a Java-based ORM framework, Hibernate.
-
Build Semantic Layer Views for Google Calendar Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Calendar data.
-
Import MailerLite Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MailerLite Data and provide access to live MailerLite data for custom reports in the Power BI Service.
-
Query SAP Business Warehouse Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Business Warehouse entities in PHP by modeling them as objects.
-
How to publish and share Quaderno Data dashboards with Tableau Server
The CData ODBC driver for Quaderno enables you integrate Quaderno data into Tableau dashboards.
-
Connect to Clari Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Clari as an External Source in Dremio.
-
How to Connect to & Open SendGrid Data in Microsoft Excel
This article uses the CData ODBC driver for SendGrid to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Outreach.io Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Outreach.io data through MCP integration.
-
How to Build an ETL App for Helpscout Data in Python with CData
Create ETL applications and real-time data pipelines for Helpscout data in Python with petl.
-
How to Create Power BI Visual Reports with Real-Time ZohoExpense Data
Use CData Power BI Connectors to visualize ZohoExpense data in Power BI.
-
Presto Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Presto data through CData Connect AI using different applications and tools.
-
Connect to HelloSign Data in Aqua Data Studio
Access HelloSign data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Choosing the Best Method to Connect Tickspot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tickspot data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate with Microsoft Dataverse Data in JReport Designer
Create charts and reports based on Microsoft Dataverse data in JReport Designer.
-
Connect to VWO from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from VWO data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software ODBC Driver for SAP BusinessObjects BI in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP BusinessObjects BI data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP BusinessObjects BI.
-
Integrate AfterShip with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AfterShip with External Services.
-
Consume Square OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Square feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Perplexity Replication to MySQL
Use CData Sync for automated, continuous, customizable Perplexity replication to MySQL.
-
How to Connect to Live Google Ad Manager 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 Google Ad Manager data for you.
-
How to import Raisers Edge NXT Data into Apache Solr
Use the CData Software JDBC Driver for Raisers Edge NXT in Data Import Handler and create an automated import of Raisers Edge NXT data to Apache Solr Enterprise Search platform.
-
How to Connect to & Open Drip Data in Microsoft Excel
This article uses the CData ODBC driver for Drip to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect DBeaver to Google Analytics via a JDBC Driver
Manage Google Analytics data with visual tools in DBeaver like the query browser.
-
Create Datasets from PolarTeamPro in Domo Workbench and Build Visualizations of PolarTeamPro Data in Domo
Use the CData Software ODBC Driver for PolarTeamPro to create datasets from PolarTeamPro data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Vimeo in MicroStrategy
Connect to Vimeo data in MicroStrategy Developer using the CData Software ODBC Driver for Vimeo.
-
Access Live SAP HANA Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP HANA data from your Excel spreadsheets.
-
Build Semantic Layer Views for FHIR Data in APOS Live Data Gateway
Use the CData Connector for FHIR in APOS Live Data Gateway to build Semantic Layer Views for FHIR data.
-
Getting Started with the CData SSIS Components for Webex
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Webex.
-
How to Connect to Live Amazon S3 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon S3 data securely in real time.
-
A PostgreSQL Interface for Rootly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Rootly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Dataiku with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live NetSuite SuiteAnalytics data.
-
Use the CData Software ODBC Driver for Optimizely in MicroStrategy
Connect to Optimizely data in MicroStrategy Developer using the CData Software ODBC Driver for Optimizely.
-
Use Claude to Talk to Your Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Marketo data for you.
-
How to Visualize Oracle Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Oracle data in Python.
-
Use the CData Software ODBC Driver for Salesforce CRM Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce CRM Analytics data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce CRM Analytics.
-
Replicate Jira Data from PowerShell
Write a quick PowerShell script to query Jira data. Use connectivity to the live data to replicate Jira data to SQL Server.
-
Analyze Hubstaff Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hubstaff from Power Pivot. You will use the Table Import Wizard to load Hubstaff data. You can visually build the import query or use any SQL supported by the driver.
-
Publish Reports with Blackbaud FE NXT Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Blackbaud FE NXT data.
-
Connect to Omnisend Data in Aqua Data Studio
Access Omnisend data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish Reports with Unbounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Unbounce data.
-
Connect to Act-On Data from HeidiSQL
Use CData Connect AI to connect to and query live Act-On data from HeidiSQL.
-
Create Zoho CRM-Connected Business Apps in AppSheet
Connect to Zoho CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho CRM data.
-
Use Claude to Talk to Your Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Timely data for you.
-
Getting Started with the CData JDBC Driver for SQL Server
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SQL Server.