CData Software - Knowledge Base
Recent Articles
-
Access Live Google Data Catalog in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Data Catalog in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Xero in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Xero Accounting.
-
Build Office 365-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Office 365 and create custom apps in Mendix.
-
How to Use a Microsoft Access Database to Update IBM Informix in Real Time
Update IBM Informix data by creating a linked table in Microsoft Access with the CData IBM Informix ODBC Driver.
-
Use the CData API Server to Access Oracle HCM Cloud in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle HCM Cloud in the Power Pivot business intelligence tool.
-
Access Live Jira Service Management in AWS Lambda (with IntelliJ IDEA)
Connect to live Atlassian Jira Service Management in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Zoho Books in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Books.
-
Visualize TaxJar in TIBCO Spotfire through OData
Integrate TaxJar into dashboards in TIBCO Spotfire.
-
Design BIRT Reports on Adobe Analytics
Provide current Adobe Analytics to your embedded analytics.
-
Automated Continuous Shopify Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Shopify replication to Apache Kafka.
-
Use Biml to Build SSIS Tasks to Replicate Raisers Edge NXT to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Raisers Edge NXT to SQL Server.
-
Perform Batch Operations with QuickBooks in Apache NiFi
Connect to QuickBooks Desktop and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to AlloyDB from Crystal Reports
Use CData Connect AI to connect to and report on live Google AlloyDB from Crystal Reports.
-
How to Work with Drip in ETL Validator JDBC
Connect to Drip from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Epicor Kinetic-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Epicor Kinetic from OutSystems and build custom enterprise apps using live Epicor Kinetic.
-
Connect to LDAP Objects in Jaspersoft Studio
Execute SQL to remote LDAP in Jaspersoft Studio.
-
Connect to Confluence in the Denodo Platform
Use CData driver technologies to create a virtual data source for Atlassian Confluence in the Denodo Virtual DataPort Administrator.
-
Access Blackbaud FE NXT in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Blackbaud FE NXT.
-
How to Query Hive in MySQL Workbench
Execute MySQL queries against live Apache Hive from MySQL Workbench.
-
Validate Neo4J with QuerySurge
Access and validate Neo4J in QuerySurge using the CData JDBC Driver.
-
Build Instagram-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Instagram.
-
Integrate Real-Time Access to HubSpot in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HubSpot in real time.
-
Connect to IBM Cloud Object Storage in CloverDX (formerly CloverETL)
Transfer IBM Cloud Object Storage using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live Sage Cloud Accounting from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Sage Business Cloud Accounting for you.
-
How to Connect to YouTube Analytics in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to YouTube Analytics. Leverage the pyodbc module for ODBC in Python.
-
Connect to Microsoft Project from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Project from HeidiSQL.
-
Automate ActiveCampaign Replication to Azure Synapse
Use CData Sync to customize and automate ActiveCampaign replication to Azure Synapse.
-
Build Charts with Databricks in Clear Analytics
Create dynamic charts and perform analytics based on Databricks in Clear Analytics.
-
Automated Continuous IBM Cloud Object Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to delimited files (CSV/TSV).
-
Automated Continuous Active Directory Replication to SQLite
Use CData Sync for automated, continuous, customizable Active Directory replication to SQLite.
-
How to connect SharePoint with Act-On through external lists
Provide Act-On to SharePoint users as an external list.
-
Visualize Live Sage 200 in the Power BI Service
Use CData Connect AI to connect to live Sage 200 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy Desktop
Connect to Google Ad Manager in MicroStrategy Desktop using the CData Software JDBC Driver for Google Ad Manager.
-
Migrating data from Dynamics 365 Business Central to Snowflake using CData SSIS Components.
Easily push Dynamics 365 Business Central to Snowflake using the CData SSIS Tasks for Dynamics 365 Business Central and Snowflake.
-
Connect to Reckon Accounts Hosted through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Reckon Accounts Hosted using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to SAS xpt in Aqua Data Studio
Access SAS XPORT from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Agents in Relevance AI with Access to Live Sugar CRM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sugar CRM within intelligent agent workflows.
-
Integrate Gmail with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Gmail with External Services.
-
How to Connect to Redis in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Redis. Leverage the pyodbc module for ODBC in Python.
-
Create Dynamic SAP Ariba Source Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Ariba Source to Infragistics XamDataGrid to build dynamic grids.
-
Automate Sage Cloud Accounting Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage Business Cloud Accounting and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to pipe Zuora to CSV in PowerShell
Use standard PowerShell cmdlets to access Zuora tables.
-
How to Connect to & Open Printful in Microsoft Excel
This article uses the CData ODBC driver for Printful to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Dash to Build to Web Apps on Zoom
Create Python applications that use pandas and Dash to build Zoom-connected web apps.
-
A PostgreSQL Interface for SAP HANA (MySQL Remoting via JDBC)
Use the Remoting features of the SAP HANA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Zoho CRM from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho CRM from Filemaker Pro on Mac.
-
Access Amazon Marketplace from MySQL in PHP
Connect to Amazon Marketplace through the standard MySQL libraries in PHP.
-
Bidirectional Access to Klipfolio from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Klipfolio in Filemaker Pro for Mac or Windows.
-
Replicate Multiple SingleStore Accounts via the CData Sync CLI
Replicate multiple SingleStore accounts to one or many databases.
-
Import MYOB AccountRight into the Power BI Service for Visualizations
Use CData Connect AI to connect to MYOB AccountRight and provide access to live MYOB AccountRight for custom reports in the Power BI Service.
-
Access Live Sybase IQ in AWS Lambda (with IntelliJ IDEA)
Connect to live Sybase IQ in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Provide OData Services of Blackbaud FE NXT from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Blackbaud FE NXT by developing a WCF Service Application.
-
Create SSAS Tabular Models from DB2
How to build a SQL Server Analysis Service Tabular Model from IBM DB2 using CData drivers.
-
Choosing the Best Method to Connect Redshift to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon Redshift from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Pipedrive Using the Script Function in Claris FileMaker Pro
-