CData Software - Knowledge Base
Recent Articles
-
Integrating Gumloop with Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Directory within automated workflows.
-
Use the CData Software ODBC Driver for Tavily in MicroStrategy
Connect to Tavily in MicroStrategy Developer using the CData Software ODBC Driver for Tavily.
-
Integrating Codex CLI with Grafana 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.
-
Publish Reports with MongoDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MongoDB.
-
Use the CData Software JDBC Driver for Samanage in MicroStrategy
Connect to Samanage in MicroStrategy Developer using the CData Software JDBC Driver for Samanage.
-
Design BIRT Reports on Guru Data
Provide current Guru to your embedded analytics.
-
Connect to Templated Data in Aqua Data Studio
Access Templated from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect and Visualize Live Klaviyo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Klaviyo into the Databricks platform and create visualization dashboards with real-time Klaviyo.
-
Access Live Asana Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Asana data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to connect Amazon QuickSight to Spark Data
Create a connection to Apache Spark SQL in CData Connect AI and insert Apache Spark SQL into Amazon QuickSight SPICE to build interactive dashboards.
-
ETL Shippo in Oracle Data Integrator
This article shows how to transfer Shippo into a data warehouse using Oracle Data Integrator.
-
Integrate VWO Data in the Pentaho Report Designer
Publish reports based on VWO in the Pentaho BI tool.
-
Connect Ontraport to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Ontraport using the CData Python MCP Server.
-
How to connect Amazon QuickSight to Zoho Inventory Data
Create a connection to Zoho Inventory in CData Connect AI and insert Zoho Inventory into Amazon QuickSight SPICE to build interactive dashboards.
-
Choosing the Best Method to Connect Samanage to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Samanage from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Rapidly Develop Wrike-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 Wrike.
-
Connect to SQL Analysis Services in SpagoBI
Create reports featuring live SQL Analysis Services in SpagoBI Studio. Host SQL Analysis Services reports on SpagoBI Server.
-
Query Live Certinia 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 Certinia directly from the development environment.
-
Google Analytics Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Analytics facts in real time.
-
Object-Relational Mapping (ORM) with ADP 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 ADP into a Java-based ORM framework, Hibernate.
-
Connect to BambooHR Data in RazorSQL
Connect to BambooHR from wizards and query BambooHR from the GUI in the RazorSQL database management tool.
-
Integrate Live Vertica Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Vertica and integrate live Vertica into apps built in Microsoft Power Apps.
-
Connect to Real-Time Tickspot Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tickspot in Power Apps.
-
Getting Started with the CData SSIS Components for PingOne
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PingOne.
-
Connect to and Query Timely Data in QlikView over ODBC
Create data visualizations with Timely in QlikView.
-
Automated Continuous Active Directory Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Active Directory replication to Amazon Redshift.
-
How to Visualize Microsoft Entra ID Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Entra ID in Python.
-
Connect to Teamwork Data in Jaspersoft Studio
Execute SQL to remote Teamwork in Jaspersoft Studio.
-
How to import Copper Data into Apache Solr
Use the CData Software JDBC Driver for Copper in Data Import Handler and create an automated import of Copper to Apache Solr Enterprise Search platform.
-
Automate Suadeo Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Suadeo and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Rapidly Develop ZohoDesk-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 ZohoDesk.
-
How to integrate GitHub with Apache Airflow
Access and process GitHub in Apache Airflow using the CData JDBC Driver.
-
Use Dash to Build to Web Apps on Salesforce Pardot Data
Create Python applications that use pandas and Dash to build Salesforce Pardot-connected web apps.
-
Model Epicor Kinetic Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Epicor Kinetic, enabling the direct import of real-time Epicor Kinetic.
-
Automated Continuous CapsuleCRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Google Cloud SQL.
-
Visualize Live Reckon Accounts Hosted Data in the Power BI Service
Use CData Connect AI to connect to live Reckon Accounts Hosted and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Excel Add-In for Jodoo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Jodoo.
-
Provide OData Services of Shippo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Shippo by developing a WCF Service Application.
-
How to Query ZohoExpense Data in MySQL Workbench
Execute MySQL queries against live ZohoExpense from MySQL Workbench.
-
Migrating data from Microsoft OneDrive to Google BigQuery using CData SSIS Components.
Easily push Microsoft OneDrive to Google BigQuery using the CData SSIS Tasks for Microsoft OneDrive and Google BigQuery.
-
Rapidly Develop ShipEngine-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 ShipEngine.
-
LINQ to Google Directory 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 Google Directory Data Provider.
-
Integrating Codex CLI with Keap 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.
-
Seamlessly Bring Stripe Data into Retool Using CData Connect AI
Integrate Stripe data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Freshservice Data from MySQL in PHP
Connect to Freshservice through the standard MySQL libraries in PHP.
-
Use the CData API Server to Access Odoo Data in Microsoft PowerPivot
Use the CData API Server to connect to live Odoo ERP in the Power Pivot business intelligence tool.
-
Connect Google Directory Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Directory using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect Outreach.io to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Outreach.io with IBM WebSphere for seamless data integration and connectivity.
-
Access ZeroBounce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZeroBounce from HeidiSQL.
-
Use ChatGPT to Talk to Your SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP SuccessFactors LMS for you.
-
Integrate Paylocity Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Paylocity and integrate live Paylocity into your Power Automate tasks.
-
Add Google Spanner Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Spanner with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Reports with Templated Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Templated.
-
Use Manus AI to Talk to Your Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sybase.
-
Access Live Cosmos DB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Cosmos DB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Tableau Connector for Highrise
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Highrise.
-
Use the CData Software ODBC Driver for Couchbase in MicroStrategy
Connect to Couchbase in MicroStrategy Developer using the CData Software ODBC Driver for Couchbase.
-
Build an OLAP Cube in SSAS from Avalara AvaTax Data
Establish a connection to Avalara AvaTax data from SQL Server Analysis Services, and use the Avalara AvaTax Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Design Google Spanner Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Google Spanner from mobile and tablet Power Apps.
-
Automated Continuous SAS xpt Replication to Oracle
Use CData Sync for automated, continuous, customizable SAS xpt replication to Oracle.
-
Connect to Pipedrive Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Pipedrive Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PhantomBuster
Provide connectivity to PhantomBuster through an SAP BusinessObjects universe.
-
Publish Azure Synapse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Synapse.
-
Replicate GitHub Data to Multiple Databases via the CData Sync CLI
Replicate GitHub to disparate databases with a single configuration.
-
Configure the CData JDBC Driver for Gmail in a Connection Pool in Tomcat
Connect to Gmail from a connection pool in Tomcat.
-
Integrate MariaDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MariaDB with External Services.
-
Working with AlloyDB Data in LINQPad
Execute LINQ queries to Google AlloyDB in LINQPad.
-
How to connect to ServiceNow Data from IntelliJ
Integrate connectivity to ServiceNow with wizards in IntelliJ.
-
Integrate Cline with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apache Cassandra from within your IDE.
-
Build MVC Applications with Connectivity to Cvent Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cvent from an ASP.NET MVC application.
-
Connect to GitHub from Asprova with CData Software ODBC Driver for GitHub
This article shows how to connect faster to GitHub data from Asprova.
-
Process & Analyze LDAP Objects in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LDAP Objects.
-
Build a Singer.io Tap for Microsoft Exchange With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Exchange data using
-
Use the CData Software ODBC Driver for SAP HANA XS Advanced in MicroStrategy
Connect to SAP HANA XS Advanced in MicroStrategy Developer using the CData Software ODBC Driver for SAP HANA XS Advanced.
-
Build a Singer.io Tap for Nethunt With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Nethunt data using
-
A PostgreSQL Interface for Toggl Data using the CData ODBC Driver
Use the SQL Gateway and Toggl ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize SAP Netweaver Gateway 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 SAP Netweaver Gateway into TIBCO Spotfire.
-
Visualize Keap Data in TIBCO Spotfire through ADO.NET
Integrate Keap into dashboards in TIBCO Spotfire.
-
Back Up PayPal to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for PayPal. In this article, we will employ an SSIS workflow to populate a database with PayPal data.
-
Visualize Typeform Data in TIBCO Spotfire through ADO.NET
Integrate Typeform into dashboards in TIBCO Spotfire.
-
How to Connect DBeaver to SQL Analysis Services via a JDBC Driver
Manage SQL Analysis Services with visual tools in DBeaver like the query browser.
-
Import and Visualize Azure Data Catalog Data in Power View
Create data visualizations based on Azure Data Catalog in Excel.
-
Integrate BenchmarkEmail Data in the Pentaho Report Designer
Publish reports based on BenchmarkEmail in the Pentaho BI tool.
-
Connect to SharePoint Data from a Connection Pool in JBoss
Integrate Microsoft SharePoint into Java servlets: Use the Management Console in JBoss to install the SharePoint JDBC Driver.
-
Edit and Search External LinkedIn Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of LinkedIn to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create LinkedIn Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData ODBC Driver for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Data Lake Storage.
-
Automated Continuous Drift Replication to Oracle
Use CData Sync for automated, continuous, customizable Drift replication to Oracle.
-
Integrating Claude Code CLI with Retently 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.
-
Publish FTP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FTP Servers.
-
Access Live Pipedrive Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Pipedrive data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Viewing Amazon Athena Data in RAD Studio Data Explorer
How to view Amazon Athena in RAD Studio Data Explorer using the CData ODBC Driver for Amazon Athena.
-
Build Apps with Live GraphQL in Adalo using CData Connect AI
Use CData Connect AI to integrate live GraphQL into the Adalo platform and build custom mobile and web applications with real-time GraphQL.
-
How to integrate Figshare with Apache Airflow
Access and process Figshare in Apache Airflow using the CData JDBC Driver.
-
Build Klipfolio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Klipfolio.
-
Work with Todoist Data in FoxPro
Load Todoist into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Presto Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Presto from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Exact Online Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Exact Online and integrate live Exact Online into your Power Automate tasks.
-
Connect to SAP Concur Data in CloverDX (formerly CloverETL)
Transfer SAP Concur using the visual workflow in the CloverDX data integration tool.
-
Connect to Asana Data from Crystal Reports
Use CData Connect AI to connect to and report on live Asana from Crystal Reports.
-
Integrating Codex CLI with Google 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.