CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Hive Data in Alteryx Designer (ODBC)
Build workflows to access live Apache Hive for self-service data analytics.
-
Use the CData Software ODBC Driver for Freshteam in MicroStrategy Web
Connect to Freshteam in MicroStrategy Web using the CData Software ODBC Driver for Freshteam.
-
Automated Continuous Freshteam Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Freshteam replication to PostgreSQL.
-
Getting Started with the CData SSIS Components for Deel
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Deel.
-
Working with Ontraport Data in LINQPad
Execute LINQ queries to Ontraport in LINQPad.
-
Integrate with Quaderno Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Quaderno to a JSON file on disk.
-
Automated Continuous CouchDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache CouchDB replication to OneLake in Microsoft Fabric.
-
How to Connect to Accelo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Accelo. Leverage the pyodbc module for ODBC in Python.
-
Connect to Planio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Planio from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Live BigQuery Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google BigQuery from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Teams Records from SQL Server
Easily push SQL Server data to Microsoft Teams using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Teams or update existing records with data from a SQL Server database.
-
Create Reports with MongoDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MongoDB.
-
Use the CData Software ODBC Driver for Cvent in MicroStrategy Desktop
Connect to Cvent in MicroStrategy Desktop using the CData Software ODBC Driver for Cvent.
-
View Reports on Real-Time MongoDB Data in Power BI Report Server
Use the CData ODBC Driver for MongoDB to visualize MongoDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live ElevenLabs Data in Coginiti Pro
Connect to and query live ElevenLabs from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating LlamaIndex with Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Apache Cassandra in real time.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle Service Cloud within intelligent workflows.
-
Back Up Pingdom 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 Pingdom data.
-
How to Connect the Power BI Service to Ontraport: Complete Guide
Connect to the CData Software Power BI Connector for Ontraport from PowerBI.com to provide real-time Ontraport across the organization.
-
How to connect to Google Forms Data in DBVisualizer
Integrate Google Forms with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Omnisend in MicroStrategy Web
Connect to Omnisend in MicroStrategy Web using the CData Software ODBC Driver for Omnisend.
-
Access RabbitMQ Data from MySQL in Amazon QuickSight
Connect to RabbitMQ and build visualizations of RabbitMQ using a MySQL Connection in Amazon QuickSight.
-
Automate Bannerbear Data Replication to Couchbase
Use CData Sync to Customize and automate Bannerbear replication to Couchbase.
-
Automated Continuous Jumpseller Replication to SQL Server
Use CData Sync for automated, continuous, customizable Jumpseller replication to SQL Server.
-
Create a Data Access Object for Pinecone Data using JDBI
A brief overview of creating a SQL Object API for Pinecone in JDBI.
-
Automated Continuous PabblySubscriptions Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Apache Kafka.
-
Connect to Yelp Data in Ruby
Connect to Yelp in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Configure the CData JDBC Driver for QuickBooks Time in a Connection Pool in Tomcat
Connect to QuickBooks Time from a connection pool in Tomcat.
-
How to Connect to Live Sybase 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 Sybase for you.
-
Automated Continuous ZohoPeople Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoPeople replication to SQLite.
-
Connecting Pipedream with PayPal Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on PayPal data in real time.
-
How to Query Live Tanda Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tanda data in natural language using Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Shopify
Provide connectivity to Shopify through an SAP BusinessObjects universe.
-
Integrating Codex CLI with IBM DB2 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.
-
Connect to Bannerbear Data in Aqua Data Studio
Access Bannerbear from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy
Connect to Oracle HCM Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Twilio
Provide connectivity to Twilio through an SAP BusinessObjects universe.
-
Visualize Live Snowflake Data in the Power BI Service
Use CData Connect AI to connect to live Snowflake and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Strava in MicroStrategy Desktop
Connect to Strava in MicroStrategy Desktop using the CData Software ODBC Driver for Strava.
-
How to work with Supabase Data in Apache Spark using SQL
Access and process Supabase Data in Apache Spark using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for Codat Data using the CData JDBC Driver
Use the Remoting features of the Codat JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Freshteam Data from IntelliJ
Integrate connectivity to Freshteam with wizards in IntelliJ.
-
Enable the Bitly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bitly.
-
Analyze Act-On Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Act-On with the CData JDBC Driver for Act-On.
-
Getting Started with the CData ODBC Driver for Contentful
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Contentful.
-
Create Informatica Mappings From/To an ODBC Data Source for PolarTeamPro
Create an ODBC connection to PolarTeamPro in Informatica and browse and transfer PolarTeamPro.
-
Analyze Live Microsoft OneDrive Data in SAS Viya
Use CData Connect AI to connect to Microsoft OneDrive from SAS Viya and deploy self-service analytics using live Microsoft OneDrive.
-
Query EnterpriseDB Data in DataGrip
Create a Data Source for EnterpriseDB in DataGrip and use SQL to query live EnterpriseDB.
-
Integrate with Live Splunk Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Splunk from the MuleSoft Anypoint Platform to integrate live Splunk into custom reports and dashboards.
-
Microsoft Entra ID Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Entra ID through CData Connect AI using different applications and tools.
-
Visualize Oracle Sales Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle Sales.
-
Integrate Live Google Drive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Drive to Blue Prism using the CData ODBC Driver for Google Drive to create automated workflows for repetitive business tasks.
-
Connect to CockroachDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access CockroachDB in Google Apps Script.
-
Integrate with Live Slack Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Slack from the MuleSoft Anypoint Platform to integrate live Slack into custom reports and dashboards.
-
Connect Webflow Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Webflow using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Slack Data from MySQL in Amazon QuickSight
Connect to Slack and build visualizations of Slack using a MySQL Connection in Amazon QuickSight.
-
Access SparkPost Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SparkPost from HeidiSQL.
-
Integrate Real-Time Access to Azure Data Lake Storage in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Data Lake Storage in real time.
-
Analyze Neo4J Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Neo4J and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to use SQLAlchemy ORM to access Microsoft Dataverse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dataverse (CDS).
-
Automated Continuous Clio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Clio replication to Snowflake.
-
How to Create Power BI Visual Reports with Real-Time Cloudant Data
Use CData Power BI Connectors to visualize IBM Cloudant in Power BI.
-
Connect to Snowflake Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Snowflake using standard SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for WooCommerce
Create an ODBC connection to WooCommerce in Informatica and browse and transfer WooCommerce.
-
Integrate Zoom Data in the Pentaho Report Designer
Publish reports based on Zoom in the Pentaho BI tool.
-
Integrate with Paddle Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Paddle to a JSON file on disk.
-
Automated Continuous SendInBlue Replication to MongoDB
Use CData Sync for automated, continuous, customizable SendInBlue replication to MongoDB.
-
Use Microsoft Copilot Studio to talk to your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apache Hive for you.
-
LINQ to Dotmailer Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Dotmailer Data Provider.
-
Access Live Azure Synapse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Synapse in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Autopilot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Autopilot replication to PostgreSQL.
-
Bidirectional Access to Azure Analysis Services Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Azure Analysis Services in Filemaker Pro for Mac or Windows.
-
Automated Continuous SurveyMonkey Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Amazon Redshift.
-
Use the CData ODBC Driver for IBM Cloud Object Storage in Microsoft Power Query
You can use the CData IBM Cloud Object Storage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM Cloud Object Storage into Microsoft Power Query.
-
Access Live Google Spanner Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Spanner in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize AlloyDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google AlloyDB.
-
Create Sybase-Connected Business Apps in AppSheet
Connect to Sybase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sybase.
-
Integrate Theia IDE with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to JobNimbus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to JobNimbus and work with JobNimbus in your FileMaker applications.
-
Access Live Access Data in AWS Lambda
Connect to live Microsoft Access in AWS Lambda using the CData JDBC Driver.
-
Build a Singer.io Tap for Lakebase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Lakebase data using
-
Viewing Zoom Data in RAD Studio Data Explorer
How to view Zoom in RAD Studio Data Explorer using the CData ODBC Driver for Zoom.
-
Replicate Stack Exchange Data from PowerShell
Write a quick PowerShell script to query Stack Exchange. Use connectivity to the live data to replicate Stack Exchange to SQL Server.
-
Connect to PabblySubscriptions Data in RazorSQL
Connect to PabblySubscriptions from wizards and query PabblySubscriptions from the GUI in the RazorSQL database management tool.
-
How to Easily Query Webex Data in OpenOffice Base
Connect to Webex data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Bidirectional Access to Pipedrive Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pipedrive in Filemaker Pro for Mac or Windows.
-
How to create PabblySubscriptions federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PabblySubscriptions in MySQL .
-
Visualize Bannerbear Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bannerbear.
-
Easily Integrate SendPulse Data in Lazarus Pascal IDE
Learn how to easily integrate live SendPulse in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to import Parallel Data into Apache Solr
Use the CData Software JDBC Driver for Parallel in Data Import Handler and create an automated import of Parallel to Apache Solr Enterprise Search platform.
-
Visualize Typeform Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Typeform.
-
Migrating data from Monday.com to Google BigQuery using CData SSIS Components.
Easily push Monday.com to Google BigQuery using the CData SSIS Tasks for Monday.com and Google BigQuery.
-
Automated Continuous Avaza Replication to Databricks
Use CData Sync for automated, continuous, customizable Avaza replication to Databricks.
-
Process & Analyze Zoho Creator Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Creator Data.
-
Getting Started with the CData SSIS Components for Harvest
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Harvest.
-
Connect to Azure DevOps Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure DevOps as an External Source in Dremio.
-
Connect to Billsby Data in Ruby
Connect to Billsby in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Deploy the ADO.NET Provider for FTP on an SSRS Report Server
Connect to FTP Servers 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.
-
Use the CData ODBC Driver for Placid from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Placid to connect to Placid from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Placid in Excel.
-
Connect to Printify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Printify to connect to Printify and execute queries in PowerBuilder.