CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ODBC Driver for Datadog
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Datadog.
-
Create Outreach.io-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Outreach.io Data from OutSystems and build custom enterprise apps using live Outreach.io.
-
Access Live Cassandra Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Cassandra into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Cassandra in the Graph Builder and Query Builder.
-
Build REST-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for REST to explore live REST Data in GitHub Copilot to assist with building REST-powered applications.
-
Automated Continuous Front Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Front replication to Amazon S3.
-
Build Semantic Layer Views for HBase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache HBase.
-
DataBind Controls to Salesforce Pardot Data in Delphi
DataBind to Salesforce Pardot in Delphi with standard data access components and controls.
-
Configure the CData JDBC Driver for Brex in a Connection Pool in Tomcat
Connect to Brex from a connection pool in Tomcat.
-
Use JayDeBeApi to access Pinecone Data in Python
Use standard Python scripting and the development environment of your choice to access live Pinecone.
-
Access Live Webflow Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Webflow into the statistical analysis tools available in SAS JMP. This article shows how to use Webflow in the Graph Builder and Query Builder.
-
Easily Integrate Adobe Target Data in Lazarus Pascal IDE
Learn how to easily integrate live Adobe Target in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Teamgate Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Teamgate using standard SQL.
-
Build Apps with Live Hugging Face Data Using the Low-Code Development Platform of Mendix
Connect Hugging Face with Mendix to build apps using the CData API Driver for JDBC.
-
Build Semantic Layer Views for Mistral AI Data in APOS Live Data Gateway
Use the CData Connector for Mistral AI in APOS Live Data Gateway to build Semantic Layer Views for Mistral AI.
-
How to connect to Invoiced Data in DBVisualizer
Integrate Invoiced with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish MarkLogic-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MarkLogic.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed IBM Cloud Object Storage to Power BI dashboards. Simply drag and drop IBM Cloud Object Storage into data visuals on the Power BI canvas.
-
Create Dynamic Todoist Grids Using the Infragistics XamDataGrid
Learn how you can connect Todoist to Infragistics XamDataGrid to build dynamic grids.
-
Automated LinkedIn Data Replication to Teradata
Use CData Sync to Customize and automate LinkedIn replication to Teradata.
-
Using the CData Software ODBC Driver for OneNote in PyCharm
Connect to OneNote as an ODBC data source in PyCharm using the CData Software ODBC Driver for OneNote.
-
Load Google Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Analytics to a database.
-
Connect to and Query Bitly Data in QlikView over ODBC
Create data visualizations with Bitly in QlikView.
-
Extend Google Sheets with PostgreSQL Data
Make calls to PostgreSQL from Google Apps Script via the API Server.
-
How to Easily Query Apify Data in OpenOffice Base
Connect to Apify data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Acumatica Data in JRuby
Create a simple JRuby app with access to live Acumatica ERP.
-
How to connect and process Google Cloud Storage from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Cloud Storage.
-
Integrate Cursor with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Facebook from within the editor.
-
Visualize Live HelloSign Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HelloSign.
-
Visualize Placid Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Placid.
-
Connect to SAP Ariba Source Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Ariba Source.
-
Back Up Beeminder to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Beeminder data.
-
Create IBM Cloud Object Storage-Connected Dashboards in Grafana
Connect to IBM Cloud Object Storage Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to IBM Cloud Object Storage.
-
How to use SQLAlchemy ORM to access SAS Data Sets Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAS Data Sets.
-
Build Semantic Layer Views for Omnisend Data in APOS Live Data Gateway
Use the CData Connector for Omnisend in APOS Live Data Gateway to build Semantic Layer Views for Omnisend.
-
Access Live Sage Intacct Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage Intacct from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to MarkLogic from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MarkLogic, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Live OData Services in the Power BI Service
Use CData Connect AI to connect to live OData and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Greenhouse Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Greenhouse and build visualizations in Tableau.
-
Automated Continuous SAP HANA Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP HANA replication to Apache Cassandra.
-
Integrating LangGraph with Couchbase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Couchbase within automated workflows.
-
Use the CData ODBC Driver for Google Forms from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Forms to connect to Google Forms from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Forms in Excel.
-
Use the CData Software JDBC Driver for Couchbase in MicroStrategy Web
Connect to Couchbase in MicroStrategy Web using the CData Software JDBC Driver for Couchbase.
-
Analyze Kafka Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Kafka and visualize live Apache Kafka in Infragistics Reveal.
-
Use the CData API Server to Access Zoho Inventory Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zoho Inventory in the Power Pivot business intelligence tool.
-
Choosing the Best Method to Connect Yelp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Yelp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Crystal Reports on Egnyte Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Egnyte.
-
Connect to FreshBooks Data from HeidiSQL
Use CData Connect AI to connect to and query live FreshBooks from HeidiSQL.
-
Extend Google Sheets with Vault CRM Data
Make calls to Vault CRM from Google Apps Script via the API Server.
-
Migrating data from Stripe to Databricks using CData SSIS Components.
Easily push Stripe to Databricks using the CData SSIS Tasks for Stripe and Databricks.
-
Analyze Azure Data Catalog Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Data Catalog from Power Pivot. You will use the Table Import Wizard to load Azure Data Catalog. You can visually build the import query or use any SQL supported by the driver.
-
Access Gumroad Data from MySQL in Amazon QuickSight
Connect to Gumroad and build visualizations of Gumroad using a MySQL Connection in Amazon QuickSight.
-
Build Data Flows from Placid to SQL Server using SSIS
Easily back up Placid to SQL Server using the SSIS components for Placid.
-
Prepare, Blend, and Analyze Zoho Creator Data in Alteryx Designer (ODBC)
Build workflows to access live Zoho Creator for self-service data analytics.
-
Create Zoom-Connected Dashboards in Grafana
Connect to Zoom Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoom.
-
Create SSAS Tabular Models from Wrike Data
How to build a SQL Server Analysis Service Tabular Model from Wrike using CData drivers.
-
A PostgreSQL Interface for Bullhorn CRM Data using the CData ODBC Driver
Use the SQL Gateway and Bullhorn CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Snowflake Data
Use the CData ODBC Driver for Snowflake to visualize Snowflake in Power BI Desktop.
-
Automated Continuous SAP Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP replication to PostgreSQL.
-
Choosing the Best Method to Connect Elasticsearch to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Elasticsearch from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Dash to Build to Web Apps on PayPal Data
Create Python applications that use pandas and Dash to build PayPal-connected web apps.
-
Connect to SAP HANA Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Jira Data in ACL Analytics
Connect to Atlassian Jira via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Atlassian Jira.
-
Build Visualizations of Salesforce Marketing Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesforce Marketing Cloud in Birst.
-
Create Datasets from Azure Data Lake Storage in Domo Workbench and Build Visualizations of Azure Data Lake Storage Data in Domo
Use the CData Software ODBC Driver for Azure Data Lake Storage to create datasets from Azure Data Lake Storage in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Cosmos DB Data in CloverDX (formerly CloverETL)
Transfer Azure Cosmos DB using the visual workflow in the CloverDX data integration tool.
-
Connect Tanda to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Tanda with IBM WebSphere for seamless data integration and connectivity.
-
Analyze OneNote Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft OneNote in Microsoft R Open.
-
Bind Live Google Cloud Storage Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Cloud Storage data
-
Integrate Open WebUI with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Act-On from within the chat interface.
-
Connect to Clio Data from a Connection Pool in Jetty
The Clio JDBC Driver supports connection pooling: This article shows how to connect faster to Clio from Web apps in Jetty.
-
Connect to GetResponse Data in Jaspersoft Studio
Execute SQL to remote GetResponse in Jaspersoft Studio.
-
SQL Server Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SQL Server facts in real time.
-
Bidirectional Access to Demio Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Demio in Filemaker Pro for Mac or Windows.
-
Query ShipStation Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ShipStation entities in PHP by modeling them as objects.
-
Connect to Egnyte Data in Jaspersoft Studio
Execute SQL to remote Egnyte in Jaspersoft Studio.
-
Automated Continuous Azure Synapse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SingleStore.
-
Work with RSS Feeds in FoxPro
Load RSS Feeds into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Amazon DynamoDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon DynamoDB.
-
Build OData Visualizations in Tableau Desktop
Use CData Connect AI to connect to live OData and build visualizations in Tableau.
-
Migrating data from SAP HANA to Google BigQuery using CData SSIS Components.
Easily push SAP HANA to Google BigQuery using the CData SSIS Tasks for SAP HANA and Google BigQuery.
-
Getting Started with the CData Tableau Connector for Coinbase
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use Databricks Agent Bricks to Talk to Your SAP Business One Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Business One for you.
-
Analyze JSON Services in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of JSON and visualize the live Services in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Basecamp 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 Basecamp through MCP integration.
-
Connect to Oracle Eloqua Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Eloqua in FileMaker Pro to connect to Oracle Eloqua and work with Oracle Eloqua in your FileMaker applications.
-
How to publish and share Sugar CRM Data dashboards with Tableau Server
The CData ODBC driver for Sugar CRM enables you integrate Sugar CRM into Tableau dashboards.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live IBM Cloud Object Storage within intelligent workflows.
-
Natively Connect to Amazon Marketplace Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon Marketplace. Leverage the native support for ODBC in PHP.
-
Replicate Multiple Cassandra Accounts
Replicate multiple Cassandra accounts to one or many databases.
-
How to Visualize Odoo 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 Odoo ERP in Python.
-
Connect to Active Directory Data in DBeaver
Use the CData ODBC Driver to connect to Active Directory in DBeaver.
-
Publish Reports with ElevenLabs Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ElevenLabs.
-
Automated Continuous Microsoft Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Google BigQuery.
-
Build Semantic Layer Views for Wistia Data in APOS Live Data Gateway
Use the CData Connector for Wistia in APOS Live Data Gateway to build Semantic Layer Views for Wistia.
-
Getting Started with the CData Excel Add-In for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for QuickBooks Time.
-
Build Charts with SharePoint Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft SharePoint in Clear Analytics.
-
Replicate Opsgenie Data from PowerShell
Write a quick PowerShell script to query Opsgenie. Use connectivity to the live data to replicate Opsgenie to SQL Server.
-
How to use SQLAlchemy ORM to access QuickBooks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks Desktop.
-
Integrate Flowlu with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Flowlu with External Services.
-
Integrating GitHub Copilot CLI with CircleCI 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.