CData Software - Knowledge Base
Recent Articles
-
Connect to and Query Box Data in QlikView over ODBC
Create data visualizations with Box in QlikView.
-
How to connect to Amazon Athena Data in DBVisualizer
Integrate Amazon Athena with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Google Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Ads.
-
Build AI/ML Models with Live Tickspot Data using Dataiku
Connect Tickspot Data with Dataiku using the CData API Driver for JDBC.
-
How to Work with DocuSign Data in AWS Glue Jobs Using JDBC
Connect to DocuSign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Exa Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Exa replication to Apache Cassandra.
-
Excel Spreadsheet Automation on Moosend Data with the QUERY Formula
Pull data from Moosend, automate spreadsheets, and more with the QUERY formula.
-
Connect to QuickBooks Time in SpagoBI
Create reports featuring live QuickBooks Time in SpagoBI Studio. Host QuickBooks Time reports on SpagoBI Server.
-
How to Connect the Power BI Service to WooCommerce: Complete Guide
Connect to the CData Software Power BI Connector for WooCommerce from PowerBI.com to provide real-time WooCommerce across the organization.
-
Automate Eventbrite Data Replication to Couchbase
Use CData Sync to Customize and automate Eventbrite replication to Couchbase.
-
DataBind Controls to Vercel Data in C++Builder
DataBind to Vercel in C++Builder with standard components and controls.
-
Connect to Oracle HCM Cloud from Asprova with CData Software ODBC Driver for Oracle HCM Cloud
This article shows how to connect faster to Oracle HCM Cloud data from Asprova.
-
How to connect SharePoint with Planio Data through external lists
Provide Planio to SharePoint users as an external list.
-
How to Seamlessly Import Gumroad Data into IBM SPSS Modeler
Integrate Gumroad data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Datasets from Outreach.io in Domo Workbench and Build Visualizations of Outreach.io Data in Domo
Use the CData Software ODBC Driver for Outreach.io to create datasets from Outreach.io in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Freshservice Data in DBeaver
Use the CData ODBC Driver to connect to Freshservice in DBeaver.
-
Integrate Cline with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live CockroachDB from within your IDE.
-
Access Live Slack Data in Excel 365 Online (Excel for the web)
Connect to Slack from Excel 365 Online (Excel for the web) with CData Connect AI.
-
LINQ to Highrise Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Highrise Data Provider.
-
Build AI/ML Models with Live Zoho Projects Data using Dataiku
Connect Zoho Projects Data with Dataiku using the CData JDBC Driver for Zoho Projects.
-
Consume XML OData Feeds in PowerBuilder
This article demonstrates how to consume XML Files as OData feeds from PowerBuilder using the API Server.
-
How to publish and share Grafana Data dashboards with Tableau Server
The CData ODBC driver for Grafana enables you integrate Grafana into Tableau dashboards.
-
Connect to SAP Business Warehouse Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Business Warehouse from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Business Warehouse.
-
How to Access Live Shippo Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Shippo from the Cline extension in Visual Studio Code.
-
Replicate Copper Data in Heroku for Use in Salesforce Connect
Replicate Copper to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Creating Couchbase-Connected Applications in Unqork
You can use CData Connect AI to feed Couchbase to Unqork and build custom business apps.
-
How to Work with Vault CRM Data in ETL Validator JDBC
Connect to Vault CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to FreshBooks Data from PowerBuilder via ADO.NET
This article demonstrates how to access FreshBooks from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to work with MailerLite Data in Apache Spark using SQL
Access and process MailerLite Data in Apache Spark using the CData Software JDBC Driver.
-
Connect Paymo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Paymo using the CData Python MCP Server.
-
Getting Started with the CData ODBC Driver for Copper
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Copper.
-
How to connect and process Gumroad from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Gumroad.
-
How to Access Salesforce Data 360 Data Using Entity Framework
This article shows how to access Salesforce Data 360 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Informatica Mappings From/To a JDBC Data Source for CouchDB
Create CouchDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Azure AI Foundry to Talk to Your Snowflake Data 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 Snowflake for you.
-
How to connect PolyBase to IBM Informix
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Informix.
-
Bidirectional Access to PayPal Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PayPal in Filemaker Pro for Mac or Windows.
-
Use Microsoft Copilot Studio to talk to your SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Integrating Codex CLI with PivotalTracker via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
DataBind Azure Data Catalog Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure Data Catalog with the DevExpress Windows Forms and Web controls to provide Azure Data Catalog to a chart.
-
Migrating data from Moosend to Google BigQuery using CData SSIS Components.
Easily push Moosend to Google BigQuery using the CData SSIS Tasks for Moosend and Google BigQuery.
-
How to Connect to & Open Stack Exchange Data in Microsoft Excel
This article uses the CData ODBC driver for Stack Exchange to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect the Power BI Service to Hive: Complete Guide
Connect to the CData Software Power BI Connector for Hive from PowerBI.com to provide real-time Apache Hive across the organization.
-
Automated Continuous Adobe Analytics Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to AlloyDB.
-
Connect to Real-Time Azure Table Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure and Dataflow to import and use Azure Table Storage in Power Apps.
-
Publish Reports with Square Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Square.
-
Use JayDeBeApi to access Act CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Act CRM.
-
Easily Integrate with Any RESTful API Using the CData API Driver
Configure the CData API Driver to enable codeless API connectivity between apps and APIs.
-
Access YouTube Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live YouTube Analytics from HeidiSQL.
-
How to Connect DBeaver to Odoo via a JDBC Driver
Manage Odoo ERP with visual tools in DBeaver like the query browser.
-
Integrate with Databricks Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Databricks to a JSON file on disk.
-
Query SQL Server Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SQL Server entities in PHP by modeling them as objects.
-
Connect to ZohoDesk Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoDesk and work with ZohoDesk in your FileMaker applications.
-
Publish Crystal Reports on Tickspot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Tickspot.
-
Integrating LangGraph with Stripe Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Stripe within automated workflows.
-
Integrate SAP Hybris C4C with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Hybris C4C with External Services.
-
Build Dashboards with MessageBird Data in DBxtra
Create dynamic dashboards and perform analytics based on MessageBird in DBxtra.
-
Create Dynamic Customer.io Grids Using the Infragistics XamDataGrid
Learn how you can connect Customer.io to Infragistics XamDataGrid to build dynamic grids.
-
Analyze REST Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze REST with the CData JDBC Driver for REST.
-
Create SSAS Tabular Models from Google Ad Manager Data
How to build a SQL Server Analysis Service Tabular Model from Google Ad Manager using CData drivers.
-
Marketo Reporting in OBIEE with the Marketo JDBC Driver
Deploy the Marketo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Yelp Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Yelp. Leverage the pyodbc module for ODBC in Python.
-
A PostgreSQL Interface for Xero Data (MySQL Remoting via JDBC)
Use the Remoting features of the Xero JDBC Driver to create a PostgreSQL entry-point for data access.
-
Edit and Search External LinkedIn Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of LinkedIn Ads to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create LinkedIn Ads Data objects that you can access from apps and the dashboard.
-
Connect to Shopify Data in NetBeans
Connect to Shopify in NetBeans with the data source configuration wizard.
-
Publish Reports with Sage 300 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage 300.
-
Connecting Mastra with Facebook Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Facebook, no replication required.
-
Integrate Real-Time Access to Spotify in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Spotify in real time.
-
Access Live Google Search Results in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Search from your Excel spreadsheets.
-
Load Google Spanner Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Spanner to a database.
-
Connect to Google Directory Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Directory in Google Apps Script.
-
Access Live Certinia Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Certinia in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Zuora Data in TIBCO Spotfire through OData
Integrate Zuora into dashboards in TIBCO Spotfire.
-
Choosing the Best Method to Connect Pipeline CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pipeline CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect the Power BI Service to ConvertAPI: Complete Guide
Connect to the CData Software Power BI Connector for ConvertAPI from PowerBI.com to provide real-time ConvertAPI across the organization.
-
Excel Spreadsheet Automation on PhantomBuster Data with the QUERY Formula
Pull data from PhantomBuster, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Snapchat Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to OneLake in Microsoft Fabric.
-
Connect to MariaDB Data from PowerBuilder via JDBC
This article demonstrates how to access MariaDB from PowerBuilder using the MariaDB JDBC Driver.
-
DataBind Charts to Freshdesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshdesk 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.
-
Automate Keap Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Keap from PowerShell? This article demonstrates how to utilize the Keap Cmdlets for tasks like connecting to Keap, automating operations, downloading data, and more.
-
How to Create Power BI Visual Reports with Real-Time Amazon Athena Data
Use CData Power BI Connectors to visualize Amazon Athena in Power BI.
-
Analyze Asana Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Asana from Power Pivot. You will use the Table Import Wizard to load Asana. You can visually build the import query or use any SQL supported by the driver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Sage Cloud Accounting actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
DataBind Perplexity Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Perplexity to a chart.
-
How to Import Data from Microsoft Teams into Google Sheets
Import Microsoft Teams into a Google spreadsheet that is automatically refreshed.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Facebook Ads
Provide connectivity to Facebook Ads through an SAP BusinessObjects universe.
-
Visualize Salesforce Data in TIBCO Spotfire through OData
Integrate Salesforce & Force.com into dashboards in TIBCO Spotfire.
-
Build a Singer.io Tap for Paylocity With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Paylocity data using
-
Easily Integrate Retently Data in Lazarus Pascal IDE
Learn how to easily integrate live Retently in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Visualize Gong Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gong in Python.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Excel Online to Power BI dashboards. Simply drag and drop Microsoft Excel Online into data visuals on the Power BI canvas.
-
DataBind Postmark Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Postmark to a chart.
-
How to connect SharePoint with Sage 300 Data through external lists
Provide Sage 300 to SharePoint users as an external list.
-
Bridge ZendeskSell Connectivity with Apache NiFi
Access and process ZendeskSell in Apache NiFi using the CData JDBC Driver.
-
Connect to Microsoft OneDrive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft OneDrive in the Denodo Virtual DataPort Administrator.
-
Import Exact Online Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Exact Online. In this article, you will use the OData format to import Exact Online into Microsoft Power Query.
-
How to connect PolyBase to Couchbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Couchbase.
-
Replicate SingleStore Data from PowerShell
Write a quick PowerShell script to query SingleStore. Use connectivity to the live data to replicate SingleStore to SQL Server.
-
How to Query SendInBlue Data in MySQL Workbench
Execute MySQL queries against live SendInBlue from MySQL Workbench.
-
Automated Continuous Figshare Replication to Vertica
Use CData Sync for automated, continuous, customizable Figshare replication to Vertica.