CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Oracle Service Cloud 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 Oracle Service Cloud data through natural language.
-
Publish Dropbox-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Dropbox data.
-
Connect Hubstaff to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hubstaff with IBM WebSphere for seamless data integration and connectivity.
-
How to connect PolyBase to SharePoint
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SharePoint data.
-
Build Procore-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Procore data without replication.
-
Build Supabase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Supabase Data and create custom apps in Mendix.
-
Visualize Amazon S3 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon S3 data.
-
Connect to Planio in SpagoBI
Create reports featuring live Planio data in SpagoBI Studio. Host Planio reports on SpagoBI Server.
-
Create Informatica Mappings From/To a JDBC Data Source for MessageBird
Create MessageBird data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect DBeaver to Figshare via a JDBC Driver
Manage Figshare data with visual tools in DBeaver like the query browser.
-
Integrating Pinterest Data in Talend Cloud Data Management Platform
Connect Pinterest Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Pinterest.
-
Use the CData ODBC Driver for Vercel from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Vercel to connect to Vercel data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Vercel data in Excel.
-
Build a PostgreSQL Interface for ConstantContact Data using the CData JDBC Driver
Use the Remoting features of the ConstantContact JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Live SAP Netweaver Gateway Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP Netweaver Gateway data directly from the development environment.
-
Build AI/ML Models with Live Pushbullet Data using Dataiku
Connect Pushbullet Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Oracle HCM Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Vertica.
-
Connect to Sugar CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sugar CRM to connect to Sugar CRM data from Web applications running on WebLogic.
-
Automated Continuous Contentful Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Contentful data replication to OneLake in Microsoft Fabric.
-
How to connect SharePoint with GraphQL Data through external lists
Provide GraphQL data to SharePoint users as an external list.
-
Build SAP Concur Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Concur data and build visualizations in Tableau Cloud.
-
Create Reports from Printify Data in Looker Studio
Use CData Connect AI to gain access to live Printify data and create custom reports in Looker Studio.
-
Connect to Flowlu Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Flowlu as an External Source in Dremio.
-
Write a Simple Go Application to work with Snowflake Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Snowflake data.
-
Analyze Zoho Creator Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Creator data and visualize live Zoho Creator data in Infragistics Reveal.
-
Integrating Cursor with Microsoft Dataverse 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.
-
Build Semantic Layer Views for Excel Data in APOS Live Data Gateway
Use the CData Connector for Excel in APOS Live Data Gateway to build Semantic Layer Views for Excel data.
-
Create Power BI Reports on Real-Time Teradata Data
Use the CData ODBC Driver for Teradata to visualize Teradata data in Power BI Desktop.
-
Build Microsoft Exchange-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Exchange Data and create custom apps in Bubble.
-
Integrate Brex Data in Pentaho Data Integration
Build ETL pipelines based on Brex data in the Pentaho Data Integration tool.
-
Connect to RabbitMQ Data in NetBeans
Connect to RabbitMQ data in NetBeans with the data source configuration wizard.
-
Connect to ScrapingBee Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ScrapingBee to connect to ScrapingBee data and execute queries in PowerBuilder.
-
Deploy the ADO.NET Provider for Oracle SCM on an SSRS Report Server
Connect to Oracle SCM data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Work with SAS xpt Data in ETL Validator JDBC
Connect to SAS xpt from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Productboard with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Productboard with External Services.
-
Getting Started with the CData SSIS Components for eBay
Complete guide to installing, licensing, and connecting with the CData SSIS Components for eBay.
-
Excel Spreadsheet Automation on Teamwork Data with the QUERY Formula
Pull data from Teamwork, automate spreadsheets, and more with the QUERY formula.
-
DataBind Controls to CloudConvert Data in C++Builder
DataBind to CloudConvert data in C++Builder with standard components and controls.
-
Connect Cloudant to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Cloudant with IBM WebSphere for seamless data integration and connectivity.
-
How to integrate Clio with Apache Airflow
Access and process Clio data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Zoho Recruit Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Databricks.
-
Link ScrapingBee with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ScrapingBee data in Filemaker Pro for Mac or Windows.
-
Query OData Services as a MySQL Database in Node.js
Execute MySQL queries against OData services from Node.js.
-
How to Connect Flowise AI Agents to Live Airtable 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 Airtable data without replication.
-
Integrate Live Bugsnag Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Bugsnag data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Query Kintone Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Kintone entities in PHP by modeling them as objects.
-
How to use SQLAlchemy ORM to access Mode Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mode data.
-
Connect to FreeAgent in SpagoBI
Create reports featuring live FreeAgent data in SpagoBI Studio. Host FreeAgent reports on SpagoBI Server.
-
Connect to Real-Time Certinia Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Certinia and Dataflow to import and use Certinia data in Power Apps.
-
Integrate Trae with Live Authorize.Net Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Authorize.Net data from within the AI-powered IDE.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy Desktop
Connect to Zoom data in MicroStrategy Desktop using the CData Software JDBC Driver for Zoom.
-
Validate Dropbox Data with QuerySurge
Access and validate Dropbox data in QuerySurge using the CData JDBC Driver.
-
How to create Visio diagrams from Avalara AvaTax Data
Automatically update Avalara AvaTax data with the changes you make to Visio master shapes.
-
How to Seamlessly Import ZohoMarketingHub Data into IBM SPSS Modeler
Integrate ZohoMarketingHub data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for EnterpriseDB in SAS for Real-Time Reporting and Analytics
Connect to real-time EnterpriseDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for EnterpriseDB.
-
Automated Continuous Billsby Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Billsby replication to AlloyDB.
-
Integrating Dataiku with SAP SuccessFactors 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 SuccessFactors data.
-
Connect and Query Live Spark Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Spark data into Databricks and enable direct, live querying and analysis without replication.
-
Automate Telegram Data Replication to SAP HANA
Use CData Sync to customize and automate Telegram data replication to SAP HANA.
-
Automate Google Tasks Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Tasks data replication to Azure Synapse.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics CRM
Create an ODBC connection to Dynamics CRM in Informatica and browse and transfer Dynamics CRM data.
-
How to Query Live Typeform Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Typeform data data in natural language using Python.
-
Visualize Confluence Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Confluence data.
-
Connect to HBase Data in ACL Analytics
Connect to HBase data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to HBase data.
-
Connect to Salesforce Marketing Data in DBArtisan
Use wizards in DBArtisan to configure Salesforce Marketing data as a data source.
-
Integrating Antigravity CLI with ConvertAPI data via CData CLI
Connect ConvertAPI data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating GitHub Copilot with Instagram 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.
-
Build Automated VWO-Connected Workflows in Zapier
Use CData Connect AI to connect to live VWO data and build automated workflows in Zapier.
-
Build Semantic Layer Views for ShipEngine Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ShipEngine data.
-
Use the CData ODBC Driver for Adobe Experience Manager from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Experience Manager to connect to Adobe Experience Manager data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Experience Manager data in Excel.
-
Automate Hugging Face Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Hugging Face data from PowerShell? This article demonstrates how to utilize the Hugging Face Cmdlets for tasks like connecting to Hugging Face data, automating operations, downloading data, and more.
-
How to Connect to Twilio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Twilio data. Leverage the pyodbc module for ODBC in Python.
-
Build AI Agents with LinkedIn Ads 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 LinkedIn Ads data through CData Connect AI.
-
Visualize Reply.io 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 Reply.io data into TIBCO Spotfire.
-
Automated Continuous Amazon S3 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Amazon Redshift.
-
Visualize Printify Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Printify data.
-
Model, Search, and Visualize Live Coda Data in ThoughtSpot
Use CData Connect AI to connect to live Coda data for modeling, searching, and visualizing.
-
Work with Live Reckon Accounts Hosted Data in Power Query
Use CData Connect AI to connect to Reckon Accounts Hosted data and work with live Reckon Accounts Hosted data in Microsoft Power Query.
-
Use Databricks Agent Bricks to Talk to Your HDFS Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HDFS data for you.
-
Connect to Workable in SpagoBI
Create reports featuring live Workable data in SpagoBI Studio. Host Workable reports on SpagoBI Server.
-
Easily Integrate Guru Data in Lazarus Pascal IDE
Learn how to easily integrate live Guru data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Visualize Salesforce Data 360 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 Salesforce Data 360 data in Python.
-
Integrating Antigravity CLI with Quaderno data via CData CLI
Connect Quaderno data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to MySQL Data in Jaspersoft Studio
Execute SQL to remote MySQL data in Jaspersoft Studio.
-
Import Real-Time Microsoft Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Ads data in ColdFusion.
-
Connect to Elasticsearch from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Elasticsearch data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use Dash to Build to Web Apps on Stripe Data
Create Python applications that use pandas and Dash to build Stripe-connected web apps.
-
A PostgreSQL Interface for Certinia Data (MySQL Remoting via JDBC)
Use the Remoting features of the Certinia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Smartsheet Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Smartsheet Data and provide access to live Smartsheet data for custom reports in the Power BI Service.
-
Analyze SFTP Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SFTP data in Microsoft R Open.
-
Integrating Google Directory Data in Talend Cloud Data Management Platform
Connect Google Directory Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Directory.
-
How to Connect DBeaver to Bitbucket via a JDBC Driver
Manage Bitbucket data with visual tools in DBeaver like the query browser.
-
Replicate REST Data to Multiple Databases via the CData Sync CLI
Replicate REST data to disparate databases with a single configuration.
-
Analyze Google Spanner Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Spanner data in Microsoft R Open.
-
Create Datasets from Invoiced in Domo Workbench and Build Visualizations of Invoiced Data in Domo
Use the CData Software ODBC Driver for Invoiced to create datasets from Invoiced data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Aweber Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Aweber data from your Excel spreadsheets.
-
Connect to SpaceX Data in HULFT Integrate
Connect to SpaceX as a JDBC data source in HULFT Integrate
-
Stream SendGrid Data into Apache Kafka Topics
Access and stream SendGrid data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating OpenCode with Discourse 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 ODBC Driver for TigerGraph
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for TigerGraph.
-
Use Biml to Build SSIS Tasks to Replicate SAP Concur Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Concur data to SQL Server.