CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Google Campaign Manager 360 from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Campaign Manager 360.
-
Automated Continuous Procore Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Procore replication to Amazon S3.
-
Build YouTube Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live YouTube Analytics.
-
Extract, Transform, and Load Highrise in Informatica PowerCenter
Create a simple Workflow for Highrise CRM in Informatica PowerCenter.
-
Use Claude to Talk to Your SAP Hybris C4C via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Connect to and Visualize Live Sugar CRM in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sugar CRM.
-
Use Azure AI Foundry to Talk to Your Azure Synapse via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Azure Synapse for you.
-
Build Microsoft Planner-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Planner and create custom apps in Mendix.
-
Manage Zoho Projects in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Projects.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MariaDB
Provide connectivity to MariaDB through an SAP BusinessObjects universe.
-
How to Access Live Reckon in Power Automate Desktop via ODBC
The CData ODBC Driver for Reckon enables you to integrate Reckon into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with Amazon Marketplace in Dundas BI
Create dynamic dashboards and perform analytics based on Amazon Marketplace in Dundas BI.
-
Build Semantic Layer Views for Shopify in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Shopify.
-
How to Query Live Dynamics 365 Business Central Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Dynamics 365 Business Central data in natural language using Python.
-
Enable the Coinbase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Coinbase.
-
Automate Salesloft Replication to Couchbase
Use CData Sync to Customize and automate Salesloft replication to Couchbase.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ADP using the Model Context Protocol.
-
Integrate Salesforce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce & Force.com.
-
How to connect to Highrise from Spring Boot
Connect to Highrise in a Spring Boot Application using CData JDBC Highrise Driver
-
Automate Avalara AvaTax Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Avalara AvaTax from PowerShell? This article demonstrates how to utilize the Avalara AvaTax Cmdlets for tasks like connecting to Avalara AvaTax, automating operations, downloading data, and more.
-
Replicate Azure Data Catalog from PowerShell
Write a quick PowerShell script to query Azure Data Catalog. Use connectivity to the live data to replicate Azure Data Catalog to SQL Server.
-
Connect to Adobe Commerce from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Commerce using standard SQL.
-
Connect to Azure Active Directory from a Connection Pool in Jetty
The Azure Active Directory JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Active Directory from Web apps in Jetty.
-
How to Connect to & Open Confluence in Microsoft Excel
This article uses the CData ODBC driver for Confluence to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Reckon Accounts Hosted in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Reckon Accounts Hosted and connect to Reckon Accounts Hosted in Akorbi Digital RunMyProcess.
-
Creating Dynamics 365 Business Central-Connected Applications in Unqork
You can use CData Connect AI to feed Dynamics 365 Business Central to Unqork and build custom business apps.
-
Bidirectional Access to PingOne from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PingOne in Filemaker Pro for Mac or Windows.
-
How to Connect the Power BI Service to Shippo: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Deploy the ADO.NET Provider for Google Contacts on an SSRS Report Server
Connect to Google Contacts 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 connect PolyBase to SAP Ariba Source
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Ariba Source.
-
Connect Facebook to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Facebook with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Bing Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bing Ads with External Services.
-
Explore Geographical Relationships in Snowflake with Power Map
Create data visualizations with Snowflake in Power Map.
-
Deploy the ADO.NET Provider for Zendesk on an SSRS Report Server
Connect to Zendesk 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.
-
Import Snowflake into the Power BI Service for Visualizations
Use CData Connect AI to connect to Snowflake and provide access to live Snowflake for custom reports in the Power BI Service.
-
Getting Started with the CData Python Connector for SAP Ariba Procurement
Learn to install and license the CData Python Connector
-
Feed Google Data Catalog into FineReport
How to set Google Data Catalog as a JDBC data source in FineReport.
-
Connect Bullhorn CRM to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bullhorn CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Prepare, Blend, and Analyze Adobe Commerce in Alteryx Designer (ODBC)
Build workflows to access live Adobe Commerce for self-service data analytics.
-
Build Visualizations of HBase in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache HBase in Birst.
-
Enable the TigerGraph JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with TigerGraph.
-
Access Tally 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 Tally ERP.
-
Publish Reports with Pipedrive in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipedrive.
-
Automated Continuous Vertica Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Vertica replication to Apache Kafka.
-
Connect to Live Redshift in PostGresSQL Interface through CData Connect AI
Create a live connection to Redshift in CData Connect AI and connect to your Amazon Redshift from PostgreSQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Amazon Marketplace to Power BI dashboards. Simply drag and drop Amazon Marketplace into data visuals on the Power BI canvas.
-
How to publish and share SAP SuccessFactors dashboards with Tableau Server
The CData ODBC driver for SAP SuccessFactors enables you integrate SAP SuccessFactors into Tableau dashboards.
-
Integrate YouTube Analytics in Pentaho Data Integration
Build ETL pipelines based on YouTube Analytics in the Pentaho Data Integration tool.
-
Connect to SAP HANA in CloverDX (formerly CloverETL)
Transfer SAP HANA using the visual workflow in the CloverDX data integration tool.
-
Connect to Oracle Service Cloud in RazorSQL
Connect to Oracle Service Cloud from wizards and query Oracle Service Cloud from the GUI in the RazorSQL database management tool.
-
Build Data Flows from Cosmos DB to SQL Server using SSIS
Easily back up Azure Cosmos DB to SQL Server using the SSIS components for Cosmos DB.
-
Connecting Moonlit Workflow with Sage Cloud Accounting via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Sage Business Cloud Accounting in real time.
-
Rapidly Develop Odoo-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 a Data Access Object for Facebook using JDBI
A brief overview of creating a SQL Object API for Facebook in JDBI.
-
Connect to Google Calendar as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Calendar.
-
Configure the CData JDBC Driver for Google Ad Manager in a Connection Pool in Tomcat
Connect to Google Ad Manager from a connection pool in Tomcat.
-
How to Work with MarkLogic in AWS Glue Jobs Using JDBC
Connect to MarkLogic from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create SAP HANA Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Crystal Reports on Zoho Inventory
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Inventory.
-
Automated Continuous Drip Replication to Databricks
Use CData Sync for automated, continuous, customizable Drip replication to Databricks.
-
Create Reports with Unbounce in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Unbounce.
-
Connect to BigQuery in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google BigQuery in the Denodo Virtual DataPort Administrator.
-
Connect to Jira Service Management in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Atlassian Jira Service Management in Airbyte.
-
Model Dynamics 365 Business Central Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365 Business Central, enabling the direct import of real-time Dynamics 365 Business Central.
-
How to Connect to Live SingleStore in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SingleStore for you.
-
How to update WooCommerce from Excel
This article explains how to transfer data from Excel to WooCommerce using the Excel Add-In for WooCommerce.
-
Analyze NetSuite in Looker
Use CData Connect AI to connect to NetSuite from Looker and build custom apps using live NetSuite CRM & ERP.
-
Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy Desktop
Connect to SharePoint Excel Services in MicroStrategy Desktop using the CData Software JDBC Driver for SharePoint Excel Services.
-
How to connect SharePoint with Zendesk through external lists
Provide Zendesk to SharePoint users as an external list.
-
DataBind Charts to ConstantContact
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ConstantContact from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Getting Started with the CData JDBC Driver for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP HANA XS Advanced.
-
Analyze ClickUp in R via JDBC
Use standard R functions and the development environment of your choice to analyze ClickUp with the CData JDBC Driver for ClickUp.
-
Build AI Agents with SAP Ariba Procurement Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Replicate Airtable to Multiple Databases via the CData Sync CLI
Replicate Airtable to disparate databases with a single configuration.
-
Access SQL Analysis Services as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SQL Analysis Services from your Oracle system.
-
Natively Connect to Adobe Commerce in PHP
The CData ODBC driver for Adobe Commerce enables you to create PHP applications with connectivity to Adobe Commerce. Leverage the native support for ODBC in PHP.
-
Replicate Kintone in Heroku for Use in Salesforce Connect
Replicate Kintone to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Automated Workflows with Live Sage Intacct in Workato
Use CData Connect AI to connect to live Sage Intacct and build automated workflows in Workato.
-
Connect to Avro in Ruby
Connect to Apache Avro in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Dashboards with Adobe Target in DBxtra
Create dynamic dashboards and perform analytics based on Adobe Target in DBxtra.
-
Connect to CockroachDB from Asprova with CData Software ODBC Driver for CockroachDB
This article shows how to connect faster to CockroachDB data from Asprova.
-
Analyze HDFS in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache HDFS in Microsoft R Open.
-
Integrate Cursor with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Synapse from within the editor.
-
Automated Continuous Exact Online Replication to Oracle
Use CData Sync for automated, continuous, customizable Exact Online replication to Oracle.
-
How to Query Live Marketo in Claude Desktop
Connect to and query live Marketo in Claude Desktop using the CData MCP Server.
-
Migrating data from ClickUp to Snowflake using CData SSIS Components.
Easily push ClickUp to Snowflake using the CData SSIS Tasks for ClickUp and Snowflake.
-
Access Jira Assets from MySQL in PHP
Connect to Jira Assets through the standard MySQL libraries in PHP.
-
Connect to Marketo from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Marketo to connect to Marketo and execute queries in PowerBuilder.
-
Build Spark-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Spark SQL and build web apps with connectivity to live Apache Spark SQL.
-
How to Easily Query Vault CRM in OpenOffice Base
-