CData Software - Knowledge Base
Recent Articles
-
Build an OLAP Cube in SSAS from Unbounce
Establish a connection to Unbounce data from SQL Server Analysis Services, and use the Unbounce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to QuickBooks Time in JRuby
Create a simple JRuby app with access to live QuickBooks Time.
-
Use the CData API Server to Access Tally in Microsoft PowerPivot
Use the CData API Server to connect to live Tally ERP in the Power Pivot business intelligence tool.
-
How to integrate Metabase with Azure Data Lake Storage
Use CData Connect AI to connect to live Azure Data Lake Storage and create an interactive dashboard in Metabase from Azure Data Lake Storage.
-
Publish Zoho Projects-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Projects.
-
Connect to SAP HANA XS Advanced from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP HANA XS Advanced using standard SQL.
-
Add MariaDB to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MariaDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
PowerShell Scripting to Replicate Zoho Books to MySQL
Write a simple PowerShell script to replicate Zoho Books to a MySQL database.
-
Migrating data from Avro to Snowflake using CData SSIS Components.
Easily push Apache Avro to Snowflake using the CData SSIS Tasks for Avro and Snowflake.
-
Access Live Google Spanner in Excel 365 Online (Excel for the web)
Connect to Google Spanner from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Choosing the Best Method to Connect Zoho Inventory to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Inventory from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Natively Connect to LinkedIn Ads in PHP
The CData ODBC driver for LinkedIn Ads enables you to create PHP applications with connectivity to LinkedIn Ads. Leverage the native support for ODBC in PHP.
-
Connect to Lakebase in Aqua Data Studio
Access Lakebase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Work with Live Vault CRM in Power Query
Use CData Connect AI to connect to Veeva Vault & Vault CRM and work with live Veeva Vault & Vault CRM in Microsoft Power Query.
-
Trigger Quickbase IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Automated Continuous SharePoint Excel Services Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Azure SQL Database.
-
Query Dynamics 365 from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Dynamics 365 and perform CRUD operations on Dynamics 365 from Node.js.
-
Integrating Gumloop with SurveyMonkey via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SurveyMonkey within automated workflows.
-
Seamlessly Bring Amazon Marketplace into Retool Using CData Connect AI
Integrate Amazon Marketplace data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
LINQ to Azure Synapse
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 Azure Synapse Data Provider.
-
Bidirectional Access to Zoho Books from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Books in Filemaker Pro for Mac or Windows.
-
How to Access Microsoft Planner Using Entity Framework
This article shows how to access Microsoft Planner using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Data Flows from Bing Ads to SQL Server using SSIS
Easily back up Bing Ads to SQL Server using the SSIS components for Bing Ads.
-
Stream Sage 300 into Apache Kafka Topics
Access and stream Sage 300 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Live Adobe Commerce in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Commerce.
-
Build a Singer.io Tap for Certinia With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Certinia data using
-
Access Coinbase from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Coinbase from HeidiSQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Analytics
Create an ODBC connection to Google Analytics in Informatica and browse and transfer Google Analytics.
-
Use the CData ODBC Driver for Bullhorn CRM in Microsoft Power Query
You can use the CData Bullhorn CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bullhorn CRM into Microsoft Power Query.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Slack using the Model Context Protocol.
-
How to work with Act-On in Apache Spark using SQL
Access and process Act-On in Apache Spark using the CData Software JDBC Driver.
-
How to Visualize Salesforce Data Cloud Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce Data Cloud in Python.
-
DataBind Slack to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Slack with the DevExpress Windows Forms and Web controls to provide Slack to a chart.
-
Integrate Todoist in Pentaho Data Integration
Build ETL pipelines based on Todoist in the Pentaho Data Integration tool.
-
How to Visualize Teradata Data in Python with pandas
Use pandas and other modules to analyze and visualize live Teradata in Python.
-
Access Okta from MySQL in Amazon QuickSight
Connect to Okta and build visualizations of Okta using a MySQL Connection in Amazon QuickSight.
-
Integrating Boomi Agentstudio with Google Spanner via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Spanner, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Semantic Layer Views for Snowflake in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Snowflake.
-
How to connect to Zoho Inventory with Squirrel SQL client
Connect to Zoho Inventory and execute queries in the Squirrel SQL Client.
-
Integrate Cursor with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache Cassandra from within the editor.
-
Consume Zoho Inventory OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoho Inventory feeds that reflect any changes in SAP Lumira.
-
Connect to Real-Time Oracle Eloqua Reporting Data in Power Apps Using Dataflows to Build Custom Applications
-