CData Software - Knowledge Base
Recent Articles
-
Import Azure DevOps into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure DevOps and provide access to live Azure DevOps for custom reports in the Power BI Service.
-
Use JayDeBeApi to access Drift in Python
Use standard Python scripting and the development environment of your choice to access live Drift.
-
Natively Connect to Couchbase in PHP
The CData ODBC driver for Couchbase enables you to create PHP applications with connectivity to Couchbase. Leverage the native support for ODBC in PHP.
-
Integrate with Sage 50 UK in JReport Designer
Create charts and reports based on Sage 50 UK in JReport Designer.
-
Visualize Greenhouse in TIBCO Spotfire through ADO.NET
Integrate Greenhouse into dashboards in TIBCO Spotfire.
-
Consume Oracle HCM Cloud OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle HCM Cloud as OData feeds from PowerBuilder using the API Server.
-
Build a Simple VCL Application for Wave Financial
How to build a simple VCL Application to view Wave Financial in RAD Studio using the CData ODBC Driver for Wave Financial.
-
Integrate Sage Cloud Accounting with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage Cloud Accounting with External Services.
-
Query Asana in DataGrip
Create a Data Source for Asana in DataGrip and use SQL to query live Asana.
-
Create Datasets from Email in Domo Workbench and Build Visualizations of Email in Domo
Use the CData Software ODBC Driver for Email to create datasets from Email in Domo Workbench and then build visualizations in the Domo service.
-
Build Zoho Books Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho Books and build visualizations in Tableau Cloud.
-
Integrate Azure Active Directory into Power Automate Desktop using CData Connect
CData Connect for Azure Active Directory enables you to integrate Azure Active Directory into workflows built using Microsoft Power Automate Desktop.
-
Trigger Redis IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
How to Create Power BI Visual Reports with Real-Time Reckon
Use CData Power BI Connectors to visualize Reckon in Power BI.
-
Use the CData Software JDBC Driver for Shippo in MicroStrategy Desktop
Connect to Shippo in MicroStrategy Desktop using the CData Software JDBC Driver for Shippo.
-
Build LinkedIn Ads Visualizations in Tableau Cloud
Use CData Connect AI to connect to live LinkedIn Ads and build visualizations in Tableau Cloud.
-
Access Live Redshift in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Redshift from your Google Sheets.
-
Automated Continuous Amazon S3 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Amazon S3 replication to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Facebook Ads
Provide connectivity to Facebook Ads through an SAP BusinessObjects universe.
-
Integrate Spark with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Spark with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Spark SQL.
-
Create SSAS Tabular Models from Google Campaign Manager 360
How to build a SQL Server Analysis Service Tabular Model from Google Campaign Manager 360 using CData drivers.
-
Integrate Reckon Accounts Hosted into Automated Tasks with Power Automate
Use CData Connect AI to connect to Reckon Accounts Hosted and integrate live Reckon Accounts Hosted into your Power Automate tasks.
-
Import API into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access API. In this article, you will use the OData format to import API into Microsoft Power Query.
-
Replicate Multiple eBay Accounts via the CData Sync CLI
Replicate multiple eBay accounts to one or many databases.
-
Edit and Search Dynamics CRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Dynamics CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Dynamics CRM objects that you can access from apps and the dashboard.
-
Connect to Salesforce in SpagoBI
Create reports featuring live Salesforce & Force.com in SpagoBI Studio. Host Salesforce reports on SpagoBI Server.
-
How to Create Power BI Visual Reports with Real-Time Bullhorn CRM
Use CData Power BI Connectors to visualize Bullhorn CRM in Power BI.
-
Connect to IBM Cloud Object Storage in Google Apps Script via SQL Gateway
Use the ODBC Driver for IBM Cloud Object Storage and the SQL Gateway to access IBM Cloud Object Storage from Google Apps Script.
-
Connect to Slack 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 Slack.
-
Working with OneNote in LINQPad
Execute LINQ queries to Microsoft OneNote in LINQPad.
-
Connect to Dynamics 365 in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics 365 and the SQL Gateway to access Microsoft Dynamics 365 from Google Apps Script.
-
Connect to Couchbase as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Couchbase.
-
Analyze Todoist in Infragistics Reveal
Use the CData API Server to create an OData API on top of Todoist and visualize live Todoist in Infragistics Reveal.
-
Create Reports with DB2 in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM DB2.
-
Automated Continuous Vertica Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Vertica replication to Microsoft Access.
-
How to Use a Microsoft Access Database to Update Email in Real Time
Update Email data by creating a linked table in Microsoft Access with the CData Email ODBC Driver.
-
Use JayDeBeApi to access Oracle Eloqua Reporting in Python
Use standard Python scripting and the development environment of your choice to access live Oracle Eloqua Reporting.
-
Connect to and Query Shopify in QlikView over ODBC
Create data visualizations with Shopify in QlikView.
-
Extract, Transform, and Load Google Ads in Informatica PowerCenter
Create a simple Workflow for Google Ads in Informatica PowerCenter.
-
Connect to HubSpot 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 HubSpot.
-
Create OData-Connected Dashboards in Grafana
Connect to OData Services via CData Connect AI in Grafana and create custom business dashboards with real-time access to OData.
-
Create Microsoft Exchange-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Exchange from Klipfolio and build custom visualizations using live Microsoft Exchange.
-
How to connect Amazon QuickSight to GitHub
Create a connection to GitHub in CData Connect AI and insert GitHub into Amazon QuickSight SPICE to build interactive dashboards.
-
Bridge Stripe Connectivity with Apache NiFi
Access and process Stripe in Apache NiFi using the CData JDBC Driver.
-
Use ChatGPT to Talk to Your Vault CRM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Veeva Vault & Vault CRM for you.
-
How to work with PayPal in Apache Spark using SQL
Access and process PayPal in Apache Spark using the CData Software JDBC Driver.
-
Connect to Live Cosmos DB in MicroStrategy through CData Connect AI
Create a live connection to Cosmos DB in CData Connect AI and connect to your Azure Cosmos DB from MicroStrategy.
-
Integrate MailChimp in Pentaho Data Integration
Build ETL pipelines based on MailChimp in the Pentaho Data Integration tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Active Directory
Provide connectivity to Active Directory through an SAP BusinessObjects universe.
-
Integrate Cursor with Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sage Business Cloud Accounting from within the editor.
-
Access Gmail from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Gmail from HeidiSQL.
-
Analyze SQL Server in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft SQL Server and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Object-Relational Mapping (ORM) with SAP 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 SAP ERP/NetWeaver into a Java-based ORM framework, Hibernate.
-
Bridge Redshift Connectivity with Apache NiFi
Access and process Amazon Redshift in Apache NiFi using the CData JDBC Driver.
-
Integrate with xBase using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy xBase to a JSON file on disk.
-
Build Twitter Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Twitter Ads.
-
Connect Unbounce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Unbounce with IBM WebSphere for seamless data integration and connectivity.
-
Publish Crystal Reports on QuickBooks Online
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date QuickBooks Online.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Acumatica ERP within intelligent workflows.
-
Access Live Outreach.io Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Outreach.io data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy
Connect to Elasticsearch in MicroStrategy Developer using the CData Software ODBC Driver for Elasticsearch.
-
Creating Amazon DynamoDB-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon DynamoDB to Unqork and build custom business apps.
-
Load HCL Domino to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HCL Domino to a database.
-
Create Power BI Reports on Real-Time SharePoint
Use the CData ODBC Driver for SharePoint to visualize Microsoft SharePoint in Power BI Desktop.
-
Automated Continuous Wave Financial Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Wave Financial replication to Azure SQL Database.
-
Connect to Couchbase in RazorSQL
Connect to Couchbase from wizards and query Couchbase from the GUI in the RazorSQL database management tool.
-
Use JayDeBeApi to access Dynamics 365 Business Central in Python
Use standard Python scripting and the development environment of your choice to access live Dynamics 365 Business Central.
-
Visualize Instagram in TIBCO Spotfire through OData
Integrate Instagram into dashboards in TIBCO Spotfire.
-
Query Office 365 in DataGrip
Create a Data Source for Office 365 in DataGrip and use SQL to query live Microsoft Office 365.
-
Connect to ClickUp in RazorSQL
Connect to ClickUp from wizards and query ClickUp from the GUI in the RazorSQL database management tool.
-
Connect to Pinterest in HULFT Integrate
Connect to Pinterest as a JDBC data source in HULFT Integrate
-
Analyze MailChimp in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MailChimp and visualize live MailChimp in Infragistics Reveal.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy
Connect to Slack in MicroStrategy Developer using the CData Software JDBC Driver for Slack.
-
Getting Started with the CData JDBC Driver for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cosmos DB.
-
Create QuickBooks Online-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to QuickBooks Online from Klipfolio and build custom visualizations using live QuickBooks Online.
-
Create Data Visualizations in Cognos BI with SingleStore
Access SingleStore as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData ODBC Driver for ShipStation
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ShipStation.
-
Integrate Live Workday into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Workday from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Workday.
-
Operational Reporting on Sugar CRM from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sugar CRM.
-
How to Access Live MarkLogic in Visual Studio Code via Cline
Run the CData MCP Server for MarkLogic on Windows Subsytem for Linux (WSL) and connect to live MarkLogic from the Cline extension in Visual Studio Code.
-
Easily Integrate Xero in Lazarus Pascal IDE
Learn how to easily integrate live Xero Accounting in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build a Singer.io Tap for HCL Domino With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HCL Domino data using
-
Query Google Cloud Storage as a MySQL Database in Node.js
Execute MySQL queries against Google Cloud Storage from Node.js.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Connect to Act-On as an External Source in Dremio
Use the CData JDBC Driver to connect to Act-On as an External Source in Dremio.
-
Integrating Dataiku with YouTube Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live YouTube Analytics.
-
Integrate Facebook with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Facebook with External Services.
-
Connect to Aha from PowerBuilder via ADO.NET
This article demonstrates how to access Aha! from Appeon PowerBuilder using the CData ADO.NET Provider for Aha.
-
How to Use a Microsoft Access Database to Update Dynamics NAV in Real Time
Update Dynamics NAV data by creating a linked table in Microsoft Access with the CData Dynamics NAV ODBC Driver.
-
Automate Sage Cloud Accounting Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage Business Cloud Accounting from PowerShell? This article demonstrates how to utilize the Sage Cloud Accounting Cmdlets for tasks like connecting to Sage Business Cloud Accounting, automating operations, downloading data, and more.
-
How to connect to Google Calendar in DBVisualizer
Integrate Google Calendar with visual data analysis tools and data connection wizards in DBVisualizer
-
Easily Integrate Google Cloud Storage in Lazarus Pascal IDE
Learn how to easily integrate live Google Cloud Storage in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live AlloyDB in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google AlloyDB into the statistical analysis tools available in SAS JMP. This article shows how to use Google AlloyDB in the Graph Builder and Query Builder.
-
Connect to eBay Analytics from Asprova with CData Software ODBC Driver for eBay Analytics
This article shows how to connect faster to eBay Analytics data from Asprova.
-
Create Power BI Reports on Real-Time Adobe Target
Use the CData ODBC Driver for Adobe Target to visualize Adobe Target in Power BI Desktop.
-
How to Easily Query Salesforce Data Cloud in OpenOffice Base
-