CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Raisers Edge NXT from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Raisers Edge NXT through natural language.
-
How to create Visio diagrams from SAP Concur
Automatically update SAP Concur with the changes you make to Visio master shapes.
-
Perform Batch Operations with SFTP in Apache NiFi
Connect to SFTP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Access Dynamics 365 Business Central Using Entity Framework
This article shows how to access Dynamics 365 Business Central using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Dataiku with Slack via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Slack.
-
How to Visualize Tally Data in Python with pandas
Use pandas and other modules to analyze and visualize live Tally ERP in Python.
-
Connect and Visualize Live Office 365 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Office 365 into the Databricks platform and create visualization dashboards with real-time Microsoft Office 365.
-
Access Live Sage Intacct in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage Intacct in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Couchbase in JRuby
Create a simple JRuby app with access to live Couchbase.
-
Load Google Spanner to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Spanner to a database.
-
How to Query Live Klipfolio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Klipfolio data in natural language using Python.
-
How to integrate EventBrite with Apache Airflow
Access and process Eventbrite in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for PostgreSQL (MySQL Remoting via JDBC)
Use the Remoting features of the PostgreSQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create SAP Fieldglass Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Fieldglass data access from reports, embedded analytics, and more.
-
Create Datasets from Act-On in Domo Workbench and Build Visualizations of Act-On in Domo
Use the CData Software ODBC Driver for Act-On to create datasets from Act-On in Domo Workbench and then build visualizations in the Domo service.
-
Deploy the ADO.NET Provider for Facebook on an SSRS Report Server
Connect to Facebook 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.
-
Using the CData Software ODBC Driver for GraphQL in PyCharm
Connect to GraphQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for GraphQL.
-
Automated Continuous Freshdesk Replication to Oracle
Use CData Sync for automated, continuous, customizable Freshdesk replication to Oracle.
-
Use JayDeBeApi to access BigCommerce in Python
Use standard Python scripting and the development environment of your choice to access live BigCommerce.
-
View Reports on Real-Time YouTube Analytics in Power BI Report Server
Use the CData ODBC Driver for YouTube Analytics to visualize YouTube Analytics in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with Sage Intacct in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage Intacct in SnapLogic.
-
Build MVC Applications with Connectivity to Zuora
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zuora from an ASP.NET MVC application.
-
Feed Teradata into FineReport
How to set Teradata as a JDBC data source in FineReport.
-
Integrate Sage Cloud Accounting into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sage Business Cloud Accounting and integrate live Sage Business Cloud Accounting into your Power Automate tasks.
-
Replicate Multiple Vault CRM Accounts via the CData Sync CLI
Replicate multiple Vault CRM accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Calendar
Provide connectivity to Google Calendar through an SAP BusinessObjects universe.
-
Analyze Typeform in R via JDBC
Use standard R functions and the development environment of your choice to analyze Typeform with the CData JDBC Driver for Typeform.
-
Connect to RSS Feeds from a Connection Pool in JBoss
Integrate RSS Feeds into Java servlets: Use the Management Console in JBoss to install the RSS JDBC Driver.
-
Using the CData Software ODBC Driver for PingOne in PyCharm
Connect to PingOne as an ODBC data source in PyCharm using the CData Software ODBC Driver for PingOne.
-
Write a Simple Go Application to work with Office 365 on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Office 365.
-
Connect to Google Calendar from Crystal Reports
Use CData Connect AI to connect to and report on live Google Calendar from Crystal Reports.
-
Object-Relational Mapping (ORM) with SQL Analysis Services 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 SQL Analysis Services into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Microsoft Dataverse from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Dataverse (CDS) for you.
-
Access HubDB from MySQL in Amazon QuickSight
Connect to HubDB and build visualizations of HubDB using a MySQL Connection in Amazon QuickSight.
-
Query DocuSign from Node.js
Use the OData endpoint of the CData API Server to connect to your DocuSign and perform CRUD operations on DocuSign from Node.js.
-
Create SSAS Tabular Models from Google Data Catalog
How to build a SQL Server Analysis Service Tabular Model from Google Data Catalog using CData drivers.
-
How to create Visio diagrams from Facebook
Automatically update Facebook with the changes you make to Visio master shapes.
-
Use the CData ODBC Driver for WordPress in Microsoft Power Query
You can use the CData WordPress ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import WordPress into Microsoft Power Query.
-
Query Invoiced through ODBC in Node.js
Use node-odbc to execute SQL queries against Invoiced from Node.js.
-
Integrating Gumloop with QuickBooks Online via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on QuickBooks Online within automated workflows.
-
Automated Continuous CSV Replication to MongoDB
Use CData Sync for automated, continuous, customizable CSV replication to MongoDB.
-
Replicate Multiple SAS xpt Accounts via the CData Sync CLI
Replicate multiple SAS xpt accounts to one or many databases.
-
Stream Elasticsearch into Apache Kafka Topics
Access and stream Elasticsearch in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Zoho Creator in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Creator and visualize live Zoho Creator in Infragistics Reveal.
-
Connect Salesforce Pardot to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce Pardot using the CData Python MCP Server.
-
Connect HarperDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HarperDB with IBM WebSphere for seamless data integration and connectivity.
-
Connect to REST in Aqua Data Studio
Access REST from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Model Dynamics 365 Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365, enabling the direct import of real-time Microsoft Dynamics 365.
-
Connect JSON to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect JSON with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData ODBC Driver for Dropbox from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dropbox to connect to Dropbox from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dropbox in Excel.
-
How to Build an ETL App for Shippo in Python with CData
Create ETL applications and real-time data pipelines for Shippo in Python with petl.
-
Create Paylocity Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Microsoft Project-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Project.
-
Connect to ADP from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ADP using standard SQL.
-
How to use SQLAlchemy ORM to access MySQL in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MySQL.
-
Connect to SAP Netweaver Gateway in DBArtisan
Use wizards in DBArtisan to configure SAP Netweaver Gateway as a data source.
-
How to integrate TaxJar with Apache Airflow
Access and process TaxJar in Apache Airflow using the CData JDBC Driver.
-
Integrate SAP Hybris C4C into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Hybris C4C and integrate live SAP Hybris C4C into your Power Automate tasks.
-
Build a Singer.io Tap for Impala With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Impala data using
-
Create Airtable-Connected Applications in Appsmith
Connect to Airtable via CData Connect AI in Appsmith and create custom business applications with real-time access to Airtable.
-
How to use SQLAlchemy ORM to access SAS xpt in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAS XPORT.
-
Access Live Oracle Financials Cloud in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Financials Cloud from your Google Sheets.
-
Access Live QuickBooks in AWS Lambda
Connect to live QuickBooks Desktop in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Microsoft Dataverse Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Microsoft Access.
-
Connect to Shippo in SpagoBI
Create reports featuring live Shippo in SpagoBI Studio. Host Shippo reports on SpagoBI Server.
-
Getting Started with the CData Excel Add-In for Shopify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Shopify.
-
Build a Singer.io Tap for RSS With the CData Python Connector
Learn how to easily build a Singer.io Tap for live RSS data using
-
Connect to IBM Informix as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Informix.
-
Create Power BI Reports on Real-Time BambooHR
Use the CData ODBC Driver for BambooHR to visualize BambooHR in Power BI Desktop.
-
How to use SQLAlchemy ORM to access Asana in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Asana.
-
Choosing the Best Method to Connect Google Data Catalog to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Data Catalog from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build AI/ML Models with Live Microsoft Project Data using Dataiku
-