CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server to Access HCL Domino in Microsoft PowerPivot
Use the CData API Server to connect to live HCL Domino in the Power Pivot business intelligence tool.
-
Use Biml to Build SSIS Tasks to Replicate Teradata to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teradata to SQL Server.
-
Connect to Oracle Eloqua in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Eloqua in Airbyte.
-
Object-Relational Mapping (ORM) with Avro 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 Apache Avro into a Java-based ORM framework, Hibernate.
-
Edit and Search Google Campaign Manager 360 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Campaign Manager 360 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Campaign Manager 360 objects that you can access from apps and the dashboard.
-
Build Odoo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Odoo ERP.
-
Build an OLAP Cube in SSAS from Cosmos DB
Establish a connection to Azure Cosmos DB data from SQL Server Analysis Services, and use the Cosmos DB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build NetSuite-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for NetSuite and create custom apps in Bubble.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Drift
Provide connectivity to Drift through an SAP BusinessObjects universe.
-
Query Smartsheet as a SQL Server Database in Node.js
Execute SQL Server queries against Smartsheet from Node.js.
-
Work with QuickBooks in FoxPro
Load QuickBooks Desktop into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Azure Data Catalog Replication to Teradata
Use CData Sync to Customize and automate Azure Data Catalog replication to Teradata.
-
Process & Analyze FTP in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FTP .
-
Connect and Query Live Sage Intacct Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sage Intacct into Databricks
-
Automated Continuous QuickBooks Time Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon Redshift.
-
How to connect to Zoho Books from IntelliJ
Integrate connectivity to Zoho Books with wizards in IntelliJ.
-
Operational Reporting on DB2 from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote IBM DB2.
-
Provide OData Services of Sage 200 from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage 200 by developing a WCF Service Application.
-
Connect to NetSuite in the Denodo Platform
Use CData driver technologies to create a virtual data source for NetSuite CRM & ERP in the Denodo Virtual DataPort Administrator.
-
Create SAP Ariba Source-Connected Applications in Appsmith
Connect to SAP Ariba Source via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Ariba Source.
-
Build Workday-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Workday and build web apps with connectivity to live Workday.
-
Viewing Google Data Catalog in RAD Studio Data Explorer
How to view Google Data Catalog in RAD Studio Data Explorer using the CData ODBC Driver for Google Data Catalog.
-
Import Real-Time MySQL via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MySQL in ColdFusion.
-
Import Real-Time Jira via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Atlassian Jira in ColdFusion.
-
Connect to Excel Online in ACL Analytics
Connect to Microsoft Excel Online via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Excel Online.
-
Connect to Monday.com in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Monday.com and connect to Monday.com in Akorbi Digital RunMyProcess.
-
Connect to Avalara AvaTax in the Denodo Platform
Use CData driver technologies to create a virtual data source for Avalara AvaTax in the Denodo Virtual DataPort Administrator.
-
How to Query Live Oracle Service Cloud in Claude Desktop
Connect to and query live Oracle Service Cloud in Claude Desktop using CData Code Assist MCP.
-
Connect to LinkedIn Ads as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live LinkedIn Ads.
-
Integrate Google Data Catalog with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Data Catalog with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Data Catalog.
-
Integrate with Live Azure Analysis Services in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Analysis Services from the MuleSoft Anypoint Platform to integrate live Azure Analysis Services into custom reports and dashboards.
-
Visualize Live Microsoft Dataverse in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dataverse (CDS).
-
Access Live Oracle Service Cloud in Excel 365 Online (Excel for the web)
Connect to Oracle Service Cloud from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Biml to Build SSIS Tasks to Replicate Calendly to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Calendly to SQL Server.
-
Build a Singer.io Tap for Paylocity With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Paylocity data using
-
Automate QuickBooks Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access QuickBooks Online from PowerShell? This article demonstrates how to utilize the QuickBooks Online Cmdlets for tasks like connecting to QuickBooks Online, automating operations, downloading data, and more.
-
Access SAS xpt from MySQL in Amazon QuickSight
Connect to SAS xpt and build visualizations of SAS XPORT using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous EnterpriseDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Amazon S3.
-
Automate Couchbase Replication to Azure Synapse
Use CData Sync to customize and automate Couchbase replication to Azure Synapse.
-
Build Microsoft OneDrive-Powered Applications in Cursor with CData Code Assist MCP
-