CData Software - Knowledge Base
Recent Articles
-
Publish Reports with Telegram Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Telegram data.
-
Build Visualizations of ClickTime Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ClickTime data in Birst.
-
Automate SAP Business Warehouse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Business Warehouse data from PowerShell? This article demonstrates how to utilize the SAP Business Warehouse Cmdlets for tasks like connecting to SAP Business Warehouse data, automating operations, downloading data, and more.
-
Integrating Gumloop with Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Reckon data within automated workflows.
-
Use the CData Software ODBC Driver for FormSite in SAS for Real-Time Reporting and Analytics
Connect to real-time FormSite data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FormSite.
-
Getting Started with the CData Power BI Connector for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to Live SendPulse Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SendPulse data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Drive
Create an ODBC connection to Google Drive in Informatica and browse and transfer Google Drive data.
-
Build ZohoMarketingHub-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoMarketingHub data and build web apps with connectivity to live ZohoMarketingHub data.
-
Create Informatica Mappings From/To an ODBC Data Source for Highrise
Create an ODBC connection to Highrise in Informatica and browse and transfer Highrise data.
-
Use Dash to Build to Web Apps on WordPress Data
Create Python applications that use pandas and Dash to build WordPress-connected web apps.
-
Access Live Wistia Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Wistia data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Templated Replication to SQLite
Use CData Sync for automated, continuous, customizable Templated replication to SQLite.
-
Choosing the Best Method to Connect Asana to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Asana data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Freshdesk-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Freshdesk Data and create custom apps in Bubble.
-
Connecting Agentforce with Freshservice Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Freshservice data for you.
-
Integrating Kiro with Close 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.
-
Analyze SAP ByDesign Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP ByDesign data and visualize live SAP ByDesign data in Infragistics Reveal.
-
Visualize Azure Data Lake Storage Data in Tableau
The CData ODBC driver for Azure Data Lake Storage enables you integrate Azure Data Lake Storage data into Tableau dashboards.
-
Integrate Dify with Live MarkLogic Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live MarkLogic data.
-
Connect to Microsoft Entra ID Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Entra ID data from Crystal Reports.
-
Replicate Excel Online Data to Multiple Databases via the CData Sync CLI
Replicate Excel Online data to disparate databases with a single configuration.
-
Integrate Live Reckon Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Reckon data and integrate live Reckon data into apps built in Microsoft Power Apps.
-
Visualize Invoiced Data in TIBCO Spotfire through ADO.NET
Integrate Invoiced data into dashboards in TIBCO Spotfire.
-
Connect to Authorize.Net Data in Claris FileMaker Pro
Use the CData ODBC Driver for Authorize.Net in FileMaker Pro to connect to Authorize.Net and work with Authorize.Net data in your FileMaker applications.
-
How to Connect Flowise AI Agents to Live Facebook 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 Facebook data without replication.
-
Back Up AlloyDB data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for AlloyDB. In this article, we will employ an SSIS workflow to populate a database with AlloyDB data data.
-
Manage CockroachDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CockroachDB.
-
Replicate Google Forms Data to Multiple Databases via the CData Sync CLI
Replicate Google Forms data to disparate databases with a single configuration.
-
How to Connect to Amazon Marketplace Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon Marketplace data. Leverage the pyodbc module for ODBC in Python.
-
Connect to and Visualize Live Autopilot Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Autopilot data.
-
Build Visualizations of Google Translate Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Translate data in Birst.
-
Build an OLAP Cube in SSAS from Reckon Accounts Hosted Data
Establish a connection to Reckon Accounts Hosted data data from SQL Server Analysis Services, and use the Reckon Accounts Hosted Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query BenchmarkEmail Data as a SQL Server Database in Node.js
Execute SQL Server queries against BenchmarkEmail data from Node.js.
-
Load Landbot Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Landbot data to a database.
-
Use Azure AI Foundry to Talk to Your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Redis data for you.
-
Create Google Analytics-Connected Business Apps in AppSheet
Connect to Google Analytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Analytics data.
-
Use Databricks Agent Bricks to Talk to Your ZohoPeople Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ZohoPeople data for you.
-
Build Data Flows from SAP Business Warehouse to SQL Server using SSIS
Easily back up SAP Business Warehouse data to SQL Server using the SSIS components for SAP Business Warehouse.
-
Getting Started with the CData Python Connector for Figshare
Learn to install and license the CData Python Connector and configure a connection to live Figshare data.
-
Automate Miro Data Replication to Azure Synapse
Use CData Sync to customize and automate Miro data replication to Azure Synapse.
-
How to Connect to Live IBM Cloud Object Storage 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 IBM Cloud Object Storage data through natural language.
-
Connect to Adobe Experience Manager Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Experience Manager data as a data source.
-
Automated Continuous ZarMoney Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZarMoney replication to Snowflake.
-
Build MVC Applications with Connectivity to Authorize.Net Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Authorize.Net from an ASP.NET MVC application.
-
Automate Webex Data Replication to Azure Synapse
Use CData Sync to customize and automate Webex data replication to Azure Synapse.
-
Access Live SAP Business One Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Business One data from your Excel spreadsheets.
-
Connect to Stripe Data from PowerBuilder via ADO.NET
This article demonstrates how to access Stripe data from Appeon PowerBuilder using the CData ADO.NET Provider for Stripe.
-
Build a Singer.io Tap for IBM Cloud Object Storage With the CData Python Connector
Learn how to easily build a Singer.io Tap for live IBM Cloud Object Storage data using the CData Python Connector.
-
Integrate with Impala Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Impala data in SnapLogic.
-
How to Build an ETL App for SFTP Data in Python with CData Connect AI
Build ETL pipelines that read and write live SFTP data in Python with petl and the CData Connect AI Python SDK.
-
Access Live Attio Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Attio data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Data Visualizations in Cognos BI with OnePageCrm Data
Access OnePageCrm data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Theia IDE with Live Microsoft Planner 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 Microsoft Planner data from within the development environment.
-
Excel Spreadsheet Automation on WooCommerce Data with the QUERY Formula
Pull data from WooCommerce, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live Email Data in the Power BI Service
Use CData Connect AI to connect to live Email data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Pingdom Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pingdom replication to IBM DB2.
-
Instagram Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Instagram facts in real time.
-
Connect to Azure Data Lake Storage Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Data Lake Storage Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Create Power BI Visual Reports with Real-Time Nuclia Data
Use CData Power BI Connectors to visualize Nuclia data in Power BI.
-
Integrating Freshservice Data in Talend Cloud Data Management Platform
Connect Freshservice Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time Procore Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Procore data in ColdFusion.
-
Replicate Multiple Landbot Accounts
Replicate multiple Landbot accounts to one or many databases.
-
How to load Oracle Eloqua Reporting data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Eloqua Reporting data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Scrapfly
Create Scrapfly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Miro Data in AWS Lambda
Connect to live Miro data in AWS Lambda using the CData JDBC Driver.
-
Working with Redis Data in Microsoft Excel and Tableau
An in-depth article walking through the installation and set up of the CData ODBC Driver for Redis and using the ODBC Driver from MS Excel and Tableau.
-
Use Agno to Talk to Your Splunk 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 Splunk data for you.
-
Connect to Asana Data in DBeaver
Use the CData ODBC Driver to connect to Asana data in DBeaver.
-
Connect to eBay Data from a Connection Pool in JBoss
Integrate eBay data into Java servlets: Use the Management Console in JBoss to install the eBay JDBC Driver.
-
Create Google Campaign Manager 360 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Campaign Manager 360 from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect DBeaver to Adobe Target via a JDBC Driver
Manage Adobe Target data with visual tools in DBeaver like the query browser.
-
Visualize Oracle Data in TIBCO Spotfire through ADO.NET
Integrate Oracle data into dashboards in TIBCO Spotfire.
-
How to connect to ZohoDesk Data with Squirrel SQL client
Connect to ZohoDesk data and execute queries in the Squirrel SQL Client.
-
Deploy the ADO.NET Provider for Cassandra on an SSRS Report Server
Connect to Cassandra 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 Seamlessly Import CapsuleCRM Data into IBM SPSS Modeler
Integrate CapsuleCRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Rapidly Develop Quaderno-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 Quaderno.
-
How to integrate Metabase with Oracle Eloqua Data
Use CData Connect AI to connect to live Oracle Eloqua data and create an interactive dashboard in Metabase from Oracle Eloqua data.
-
Integrate Trello Data into Power Automate Desktop using CData Connect
CData Connect for Trello Data enables you to integrate Trello data into workflows built using Microsoft Power Automate Desktop.
-
Build an OLAP Cube in SSAS from Workable Data
Establish a connection to Workable data data from SQL Server Analysis Services, and use the Workable Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate MYOB AccountRight Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MYOB AccountRight data and integrate live MYOB AccountRight data into your Power Automate tasks.
-
Automated Continuous Avalara AvaTax Replication to Oracle
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Oracle.
-
Automated Continuous Google Search Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Search replication to PostgreSQL.
-
Connect to Real-Time Zoho Projects Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Projects and Dataflow to import and use Zoho Projects data in Power Apps.
-
How to connect to Oracle HCM Cloud Data from IntelliJ
Integrate connectivity to Oracle HCM Cloud data with wizards in IntelliJ.
-
Connect to Freshservice Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshservice data using standard SQL.
-
Stream Google Search Results into Apache Kafka Topics
Access and stream Google Search results in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Agno to Talk to Your SurveyMonkey 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 SurveyMonkey data for you.
-
Connect to ClickTime Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ClickTime data.
-
Query Oracle Service Cloud Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Service Cloud entities in PHP by modeling them as objects.
-
Connect to MailerSend Data from a Connection Pool in JBoss
Integrate MailerSend data into Java servlets: Use the Management Console in JBoss to install the MailerSend JDBC Driver.
-
View Reports on Real-Time AdRoll Data in Power BI Report Server
Use the CData ODBC Driver for AdRoll to visualize AdRoll data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Pinterest Data Replication to Teradata
Use CData Sync to Customize and automate Pinterest data replication to Teradata.
-
Rapidly Develop ChargeOver-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 ChargeOver.
-
Connect to Sage Intacct Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage Intacct data.
-
Access RSS Feeds from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live RSS feeds from HeidiSQL.
-
How to Build an ETL App for Dropbox Data in Python with CData
Create ETL applications and real-time data pipelines for Dropbox data in Python with petl.
-
How to integrate Humanity with Apache Airflow
Access and process Humanity data in Apache Airflow using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Google Directory on an SSRS Report Server
Connect to Google Directory 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.
-
Connect to Asana Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Asana Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.