CData Software - Knowledge Base
Recent Articles
-
How to Access Live Strava Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Strava enables you to integrate Strava data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to SAP Business Warehouse: Complete Guide
Connect to the CData Software Power BI Connector for SAP Business Warehouse from PowerBI.com to provide real-time SAP Business Warehouse data across the organization.
-
Automate Freshsales Data Replication to Couchbase
Use CData Sync to Customize and automate Freshsales data replication to Couchbase.
-
Model Google Cloud Storage Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Cloud Storage, enabling the direct import of real-time Google Cloud Storage data.
-
Integrating Gorgias Data in Talend Cloud Data Management Platform
Connect Gorgias Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Postmark Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Postmark replication to Amazon Redshift.
-
Build AI/ML Models with Live Pinecone Data using Dataiku
Connect Pinecone Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Real-Time SendGrid Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SendGrid and Dataflow to import and use SendGrid data in Power Apps.
-
Visualize BigCommerce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to BigCommerce data.
-
Validate Amazon Marketplace Data with QuerySurge
Access and validate Amazon Marketplace data in QuerySurge using the CData JDBC Driver.
-
Analyze XML Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of XML data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build an OLAP Cube in SSAS from Cosmos DB Data
Establish a connection to Cosmos DB data data from SQL Server Analysis Services, and use the Cosmos DB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Datadog Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Datadog data in the Denodo Virtual DataPort Administrator.
-
Connect to Reckon Data from a Connection Pool in JBoss
Integrate Reckon data into Java servlets: Use the Management Console in JBoss to install the Reckon JDBC Driver.
-
Work with Bugsnag Data in FoxPro
Load Bugsnag data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to load SpaceX data into Elasticsearch via Logstash
Introducing a simple method to load SpaceX data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Browserless Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Browserless and work with Browserless data in your FileMaker applications.
-
Integrating LangChain with Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Vault CRM data within automated workflows.
-
Integrate Open WebUI with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Neo4J data from within the chat interface.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via ADO.NET
This article demonstrates how to access Dynamics 365 Business Central data from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365 Business Central.
-
How to Connect to & Open Copper Data in Microsoft Excel
This article uses the CData ODBC driver for Copper to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Configure the CData JDBC Driver for Tickspot in a Connection Pool in Tomcat
Connect to Tickspot data from a connection pool in Tomcat.
-
Add Apify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Apify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use JayDeBeApi to access Microsoft Dataverse Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Dataverse data.
-
Build Pipelines with Live BenchmarkEmail Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to BenchmarkEmail from Google Cloud Data Fusion, enabling the integration of live BenchmarkEmail data into the building and management of effective data pipelines.
-
Enable the Notion JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Notion data.
-
Automated Continuous Templated Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Templated replication to Azure SQL Database.
-
Getting Started with the CData Power BI Connector for Microsoft Exchange
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft Exchange.
-
Analyze Live Mode Data in SAS Viya
Use CData Connect AI to connect to Mode data from SAS Viya and deploy self-service analytics using live Mode data.
-
Analyze ZohoSubscriptions Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ZohoSubscriptions data and visualize ZohoSubscriptions data in SAP Analytics Cloud.
-
How to Connect to Live SAP Fieldglass Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Fieldglass data securely in real time.
-
Analyze Live ServiceDesk Plus Data in SAS Viya
Use CData Connect AI to connect to ServiceDesk Plus data from SAS Viya and deploy self-service analytics using live ServiceDesk Plus data.
-
Use Databricks Agent Bricks to Talk to Your Airtable Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Airtable data for you.
-
Build QuickBooks Online-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to QuickBooks Online Data from Zoho Analytics and import live QuickBooks Online data.
-
Build Data Flows from Microsoft Planner to SQL Server using SSIS
Easily back up Microsoft Planner data to SQL Server using the SSIS components for Microsoft Planner.
-
Validate Typeform Data with QuerySurge
Access and validate Typeform data in QuerySurge using the CData JDBC Driver.
-
Connect and Visualize Live Printify Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Printify data into the Databricks platform and create visualization dashboards with real-time Printify data.
-
Seamlessly Bring Jira Data into Retool Using CData Connect AI
Integrate Jira data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Live Tally Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Tally data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open Lakebase Data in Microsoft Excel
This article uses the CData ODBC driver for Lakebase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Power BI Connector for Lakebase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Lakebase.
-
Automated Continuous FormSite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable FormSite replication to Apache Cassandra.
-
Integrate with Customer.io Data in JReport Designer
Create charts and reports based on Customer.io data in JReport Designer.
-
Automate Telegram Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Telegram data from PowerShell? This article demonstrates how to utilize the Telegram Cmdlets for tasks like connecting to Telegram data, automating operations, downloading data, and more.
-
How to Visualize ConstantContact Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConstantContact data in Python.
-
Create Apps from Blackbaud FE NXT Data in Qlik Sense Cloud
Use CData Connect AI to connect to Blackbaud FE NXT Data and build apps from live Blackbaud FE NXT data in Qlik Sense Cloud.
-
Explore Geographical Relationships in SFTP Data with Power Map
Create data visualizations with SFTP data in Power Map.
-
Sugar CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sugar CRM data through CData Connect AI using different applications and tools.
-
Migrating data from Dynamics 365 Business Central to Snowflake using CData SSIS Components.
Easily push Dynamics 365 Business Central data to Snowflake using the CData SSIS Tasks for Dynamics 365 Business Central and Snowflake.
-
Replicate Bugsnag Data from PowerShell
Write a quick PowerShell script to query Bugsnag data. Use connectivity to the live data to replicate Bugsnag data to SQL Server.
-
How to Connect DBeaver to Active Directory via a JDBC Driver
Manage Active Directory data with visual tools in DBeaver like the query browser.
-
Automated Continuous YouTube Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Apache Kafka.
-
How to Connect to Live Raisers Edge NXT Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Raisers Edge NXT data without replication.
-
Analyze Jira Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Jira data in Microsoft R Open.
-
Trigger Salesforce Marketing IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce Marketing with standard wizards in Logic Apps.
-
How to Connect DBeaver to Clockify via a JDBC Driver
Manage Clockify data with visual tools in DBeaver like the query browser.
-
Use JayDeBeApi to access Auth0 Data in Python
Use standard Python scripting and the development environment of your choice to access live Auth0 data.
-
Connect to FormSite Data in RazorSQL
Connect to FormSite from wizards and query FormSite data from the GUI in the RazorSQL database management tool.
-
Create Dashboards and Visualize Live Google Ad Manager Data in Geckoboard
Use CData Connect AI to connect to live Google Ad Manager data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Provide OData Services of Clari Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Clari data by developing a WCF Service Application.
-
Build Apps with Live Omnisend Data Using the Low-Code Development Platform of Mendix
Connect Omnisend data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Float Data Replication to Teradata
Use CData Sync to Customize and automate Float data replication to Teradata.
-
Automated Continuous Splunk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Splunk replication to Amazon Redshift.
-
Create Coda Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Coda from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Data Visualizations in Cognos BI with Impala Data
Access Impala data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Snowflake Data in AWS Lambda
Connect to live Snowflake data in AWS Lambda using the CData JDBC Driver.
-
Connect to Webex Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Webex and work with Webex data in your FileMaker application.
-
Import Microsoft Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Ads Data from Azure Data Factory and import live Microsoft Ads data.
-
Connect to Workday Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Workday data from Filemaker Pro on Mac.
-
Access Live Dynamics 365 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Dynamics 365 data from your Excel spreadsheets.
-
Create Productboard Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Productboard from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connecting GenSpark with Instagram Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Instagram data without any replication or custom integration required.
-
Provide OData Services of xBase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for xBase data by developing a WCF Service Application.
-
Integrating LangGraph with Smartsheet Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Smartsheet data within automated workflows.
-
Access Discord Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Discord data from your Oracle system.
-
Build Quickbase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Quickbase data.
-
Connecting Pipedream with DocuSign 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 DocuSign data in real time.
-
Connect to Elorus Data in Ruby
Connect to Elorus data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to work with Microsoft Planner Data in Apache Spark using SQL
Access and process Microsoft Planner Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP SuccessFactors LMS.
-
Working with Accelo Data in LINQPad
Execute LINQ queries to Accelo data in LINQPad.
-
Integrating OpenCode with Stack Exchange 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.
-
Access Tally Data from MySQL in Amazon QuickSight
Connect to Tally and build visualizations of Tally data using a MySQL Connection in Amazon QuickSight.
-
A PostgreSQL Interface for xBase Data (MySQL Remoting via JDBC)
Use the Remoting features of the xBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Real-Time Access to Wave Financial in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Wave Financial data in real time.
-
Create Data Visualizations Based On Printify Data in Mode
Use CData Connect AI to connect to Printify Data from Mode and build visualizations using live Printify data.
-
Load Deel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Deel data to a database.
-
Create Vertica-Connected Nintex Workflows
Use CData Connect AI to connect to Vertica Data from Nintex Workflow Cloud and build custom workflows using live Vertica data.
-
Easily Integrate Mocean Data in Lazarus Pascal IDE
Learn how to easily integrate live Mocean data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to AlloyDB Data in NetBeans
Connect to AlloyDB data in NetBeans with the data source configuration wizard.
-
How to Create Power BI Visual Reports with Real-Time Xero Data
Use CData Power BI Connectors to visualize Xero data in Power BI.
-
Stream Factorial Data into Apache Kafka Topics
Access and stream Factorial data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create SSAS Tabular Models from CampaignMonitor Data
How to build a SQL Server Analysis Service Tabular Model from CampaignMonitor data using CData drivers.
-
How to Work with Avaza Data in ETL Validator JDBC
Connect to Avaza from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Query Live Qualaroo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Qualaroo data data in natural language using Python.
-
Import Real-Time Bullhorn CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bullhorn CRM data in ColdFusion.
-
How to connect and process OData services from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live OData services.
-
Create Power BI Reports on Real-Time Clari Data
Use the CData ODBC Driver for Clari to visualize Clari data in Power BI Desktop.
-
How to import Wrike Data into Apache Solr
Use the CData Software JDBC Driver for Wrike in Data Import Handler and create an automated import of Wrike data to Apache Solr Enterprise Search platform.
-
Query Reply.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Reply.io data from Node.js.