CData Software - Knowledge Base
Recent Articles
-
Connecting Moonlit Workflow with Google Drive via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Drive in real time.
-
Use Dash to Build to Web Apps on OData Services
Create Python applications that use pandas and Dash to build OData-connected web apps.
-
Automated Continuous Instagram Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Instagram replication to Azure SQL Database.
-
Visualize Slack in TIBCO Spotfire through OData
Integrate Slack into dashboards in TIBCO Spotfire.
-
Replicate JotForm to Multiple Databases
Replicate JotForm to disparate databases with a point-and-click configuration.
-
Build Data Flows from Kintone to SQL Server using SSIS
Easily back up Kintone to SQL Server using the SSIS components for Kintone.
-
How to Query Live Raisers Edge NXT in Perplexity MacOS Desktop
Connect to and query live Raisers Edge NXT in Perplexity Desktop using the CData MCP Server.
-
Consume Sybase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sybase feeds that reflect any changes in SAP Lumira.
-
Query TaxJar from Node.js
Use the OData endpoint of the CData API Server to connect to your TaxJar and perform CRUD operations on TaxJar from Node.js.
-
How to Query Active Directory in MySQL Workbench
Execute MySQL queries against live Active Directory from MySQL Workbench.
-
Use the CData Software ODBC Driver for BambooHR in MicroStrategy Web
Connect to BambooHR in MicroStrategy Web using the CData Software ODBC Driver for BambooHR.
-
Access DocuSign from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live DocuSign from HeidiSQL.
-
Visualize Google Sheets in Tableau
The CData ODBC driver for Google Sheets enables you integrate Google Sheets into Tableau dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for Pinterest
Create Pinterest data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bidirectional Access to OData Services from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate OData in Filemaker Pro for Mac or Windows.
-
LINQ to Jira Assets
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Jira Assets Data Provider.
-
Create Reckon-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Reckon from Klipfolio and build custom visualizations using live Reckon.
-
Easily Integrate Instagram in Lazarus Pascal IDE
Learn how to easily integrate live Instagram in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query Excel from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Excel and perform CRUD operations on Excel from Node.js.
-
Write a Simple Go Application to work with Marketo on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Marketo.
-
How to connect SharePoint with Azure DevOps through external lists
Provide Azure DevOps to SharePoint users as an external list.
-
How to pipe SAP BusinessObjects BI to CSV in PowerShell
Use standard PowerShell cmdlets to access SAP BusinessObjects BI tables.
-
Import Real-Time RSS Feeds via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use RSS Feeds in ColdFusion.
-
Create Zuora-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zuora from Klipfolio and build custom visualizations using live Zuora.
-
Replicate Multiple SendGrid Accounts via the CData Sync CLI
Replicate multiple SendGrid accounts to one or many databases.
-
How to Access Live Power BI XMLA in Power Automate Desktop via ODBC
The CData ODBC Driver for Power BI XMLA enables you to integrate Power BI XMLA into workflows built using Microsoft Power Automate Desktop.
-
Automate Act CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Act CRM from PowerShell? This article demonstrates how to utilize the Act CRM Cmdlets for tasks like connecting to Act CRM, automating operations, downloading data, and more.
-
Access Live Tableau CRM Analytics in Excel 365 Online (Excel for the web)
Connect to Tableau CRM Analytics from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Semantic Layer Views for GitHub in APOS Live Data Gateway
Use the CData Connector for GitHub in APOS Live Data Gateway to build Semantic Layer Views for GitHub.
-
Connect to Gmail in HULFT Integrate
Connect to Gmail as a JDBC data source in HULFT Integrate
-
Build Automated Hive-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Hive and build automated workflows in Zapier.
-
Connect to and Visualize Live MariaDB in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MariaDB.
-
How to connect and process Microsoft Office 365 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Office 365.
-
Automated Continuous Slack Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Slack replication to IBM DB2.
-
Create Power BI Reports on Real-Time JotForm
Use the CData ODBC Driver for JotForm to visualize JotForm in Power BI Desktop.
-
Automate Amazon Marketplace Replication to SAP HANA
Use CData Sync to customize and automate Amazon Marketplace replication to SAP HANA.
-
Stream Reckon into Apache Kafka Topics
Access and stream Reckon in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Marketo Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
A PostgreSQL Interface for EnterpriseDB (MySQL Remoting via JDBC)
Use the Remoting features of the EnterpriseDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect MySQL to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MySQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Quickbase Replication to MySQL
Use CData Sync for automated, continuous, customizable Quickbase replication to MySQL.
-
Build AI Agents with Azure Analysis Services Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Pinterest Reporting in OBIEE with the Pinterest JDBC Driver
Deploy the Pinterest JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to GitHub from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GitHub from Filemaker Pro on Mac.
-
How to connect to REST from Spring Boot
Connect to REST in a Spring Boot Application using CData JDBC REST Driver
-
Query Google Search Results through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Search from Node.js.
-
Connect to Sage 200 from a Connection Pool in Jetty
The Sage 200 JDBC Driver supports connection pooling: This article shows how to connect faster to Sage 200 from Web apps in Jetty.
-
Use Claude to Talk to Your MYOB AccountRight via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your MYOB AccountRight for you.
-
Automate LDAP Objects Replication to Azure Synapse
Use CData Sync to customize and automate LDAP replication to Azure Synapse.
-
Build Visualizations of Monday.com in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Monday.com in Birst.
-
Build a Singer.io Tap for Basecamp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Basecamp data using
-
Publish AlloyDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google AlloyDB.
-
Automated Continuous PayPal Replication to Snowflake
Use CData Sync for automated, continuous, customizable PayPal replication to Snowflake.
-
How to Connect to Live HubSpot Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live HubSpot securely in real time.
-
How to Access Greenplum Using Entity Framework
This article shows how to access Pivotal GreenPlum using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Dynamics 365 from Asprova with CData Software ODBC Driver for Dynamics 365
This article shows how to connect faster to Dynamics 365 data from Asprova.
-
Build SurveyMonkey Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SurveyMonkey and build visualizations in Tableau.
-
Connect Email to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Email with IBM WebSphere for seamless data integration and connectivity.
-
Prepare, Blend, and Analyze Smartsheet in Alteryx Designer (ODBC)
Build workflows to access live Smartsheet for self-service data analytics.
-
Use JayDeBeApi to access Excel in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Excel.
-
Extend Google Sheets with Amazon Athena
Make calls to the API Server from Google Apps Script.
-
Connect to Amazon Marketplace from a Connection Pool in JBoss
Integrate Amazon Marketplace into Java servlets: Use the Management Console in JBoss to install the Amazon Marketplace JDBC Driver.
-
Using the CData Software ODBC Driver for Snowflake in PyCharm
Connect to Snowflake as an ODBC data source in PyCharm using the CData Software ODBC Driver for Snowflake.
-
Use Biml to Build SSIS Tasks to Replicate Azure Table to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Table Storage to SQL Server.
-
How to Connect the Power BI Service to Oracle Sales: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Migrating data from Azure Active Directory to Databricks using CData SSIS Components.
Easily push Azure Active Directory to Databricks using the CData SSIS Tasks for Azure Active Directory and Databricks.
-
Import Freshdesk into the Power BI Service for Visualizations
Use CData Connect AI to connect to Freshdesk and provide access to live Freshdesk for custom reports in the Power BI Service.
-
Access Live MYOB AccountRight in Coginiti Pro
Connect to and query live MYOB AccountRight from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Enable the Snowflake JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Snowflake.
-
CData Virtuality Cloud Agent: Simplifying Hybrid Data Connectivity
Securely access on-premises data from the cloud using CData Virtuality’s Cloud Agent, a seamless hybrid connectivity without firewall changes.
-
Choosing the Best Method to Connect Facebook to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Facebook from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Jira Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Jira replication to Apache Cassandra.
-
Connect to Google Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Analytics, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Calendly Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Prepare, Blend, and Analyze SAP SuccessFactors in Alteryx Designer (Connect AI)
Build workflows to access live SAP SuccessFactors for self-service data analytics.
-
Connect to Calendly in Aqua Data Studio
Access Calendly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect Exact Online to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Exact Online using the CData Python MCP Server.
-
Working with SAP BusinessObjects BI in LINQPad
Execute LINQ queries to SAP BusinessObjects BI in LINQPad.
-
How to connect PolyBase to Google Cloud Storage
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Cloud Storage.
-
Use CData Connect AI to Access Facebook Ads in Microsoft Power Pivot
Use CData Connect AI to connect to live Facebook Ads in the Power Pivot business intelligence tool.
-
Creating GraphQL-Connected Applications in Unqork
You can use CData Connect AI to feed GraphQL to Unqork and build custom business apps.
-
Use Microsoft Copilot Studio to talk to your CockroachDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your CockroachDB for you.
-
Integrate Real-Time Access to CSV in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CSV/TSV Files in real time.
-
Query Raisers Edge NXT as a MySQL Database in Node.js
Execute MySQL queries against Raisers Edge NXT from Node.js.
-
Getting Started with the CData ODBC Driver for Azure Active Directory
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Active Directory.
-
Create Excel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Excel data access from reports, embedded analytics, and more.
-
How to publish and share SAP dashboards with Tableau Server
The CData ODBC driver for SAP enables you integrate SAP ERP/NetWeaver into Tableau dashboards.
-
Getting Started with the CData Python Connector for Square
Learn to install and license the CData Python Connector
-
Integrating LangGraph with IBM Informix via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on IBM Informix within automated workflows.
-
Access Live Zoho Books in AWS Lambda
Connect to live Zoho Books in AWS Lambda using the CData JDBC Driver.
-
Integrating Dataiku with ADP via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ADP.
-
How to Access Live JotForm in Power Automate Desktop via ODBC
The CData ODBC Driver for JotForm enables you to integrate JotForm into workflows built using Microsoft Power Automate Desktop.
-
Create Dynamic HDFS Grids Using the Infragistics XamDataGrid
Learn how you can connect HDFS to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Boomi Agentstudio with Facebook via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Facebook, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software JDBC Driver for Box in MicroStrategy
Connect to Box in MicroStrategy Developer using the CData Software JDBC Driver for Box.
-
Build SAP ByDesign-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Business ByDesign.
-
Automated Continuous Office 365 Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Office 365 replication to Microsoft Access.
-
Model, Search, and Visualize Live Cloudant in ThoughtSpot
Use CData Connect AI to connect to live IBM Cloudant for modeling, searching, and visualizing.
-
Connect to API from Crystal Reports
Use CData Connect AI to connect to and report on live API from Crystal Reports.
-
Publish CockroachDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CockroachDB.