CData Software - Knowledge Base
Recent Articles
-
Automate Invoiced Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Invoiced and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use Manus AI to Talk to Your SharePoint via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Microsoft SharePoint.
-
Create SSAS Tabular Models from Calendly
How to build a SQL Server Analysis Service Tabular Model from Calendly using CData drivers.
-
Visualize Twitter Ads in Tableau
The CData ODBC driver for Twitter Ads enables you integrate Twitter Ads into Tableau dashboards.
-
CouchDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CouchDB facts in real time.
-
Visualize Live Drift in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Drift.
-
Deploy the ADO.NET Provider for Pinterest on an SSRS Report Server
Connect to Pinterest 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.
-
Connect to Azure Analysis Services from HeidiSQL
Use CData Connect AI to connect to and query live Azure Analysis Services from HeidiSQL.
-
Integrate Real-Time Access to Freshdesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Freshdesk in real time.
-
Integrate Cline with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Planner from within your IDE.
-
How to Access Live Confluence in Power Automate Desktop via ODBC
The CData ODBC Driver for Confluence enables you to integrate Atlassian Confluence into workflows built using Microsoft Power Automate Desktop.
-
Connect to Google Cloud Storage from Asprova with CData Software ODBC Driver for Google Cloud Storage
This article shows how to connect faster to Google Cloud Storage data from Asprova.
-
Connecting Moonlit Workflow with Spark 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 Apache Spark SQL in real time.
-
Connect to Google Ad Manager as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Ad Manager as an External Source in Dremio.
-
How to Work with Unbounce in ETL Validator JDBC
Connect to Unbounce from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Avalara AvaTax from MySQL in Amazon QuickSight
Connect to Avalara AvaTax and build visualizations of Avalara AvaTax using a MySQL Connection in Amazon QuickSight.
-
Viewing Power BI XMLA in RAD Studio Data Explorer
How to view Power BI XMLA in RAD Studio Data Explorer using the CData ODBC Driver for Power BI XMLA.
-
Load FTP to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FTP Servers to a database.
-
LINQ to DB2
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 DB2 Data Provider.
-
Replicate Multiple Azure Active Directory Accounts
Replicate multiple Azure Active Directory accounts to one or many databases.
-
Enable the Quickbase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Quickbase.
-
Automated Continuous Microsoft Project Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Project replication to Amazon Redshift.
-
Automate Procore Replication to Azure Data Lake
Use CData Sync to customize and automate Procore replication to Azure Data Lake.
-
Automated Continuous TaxJar Replication to Snowflake
Use CData Sync for automated, continuous, customizable TaxJar replication to Snowflake.
-
Query JotForm in ColdFusion
Write standard ColdFusion data access code to connect to JotForm.
-
Connect to SAS xpt in HULFT Integrate
Connect to SAS xpt as a JDBC data source in HULFT Integrate
-
How to Query Live Smartsheet in Perplexity MacOS Desktop
Connect to and query live Smartsheet in Perplexity Desktop using CData Code Assist MCP.
-
Airtable Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Airtable through CData Connect AI using different applications and tools.
-
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.
-
Automated Continuous EnterpriseDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Snowflake.
-
Integrate Live Amazon Marketplace into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon Marketplace and integrate live Amazon Marketplace into apps built in Microsoft Power Apps.
-
Connect to Bing Ads in DBeaver
Use the CData ODBC Driver to connect to Bing Ads in DBeaver.
-
Connect to Impala in NetBeans
Connect to Apache Impala in NetBeans with the data source configuration wizard.
-
Migrating data from Sugar CRM to Snowflake using CData SSIS Components.
Easily push Sugar CRM to Snowflake using the CData SSIS Tasks for Sugar CRM and Snowflake.
-
Create Azure Analysis Services-Connected Applications in Appsmith
Connect to Azure Analysis Services via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Analysis Services.
-
A PostgreSQL Interface for Dynamics 365 using the CData ODBC Driver
Use the SQL Gateway and Dynamics 365 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Visualize Live Zoho Projects Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho Projects into the Databricks platform and create visualization dashboards with real-time Zoho Projects.
-
Analyze Bitbucket in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bitbucket with the CData JDBC Driver for Bitbucket.
-
Create LinkedIn Ads-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to LinkedIn Ads from OutSystems and build custom enterprise apps using live LinkedIn Ads.
-
Work with Live Zoho CRM in Power Query
Use CData Connect AI to connect to Zoho CRM and work with live Zoho CRM in Microsoft Power Query.
-
Connect to Couchbase in RazorSQL
Connect to Couchbase from wizards and query Couchbase from the GUI in the RazorSQL database management tool.
-
Work with Live Airtable in Power Query
Use CData Connect AI to connect to Airtable and work with live Airtable in Microsoft Power Query.
-
Use JayDeBeApi to access xBase in Python
Use standard Python scripting and the development environment of your choice to access live xBase.
-
Integrate Theia IDE with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Bidirectional Access to SAP Netweaver Gateway from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Netweaver Gateway in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for Paylocity using the CData ODBC Driver
Use the SQL Gateway and Paylocity ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Directory in Claris FileMaker Pro
-