CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with SAS xpt Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAS xpt data.
-
How to Connect to Live Mailjet Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Mailjet data securely in real time.
-
Build a Simple VCL Application for SAP Ariba Procurement Data
How to build a simple VCL Application to view SAP Ariba Procurement data in RAD Studio using the CData ODBC Driver for SAP Ariba Procurement.
-
Use the CData Software ODBC Driver for AlloyDB in MicroStrategy
Connect to AlloyDB data in MicroStrategy Developer using the CData Software ODBC Driver for AlloyDB.
-
How to Connect to Live Google Drive Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Drive data for you.
-
Prepare, Blend, and Analyze Gorgias Data in Alteryx Designer (ODBC)
Build workflows to access live Gorgias data for self-service data analytics.
-
How to use SQLAlchemy ORM to access Salesforce CRM Analytics Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce CRM Analytics data.
-
Access Live Authorize.Net Data in Excel 365 Online (Excel for the web)
Connect to Authorize.Net data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Informatica Mappings From/To a JDBC Data Source for ScrapingBee
Create ScrapingBee data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Adobe Analytics Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Adobe Analytics data with the CData JDBC Driver for Adobe Analytics.
-
Build Microsoft Planner-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Planner Data from Choreo and build custom apps using live Microsoft Planner data.
-
Connect to Zoom Data in RapidMiner
Integrate Zoom data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Unbounce from Asprova with CData Software ODBC Driver for Unbounce
This article shows how to connect faster to Unbounce data from Asprova.
-
Design BIRT Reports on Trello Data
Provide current Trello data to your embedded analytics.
-
How to connect PolyBase to Facebook Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Facebook Ads data.
-
Extract, Transform, and Load Azure DevOps Data in Informatica PowerCenter
Create a simple Workflow for Azure DevOps data in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for SpaceX in MicroStrategy Desktop
Connect to SpaceX data in MicroStrategy Desktop using the CData Software JDBC Driver for SpaceX.
-
Establish a Live Connection with Google Cloud Storage Data using Tableau Bridge
The CData ODBC Driver for Google Cloud Storage enables you to integrate live Google Cloud Storage data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Agno to Talk to Your Power BI XMLA 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 Power BI XMLA data for you.
-
Automated Continuous SAP SuccessFactors Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to PostgreSQL.
-
Use the CData Software JDBC Driver for Onfleet in MicroStrategy Web
Connect to Onfleet data in MicroStrategy Web using the CData Software JDBC Driver for Onfleet.
-
Build a PostgreSQL Interface for Power BI XMLA Data using the CData JDBC Driver
Use the Remoting features of the Power BI XMLA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live GitLab Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live GitLab data through MCP integration.
-
Pipeliner CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pipeliner CRM facts in real time.
-
Access Gmail Data from MySQL in PHP
Connect to Gmail through the standard MySQL libraries in PHP.
-
How to Connect to Live Teradata 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 Teradata data for you.
-
Validate Salesforce CRM Analytics Data with QuerySurge
Access and validate Salesforce CRM Analytics data in QuerySurge using the CData JDBC Driver.
-
How to Visualize Teamwork Data in Python with pandas
Use pandas and other modules to analyze and visualize live Teamwork data in Python.
-
Integrating Antigravity CLI with Google Tasks data via CData CLI
Connect Google Tasks data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Consume QuickBooks OData Feeds in SAP Lumira
Use the API Server to create data visualizations on QuickBooks feeds that reflect any changes in SAP Lumira.
-
How to Use a Microsoft Access Database to Update Vault CRM Data in Real Time
Update Vault CRM data by creating a linked table in Microsoft Access with the CData Vault CRM ODBC Driver.
-
Publish Crystal Reports on RabbitMQ Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date RabbitMQ data.
-
Natively Connect to Salesforce Data 360 Data in PHP
The CData ODBC driver for Salesforce Data 360 enables you to create PHP applications with connectivity to Salesforce Data 360 data. Leverage the native support for ODBC in PHP.
-
Integrate with Klipfolio Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Klipfolio data in SnapLogic.
-
How to connect to Odoo Data from IntelliJ
Integrate connectivity to Odoo data with wizards in IntelliJ.
-
How to load Google Directory data into Elasticsearch via Logstash
Introducing a simple method to load Google Directory data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Data Visualizations Based On Moosend Data in Mode
Use CData Connect AI to connect to Moosend Data from Mode and build visualizations using live Moosend data.
-
Bridge Placid Connectivity with Apache NiFi
Access and process Placid data in Apache NiFi using the CData JDBC Driver.
-
Integrate with Live Azure Data Catalog Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Data Catalog from the MuleSoft Anypoint Platform to integrate live Azure Data Catalog data into custom reports and dashboards.
-
Create Reports from Pinterest Data in Looker Studio
Use CData Connect AI to gain access to live Pinterest data and create custom reports in Looker Studio.
-
Integrating Kiro with Spotify 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 Azure Table Data from IntelliJ
Integrate connectivity to Azure Table data with wizards in IntelliJ.
-
Use the CData ODBC Driver for ServiceDesk Plus in Microsoft Power Query
You can use the CData ServiceDesk Plus ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ServiceDesk Plus data into Microsoft Power Query.
-
Analyze ShipStation Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ShipStation from Power Pivot. You will use the Table Import Wizard to load ShipStation data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Discourse Data in JRuby
Create a simple JRuby app with access to live Discourse data.
-
Create a Data Access Object for EmailOctopus Data using JDBI
A brief overview of creating a SQL Object API for EmailOctopus data in JDBI.
-
Connect to Azure Data Lake Storage Data from a Connection Pool in JBoss
Integrate Azure Data Lake Storage data into Java servlets: Use the Management Console in JBoss to install the Azure Data Lake Storage JDBC Driver.
-
Analyze Shippo Data in Looker
Use CData Connect AI to connect to Shippo Data from Looker and build custom apps using live Shippo data.
-
Replicate Email Data in Heroku for Use in Salesforce Connect
Replicate Email data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
SAP SuccessFactors LMS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP SuccessFactors LMS facts in real time.
-
Connect to Instagram Data in DBArtisan
Use wizards in DBArtisan to configure Instagram data as a data source.
-
Getting Started with the CData Excel Add-In for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Analytics.
-
Connect to Hacker News Data in DBArtisan
Use wizards in DBArtisan to configure Hacker News data as a data source.
-
Integrating Dataiku with Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Trello data.
-
DataBind PolarTeamPro Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PolarTeamPro data to a chart.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dotmailer
Provide connectivity to Dotmailer data through an SAP BusinessObjects universe.
-
Build Data Flows from Blackbaud FE NXT to SQL Server using SSIS
Easily back up Blackbaud FE NXT data to SQL Server using the SSIS components for Blackbaud FE NXT.
-
Integrate Google's Vertex AI Agent with Live SAP SuccessFactors 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 SAP SuccessFactors data within intelligent workflows.
-
How to Connect to Live Perplexity Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Perplexity data through natural language.
-
Automated Continuous Bright Data Replication to Oracle
Use CData Sync for automated, continuous, customizable Bright Data replication to Oracle.
-
Build Pipelines with Live Oracle Sales Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Sales from Google Cloud Data Fusion, enabling the integration of live Oracle Sales data into the building and management of effective data pipelines.
-
Use the CData Software JDBC Driver for SQL Analysis Services in MicroStrategy
Connect to SQL Analysis Services data in MicroStrategy Developer using the CData Software JDBC Driver for SQL Analysis Services.
-
How to Work with Samanage Data in AWS Glue Jobs Using JDBC
Connect to Samanage from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Authorize.Net Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Authorize.Net data through MCP integration.
-
Integrate Open WebUI with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Blackbaud FE NXT data from within the chat interface.
-
Analyze Live Azure Analysis Services Data in SAS Viya
Use CData Connect AI to connect to Azure Analysis Services data from SAS Viya and deploy self-service analytics using live Azure Analysis Services data.
-
Access Live ADP Data in Coginiti Pro
Connect to and query live ADP data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating LangGraph with Reckon Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Reckon data within automated workflows.
-
Build Charts with Factorial Data in Clear Analytics
Create dynamic charts and perform analytics based on Factorial data in Clear Analytics.
-
Getting Started with the CData JDBC Driver for Coda
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Coda.
-
Integrate Open WebUI with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sendwithus data from within the chat interface.
-
Add Foursquare Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Foursquare with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query AgileCRM Data in MySQL Workbench
Execute MySQL queries against live AgileCRM data from MySQL Workbench.
-
Connect to Pinecone Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pinecone data.
-
How to Access Live Facebook Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Facebook enables you to integrate Facebook data into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Dynamics NAV Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dynamics NAV data in Python.
-
Model LinkedIn Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and LinkedIn Ads, enabling the direct import of real-time LinkedIn Ads data.
-
Process & Analyze Todoist Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Todoist Data.
-
How to Connect DBeaver to ZendeskSell via a JDBC Driver
Manage ZendeskSell data with visual tools in DBeaver like the query browser.
-
Replicate Multiple LinkedIn Accounts via the CData Sync CLI
Replicate multiple LinkedIn accounts to one or many databases.
-
Access Live Cloudant Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Cloudant data from your Excel spreadsheets.
-
Connect to Omnisend Data in RazorSQL
Connect to Omnisend from wizards and query Omnisend data from the GUI in the RazorSQL database management tool.
-
Connect to BigCommerce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from BigCommerce data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Copper Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Copper and work with Copper data in your FileMaker applications.
-
Getting Started with the CData ADO.NET Provider for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating OpenCode with Jumpseller 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.
-
Create Dashboards and Visualize Live Azure Synapse Data in Geckoboard
Use CData Connect AI to connect to live Azure Synapse data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Publish BigCommerce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BigCommerce data.
-
Visualize Live Microsoft Teams Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Teams data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Active Directory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Active Directory data.
-
Connect to Amazon Marketplace Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon Marketplace data from Filemaker Pro on Mac.
-
Tavily Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Tavily data through CData Connect AI using different applications and tools.
-
Create BambooHR-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to BambooHR Data from Klipfolio and build custom visualizations using live BambooHR data.
-
Connect to Azure Synapse Data in Ruby
Connect to Azure Synapse data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software JDBC Driver for Twitter Ads in MicroStrategy
Connect to Twitter Ads data in MicroStrategy Developer using the CData Software JDBC Driver for Twitter Ads.
-
Query Live Freshdesk 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 Freshdesk data through a conversational interface.
-
How to load Excel Online data into Elasticsearch via Logstash
Introducing a simple method to load Excel Online data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Mode Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Mode data from your Excel spreadsheets.
-
Create Lakebase-Connected Applications in Appsmith
Connect to Lakebase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Lakebase data.
-
Automated Continuous Cloudflare Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Cloudflare replication to Azure SQL Database.