CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Google Drive in MicroStrategy Web
Connect to Google Drive in MicroStrategy Web using the CData Software ODBC Driver for Google Drive.
-
Build Automated SAP HANA-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP HANA and build automated workflows in Zapier.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for JotForm
Provide connectivity to JotForm through an SAP BusinessObjects universe.
-
Manage Avro in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Avro.
-
Query SharePoint Excel Services through ODBC in Node.js
Use node-odbc to execute SQL queries against SharePoint Excel Services from Node.js.
-
Integrating Boomi Agentstudio with Marketo via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Marketo, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Access Live Sage 300 in Visual Studio Code via Cline
Run the CData MCP Server for Sage 300 on Windows Subsytem for Linux (WSL) and connect to live Sage 300 from the Cline extension in Visual Studio Code.
-
Connect to LinkedIn Ads in Aqua Data Studio
Access LinkedIn Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
ETL Sage 50 UK in Oracle Data Integrator
This article shows how to transfer Sage 50 UK into a data warehouse using Oracle Data Integrator.
-
Access Live SAP Concur in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Concur from your Excel spreadsheets.
-
Access SAP HANA from MySQL in Amazon QuickSight
Connect to SAP HANA and build visualizations of SAP HANA using a MySQL Connection in Amazon QuickSight.
-
Establish a Live Connection with YouTube Analytics using Tableau Bridge
The CData ODBC Driver for YouTube Analytics enables you to integrate live YouTube Analytics into Tableau Cloud dashboards using the Tableau Bridge.
-
Extend Google Sheets with Jira Service Management
Make calls to the API Server from Google Apps Script.
-
How to Connect to Live Jira Service Management from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Atlassian Jira Service Management through natural language.
-
Extend Google Sheets with Pipedrive
Make calls to the API Server from Google Apps Script.
-
How to Connect the Power BI Service to Bing Ads: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Analyze Google Ads in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Ads and visualize live Google Ads in Infragistics Reveal.
-
Create Power BI Reports on Real-Time LinkedIn Ads
Use the CData ODBC Driver for LinkedIn Ads to visualize LinkedIn Ads in Power BI Desktop.
-
Rapidly Develop Instagram-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.
-
Use Azure AI Foundry to Talk to Your SAP HANA 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 SAP HANA for you.
-
Connect to Raisers Edge NXT in JRuby
Create a simple JRuby app with access to live Raisers Edge NXT.
-
Automated Continuous Google Spanner Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Spanner replication to SQLite.
-
Configure the CData JDBC Driver for HubDB in a Connection Pool in Tomcat
Connect to HubDB from a connection pool in Tomcat.
-
Integrate Azure Analysis Services into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Analysis Services and integrate live Azure Analysis Services into your Power Automate tasks.
-
Connect to Impala from PowerBuilder via JDBC
This article demonstrates how to access Apache Impala from PowerBuilder using the Impala JDBC Driver.
-
How to Connect to Live MailChimp 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 MailChimp for you.
-
Automated Continuous AlloyDB Replication to Vertica
Use CData Sync for automated, continuous, customizable AlloyDB replication to Vertica.
-
Automate Azure DevOps Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure DevOps from PowerShell? This article demonstrates how to utilize the Azure DevOps Cmdlets for tasks like connecting to Azure DevOps, automating operations, downloading data, and more.
-
Integrating Dataiku with Jira Service Management via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Atlassian Jira Service Management.
-
Validate Workday with QuerySurge
Access and validate Workday in QuerySurge using the CData JDBC Driver.
-
Migrating data from QuickBooks Time to Google BigQuery using CData SSIS Components.
Easily push QuickBooks Time to Google BigQuery using the CData SSIS Tasks for QuickBooks Time and Google BigQuery.
-
How to publish and share Invoiced dashboards with Tableau Server
The CData ODBC driver for Invoiced enables you integrate Invoiced into Tableau dashboards.
-
Getting Started with the CData Python Connector for SendGrid
Learn to install and license the CData Python Connector
-
Integrate Real-Time Access to Act CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Act CRM in real time.
-
How to connect to CockroachDB in DBVisualizer
Integrate CockroachDB with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect and process Amazon Redshift from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon Redshift.
-
Connect to Facebook Ads from Crystal Reports
Use CData Connect AI to connect to and report on live Facebook Ads from Crystal Reports.
-
Connect Google Drive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Drive using the CData Python MCP Server.
-
Visualize Live Snowflake in the Power BI Service
Use CData Connect AI to connect to live Snowflake and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create Visio diagrams from Odoo
Automatically update Odoo ERP with the changes you make to Visio master shapes.
-
Analyze Twilio in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Twilio and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Write a Simple Go Application to work with QuickBooks Time on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to QuickBooks Time.
-
Replicate Wave Financial to Multiple Databases via the CData Sync CLI
Replicate Wave Financial to disparate databases with a single configuration.
-
Query Basecamp from Node.js
Use the OData endpoint of the CData API Server to connect to your Basecamp and perform CRUD operations on Basecamp from Node.js.
-
Create Data Visualizations Based On Raisers Edge NXT in Mode
Use CData Connect AI to connect to Raisers Edge NXT from Mode and build visualizations using live
-
Access Live Hive in Coginiti Pro
Connect to and query live Apache Hive from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to MailChimp from a Connection Pool in JBoss
Integrate MailChimp into Java servlets: Use the Management Console in JBoss to install the MailChimp JDBC Driver.
-
Analyze Jira Service Management in Looker
Use CData Connect AI to connect to Jira Service Management from Looker and build custom apps using live Atlassian Jira Service Management.
-
Build Dynamics 365 Business Central-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Dynamics 365 Business Central and build Dynamics 365 Business Central-connected web apps with Axios.
-
Connect to Live Dynamics CRM in PostGresSQL Interface through CData Connect AI
Create a live connection to Dynamics CRM in CData Connect AI and connect to your Microsoft Dynamics CRM from PostgreSQL.
-
Query HarperDB in DataGrip
Create a Data Source for HarperDB in DataGrip and use SQL to query live HarperDB.
-
Create SSAS Tabular Models from Unbounce
How to build a SQL Server Analysis Service Tabular Model from Unbounce using CData drivers.
-
Import Real-Time LinkedIn Ads via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LinkedIn Ads in ColdFusion.
-
Create Power BI XMLA-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Power BI XMLA from Klipfolio and build custom visualizations using live Power BI XMLA.
-
Create Data Visualizations in Cognos BI with Azure Data Lake Storage
Access Azure Data Lake Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use CData Connect AI to Access Active Directory in Microsoft Power Pivot
Use CData Connect AI to connect to live Active Directory in the Power Pivot business intelligence tool.
-
Connect QuickBooks Online to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your QuickBooks Online using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Quickbase in NetBeans
Connect to Quickbase in NetBeans with the data source configuration wizard.
-
How to connect to SAP Ariba Procurement with Squirrel SQL client
Connect to SAP Ariba Procurement and execute queries in the Squirrel SQL Client.
-
Build Amazon S3 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Amazon S3 and build visualizations in Tableau.
-
Connect to Zendesk in Jaspersoft Studio
Execute SQL to remote Zendesk in Jaspersoft Studio.
-
Connect to Amazon Athena from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon Athena from Crystal Reports.
-
Connect to Dynamics 365 from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dynamics 365 from HeidiSQL.
-
Import Real-Time Zoho Books via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Books in ColdFusion.
-
How to connect to Phoenix from IntelliJ
Integrate connectivity to Apache Phoenix with wizards in IntelliJ.
-
Connect to Salesforce Pardot in ACL Analytics
Connect to Salesforce Pardot via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce Pardot.
-
Connect to Cloudant in the Denodo Platform
Use CData driver technologies to create a virtual data source for IBM Cloudant in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Oracle Eloqua Reporting from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua Reporting to connect to Oracle Eloqua Reporting from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Eloqua Reporting in Excel.
-
Integrating Sybase IQ in Talend Cloud Data Management Platform
-