CData Software - Knowledge Base
Recent Articles
-
How to Connect QuickBooks Online Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live QuickBooks Online data in real time using natural language.
-
Build an OLAP Cube in SSAS from SAP Ariba Procurement Data
Establish a connection to SAP Ariba Procurement data from SQL Server Analysis Services, and use the SAP Ariba Procurement Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Cline with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Quickbase from within your IDE.
-
Connecting Mastra with SAS xpt 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 SAS XPORT, no replication required.
-
CData Drivers Now Support UI URL Capture for Seamless SaaS Navigation: Asana, HubSpot, Jira, and more
Jump seamlessly to the SaaS interface using the URL from your BI tools or applications like Power BI
-
Visualize Zoho Books Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zoho Books into TIBCO Spotfire.
-
How to create an RPA flow for Webex Data in UiPath Studio
Use the Webex ODBC Driver to create workflows that access real-time Webex without any coding.
-
Connect to and Visualize Live Shippo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shippo.
-
Connect to Sage Intacct Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sage Intacct from Crystal Reports.
-
How to Easily Query AlloyDB Data in OpenOffice Base
Connect to AlloyDB data in OpenOffice Base using the CData ODBC Driver for AlloyDB and generate reports with live data insights.
-
Automate Google Contacts Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Contacts from PowerShell? This article demonstrates how to utilize the Google Contacts Cmdlets for tasks like connecting to Google Contacts, automating operations, downloading data, and more.
-
Splunk Reporting in OBIEE with the Splunk JDBC Driver
Deploy the Splunk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Migrating data from Microsoft Dataverse to Google BigQuery using CData SSIS Components.
Easily push Microsoft Dataverse (CDS) to Google BigQuery using the CData SSIS Tasks for Microsoft Dataverse and Google BigQuery.
-
Bridge Short.io Connectivity with Apache NiFi
Access and process Short.io in Apache NiFi using the CData JDBC Driver.
-
Connect Clio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Clio with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Basecamp Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Basecamp for you.
-
Build Templated-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Templated.
-
Using the CData Software ODBC Driver for Anaplan in PyCharm
Connect to Anaplan as an ODBC data source in PyCharm using the CData Software ODBC Driver for Anaplan.
-
Integrating Perigon Data in Talend Cloud Data Management Platform
Connect Perigon Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to LDAP Objects in CloverDX (formerly CloverETL)
Transfer LDAP using the visual workflow in the CloverDX data integration tool.
-
Replicate Multiple SpaceX Accounts
Replicate multiple SpaceX accounts to one or many databases.
-
Use the CData Software JDBC Driver for Tavily in MicroStrategy Desktop
Connect to Tavily in MicroStrategy Desktop using the CData Software JDBC Driver for Tavily.
-
Build Semantic Layer Views for SparkPost Data in APOS Live Data Gateway
Use the CData Connector for SparkPost in APOS Live Data Gateway to build Semantic Layer Views for SparkPost.
-
Migrating data from Templated to Snowflake using CData SSIS Components.
Easily push Templated to Snowflake using the CData SSIS Tasks for Templated and Snowflake.
-
Connect to Acumatica Data in DBeaver
Use the CData ODBC Driver to connect to Acumatica ERP in DBeaver.
-
Bridge PDFMonkey Connectivity with Apache NiFi
Access and process PDFMonkey in Apache NiFi using the CData JDBC Driver.
-
Access Square Data from MySQL in PHP
Connect to Square through the standard MySQL libraries in PHP.
-
How to Easily Query Intercom Data in OpenOffice Base
Connect to Intercom data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
A PostgreSQL Interface for SQL Server Data (MySQL Remoting via JDBC)
Use the Remoting features of the SQL Server JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live MongoDB Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your MongoDB for you.
-
Use the CData Software ODBC Driver for Azure Table in MicroStrategy Web
Connect to Azure Table Storage in MicroStrategy Web using the CData Software ODBC Driver for Azure Table.
-
Connecting Pipedream with Stripe Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Stripe data in real time.
-
Integrate with Live CSV Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to CSV from the MuleSoft Anypoint Platform to integrate live CSV/TSV Files into custom reports and dashboards.
-
Query MarkLogic Data as a SQL Server Database in Node.js
Execute SQL Server queries against MarkLogic from Node.js.
-
Create Dynamic SAP HANA XS Advanced Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP HANA XS Advanced to Infragistics XamDataGrid to build dynamic grids.
-
Create Dynamic Attio Grids Using the Infragistics XamDataGrid
Learn how you can connect Attio to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Google Sheets Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Sheets data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Dashboards with Teamgate Data in DBxtra
Create dynamic dashboards and perform analytics based on Teamgate in DBxtra.
-
Integrate with REST Data in JReport Designer
Create charts and reports based on REST in JReport Designer.
-
Access Clio Data from MySQL in Amazon QuickSight
Connect to Clio and build visualizations of Clio using a MySQL Connection in Amazon QuickSight.
-
Connect to Salesforce Data 360 Data in Aqua Data Studio
Access Salesforce Data 360 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Prepare, Blend, and Analyze Google Directory Data in Alteryx Designer (ODBC)
Build workflows to access live Google Directory for self-service data analytics.
-
Visualize Live Zendesk Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zendesk into custom reports in Power BI.
-
Automated Autopilot Data Replication to Teradata
Use CData Sync to Customize and automate Autopilot replication to Teradata.
-
Viewing Postmark Data in RAD Studio Data Explorer
How to view Postmark in RAD Studio Data Explorer using the CData ODBC Driver for Postmark.
-
Build Charts with Vault CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Veeva Vault & Vault CRM in Clear Analytics.
-
Getting Started with the CData SSIS Components for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PhantomBuster.
-
Explore Geographical Relationships in SAP Netweaver Gateway Data with Power Map
Create data visualizations with SAP Netweaver Gateway in Power Map.
-
Process & Analyze Billsby Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Billsby Data.
-
How to Visualize EmailOctopus Data in Python with pandas
Use pandas and other modules to analyze and visualize live EmailOctopus in Python.
-
Integrating Boomi Agentstudio with GitHub Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to GitHub, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to & Open SQL Server Data in Microsoft Excel
This article uses the CData ODBC driver for SQL Server to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Drift Data in Aqua Data Studio
Access Drift from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ADP
Provide connectivity to ADP through an SAP BusinessObjects universe.
-
Connect to Microsoft Exchange Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Exchange in DBeaver.
-
Natively Connect to Keap Data in PHP
The CData ODBC driver for Keap enables you to create PHP applications with connectivity to Keap. Leverage the native support for ODBC in PHP.
-
Build Dashboards with Perplexity Data in DBxtra
Create dynamic dashboards and perform analytics based on Perplexity in DBxtra.
-
Object-Relational Mapping (ORM) with Google Ads 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 Google Ads into a Java-based ORM framework, Hibernate.
-
DataBind Charts to Jumpseller Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Jumpseller 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.
-
Connect to BambooHR Data in ACL Analytics
Connect to BambooHR via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to BambooHR.
-
Connect to Microsoft Exchange Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Exchange using standard SQL.
-
Replicate Coda Data from PowerShell
Write a quick PowerShell script to query Coda. Use connectivity to the live data to replicate Coda to SQL Server.
-
Use the CData Software ODBC Driver for Supabase in MicroStrategy Web
Connect to Supabase in MicroStrategy Web using the CData Software ODBC Driver for Supabase.
-
How to Query Live Bitly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bitly data in natural language using Python.
-
Use Biml to Build SSIS Tasks to Replicate Pipeline CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pipeline CRM to SQL Server.
-
Model, Search, and Visualize Live Amazon S3 Data in ThoughtSpot
Use CData Connect AI to connect to live Amazon S3 for modeling, searching, and visualizing.
-
Using the CData Software ODBC Driver for Spotify in PyCharm
Connect to Spotify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Spotify.
-
Analyze FTP Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of FTP Servers and visualize live FTP Servers in Infragistics Reveal.
-
Access Coinbase Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Coinbase.
-
Create a Data Access Object for Google Spanner Data using JDBI
A brief overview of creating a SQL Object API for Google Spanner in JDBI.
-
Analyze Xero Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Xero Accounting and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Rapidly Develop Simplesat-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Simplesat.
-
Moving Data from Parallel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Parallel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Feed Rootly Data into FineReport
How to set Rootly as a JDBC data source in FineReport.
-
Access Live Facebook Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Facebook from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live QuickBooks Time Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Time data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software JDBC Driver for Pipeline CRM in MicroStrategy
Connect to Pipeline CRM in MicroStrategy Developer using the CData Software JDBC Driver for Pipeline CRM.
-
Access WordPress Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live WordPress from HeidiSQL.
-
Connect to and Visualize Live Cassandra Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Cassandra.
-
Query Superchat Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Superchat from Node.js.
-
How to Design DB2 Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to DB2 from mobile and tablet Power Apps.
-
Stream Omnisend Data into Apache Kafka Topics
Access and stream Omnisend in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use JayDeBeApi to access Asana Data in Python
Use standard Python scripting and the development environment of your choice to access live Asana.
-
Access Live Productboard Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Productboard in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Theia IDE with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build AfterShip-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to AfterShip and build web apps with connectivity to live AfterShip.
-
Replicate Multiple Freshsales Accounts via the CData Sync CLI
Replicate multiple Freshsales accounts to one or many databases.
-
Connect to and Visualize Live Webflow Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Webflow.
-
Migrating data from Oracle to Snowflake using CData SSIS Components.
Easily push Oracle Database to Snowflake using the CData SSIS Tasks for Oracle and Snowflake.
-
Connect to SAP HANA Data from a Connection Pool in Jetty
The SAP HANA JDBC Driver supports connection pooling: This article shows how to connect faster to SAP HANA from Web apps in Jetty.
-
Publish Zoho Recruit-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Recruit.
-
Automated Continuous Pipeline CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to SQLite.
-
Connect Oracle to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Azure Data Lake Storage Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure Data Lake Storage Data and connect to Azure Data Lake Storage in Akorbi Digital RunMyProcess.
-
Bidirectional Access to ZohoPeople Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoPeople in Filemaker Pro for Mac or Windows.
-
Prepare, Blend, and Analyze Sentry Data in Alteryx Designer (ODBC)
Build workflows to access live Sentry for self-service data analytics.
-
Integrating Claude Code CLI with Paylocity 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 BigCommerce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live BigCommerce.
-
Publish Crystal Reports on Intercom Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Intercom.
-
Query Certinia Data in ColdFusion
Write standard ColdFusion data access code to connect to Certinia.