CData Software - Knowledge Base
Recent Articles
-
Access Tableau CRM Analytics from MySQL in Amazon QuickSight
Connect to Tableau CRM Analytics and build visualizations of Tableau CRM Analytics using a MySQL Connection in Amazon QuickSight.
-
How to Connect to & Open Typeform in Microsoft Excel
This article uses the CData ODBC driver for Typeform to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Design Snowflake Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Connect to Parquet from Asprova with CData Software ODBC Driver for Parquet
This article shows how to connect faster to Parquet data from Asprova.
-
Connect Databricks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Databricks using the CData Python MCP Server.
-
How to connect to IBM Cloud Object Storage from IntelliJ
Integrate connectivity to IBM Cloud Object Storage with wizards in IntelliJ.
-
How to Work with Gmail in AWS Glue Jobs Using JDBC
Connect to Gmail from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Dynamics 365 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Dynamics 365, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Raisers Edge NXT from MySQL in PHP
Connect to Raisers Edge NXT through the standard MySQL libraries in PHP.
-
Automated Continuous YouTube Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Amazon S3.
-
Rapidly Develop PingOne-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Use Agno to Talk to Your Elasticsearch 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 Elasticsearch for you.
-
How to Work with SAP Fieldglass in ETL Validator JDBC
Connect to SAP Fieldglass from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData API Server to Access Slack in Microsoft PowerPivot
Use the CData API Server to connect to live Slack in the Power Pivot business intelligence tool.
-
Create a Data Access Object for Google Spanner using JDBI
A brief overview of creating a SQL Object API for Google Spanner in JDBI.
-
How to Connect to Live Trello 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 Trello for you.
-
Analyze Box in Infragistics Reveal
Use the CData API Server to create an OData API on top of Box and visualize live Box in Infragistics Reveal.
-
Connect to and Visualize Live Kintone in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Kintone.
-
LINQ to Xero
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 Xero Data Provider.
-
Create Apps from Salesforce Pardot in Qlik Sense Cloud
Use CData Connect AI to connect to Salesforce Pardot and build apps from live Salesforce Pardot in Qlik Sense Cloud.
-
Automated Continuous Facebook Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Amazon S3.
-
A PostgreSQL Interface for Oracle Sales (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Sales JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate WordPress into Power Automate Desktop using CData Connect
CData Connect for WordPress enables you to integrate WordPress into workflows built using Microsoft Power Automate Desktop.
-
Build a Singer.io Tap for Neo4J With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Neo4J data using
-
Replicate Office 365 from PowerShell
Write a quick PowerShell script to query Microsoft Office 365. Use connectivity to the live data to replicate Microsoft Office 365 to SQL Server.
-
How to create Todoist federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Todoist in MySQL .
-
Connecting Mastra with Dynamics CRM via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
DataBind Charts to SAP Fieldglass
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Fieldglass 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.
-
How to connect PolyBase to SharePoint
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft SharePoint.
-
Connect to Outreach.io as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Outreach.io.
-
Use the CData SSIS Components to Insert New or Update Existing SharePoint Excel Services Records from SQL Server
Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SharePoint Excel Services or update existing records with data from a SQL Server database.
-
Getting Started with the CData ODBC Driver for Snowflake
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Snowflake.
-
Connect to Neo4J from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Neo4J using standard SQL.
-
Build Visualizations of Zendesk in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zendesk in Birst.
-
How to Query Live LinkedIn Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LinkedIn Ads data in natural language using Python.
-
Use CData Connect AI to Access YouTube Analytics in Microsoft Power Pivot
Use CData Connect AI to connect to live YouTube Analytics in the Power Pivot business intelligence tool.
-
Getting Started with the CData Excel Add-In for ADP
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ADP.
-
Build a Singer.io Tap for Drip With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Drip data using
-
Create Informatica Mappings From/To a JDBC Data Source for Sage Intacct
Create Sage Intacct data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query IBM Informix in DataGrip
Create a Data Source for IBM Informix in DataGrip and use SQL to query live IBM Informix.
-
Automate Azure Table Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Table Storage from PowerShell? This article demonstrates how to utilize the Azure Table Cmdlets for tasks like connecting to Azure Table Storage, automating operations, downloading data, and more.
-
Extend Google Sheets with Amazon S3
Make calls to the API Server from Google Apps Script.
-
Create Dynamic ClickUp Grids Using the Infragistics XamDataGrid
Learn how you can connect ClickUp to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous SAP BusinessObjects BI Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to MySQL.
-
How to connect to HDFS in DBVisualizer
Integrate Apache HDFS with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect SharePoint with Pipedrive through external lists
Provide Pipedrive to SharePoint users as an external list.
-
Prepare, Blend, and Analyze SAP Business One in Alteryx Designer (Connect AI)
Build workflows to access live SAP Business One for self-service data analytics.
-
Cassandra Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cassandra facts in real time.
-
Create Apps from LinkedIn Ads in Qlik Sense Cloud
Use CData Connect AI to connect to LinkedIn Ads and build apps from live LinkedIn Ads in Qlik Sense Cloud.
-
Build AI/ML Models with Live Pipedrive Data using Dataiku
-