CData Software - Knowledge Base
Recent Articles
-
Analyze EnterpriseDB in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze EnterpriseDB in Microsoft R Open.
-
Connect to Facebook Ads in Jaspersoft Studio
Execute SQL to remote Facebook Ads in Jaspersoft Studio.
-
Work with Live Snapchat Ads in Power Query
Use CData Connect AI to connect to Snapchat Ads and work with live Snapchat Ads in Microsoft Power Query.
-
Integrating LangChain with OneNote via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft OneNote within automated workflows.
-
How to connect PolyBase to Blackbaud FE NXT
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Blackbaud FE NXT.
-
Build Jira Service Management Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Atlassian Jira Service Management and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for Azure Data Catalog in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Data Catalog in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Data Catalog.
-
Access Live Sage Intacct in Coginiti Pro
Connect to and query live Sage Intacct from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for YouTube Analytics in MicroStrategy
Connect to YouTube Analytics in MicroStrategy Developer using the CData Software ODBC Driver for YouTube Analytics.
-
Query REST in ColdFusion
Write standard ColdFusion data access code to connect to REST.
-
Connect to Google Sheets from Crystal Reports
Use CData Connect AI to connect to and report on live Google Sheets from Crystal Reports.
-
Connect to Jira from PowerBuilder via JDBC
This article demonstrates how to access Atlassian Jira from PowerBuilder using the Jira JDBC Driver.
-
Automated Continuous Oracle Service Cloud Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Oracle.
-
Integrate QuickBooks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Desktop.
-
Build Adobe Commerce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Adobe Commerce.
-
Viewing Act CRM in RAD Studio Data Explorer
How to view Act CRM in RAD Studio Data Explorer using the CData ODBC Driver for Act CRM.
-
Automated Continuous Square Replication to MySQL
Use CData Sync for automated, continuous, customizable Square replication to MySQL.
-
Using the CData Software ODBC Driver for TigerGraph in PyCharm
Connect to TigerGraph as an ODBC data source in PyCharm using the CData Software ODBC Driver for TigerGraph.
-
How to Connect to Live MariaDB 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 MariaDB for you.
-
Visualize Aha from Tableau
Use the Tableau Desktop business intelligence tool to connect to Aha!.
-
Build Asana Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Asana and build visualizations in Tableau Cloud.
-
Create Avalara AvaTax Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Avalara AvaTax data access from reports, embedded analytics, and more.
-
How to connect to MariaDB in DBVisualizer
Integrate MariaDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Use CData Connect AI to Access NetSuite in Microsoft Power Pivot
Use CData Connect AI to connect to live NetSuite CRM & ERP in the Power Pivot business intelligence tool.
-
How to integrate Metabase with Power BI XMLA
Use CData Connect AI to connect to live Power BI XMLA and create an interactive dashboard in Metabase from Power BI XMLA.
-
Use JayDeBeApi to access Square in Python
Use standard Python scripting and the development environment of your choice to access live Square.
-
Create Shopify-Connected Nintex Workflows
Use CData Connect AI to connect to Shopify from Nintex Workflow Cloud and build custom workflows using live Shopify.
-
Integrating Gumloop with QuickBooks Time via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on QuickBooks Time within automated workflows.
-
Connect to Sage 300 as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage 300 as an External Source in Dremio.
-
Create Datasets from Twitter in Domo Workbench and Build Visualizations of Twitter in Domo
Use the CData Software ODBC Driver for Twitter to create datasets from Twitter in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Harvest from PowerBuilder via ADO.NET
This article demonstrates how to access Harvest from Appeon PowerBuilder using the CData ADO.NET Provider for Harvest.
-
Import Zoho Books into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho Books and provide access to live Zoho Books for custom reports in the Power BI Service.
-
Analyze Azure Analysis Services in Infragistics Reveal
Use the CData API Server to create an OData API on top of Azure Analysis Services and visualize live Azure Analysis Services in Infragistics Reveal.
-
How to Query GraphQL in MySQL Workbench
Execute MySQL queries against live GraphQL from MySQL Workbench.
-
How to create an RPA flow for Azure DevOps in UiPath Studio
Use the Azure DevOps ODBC Driver to create workflows that access real-time Azure DevOps without any coding.
-
Object-Relational Mapping (ORM) with Pipedrive 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 Pipedrive into a Java-based ORM framework, Hibernate.
-
Build Tableau CRM Analytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Tableau CRM Analytics and build visualizations in Tableau.
-
Connect to xBase from PowerBuilder via JDBC
This article demonstrates how to access xBase from PowerBuilder using the xBase JDBC Driver.
-
Connect to Salesforce from a Connection Pool in JBoss
Integrate Salesforce & Force.com into Java servlets: Use the Management Console in JBoss to install the Salesforce JDBC Driver.
-
Access Live Microsoft Planner in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Planner in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for YouTube Analytics in Microsoft Power Query
You can use the CData YouTube Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import YouTube Analytics into Microsoft Power Query.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Stripe to Power BI dashboards. Simply drag and drop Stripe into data visuals on the Power BI canvas.
-
How to integrate Metabase with WordPress
Use CData Connect AI to connect to live WordPress and create an interactive dashboard in Metabase from WordPress.
-
Query Pipedrive as a MySQL Database in Node.js
Execute MySQL queries against Pipedrive from Node.js.
-
Write a Simple Go Application to work with Airtable on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Airtable.
-
Publish Reports with OData Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OData.
-
Build Semantic Layer Views for PostgreSQL in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for PostgreSQL.
-
DataBind Charts to Azure Data Catalog
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Data Catalog 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.
-
Connect to WooCommerce in Jaspersoft Studio
Execute SQL to remote WooCommerce in Jaspersoft Studio.
-
Validate Oracle Eloqua with QuerySurge
Access and validate Oracle Eloqua in QuerySurge using the CData JDBC Driver.
-
Connecting Agentforce with Dynamics 365 Business Central via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Dynamics 365 Business Central for you.
-
Visualize Avalara AvaTax in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Avalara AvaTax into TIBCO Spotfire.
-
Working with Exact Online in LINQPad
Execute LINQ queries to Exact Online in LINQPad.
-
Automated Continuous Google Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Ads replication to Azure SQL Database.
-
Connect to Google Cloud Storage in Aqua Data Studio
Access Google Cloud Storage from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Azure Analysis Services in TIBCO Data Virtualization
-