CData Software - Knowledge Base
Recent Articles
-
Build Exact Online-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Exact Online to explore live Exact Online Data in Cursor to assist with building Exact Online-powered applications.
-
Establish a Live Connection with Suadeo Data using Tableau Bridge
The CData ODBC Driver for Suadeo enables you to integrate live Suadeo into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Live Avro Data in MicroStrategy through CData Connect AI
Create a live connection to Avro Data in CData Connect AI and connect to your Apache Avro from MicroStrategy.
-
How to Connect the Power BI Service to Figshare: Complete Guide
Connect to the CData Software Power BI Connector for Figshare from PowerBI.com to provide real-time Figshare across the organization.
-
Building Dynamic Web Pages with SAP Data Using AngularJS
Create single-page applications with live connectivity to SAP using the CData API Server.
-
Publish Coinbase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Coinbase.
-
Edit and Search Google Drive External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Drive to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Drive objects that you can access from apps and the dashboard.
-
Visualize Adobe Experience Manager Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Adobe Experience Manager.
-
Design BIRT Reports on Instagram Data
Provide current Instagram to your embedded analytics.
-
ETL Act-On in Oracle Data Integrator
This article shows how to transfer Act-On into a data warehouse using Oracle Data Integrator.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Salesforce Marketing Cloud within intelligent workflows.
-
Consume SAP BusinessObjects BI OData Feeds in PowerBuilder
This article demonstrates how to consume SAP BusinessObjects BI as OData feeds from PowerBuilder using the API Server.
-
Visualize Google Ads Data in TIBCO Spotfire through OData
Integrate Google Ads into dashboards in TIBCO Spotfire.
-
Create Dashboards and Visualize Live Redis Data in Geckoboard
Use CData Connect AI to connect to live Redis and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Power BI Reports on Real-Time Facebook Data
Use the CData ODBC Driver for Facebook to visualize Facebook in Power BI Desktop.
-
How to Query Live MailChimp Data in Perplexity MacOS Desktop
Connect to and query live MailChimp Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Oracle Service Cloud Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Snowflake.
-
Build Wave Financial-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Wave Financial to explore live Wave Financial Data in Gemini Code Assist to assist with building Wave Financial-powered applications.
-
How to connect and process AdRoll from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live AdRoll.
-
Query, Visualize, and Share live Amazon S3 Data in Redash
Use CData Connect AI to connect to live Amazon S3 in Redash for querying, visualizing, and sharing.
-
Use JayDeBeApi to access SAP Fieldglass Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Fieldglass.
-
Connect to Cloudant Data from PowerBuilder via ADO.NET
This article demonstrates how to access IBM Cloudant from Appeon PowerBuilder using the CData ADO.NET Provider for Cloudant.
-
Use the CData Software JDBC Driver for Amplitude in MicroStrategy Web
Connect to Amplitude in MicroStrategy Web using the CData Software JDBC Driver for Amplitude.
-
Connect to Notion Data in DBArtisan
Use wizards in DBArtisan to configure Notion as a data source.
-
Integrate with FTP Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy FTP Servers to a JSON file on disk.
-
Build Semantic Layer Views for OneNote Data in APOS Live Data Gateway
Use the CData Connector for OneNote in APOS Live Data Gateway to build Semantic Layer Views for Microsoft OneNote.
-
Connect to Zoho Books Data in JRuby
Create a simple JRuby app with access to live Zoho Books.
-
Build a Singer.io Tap for Bright Data With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bright Data data using
-
Migrating data from MarkLogic to Google BigQuery using CData SSIS Components.
Easily push MarkLogic to Google BigQuery using the CData SSIS Tasks for MarkLogic and Google BigQuery.
-
Process & Analyze BenchmarkEmail Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live BenchmarkEmail Data.
-
How to connect to Sybase Data with Squirrel SQL client
Connect to Sybase and execute queries in the Squirrel SQL Client.
-
Use Azure AI Foundry to Talk to Your Sybase IQ 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 Sybase IQ for you.
-
Integrate LibreChat with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live CSV/TSV Files from within the chat interface.
-
Connecting GenSpark with Zoho Projects Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zoho Projects without any replication or custom integration required.
-
How to Access Jira Data Using Entity Framework
This article shows how to access Atlassian Jira using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Object-Relational Mapping (ORM) with FHIR Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to FHIR into a Java-based ORM framework, Hibernate.
-
Analyze Act-On Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Act-On and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Nethunt Data in DBArtisan
Use wizards in DBArtisan to configure Nethunt as a data source.
-
Connect to Marketo Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Marketo.
-
Create Square-Connected Business Apps in AppSheet
Connect to Square Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Square.
-
Integrate Quaderno Data in the Pentaho Report Designer
Publish reports based on Quaderno in the Pentaho BI tool.
-
Integrating LlamaIndex with Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Basecamp in real time.
-
Connect to Cvent Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Cvent.
-
Access PayPal Data from MySQL in Amazon QuickSight
Connect to PayPal and build visualizations of PayPal using a MySQL Connection in Amazon QuickSight.
-
Integrating Gumloop with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Exchange within automated workflows.
-
Connect to Jira Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Jira and the Script function in FileMaker Pro to connect to Jira and work with Atlassian Jira in your FileMaker application.
-
Deploy the ADO.NET Provider for Salesforce on an SSRS Report Server
Connect to Salesforce & Force.com 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 connect to EnterpriseDB Data with Squirrel SQL client
Connect to EnterpriseDB and execute queries in the Squirrel SQL Client.
-
Build NetSuite-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for NetSuite to explore live NetSuite Data in Cursor to assist with building NetSuite-powered applications.
-
Automate Azure Data Catalog Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Data Catalog replication to Couchbase.
-
DataBind Charts to Helpscout Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Helpscout from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to CouchDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with CouchDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Dashboards and Visualize Live DB2 Data in Geckoboard
Use CData Connect AI to connect to live IBM DB2 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Query Teradata Data as a MySQL Database in Node.js
Execute MySQL queries against Teradata from Node.js.
-
Use Dash to Build Web Apps on Authorize.Net Data via CData Connect AI
Build interactive Dash web apps on live Authorize.Net using pandas and the CData Connect AI Python SDK.
-
Seamlessly Bring Cassandra Data into Retool Using CData Connect AI
Integrate Cassandra data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Viewing Acumatica Data in RAD Studio Data Explorer
How to view Acumatica ERP in RAD Studio Data Explorer using the CData ODBC Driver for Acumatica.
-
Connect to ServiceDesk Plus Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ServiceDesk Plus in the Denodo Virtual DataPort Administrator.
-
Replicate Microsoft OneDrive Data from PowerShell
Write a quick PowerShell script to query Microsoft OneDrive. Use connectivity to the live data to replicate Microsoft OneDrive to SQL Server.
-
Use the CData Software ODBC Driver for Pipeliner CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Pipeliner CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pipeliner CRM.
-
Integrating Cursor CLI with eBay Analytics 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.
-
Connecting Pipedream with Smartsheet 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 Smartsheet data in real time.
-
Use the CData Software ODBC Driver for Insightly in MicroStrategy
Connect to Insightly in MicroStrategy Developer using the CData Software ODBC Driver for Insightly.
-
Automated Continuous Discord Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Discord replication to IBM DB2.
-
Integrate with Power BI XMLA Data in JReport Designer
Create charts and reports based on Power BI XMLA in JReport Designer.
-
Back Up Power BI XMLA to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Power BI XMLA. In this article, we will employ an SSIS workflow to populate a database with Power BI XMLA data.
-
Use the CData Software ODBC Driver for Adobe Experience Manager in MicroStrategy Desktop
Connect to Adobe Experience Manager in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Experience Manager.
-
Publish Oracle Service Cloud-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle Service Cloud.
-
How to integrate QuickBooks Online with Apache Airflow
Access and process QuickBooks Online in Apache Airflow using the CData JDBC Driver.
-
Integrate Open WebUI with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Redis from within the chat interface.
-
Use the CData Software ODBC Driver for Bugsnag in SAS for Real-Time Reporting and Analytics
Connect to real-time Bugsnag in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Bugsnag.
-
Connect to Samanage Data in HULFT Integrate
Connect to Samanage as a JDBC data source in HULFT Integrate
-
Load Pinecone Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pinecone to a database.
-
Choosing the Best Method to Connect Scrapfly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Scrapfly from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Aweber Data in Aqua Data Studio
Access Aweber from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Xero Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Xero replication to AlloyDB.
-
Automated Continuous Paymo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Paymo replication to Amazon Redshift.
-
How to Visualize Trello 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 Trello in Python.
-
Feed Google Directory Data into FineReport
How to set Google Directory as a JDBC data source in FineReport.
-
Connect to ShipEngine Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ShipEngine as an External Source in Dremio.
-
Replicate Multiple Sage Cloud Accounting Accounts via the CData Sync CLI
Replicate multiple Sage Cloud Accounting accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PayPal
Provide connectivity to PayPal through an SAP BusinessObjects universe.
-
Model Tally Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Tally, enabling the direct import of real-time Tally ERP.
-
Integrate MessageBird with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MessageBird with External Services.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CapsuleCRM
Provide connectivity to CapsuleCRM through an SAP BusinessObjects universe.
-
Import Real-Time Snapchat Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Snapchat Ads in ColdFusion.
-
DataBind Controls to Zoho CRM Data in Delphi
DataBind to Zoho CRM in Delphi with standard data access components and controls.
-
Create SSAS Tabular Models from LeadDesk Data
How to build a SQL Server Analysis Service Tabular Model from LeadDesk using CData drivers.
-
Use the CData Software ODBC Driver for Jodoo in MicroStrategy Desktop
Connect to Jodoo in MicroStrategy Desktop using the CData Software ODBC Driver for Jodoo.
-
Create MariaDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MariaDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect and Visualize Live Confluence Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Atlassian Confluence into the Databricks platform and create visualization dashboards with real-time Atlassian Confluence.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Bitbucket actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous SAP Netweaver Gateway Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Google Cloud SQL.
-
Import and Visualize MessageBird Data in Power View
Create data visualizations based on MessageBird in Excel.
-
Replicate Supabase Data to Multiple Databases
Replicate Supabase to disparate databases with a point-and-click configuration.
-
Automated Continuous Vault CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Vault CRM replication to Azure SQL Database.
-
Build Apps with Live Paymo Data Using the Low-Code Development Platform of Mendix
Connect Paymo with Mendix to build apps using the CData API Driver for JDBC.
-
Replicate eBay Analytics Data from PowerShell
Write a quick PowerShell script to query eBay Analytics. Use connectivity to the live data to replicate eBay Analytics to SQL Server.
-
ETL ZendeskSell in Oracle Data Integrator
This article shows how to transfer ZendeskSell into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live Zuora Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Zuora for you.