CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for Confluence Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Confluence data.
-
Access Sage Intacct Data from MySQL in Amazon QuickSight
Connect to Sage Intacct and build visualizations of Sage Intacct data using a MySQL Connection in Amazon QuickSight.
-
How to Connect Flowise AI Agents to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data without replication.
-
Build Automated Workflows with Live ShipStation Data in Workato
Use CData Connect AI to connect to live ShipStation data and build automated workflows in Workato.
-
Visualize LinkedIn Ads Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load LinkedIn Ads data into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Recurly in MicroStrategy
Connect to Recurly data in MicroStrategy Developer using the CData Software ODBC Driver for Recurly.
-
Creating Elasticsearch-Connected Applications in Unqork
You can use CData Connect AI to feed Elasticsearch data to Unqork and build custom business apps.
-
Viewing ShipStation Data in RAD Studio Data Explorer
How to view ShipStation data in RAD Studio Data Explorer using the CData ODBC Driver for ShipStation.
-
Visualize Live Act CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Act CRM data into custom reports in Power BI.
-
Model Gmail Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Gmail, enabling the direct import of real-time Gmail data.
-
Prepare, Blend, and Analyze ServiceNow Data in Alteryx Designer (ODBC)
Build workflows to access live ServiceNow data for self-service data analytics.
-
Import Snowflake Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Snowflake Data and provide access to live Snowflake data for custom reports in the Power BI Service.
-
How to create an RPA flow for NASA Data in UiPath Studio
Use the NASA ODBC Driver to create workflows that access real-time NASA data without any coding.
-
Migrating data from Google Ads to Google BigQuery using CData SSIS Components.
Easily push Google Ads data to Google BigQuery using the CData SSIS Tasks for Google Ads and Google BigQuery.
-
Access Live GitHub Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GitHub data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating LangChain with Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Mailjet data within automated workflows.
-
Build Semantic Layer Views for Azure Data Lake Storage Data in APOS Live Data Gateway
Use the CData Connector for Azure Data Lake Storage in APOS Live Data Gateway to build Semantic Layer Views for Azure Data Lake Storage data.
-
How to connect and process Keap data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Keap data.
-
Connect to Dynamics 365 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Dynamics 365 data in Airbyte.
-
Build an OLAP Cube in SSAS from Nuclia Data
Establish a connection to Nuclia data data from SQL Server Analysis Services, and use the Nuclia Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live Oracle SCM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle SCM data into custom reports in Power BI.
-
Connect to Hugging Face Data in RazorSQL
Connect to Hugging Face from wizards and query Hugging Face data from the GUI in the RazorSQL database management tool.
-
Connect to and Query ZohoInvoice Data in QlikView over ODBC
Create data visualizations with ZohoInvoice data in QlikView.
-
Connect and Visualize Live Elasticsearch Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Elasticsearch data into the Databricks platform and create visualization dashboards with real-time Elasticsearch data.
-
Use Databricks Agent Bricks to Talk to Your Mailgun Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Mailgun data for you.
-
Model BigQuery Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and BigQuery, enabling the direct import of real-time BigQuery data.
-
Connect Google Sheets Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Sheets data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Datasets from Google Analytics in Domo Workbench and Build Visualizations of Google Analytics Data in Domo
Use the CData Software ODBC Driver for Google Analytics to create datasets from Google Analytics data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Power BI Connector for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Zoho CRM.
-
Integrate Live Salesforce Data 360 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Data 360 data and integrate live Salesforce Data 360 data into apps built in Microsoft Power Apps.
-
Automated Continuous ClickUp Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ClickUp replication to delimited files (CSV/TSV).
-
Build a PostgreSQL Interface for Notion Data using the CData JDBC Driver
Use the Remoting features of the Notion JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Ontraport Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Ontraport data with the CData JDBC Driver for Ontraport.
-
Visualize Office 365 Data in Sisense
Create an ElastiCube in Sisense app with access to Office 365 data.
-
Connect to Zoom Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoom data in Google Apps Script.
-
Connect to Paddle Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Paddle and work with Paddle data in your FileMaker applications.
-
Access PabblySubscriptions Data from MySQL in PHP
Connect to PabblySubscriptions through the standard MySQL libraries in PHP.
-
Connect Helpscout Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Helpscout data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData SSIS Components for Vimeo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Vimeo.
-
How to connect to Raisers Edge NXT Data in DBVisualizer
Integrate Raisers Edge NXT data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Apps from CouchDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to CouchDB Data and build apps from live CouchDB data in Qlik Sense Cloud.
-
How to Connect to Live PingOne 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 PingOne data for you.
-
Work with Square Data in FoxPro
Load Square data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Seamlessly Import Webex Data into IBM SPSS Modeler
Integrate Webex data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Build an ETL App for Webflow Data in Python with CData
Create ETL applications and real-time data pipelines for Webflow data in Python with petl.
-
Extract, Transform, and Load CircleCI Data in Informatica PowerCenter
Create a simple Workflow for CircleCI data in Informatica PowerCenter.
-
Integrate Goose with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Bullhorn CRM data from within the local AI agent.
-
Use the CData ODBC Driver for Google Sheets in Microsoft Power Query
You can use the CData Google Sheets ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Sheets data into Microsoft Power Query.
-
Analyze JSON Services in Infragistics Reveal
Use CData Connect AI to create on OData API on top of JSON services and visualize live JSON services in Infragistics Reveal.
-
Automated Continuous xBase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable xBase replication to Amazon S3.
-
Automate Perigon Data Replication to Azure Synapse
Use CData Sync to customize and automate Perigon data replication to Azure Synapse.
-
Explore Geographical Relationships in SpaceX Data with Power Map
Create data visualizations with SpaceX data in Power Map.
-
Build a Simple VCL Application for CSV Data
How to build a simple VCL Application to view CSV data in RAD Studio using the CData ODBC Driver for CSV.
-
Create Power BI Reports on Real-Time Freshdesk Data
Use the CData ODBC Driver for Freshdesk to visualize Freshdesk data in Power BI Desktop.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Eloqua Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle Eloqua data.
-
Connect to SAP Business One Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Business One data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Business One.
-
Automated Continuous Databricks Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Databricks replication to AlloyDB.
-
Connect to Guru Data in Jaspersoft Studio
Execute SQL to remote Guru data in Jaspersoft Studio.
-
Connecting Moonlit Workflow with Typeform Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Typeform data in real time.
-
How to Seamlessly Import ADP Data into IBM SPSS Modeler
Integrate ADP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live Supabase 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 Supabase data for you.
-
Analyze Recurly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Recurly data with the CData JDBC Driver for Recurly.
-
Import Real-Time LDAP Objects via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LDAP objects in ColdFusion.
-
Connect to Freshdesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshdesk data.
-
How to create Salesforce Pardot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Pardot data in MySQL .
-
Connect to JobNimbus Data in DBArtisan
Use wizards in DBArtisan to configure JobNimbus data as a data source.
-
How to Visualize Short.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Short.io data in Python.
-
Moving Data from Exa to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Exa data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Optimizely Data from Crystal Reports
Use CData Connect AI to connect to and report on live Optimizely data from Crystal Reports.
-
Use the CData Software ODBC Driver for Pinecone in MicroStrategy
Connect to Pinecone data in MicroStrategy Developer using the CData Software ODBC Driver for Pinecone.
-
Working with Highrise Data in LINQPad
Execute LINQ queries to Highrise data in LINQPad.
-
Automated Continuous Basecamp Replication to Vertica
Use CData Sync for automated, continuous, customizable Basecamp replication to Vertica.
-
Connect to Authorize.Net Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Authorize.Net and the Script function in FileMaker Pro to connect to Authorize.Net and work with Authorize.Net data in your FileMaker application.
-
Build QuickBooks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live QuickBooks data and build visualizations in Tableau Cloud.
-
Natively Connect to Elasticsearch Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Elasticsearch data. Leverage the native support for ODBC in PHP.
-
How to connect Amazon QuickSight to QuickBooks Online Data
Create a connection to QuickBooks Online data in CData Connect AI and insert QuickBooks Online data into Amazon QuickSight SPICE to build interactive dashboards.
-
Excel Spreadsheet Automation on PingOne Data with the QUERY Formula
Pull data from PingOne, automate spreadsheets, and more with the QUERY formula.
-
How to create Procore federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Procore data in MySQL .
-
Connect to Avro Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Avro data.
-
Automated Continuous ChargeOver Replication to Databricks
Use CData Sync for automated, continuous, customizable ChargeOver replication to Databricks.
-
How to work with Oracle HCM Cloud Data in Apache Spark using SQL
Access and process Oracle HCM Cloud Data in Apache Spark using the CData Software JDBC Driver.
-
Import and Visualize Superchat Data in Power View
Create data visualizations based on Superchat data in Excel.
-
Create Cohere Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cohere data access from reports, embedded analytics, and more.
-
View Reports on Real-Time Authorize.Net Data in Power BI Report Server
Use the CData ODBC Driver for Authorize.Net to visualize Authorize.Net data in Power BI Desktop and then publish them to Power BI Report Server.
-
Model CockroachDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and CockroachDB, enabling the direct import of real-time CockroachDB data.
-
Choosing the Best Method to Connect Klaviyo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Klaviyo data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Bridge Float Connectivity with Apache NiFi
Access and process Float data in Apache NiFi using the CData JDBC Driver.
-
Access Live Oracle Eloqua Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Eloqua data from your Excel spreadsheets.
-
How to update Blackbaud FE NXT from Excel
This article explains how to transfer data from Excel to Blackbaud FE NXT using the Excel Add-In for Blackbaud FE NXT.
-
Automated Continuous Mocean Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mocean replication to IBM DB2.
-
Automated Continuous Oracle Sales Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle Sales replication to PostgreSQL.
-
Build Stripe-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Stripe data and build web apps with connectivity to live Stripe data.
-
Integrate Goose with Live Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Bright Data data from within the local AI agent.
-
Connect to Contentful Data in DBeaver
Use the CData ODBC Driver to connect to Contentful data in DBeaver.
-
Replicate Multiple Microsoft Entra ID Accounts
Replicate multiple Microsoft Entra ID accounts to one or many databases.
-
Build Pipelines with Live xBase Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to xBase from Google Cloud Data Fusion, enabling the integration of live xBase data into the building and management of effective data pipelines.
-
Visualize SharePoint Data in TIBCO Spotfire through OData
Integrate SharePoint data into dashboards in TIBCO Spotfire.
-
Create Reports with Printful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printful data.
-
Use JayDeBeApi to access Google Campaign Manager 360 Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Campaign Manager 360 data.
-
How to connect to Google Sheets Data with Squirrel SQL client
Connect to Google Sheets data and execute queries in the Squirrel SQL Client.