CData Software - Knowledge Base
Recent Articles
-
How to create xBase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for xBase in MySQL .
-
How to publish and share Oracle Sales dashboards with Tableau Server
The CData ODBC driver for Oracle Sales enables you integrate Oracle Sales into Tableau dashboards.
-
Analyze SharePoint Excel Services in Infragistics Reveal
Use the CData API Server to create an OData API on top of SharePoint Excel Services and visualize live SharePoint Excel Services in Infragistics Reveal.
-
Work with MarkLogic in FoxPro
Load MarkLogic into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live HDFS of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache HDFS using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use JayDeBeApi to access QuickBooks Time in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks Time.
-
How to Access Live FTP in Power Automate Desktop via ODBC
The CData ODBC Driver for FTP enables you to integrate FTP Servers into workflows built using Microsoft Power Automate Desktop.
-
Connect to ADP from a Connection Pool in Jetty
The ADP JDBC Driver supports connection pooling: This article shows how to connect faster to ADP from Web apps in Jetty.
-
Extract, Transform, and Load Google Campaign Manager 360 in Informatica PowerCenter
Create a simple Workflow for Google Campaign Manager 360 in Informatica PowerCenter.
-
How to create an RPA flow for MailChimp in UiPath Studio
Use the MailChimp ODBC Driver to create workflows that access real-time MailChimp without any coding.
-
Analyze Google Directory in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Directory and visualize live Google Directory in Infragistics Reveal.
-
Analyze Paylocity with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Paylocity from Power Pivot. You will use the Table Import Wizard to load Paylocity. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Wave Financial in NetBeans
Connect to Wave Financial in NetBeans with the data source configuration wizard.
-
Integrating LangChain with Google Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Analytics within automated workflows.
-
Automate Parquet Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Parquet and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Data Flows from Tableau CRM Analytics to SQL Server using SSIS
Easily back up Tableau CRM Analytics to SQL Server using the SSIS components for Tableau CRM Analytics.
-
DataBind Controls to MYOB AccountRight in C++Builder
DataBind to MYOB AccountRight in C++Builder with standard components and controls.
-
Access Live Raisers Edge NXT in AWS Lambda
Connect to live Raisers Edge NXT in AWS Lambda using the CData JDBC Driver.
-
Analyze SQL Analysis Services in Infragistics Reveal
Use the CData API Server to create an OData API on top of SQL Analysis Services and visualize live SQL Analysis Services in Infragistics Reveal.
-
Connect to Asana as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Asana.
-
Choosing the Best Method to Connect SAP Concur to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Concur from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query Azure Data Catalog in DataGrip
Create a Data Source for Azure Data Catalog in DataGrip and use SQL to query live Azure Data Catalog.
-
Create Reports with Microsoft OneDrive in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneDrive.
-
Automated Continuous QuickBooks Time Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Azure SQL Database.
-
Build Dynamics 365-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dynamics 365 and create custom apps in Mendix.
-
Connect to Azure Active Directory from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Active Directory to connect to Azure Active Directory from Web applications running on WebLogic.
-
How to Connect to Live Stripe Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Stripe securely in real time.
-
Build Apps with Live Salesforce Data Cloud Using the Low-Code Development Platform of Mendix
-