CData Software - Knowledge Base
Recent Articles
-
Connect to Attio Data in RazorSQL
Connect to Attio from wizards and query Attio data from the GUI in the RazorSQL database management tool.
-
Access QuickBooks from Aqua Data Studio
Connect to the CData JDBC Driver for QuickBooks through the Aqua Data Studio connection manager.
-
Query Productboard Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Productboard data from Node.js.
-
Use Databricks Agent Bricks to Talk to Your Anaplan Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Anaplan data for you.
-
Connect to Todoist Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Todoist data.
-
Connect to Power BI XMLA Data from a Connection Pool in JBoss
Integrate Power BI XMLA data into Java servlets: Use the Management Console in JBoss to install the Power BI XMLA JDBC Driver.
-
Build a Singer.io Tap for Paymo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Paymo data using the CData Python Connector.
-
Use Dash to Build Web Apps on Exa Data via CData Connect AI
Build interactive Dash web apps on live Exa data using pandas and the CData Connect AI Python SDK.
-
How to Seamlessly Import REST Data into IBM SPSS Modeler
Integrate REST data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to ZohoPeople Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoPeople to connect to ZohoPeople data and execute queries in PowerBuilder.
-
Access Live GitLab Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live GitLab data through MCP integration.
-
Visualize ADP Data in Tableau
The CData ODBC driver for ADP enables you integrate ADP data into Tableau dashboards.
-
Connect to Bugsnag Data in CloverDX (formerly CloverETL)
Transfer Bugsnag data using the visual workflow in the CloverDX data integration tool.
-
Build Charts with Gong Data in Clear Analytics
Create dynamic charts and perform analytics based on Gong data in Clear Analytics.
-
Build Printful-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Printful data.
-
Connect to Retently Data from PowerBuilder via ADO.NET
This article demonstrates how to access Retently data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Box-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Box data without replication.
-
Load Amazon Athena Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Athena data to a database.
-
How to connect to Unbounce Data in DBVisualizer
Integrate Unbounce data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Adobe Target Data with Squirrel SQL client
Connect to Adobe Target data and execute queries in the Squirrel SQL Client.
-
Visualize XML Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to XML data.
-
Import and Visualize Mailjet Data in Power View
Create data visualizations based on Mailjet data in Excel.
-
Prepare, Blend, and Analyze Bitly Data in Alteryx Designer (ODBC)
Build workflows to access live Bitly data for self-service data analytics.
-
Connect to Gong Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Gong Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Datasets from Brex in Domo Workbench and Build Visualizations of Brex Data in Domo
Use the CData Software ODBC Driver for Brex to create datasets from Brex data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Wistia Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Wistia as an External Source in Dremio.
-
Build TaxJar-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for TaxJar Data and create custom apps in Mendix.
-
DataBind Controls to Teamgate Data in Delphi
DataBind to Teamgate data in Delphi with standard data access components and controls.
-
How to Access Live Azure Data Lake Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Data Lake Storage enables you to integrate Azure Data Lake Storage data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Parquet Replication to Snowflake
Use CData Sync for automated, continuous, customizable Parquet replication to Snowflake.
-
Use the CData Software ODBC Driver for Todoist in MicroStrategy
Connect to Todoist data in MicroStrategy Developer using the CData Software ODBC Driver for Todoist.
-
Connect to and Visualize Live Email Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Email data.
-
How to Connect to Google Contacts Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Contacts data. Leverage the pyodbc module for ODBC in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for ZarMoney
Create ZarMoney data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Aha!-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Aha! data.
-
Integrating Dataiku with Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Omnisend data.
-
Connect to Supabase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Supabase data in the Denodo Virtual DataPort Administrator.
-
Migrating data from Bannerbear to Databricks using CData SSIS Components.
Easily push Bannerbear data to Databricks using the CData SSIS Tasks for Bannerbear and Databricks.
-
Integrating PostgreSQL Data in Talend Cloud Data Management Platform
Connect PostgreSQL Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PostgreSQL.
-
Use Grok to Talk to Your Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Databricks data for you.
-
Back Up OnePageCrm data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with OnePageCrm data data.
-
Migrating data from Onfleet to Databricks using CData SSIS Components.
Easily push Onfleet data to Databricks using the CData SSIS Tasks for Onfleet and Databricks.
-
Connect to and Query GitHub Data in QlikView over ODBC
Create data visualizations with GitHub data in QlikView.
-
Integrating Codex with Outlook 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AgileCRM
Provide connectivity to AgileCRM data through an SAP BusinessObjects universe.
-
Connect to Everhour in SpagoBI
Create reports featuring live Everhour data in SpagoBI Studio. Host Everhour reports on SpagoBI Server.
-
Connect to SAP BusinessObjects BI Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP BusinessObjects BI data from Filemaker Pro on Mac.
-
Create MessageBird Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MessageBird data access from reports, embedded analytics, and more.
-
Build Apps with Live Amazon Athena Data Using the Low-Code Development Platform of Mendix
Connect Amazon Athena data with Mendix to build apps using the CData JDBC Driver for Amazon Athena.
-
Configure the CData JDBC Driver for Workday in a Connection Pool in Tomcat
Connect to Workday data from a connection pool in Tomcat.
-
Import Real-Time Parallel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Parallel data in ColdFusion.
-
Analyze Cassandra Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cassandra from Power Pivot. You will use the Table Import Wizard to load Cassandra data. You can visually build the import query or use any SQL supported by the driver.
-
Configure the CData JDBC Driver for Authorize.Net in a Connection Pool in Tomcat
Connect to Authorize.Net data from a connection pool in Tomcat.
-
Build Semantic Layer Views for Tally Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Tally data.
-
Build a PostgreSQL Interface for SQL Analysis Services Data using the CData JDBC Driver
Use the Remoting features of the SQL Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze GitLab Data in Alteryx Designer (ODBC)
Build workflows to access live GitLab data for self-service data analytics.
-
Choosing the Best Method to Connect HBase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use HBase data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with Dotmailer Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dotmailer data.
-
Connect to FTP Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FTP and the SQL Gateway to access FTP data from Google Apps Script.
-
Viewing SAP Ariba Source Data in RAD Studio Data Explorer
How to view SAP Ariba Source data in RAD Studio Data Explorer using the CData ODBC Driver for SAP Ariba Source.
-
Feed Monday.com Data into FineReport
How to set Monday.com data as a JDBC data source in FineReport.
-
Connect to Azure Analysis Services Data in RapidMiner
Integrate Azure Analysis Services data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Campaigner Data in DBVisualizer
Integrate Campaigner data with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Live Twitter Ads Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Twitter Ads data through a conversational interface.
-
Use the CData Software ODBC Driver for BenchmarkEmail in MicroStrategy Desktop
Connect to BenchmarkEmail data in MicroStrategy Desktop using the CData Software ODBC Driver for BenchmarkEmail.
-
Integrate Microsoft OneDrive Data in the Pentaho Report Designer
Publish reports based on Microsoft OneDrive data in the Pentaho BI tool.
-
Automated Continuous Jodoo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jodoo replication to AlloyDB.
-
Object-Relational Mapping (ORM) with Clockify 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 Clockify data into a Java-based ORM framework, Hibernate.
-
Integrating Cursor with Paymo 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.
-
Build Visualizations of Pinterest Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pinterest data in Birst.
-
Build ZohoInvoice-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoInvoice data and build web apps with connectivity to live ZohoInvoice data.
-
How to connect to Pingdom Data in DBVisualizer
Integrate Pingdom data with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Crystal Reports on Hive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Hive data.
-
Connect to Real-Time Redis Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Redis and Dataflow to import and use Redis data in Power Apps.
-
Build Dashboards with Microsoft Exchange Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Exchange data in DBxtra.
-
Analyze Trello Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Trello data and visualize Trello data in SAP Analytics Cloud.
-
Connect to Act-On Data in NetBeans
Connect to Act-On data in NetBeans with the data source configuration wizard.
-
Use Biml to Build SSIS Tasks to Replicate Rootly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Rootly data to SQL Server.
-
Build Dashboards with NetSuite Data in Dundas BI
Create dynamic dashboards and perform analytics based on NetSuite data in Dundas BI.
-
Create Power BI Reports on Real-Time ElevenLabs Data
Use the CData ODBC Driver for ElevenLabs to visualize ElevenLabs data in Power BI Desktop.
-
Connect to Spotify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Spotify.
-
Publish Shippo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Shippo data.
-
Build Semantic Layer Views for Basecamp Data in APOS Live Data Gateway
Use the CData Connector for Basecamp in APOS Live Data Gateway to build Semantic Layer Views for Basecamp data.
-
Connect to SAP Hybris C4C Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Hybris C4C data from Crystal Reports.
-
Operational Reporting on Rootly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Rootly data.
-
How to Connect to Live SAS Data Sets Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAS Data Sets data for you.
-
Use the CData Software ODBC Driver for Paddle in MicroStrategy Web
Connect to Paddle data in MicroStrategy Web using the CData Software ODBC Driver for Paddle.
-
Integrate with EmailOctopus Data in JReport Designer
Create charts and reports based on EmailOctopus data in JReport Designer.
-
How to Connect the Power BI Service to iContact: Complete Guide
Connect to the CData Software Power BI Connector for iContact from PowerBI.com to provide real-time iContact data across the organization.
-
How to Connect to & Open Gorgias Data in Microsoft Excel
This article uses the CData ODBC driver for Gorgias to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Google's Antigravity Agent with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Concur data using the Model Context Protocol.
-
Access EmailOctopus Data from MySQL in Amazon QuickSight
Connect to EmailOctopus and build visualizations of EmailOctopus data using a MySQL Connection in Amazon QuickSight.
-
Use Biml to Build SSIS Tasks to Replicate ElevenLabs Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ElevenLabs data to SQL Server.
-
Connecting Supabase to CData Connect AI
Learn how to connect a Supabase PostgreSQL database to CData Connect AI so your AI tools and agents can query live data using natural language.
-
Connect to Trello Data 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 Trello data.
-
Analyze Gong Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gong data in Microsoft R Open.
-
Integrate Jira with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira with External Services.
-
Automated Continuous API Replication to IBM DB2
Use CData Sync for automated, continuous, customizable API replication to IBM DB2.
-
Build Oracle Eloqua-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Eloqua Data and create custom apps in Mendix.
-
Automated Continuous Klaviyo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Klaviyo replication to Google Cloud SQL.