CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access SuiteCRM in Python
Use standard Python scripting and the development environment of your choice to access live SuiteCRM.
-
Publish Reports with Microsoft Dataverse in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dataverse (CDS).
-
QuickBooks Time Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to QuickBooks Time through CData Connect AI using different applications and tools.
-
LINQ to REST
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 REST Data Provider.
-
Natively Connect to HarperDB in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HarperDB. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with MYOB AccountRight
Access MYOB AccountRight as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Microsoft Dataverse through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Dataverse (CDS) from Node.js.
-
Build Agents in Relevance AI with Access to Live Azure Analysis Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Analysis Services within intelligent agent workflows.
-
Extract, Transform, and Load Azure Table in Informatica PowerCenter
Create a simple Workflow for Azure Table Storage in Informatica PowerCenter.
-
Prepare, Blend, and Analyze NetSuite in Alteryx Designer (ODBC)
Build workflows to access live NetSuite CRM & ERP for self-service data analytics.
-
Replicate LinkedIn Ads from PowerShell
Write a quick PowerShell script to query LinkedIn Ads. Use connectivity to the live data to replicate LinkedIn Ads to SQL Server.
-
Integrate with Live Spark in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Spark from the MuleSoft Anypoint Platform to integrate live Apache Spark SQL into custom reports and dashboards.
-
Integrate Cursor with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Bullhorn CRM from within the editor.
-
Object-Relational Mapping (ORM) with SAP SuccessFactors Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP SuccessFactors into a Java-based ORM framework, Hibernate.
-
Create Informatica Mappings From/To a JDBC Data Source for YouTube Analytics
Create YouTube Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
View Reports on Real-Time Acumatica in Power BI Report Server
Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop and then publish them to Power BI Report Server.
-
A PostgreSQL Interface for ActiveCampaign using the CData ODBC Driver
Use the SQL Gateway and ActiveCampaign ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Easily Query Power BI XMLA in OpenOffice Base
-
