CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with NetSuite Data in DBxtra
Create dynamic dashboards and perform analytics based on NetSuite CRM & ERP in DBxtra.
-
Connect to Webflow Data from PowerBuilder via JDBC
This article demonstrates how to access Webflow from PowerBuilder using the Webflow JDBC Driver.
-
Connect to Snowflake Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Snowflake.
-
Visualize Webflow Data in TIBCO Spotfire through ADO.NET
Integrate Webflow into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot CLI with Paddle 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.
-
Use the CData SSIS Components to Insert New or Update Existing Marketo Records from SQL Server
Easily push SQL Server data to Marketo using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Marketo or update existing records with data from a SQL Server database.
-
Use the CData Software JDBC Driver for Chargebee in MicroStrategy Desktop
Connect to Chargebee in MicroStrategy Desktop using the CData Software JDBC Driver for Chargebee.
-
Extract, Transform, and Load Blackbaud FE NXT Data in Informatica PowerCenter
Create a simple Workflow for Blackbaud FE NXT in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for CircleCI in MicroStrategy
Connect to CircleCI in MicroStrategy Developer using the CData Software JDBC Driver for CircleCI.
-
Analyze Amazon Athena Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Amazon Athena from Power Pivot. You will use the Table Import Wizard to load Amazon Athena. You can visually build the import query or use any SQL supported by the driver.
-
Connect SharePoint Excel Services Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SharePoint Excel Services using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Create a Linked Server in AWS RDS for SQL Server
Learn how to create and use linked servers with AWS RDS for SQL Server, including limitations, stored procedure setup, and query examples.
-
Automated Continuous Jira Assets Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Jira Assets replication to PostgreSQL.
-
Connect to SAP Netweaver Gateway Data from a Connection Pool in JBoss
Integrate SAP Netweaver Gateway into Java servlets: Use the Management Console in JBoss to install the SAP Netweaver Gateway JDBC Driver.
-
Connect to Paymo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Paymo as an External Source in Dremio.
-
Query Live Apollo Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Apollo directly from the development environment.
-
Build CouchDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache CouchDB.
-
Getting Started with the CData ADO.NET Provider for Exact Online
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Exact Online.
-
Wistia Reporting in OBIEE with the Wistia JDBC Driver
Deploy the Wistia JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Greenplum Data into Power Automate Desktop using CData Connect
CData Connect for Greenplum Data enables you to integrate Pivotal GreenPlum into workflows built using Microsoft Power Automate Desktop.
-
Query Azure Table Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Table entities in PHP by modeling them as objects.
-
Use Dash to Build to Web Apps on Google Tasks Data
Create Python applications that use pandas and Dash to build Google Tasks-connected web apps.
-
Analyze Ontraport Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Ontraport from Power Pivot. You will use the Table Import Wizard to load Ontraport. You can visually build the import query or use any SQL supported by the driver.
-
Create SSAS Tabular Models from Gong Data
How to build a SQL Server Analysis Service Tabular Model from Gong using CData drivers.
-
Use the CData Software JDBC Driver for SendGrid in MicroStrategy Web
Connect to SendGrid in MicroStrategy Web using the CData Software JDBC Driver for SendGrid.
-
Build Exact Online-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Exact Online.
-
Connect to Acumatica from Asprova with CData Software ODBC Driver for Acumatica
This article shows how to connect faster to Acumatica data from Asprova.
-
Integrating Cursor CLI with Adobe Commerce Data 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.
-
Visualize Copper Data in Sisense
Create an ElastiCube in Sisense app with access to Copper.
-
Connect to Klaviyo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Klaviyo in Google Apps Script.
-
How to load Bugsnag data into Elasticsearch via Logstash
Introducing a simple method to load Bugsnag data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to create an RPA flow for iContact Data in UiPath Studio
Use the iContact ODBC Driver to create workflows that access real-time iContact without any coding.
-
How to use SQLAlchemy ORM to access Lakebase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Lakebase.
-
Design BIRT Reports on Testmonitor Data
Provide current Testmonitor to your embedded analytics.
-
Create HDFS Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HDFS from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate MySQL Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MySQL from Informatica Cloud.
-
Build Databricks-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Databricks.
-
How to Seamlessly Import Zendesk Data into IBM SPSS Modeler
Integrate Zendesk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Biml to Build SSIS Tasks to Replicate Excel Online Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Excel Online to SQL Server.
-
Integrating GitHub Copilot CLI with Facebook Ads 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 Controls to Perigon Data in C++Builder
DataBind to Perigon in C++Builder with standard components and controls.
-
Integrate Oracle Sales Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Sales Data enables you to integrate Oracle Sales into workflows built using Microsoft Power Automate Desktop.
-
Build HBase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apache HBase and build visualizations in Tableau.
-
Access Live ChartMogul Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ChartMogul in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live Mouseflow Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mouseflow using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Box Data to Multiple Databases
Replicate Box to disparate databases with a point-and-click configuration.
-
Integrating Impala Data in Talend Cloud Data Management Platform
Connect Impala Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Impala.
-
How to Work with PostgreSQL Data in AWS Glue Jobs Using JDBC
Connect to PostgreSQL from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating OpenCode Terminal with Miro Data 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.
-
Import and Visualize Microsoft Teams Data in Power View
Create data visualizations based on Microsoft Teams in Excel.
-
Connect to Azure Analysis Services Data from AWS Glue
Use CData Connect AI to gain access to live Azure Analysis Services from your AWS Glue jobs.
-
Create Informatica Mappings From/To a JDBC Data Source for Suadeo
Create Suadeo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Create Power BI Visual Reports with Real-Time IBM Cloud Object Storage Data
Use CData Power BI Connectors to visualize IBM Cloud Object Storage in Power BI.
-
Build a Singer.io Tap for Moosend With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Moosend data using
-
How to create an RPA flow for PolarTeamPro Data in UiPath Studio
Use the PolarTeamPro ODBC Driver to create workflows that access real-time PolarTeamPro without any coding.
-
Build BigQuery-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for BigQuery Data and create custom apps in Mendix.
-
View Reports on Real-Time PayPal Data in Power BI Report Server
Use the CData ODBC Driver for PayPal to visualize PayPal in Power BI Desktop and then publish them to Power BI Report Server.
-
Moving Data from Spark to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Spark data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Antigravity CLI with SAP Netweaver Gateway via CData CLI
Connect SAP Netweaver Gateway to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Python Connector for Box
Learn to install and license the CData Python Connector
-
Integrating Kiro CLI with Zendesk Data 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.
-
Validate Oracle Eloqua Reporting Data with QuerySurge
Access and validate Oracle Eloqua Reporting in QuerySurge using the CData JDBC Driver.
-
Create Dashboards and Visualize Live QuickBooks Time Data in Geckoboard
Use CData Connect AI to connect to live QuickBooks Time and create dashboards for real-time monitoring and visualization in Geckoboard.
-
LINQ to Dropbox 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 Dropbox Data Provider.
-
Use the CData Software JDBC Driver for Paylocity in MicroStrategy Web
Connect to Paylocity in MicroStrategy Web using the CData Software JDBC Driver for Paylocity.
-
Connect to JotForm Data from PowerBuilder via JDBC
This article demonstrates how to access JotForm from PowerBuilder using the JotForm JDBC Driver.
-
How to connect SharePoint with WooCommerce Data through external lists
Provide WooCommerce to SharePoint users as an external list.
-
Visualize Google Ad Manager Data in TIBCO Spotfire through ADO.NET
Integrate Google Ad Manager into dashboards in TIBCO Spotfire.
-
Connect to HCL Domino Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HCL Domino and the SQL Gateway to access HCL Domino from Google Apps Script.
-
Visualize Live Microsoft Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Ads.
-
Explore Geographical Relationships in ZohoMarketingHub Data with Power Map
Create data visualizations with ZohoMarketingHub in Power Map.
-
How to connect to FHIR Data from Spring Boot
Connect to FHIR in a Spring Boot Application using the CData JDBC Driver for FHIR
-
Use the CData Software JDBC Driver for Elorus in MicroStrategy Web
Connect to Elorus in MicroStrategy Web using the CData Software JDBC Driver for Elorus.
-
Replicate Pipedrive Data from PowerShell
Write a quick PowerShell script to query Pipedrive. Use connectivity to the live data to replicate Pipedrive to SQL Server.
-
MariaDB Reporting in OBIEE with the MariaDB JDBC Driver
Deploy the MariaDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Square-Connected Applications in Appsmith
Connect to Square Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Square.
-
Build Dashboards with Testmonitor Data in DBxtra
Create dynamic dashboards and perform analytics based on Testmonitor in DBxtra.
-
Create Dynamic Telegram Grids Using the Infragistics XamDataGrid
Learn how you can connect Telegram to Infragistics XamDataGrid to build dynamic grids.
-
Viewing Oracle Eloqua Data in RAD Studio Data Explorer
How to view Oracle Eloqua in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Eloqua.
-
Provide OData Services of Spark Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Spark SQL by developing a WCF Service Application.
-
Work with Live Dynamics 365 Data in Power Query
Use CData Connect AI to connect to Microsoft Dynamics 365 and work with live Microsoft Dynamics 365 in Microsoft Power Query.
-
Integrating Kiro CLI with Todoist Data 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.
-
Object-Relational Mapping (ORM) with Azure Table Data 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 Azure Table Storage into a Java-based ORM framework, Hibernate.
-
How to load Customer.io data into Elasticsearch via Logstash
Introducing a simple method to load Customer.io data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Load OneNote Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft OneNote to a database.
-
Access Live ZohoMarketingHub Data in Coginiti Pro
Connect to and query live ZohoMarketingHub from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Excel Spreadsheet Automation on Oracle Eloqua Reporting Data with the QUERY Formula
Pull data from Oracle Eloqua Reporting, automate spreadsheets, and more with the QUERY formula.
-
Import MySQL Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MySQL. In this article, you will use the OData format to import MySQL into Microsoft Power Query.
-
Integrate Discourse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Discourse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Discourse.
-
DataBind Gorgias Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Gorgias to a chart.
-
Automated Continuous Basecamp Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Basecamp replication to delimited files (CSV/TSV).
-
Integrate PolarTeamPro with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PolarTeamPro with External Services.
-
How to connect and process Insightly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Insightly.
-
Integrate Real-Time Access to Dropbox in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Dropbox in real time.
-
Create Reports with CapsuleCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CapsuleCRM.
-
Use the CData Software ODBC Driver for OpenWeatherMap in MicroStrategy Web
Connect to OpenWeatherMap in MicroStrategy Web using the CData Software ODBC Driver for OpenWeatherMap.
-
Visualize Salesforce Marketing Data in TIBCO Spotfire through OData
Integrate Salesforce Marketing Cloud into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for iContact in SAS for Real-Time Reporting and Analytics
Connect to real-time iContact in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for iContact.
-
Create Informatica Mappings From/To a JDBC Data Source for GetResponse
Create GetResponse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Qualaroo Data from MySQL in PHP
Connect to Qualaroo through the standard MySQL libraries in PHP.