CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Email Replication to SQLite
Use CData Sync for automated, continuous, customizable Email replication to SQLite.
-
How to Work with Sybase IQ Data in AWS Glue Jobs Using JDBC
Connect to Sybase IQ from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Sage Intacct Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sage Intacct data and build visualizations in Tableau.
-
Access ConstantContact Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ConstantContact data.
-
Use CData Connect AI to Access SAP BusinessObjects BI Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP BusinessObjects BI data in the Power Pivot business intelligence tool.
-
How to Connect to & Open JotForm Data in Microsoft Excel
This article uses the CData ODBC driver for JotForm to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
A PostgreSQL Interface for Microsoft OneDrive Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft OneDrive ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData SSIS Components to Insert New or Update Existing REST Records from SQL Server
Easily push SQL Server data to REST using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into REST or update existing records with data from a SQL Server database.
-
Integrating Codex with Bannerbear 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 SAS xpt-Connected Business Apps in AppSheet
Connect to SAS xpt Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAS xpt data.
-
Build Data Flows from Cohere to SQL Server using SSIS
Easily back up Cohere data to SQL Server using the SSIS components for Cohere.
-
Create Reports with Beeminder Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Beeminder data.
-
How to Use a Microsoft Access Database to Update Elasticsearch Data in Real Time
Update Elasticsearch data by creating a linked table in Microsoft Access with the CData Elasticsearch ODBC Driver.
-
Build Bitly-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Bitly Data from Zoho Analytics and import live Bitly data.
-
How to integrate Metabase with Azure DevOps Data
Use CData Connect AI to connect to live Azure DevOps data and create an interactive dashboard in Metabase from Azure DevOps data.
-
Visualize Live Deel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Deel data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Dataiku with Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Adobe Analytics data.
-
Integrate JSON Services in Pentaho Data Integration
Build ETL pipelines based on JSON services in the Pentaho Data Integration tool.
-
Rapidly Develop Perigon-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Perigon.
-
Connect to Authorize.Net Data from a Connection Pool in JBoss
Integrate Authorize.Net data into Java servlets: Use the Management Console in JBoss to install the Authorize.Net JDBC Driver.
-
Analyze Asana Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Asana data with the CData JDBC Driver for Asana.
-
Create Workable Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Workable from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Easily Query ClickTime Data in OpenOffice Base
Connect to ClickTime data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
View Reports on Real-Time Paddle Data in Power BI Report Server
Use the CData ODBC Driver for Paddle to visualize Paddle data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect DBeaver to Azure Table via a JDBC Driver
Manage Azure Table data with visual tools in DBeaver like the query browser.
-
Access Live Oracle SCM Data in TIBCO Data Virtualization
Use the Oracle SCM Tibco DV Adapter to create a Oracle SCM data data source in TIBCO Data Virtualization Studio and gain access to live Oracle SCM data from your TDV Server.
-
Access Live Notion Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Notion data from your Google Sheets.
-
Process & Analyze Apify Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Apify Data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Translate
Provide connectivity to Google Translate data through an SAP BusinessObjects universe.
-
Integrate with ADP Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ADP data to a JSON file on disk.
-
Getting Started with the CData JDBC Driver for MySQL
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MySQL.
-
Migrating data from Gong to Snowflake using CData SSIS Components.
Easily push Gong data to Snowflake using the CData SSIS Tasks for Gong and Snowflake.
-
Integrate Theia IDE with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Blackbaud FE NXT data from within the development environment.
-
Connect to PolarTeamPro in SpagoBI
Create reports featuring live PolarTeamPro data in SpagoBI Studio. Host PolarTeamPro reports on SpagoBI Server.
-
Connecting Mastra with Oracle Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Oracle data, no replication required.
-
How to Connect DBeaver to SAP Concur via a JDBC Driver
Manage SAP Concur data with visual tools in DBeaver like the query browser.
-
Connect to CloudConvert Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CloudConvert and work with CloudConvert data in your FileMaker applications.
-
How to Access Testmonitor Data Using Entity Framework
This article shows how to access Testmonitor data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Connect AI Python SDK for Microsoft Dataverse
Install the CData Connect AI Python SDK to read and write live Microsoft Dataverse data with standard DB-API 2.0 Python code.
-
Write a Simple Go Application to work with Google Campaign Manager 360 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Campaign Manager 360 data.
-
Access Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data through MCP integration.
-
Access Live Twilio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Twilio data into the statistical analysis tools available in SAS JMP. This article shows how to use Twilio data in the Graph Builder and Query Builder.
-
Excel Spreadsheet Automation on OneNote Data with the QUERY Formula
Pull data from OneNote, automate spreadsheets, and more with the QUERY formula.
-
How to Query Live Microsoft Dataverse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Dataverse data data in natural language using Python.
-
Connect to Autopilot Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Autopilot as an External Source in Dremio.
-
How to connect and process Couchbase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Couchbase data.
-
ETL Parquet in Oracle Data Integrator
This article shows how to transfer Parquet data into a data warehouse using Oracle Data Integrator.
-
Connect to ShipEngine from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ShipEngine data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Gong Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Gong data from your Oracle system.
-
Access Live Snowflake Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Snowflake data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Power BI XMLA-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Power BI XMLA data.
-
Integrate Everhour Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Everhour data from Informatica Cloud.
-
DataBind Controls to Beeminder Data in Delphi
DataBind to Beeminder data in Delphi with standard data access components and controls.
-
Integrating OpenCode with SendInBlue 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 Power BI Reports on Real-Time Act CRM Data
Use the CData ODBC Driver for Act CRM to visualize Act CRM data in Power BI Desktop.
-
Automated Continuous Zendesk Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zendesk replication to PostgreSQL.
-
How to Work with Teradata Data in ETL Validator JDBC
Connect to Teradata from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for Cassandra Data using the CData JDBC Driver
Use the Remoting features of the Cassandra JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Dynamics 365 Business Central Data in Pentaho Data Integration
Build ETL pipelines based on Dynamics 365 Business Central data in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for Wave Financial in MicroStrategy Desktop
Connect to Wave Financial data in MicroStrategy Desktop using the CData Software ODBC Driver for Wave Financial.
-
Build MVC Applications with Connectivity to Miro Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Miro from an ASP.NET MVC application.
-
Use JayDeBeApi to access Quickbase Data in Python
Use standard Python scripting and the development environment of your choice to access live Quickbase data.
-
Access Live Dynamics 365 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dynamics 365 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live Dynamics CRM Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Dynamics CRM data for you.
-
Access Live Brex Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Brex data into the statistical analysis tools available in SAS JMP. This article shows how to use Brex data in the Graph Builder and Query Builder.
-
Manage Campaigner Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Campaigner.
-
Connect to Adobe Analytics in SpagoBI
Create reports featuring live Adobe Analytics data in SpagoBI Studio. Host Adobe Analytics reports on SpagoBI Server.
-
How to Work with TigerGraph Data in ETL Validator JDBC
Connect to TigerGraph from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to CircleCI Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CircleCI data using standard SQL.
-
Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy Web
Connect to Microsoft Dataverse data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Dataverse.
-
Use Dash to Build Web Apps on LinkedIn Data via CData Connect AI
Build interactive Dash web apps on live LinkedIn data using pandas and the CData Connect AI Python SDK.
-
Visualize ZohoMarketingHub Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoMarketingHub data.
-
Create Harvest Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Harvest from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live Planio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Planio data.
-
Analyze Vertica Data in Looker
Use CData Connect AI to connect to Vertica Data from Looker and build custom apps using live Vertica data.
-
Replicate Bitly Data from PowerShell
Write a quick PowerShell script to query Bitly data. Use connectivity to the live data to replicate Bitly data to SQL Server.
-
Connect Google Spanner Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Spanner data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Reckon Accounts Hosted Replication to SingleStore
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SingleStore.
-
Access Live Coda Data in Excel 365 Online (Excel for the web)
Connect to Coda data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Deploy the ADO.NET Provider for Factorial on an SSRS Report Server
Connect to Factorial 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.
-
Integrate Live xBase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to xBase data and integrate live xBase data into apps built in Microsoft Power Apps.
-
Integrate Cline with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Drive data from within your IDE.
-
Connect AdRoll to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AdRoll with IBM WebSphere for seamless data integration and connectivity.
-
Create DB2-Connected Nintex Workflows
Use CData Connect AI to connect to DB2 Data from Nintex Workflow Cloud and build custom workflows using live DB2 data.
-
How to Seamlessly Import Apify Data into IBM SPSS Modeler
Integrate Apify data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Tableau Connector for Moosend
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating Codex with Clio 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.
-
Connect to Customer.io in SpagoBI
Create reports featuring live Customer.io data in SpagoBI Studio. Host Customer.io reports on SpagoBI Server.
-
Integrate Facebook with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Facebook with External Services.
-
How to load Google Spanner data into Elasticsearch via Logstash
Introducing a simple method to load Google Spanner data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Seamlessly Bring Sybase IQ Data into Retool Using CData Connect AI
Integrate Sybase IQ data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build DB2-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for DB2 Data and create custom apps in Mendix.
-
Connect and Query Live Salesloft Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesloft data into Databricks and enable direct, live querying and analysis without replication.
-
Choosing the Best Method to Connect Presto to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Presto data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Data Flows from Google Forms to SQL Server using SSIS
Easily back up Google Forms data to SQL Server using the SSIS components for Google Forms.
-
Create Presto-Connected Applications in Appsmith
Connect to Presto Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Presto data.
-
Perform Batch Operations with SFTP Data in Apache NiFi
Connect to SFTP data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Mistral AI Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mistral AI replication to Apache Kafka.
-
Migrating data from Workable to Databricks using CData SSIS Components.
Easily push Workable data to Databricks using the CData SSIS Tasks for Workable and Databricks.
-
Automated Continuous Marketo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Marketo replication to Amazon S3.