CData Software - Knowledge Base
Recent Articles
-
Automate Authorize.Net Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Authorize.Net data from PowerShell? This article demonstrates how to utilize the Authorize.Net Cmdlets for tasks like connecting to Authorize.Net data, automating operations, downloading data, and more.
-
How to integrate Microsoft Teams with Apache Airflow
Access and process Microsoft Teams data in Apache Airflow using the CData JDBC Driver.
-
Model, Search, and Visualize Live Grafana Data in ThoughtSpot
Use CData Connect AI to connect to live Grafana data for modeling, searching, and visualizing.
-
Build MailerLite-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MailerLite Data and create custom apps in Bubble.
-
Visualize Live Dynamics 365 Business Central Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Dynamics 365 Business Central data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
SSIS Components: The PerformUpgrade Method Failed
In this entry, you will find resolutions for the SSIS PerformUpgrade error.
-
Connecting Pipedream with Exa 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 Exa data in real time.
-
How to connect PolyBase to Chargebee
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Chargebee data.
-
Query Live Paylocity Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Paylocity data directly from the development environment.
-
Creating iContact-Connected Applications in Unqork
You can use CData Connect AI to feed iContact data to Unqork and build custom business apps.
-
Visualize ConstantContact Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ConstantContact data.
-
Automated Continuous Email Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Email replication to Amazon Redshift.
-
How to Connect to Live Omnisend Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Omnisend data securely in real time.
-
Access PostgreSQL Data from MySQL in PHP
Connect to PostgreSQL through the standard MySQL libraries in PHP.
-
Build Data Flows from Zoom to SQL Server using SSIS
Easily back up Zoom data to SQL Server using the SSIS components for Zoom.
-
Natively Connect to SparkPost Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SparkPost data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ADO.NET Provider for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Coinbase Data from MySQL in Amazon QuickSight
Connect to Coinbase and build visualizations of Coinbase data using a MySQL Connection in Amazon QuickSight.
-
Build Automated Workflows with Live Freshservice Data in Workato
Use CData Connect AI to connect to live Freshservice data and build automated workflows in Workato.
-
Query iContact Data in DataGrip
Create a Data Source for iContact in DataGrip and use SQL to query live iContact data.
-
Automated Continuous Zoho Books Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Books replication to delimited files (CSV/TSV).
-
Connect to SAP Ariba Procurement Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Ariba Procurement Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Testmonitor-Connected Business Apps in AppSheet
Connect to Testmonitor Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Testmonitor data.
-
Visualize Greenhouse Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Greenhouse data into TIBCO Spotfire.
-
Automated Continuous Odoo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Odoo replication to delimited files (CSV/TSV).
-
Connect Zoho Creator to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Creator data using the CData Python MCP Server.
-
Explore Geographical Relationships in Pipeliner CRM Data with Power Map
Create data visualizations with Pipeliner CRM data in Power Map.
-
Build AI/ML Models with Live Okta Data using Dataiku
Connect Okta Data with Dataiku using the CData JDBC Driver for Okta.
-
Query, Visualize, and Share live ServiceNow Data in Redash
Use CData Connect AI to connect to live ServiceNow data in Redash for querying, visualizing, and sharing.
-
Integrate with PagerDuty Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PagerDuty data to a JSON file on disk.
-
Use Dash to Build Web Apps on BigCommerce Data via CData Connect AI
Build interactive Dash web apps on live BigCommerce data using pandas and the CData Connect AI Python SDK.
-
Create Reports from ZohoInvoice Data in Looker Studio
Use CData Connect AI to gain access to live ZohoInvoice data and create custom reports in Looker Studio.
-
Automate XML Data Replication to Azure Synapse
Use CData Sync to customize and automate XML data replication to Azure Synapse.
-
Use Dash to Build Web Apps on Amazon Athena Data via CData Connect AI
Build interactive Dash web apps on live Amazon Athena data using pandas and the CData Connect AI Python SDK.
-
Migrating data from Tally to Databricks using CData SSIS Components.
Easily push Tally data to Databricks using the CData SSIS Tasks for Tally and Databricks.
-
Build Data Flows from Drip to SQL Server using SSIS
Easily back up Drip data to SQL Server using the SSIS components for Drip.
-
Visualize Avaza Data in Tableau
The CData ODBC driver for Avaza enables you integrate Avaza data into Tableau dashboards.
-
How to Connect DBeaver to SurveyMonkey via a JDBC Driver
Manage SurveyMonkey data with visual tools in DBeaver like the query browser.
-
Integrate Real-Time Access to BigCommerce in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to BigCommerce data in real time.
-
Connecting GenSpark with AgileCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to AgileCRM data without any replication or custom integration required.
-
Deploy the ADO.NET Provider for Klipfolio on an SSRS Report Server
Connect to Klipfolio 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.
-
Automated Continuous Exact Online Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Exact Online replication to Google BigQuery.
-
Automated Continuous MariaDB Replication to Vertica
Use CData Sync for automated, continuous, customizable MariaDB replication to Vertica.
-
Create Informatica Mappings From/To an ODBC Data Source for Impala
Create an ODBC connection to Impala in Informatica and browse and transfer Impala data.
-
Create Dynamic Oracle Eloqua Reporting Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle Eloqua Reporting to Infragistics XamDataGrid to build dynamic grids.
-
Use Claude to Talk to Your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Shopify data for you.
-
Analyze Live Salesloft Data in SAS Viya
Use CData Connect AI to connect to Salesloft data from SAS Viya and deploy self-service analytics using live Salesloft data.
-
Build Agents in Relevance AI with Access to Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on GetResponse data within intelligent agent workflows.
-
Build AfterShip-Connected Apps in Choreo
Use CData Connect AI to connect to AfterShip Data from Choreo and build custom apps using live AfterShip data.
-
Integrate Devin with Live Google Sheets Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Google Sheets data.
-
How to use SQLAlchemy ORM to access Oracle Financials Cloud Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Financials Cloud data.
-
How to Connect to Live PostgreSQL Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live PostgreSQL data securely in real time.
-
Connecting Agentforce with Snowflake 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 Snowflake data for you.
-
Integrate Adobe Target with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Adobe Target with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Adobe Target data.
-
Natively Connect to Blackbaud FE NXT Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Blackbaud FE NXT data. Leverage the native support for ODBC in PHP.
-
Query Calendly Data in DataGrip
Create a Data Source for Calendly in DataGrip and use SQL to query live Calendly data.
-
Interact with Live Microsoft Exchange Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Microsoft Exchange data.
-
Extract, Transform, and Load Sybase IQ Data in Informatica PowerCenter
Create a simple Workflow for Sybase IQ data in Informatica PowerCenter.
-
Automated Continuous Instantly Replication to Databricks
Use CData Sync for automated, continuous, customizable Instantly replication to Databricks.
-
Publish Crystal Reports on PingOne Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PingOne data.
-
Validate iContact Data with QuerySurge
Access and validate iContact data in QuerySurge using the CData JDBC Driver.
-
Replicate Multiple Paymo Accounts
Replicate multiple Paymo accounts to one or many databases.
-
Query Live Power BI XMLA Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Power BI XMLA data through a conversational interface.
-
Connect to SAP SuccessFactors Data in Aqua Data Studio
Access SAP SuccessFactors data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to load Cvent data into Elasticsearch via Logstash
Introducing a simple method to load Cvent data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Multiple Microsoft Exchange Accounts via the CData Sync CLI
Replicate multiple Microsoft Exchange accounts to one or many databases.
-
Use the CData Software ODBC Driver for Databricks in MicroStrategy
Connect to Databricks data in MicroStrategy Developer using the CData Software ODBC Driver for Databricks.
-
How to connect PolyBase to BigCommerce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live BigCommerce data.
-
Use Azure AI Foundry to Talk to Your HubDB 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 HubDB data for you.
-
Integrate Cursor with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Sheets data from within the editor.
-
Create SSAS Tabular Models from SAP Concur Data
How to build a SQL Server Analysis Service Tabular Model from SAP Concur data using CData drivers.
-
Analyze AfterShip Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for AfterShip from Power Pivot. You will use the Table Import Wizard to load AfterShip data. You can visually build the import query or use any SQL supported by the driver.
-
Easily Integrate ConvertAPI Data in Lazarus Pascal IDE
Learn how to easily integrate live ConvertAPI data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Query Discord Data in MySQL Workbench
Execute MySQL queries against live Discord data from MySQL Workbench.
-
Import Dropbox Data Using Azure Data Factory
Use CData Connect AI to connect to Dropbox Data from Azure Data Factory and import live Dropbox data.
-
Query TigerGraph Data in ColdFusion
Write standard ColdFusion data access code to connect to TigerGraph data.
-
How to Build an ETL App for Kafka Data in Python with CData Connect AI
Build ETL pipelines that read and write live Kafka data in Python with petl and the CData Connect AI Python SDK.
-
Migrating data from Facebook Ads to Databricks using CData SSIS Components.
Easily push Facebook Ads data to Databricks using the CData SSIS Tasks for Facebook Ads and Databricks.
-
Dynamically Retrieve Data Based on Cell Values with the CData Excel Add-in: CData Excel Formulas
Learn how to use the CData Excel Add-in and CData Excel Formulas to dynamically retrieve and refresh live cloud data in Excel using SQL queries.
-
Build a PostgreSQL Interface for Spotify Data using the CData JDBC Driver
Use the Remoting features of the Spotify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Dotmailer-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Dotmailer data.
-
Automate Clockify Data Replication to Couchbase
Use CData Sync to Customize and automate Clockify data replication to Couchbase.
-
Automated Continuous Azure Blob Storage Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Databricks.
-
How to Visualize eBay Analytics 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 eBay Analytics data in Python.
-
Consume Azure Analysis Services OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Analysis Services feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Amazon DynamoDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to delimited files (CSV/TSV).
-
How to create an RPA flow for Postmark Data in UiPath Studio
Use the Postmark ODBC Driver to create workflows that access real-time Postmark data without any coding.
-
Build Semantic Layer Views for Mailjet Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Mailjet data.
-
Connect to PDFMonkey Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PDFMonkey and the SQL Gateway to access PDFMonkey data from Google Apps Script.
-
How to connect to Avaza Data with Squirrel SQL client
Connect to Avaza data and execute queries in the Squirrel SQL Client.
-
Integrate Dify with Live Marketo 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 Marketo data.
-
Automated Continuous QuickBooks Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable QuickBooks data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Miro Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Miro replication to Amazon Redshift.
-
Integrate Dify with Live Exa 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 Exa data.
-
How to use SQLAlchemy ORM to access OneNote Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of OneNote data.
-
Bridge Twilio Connectivity with Apache NiFi
Access and process Twilio data in Apache NiFi using the CData JDBC Driver.
-
Query SFTP Data in DataGrip
Create a Data Source for SFTP in DataGrip and use SQL to query live SFTP data.
-
Create Informatica Mappings From/To an ODBC Data Source for NetSuite
Create an ODBC connection to NetSuite in Informatica and browse and transfer NetSuite data.
-
Connect to Supabase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Supabase to connect to Supabase data and execute queries in PowerBuilder.
-
Connect to SAP Ariba Source Data in RazorSQL
Connect to SAP Ariba Source from wizards and query SAP Ariba Source data from the GUI in the RazorSQL database management tool.