Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Integrate Live Oracle Eloqua into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Oracle Eloqua and integrate live Oracle Eloqua into apps built in Microsoft Power Apps.
Build a Simple VCL Application for Couchbase

How to build a simple VCL Application to view Couchbase in RAD Studio using the CData ODBC Driver for Couchbase.
Integrate Dynamics CRM with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Dynamics CRM with External Services.
Build Dashboards with HubSpot in Dundas BI

Create dynamic dashboards and perform analytics based on HubSpot in Dundas BI.
Access Live Salesforce Pardot in Excel 365 Online (Excel for the web)

Connect to Salesforce Pardot from Excel 365 Online (Excel for the web) with CData Connect Cloud.
How to use SQLAlchemy ORM to access Snowflake in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Snowflake.
Create Office 365 Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Office 365 data access from reports, embedded analytics, and more.
Query Todoist through ODBC in Node.js

Use node-odbc to execute SQL queries against Todoist from Node.js.
Use CData Connect Cloud to Access SAP Concur in Microsoft Power Pivot

Use CData Connect Cloud to connect to live SAP Concur in the Power Pivot business intelligence tool.
Build Semantic Layer Views for HubDB in APOS Live Data Gateway

Use the CData Connector for HubDB in APOS Live Data Gateway to build Semantic Layer Views for HubDB.
Analyze Microsoft Dataverse in Looker

Use CData Connect Cloud to connect to Microsoft Dataverse from Looker and build custom apps using live Microsoft Dataverse (CDS).
Stream Azure Active Directory into Apache Kafka Topics

Access and stream Azure Active Directory in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
Automate ClickUp Replication to Couchbase

Use CData Sync to Customize and automate ClickUp replication to Couchbase.
Connect to Printful as an External Source in Dremio

Use the CData JDBC Driver to connect to Printful as an External Source in Dremio.
Model BCart Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and BCart, enabling the direct import of real-time BCart.
Automated Continuous MongoDB Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable MongoDB replication to Google BigQuery.
Analyze NetSuite in R via JDBC

Use standard R functions and the development environment of your choice to analyze NetSuite CRM & ERP with the CData JDBC Driver for NetSuite.
Visualize Dropbox in Tableau

The CData ODBC driver for Dropbox enables you integrate Dropbox into Tableau dashboards.
Rapidly Develop PayPal-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
Create Salesloft Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Salesloft to build custom dashboards in Bold BI.
Deploy the ADO.NET Provider for SQL Analysis Services on an SSRS Report Server

Connect to SQL Analysis Services 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.
How to Access JotForm Using Entity Framework

This article shows how to access JotForm using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
How to Connect to Oracle Service Cloud in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Oracle Service Cloud. Leverage the pyodbc module for ODBC in Python.
Build Semantic Layer Views for Oracle Eloqua in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Oracle Eloqua.
Connect to Shippo in Aqua Data Studio

Access Shippo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
Operational Reporting on Zoho CRM from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Zoho CRM.
Visualize Xero in Sisense

Create an ElastiCube in Sisense app with access to Xero Accounting.
Using the CData Software ODBC Driver for Authorize.Net in PyCharm

Connect to Authorize.Net as an ODBC data source in PyCharm using the CData Software ODBC Driver for Authorize.Net.
Visualize Live AlloyDB in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Google AlloyDB into custom reports in Power BI.
Query SAP ByDesign as a SQL Server Database in Node.js

Execute SQL Server queries against SAP Business ByDesign from Node.js.
Seamlessly Bring Azure Synapse into Retool Using CData Connect Cloud

Integrate Azure Synapse data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
Replicate Multiple SAP Hybris C4C Accounts via the CData Sync CLI

Replicate multiple SAP Hybris C4C accounts to one or many databases.
Integrate with Xero using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Xero Accounting to a JSON file on disk.
How to connect to LinkedIn Ads from IntelliJ

Integrate connectivity to LinkedIn Ads with wizards in IntelliJ.
Use the CData ODBC Driver for Twilio from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Twilio to connect to Twilio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Twilio in Excel.
Build a Simple VCL Application for Adobe Commerce

How to build a simple VCL Application to view Adobe Commerce in RAD Studio using the CData ODBC Driver for Adobe Commerce.
How to Query Live Aha Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Aha! data in natural language using Python.
Connect to QuickBooks Time as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live QuickBooks Time.
Use JayDeBeApi to access SharePoint in Python

Use standard Python scripting and the development environment of your choice to access live Microsoft SharePoint.
Stream Workday into Apache Kafka Topics

Access and stream Workday in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
Deploy the ADO.NET Provider for LinkedIn on an SSRS Report Server

Connect to LinkedIn 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.
How to load Dynamics NAV data into Elasticsearch via Logstash

Introducing a simple method to load Dynamics NAV data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
Build Visualizations of Smartsheet in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Smartsheet in Birst.
How to integrate CSV with Apache Airflow

Access and process CSV/TSV Files in Apache Airflow using the CData JDBC Driver.
Access Live Acumatica in Coginiti Pro

Connect to and query live Acumatica ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.
Validate Zendesk with QuerySurge

Access and validate Zendesk in QuerySurge using the CData JDBC Driver.
How to import Microsoft Planner into Apache Solr

Use the CData Software JDBC Driver for Microsoft Planner in Data Import Handler and create an automated import of Microsoft Planner to Apache Solr Enterprise Search platform.
Access Live QuickBooks in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for QuickBooks to create a QuickBooks Desktop source in TIBCO Data Virtualization Studio and gain access to live QuickBooks Desktop from your TDV Server.
Visualize Live MongoDB in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live MongoDB into custom reports in Power BI.
Connect to Outreach.io in DBeaver

Use the CData ODBC Driver to connect to Outreach.io in DBeaver.
Visualize Certinia in TIBCO Spotfire through ADO.NET

Integrate Certinia into dashboards in TIBCO Spotfire.
Visualize Dropbox in Tableau Desktop (through CData Connect)

Create a virtual SQL Server database for Dropbox in CData Software Connect (or Connect Server) and build visualizations from live Dropbox in Tableau Desktop.
Automated Continuous SAP Ariba Procurement Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Apache Kafka.
Automated Continuous SAP Netweaver Gateway Replication to Vertica

Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Vertica.
Use the CData ODBC Driver for Sugar CRM in Microsoft Power Query

You can use the CData Sugar CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sugar CRM into Microsoft Power Query.
Automated Continuous Blackbaud FE NXT Replication to MongoDB

Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to MongoDB.
Automated Continuous Basecamp Replication to Oracle

Use CData Sync for automated, continuous, customizable Basecamp replication to Oracle.
How to update Exact Online from Excel

This article explains how to transfer data from Excel to Exact Online using the Excel Add-In for Exact Online.
Create a Data Access Object for Google Data Catalog using JDBI

A brief overview of creating a SQL Object API for Google Data Catalog in JDBI.
How to Query Live SuiteCRM Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live SuiteCRM data in natural language using Python.
Build AI/ML Models with Live SAP SuccessFactors Data using Dataiku