CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time Couchbase Data
Use CData Power BI Connectors to visualize Couchbase in Power BI.
-
Build AI Agents with Freshdesk Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Freshdesk through CData Connect AI.
-
How to Easily Query SageHR Data in OpenOffice Base
Connect to SageHR data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Bidirectional Access to Sugar CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sugar CRM in Filemaker Pro for Mac or Windows.
-
Access Live Opsgenie Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Opsgenie into the statistical analysis tools available in SAS JMP. This article shows how to use Opsgenie in the Graph Builder and Query Builder.
-
How to Connect to & Open ShipEngine Data in Microsoft Excel
This article uses the CData ODBC driver for ShipEngine to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build AI/ML Models with Live PingOne Data using Dataiku
Connect PingOne Data with Dataiku using the CData JDBC Driver for PingOne.
-
How to Connect Sybase 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 Sybase data in real time using natural language.
-
Create Monday.com-Connected Dashboards in Grafana
Connect to Monday.com Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Monday.com.
-
Access Live ZarMoney Data in Coginiti Pro
Connect to and query live ZarMoney from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Dashboards with Greenplum Data in DBxtra
Create dynamic dashboards and perform analytics based on Pivotal GreenPlum in DBxtra.
-
Create Data Visualizations in Cognos BI with Airtable Data
Access Airtable as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Dataverse
Create an ODBC connection to Microsoft Dataverse in Informatica and browse and transfer Microsoft Dataverse (CDS).
-
Visualize Live Act CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Act CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Foursquare-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Foursquare.
-
Access Live LDAP Objects in AWS Lambda (with IntelliJ IDEA)
Connect to live LDAP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData JDBC Driver for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Teams.
-
Visualize Microsoft Ads Data in Tableau
The CData ODBC driver for Microsoft Ads enables you integrate Microsoft Ads into Tableau dashboards.
-
Build Semantic Layer Views for Sage 200 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage 200.
-
Prepare, Blend, and Analyze Everhour Data in Alteryx Designer (ODBC)
Build workflows to access live Everhour for self-service data analytics.
-
Build HCL Domino-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for HCL Domino to explore live HCL Domino Data in Claude Code to assist with building HCL Domino-powered applications.
-
Choosing the Best Method to Connect Clio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Clio from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Natively Connect to Nethunt Data in PHP
The CData ODBC driver for Nethunt enables you to create PHP applications with connectivity to Nethunt. Leverage the native support for ODBC in PHP.
-
Configure the CData JDBC Driver for PolarTeamPro in a Connection Pool in Tomcat
Connect to PolarTeamPro from a connection pool in Tomcat.
-
Access Live GraphQL Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live GraphQL through MCP integration.
-
DataBind Charts to Oracle Service Cloud Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Service Cloud 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 Todoist Data from PowerBuilder via JDBC
This article demonstrates how to access Todoist from PowerBuilder using the Todoist JDBC Driver.
-
Extract, Transform, and Load Highrise Data in Informatica PowerCenter
Create a simple Workflow for Highrise CRM in Informatica PowerCenter.
-
Create Apps from Microsoft Teams Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Teams Data and build apps from live Microsoft Teams in Qlik Sense Cloud.
-
Access Live GraphQL Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GraphQL into the statistical analysis tools available in SAS JMP. This article shows how to use GraphQL in the Graph Builder and Query Builder.
-
Easily Integrate Reply.io Data in Lazarus Pascal IDE
Learn how to easily integrate live Reply.io in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Query Oracle Sales Data in MySQL Workbench
Execute MySQL queries against live Oracle Sales from MySQL Workbench.
-
Integrate with Live MySQL Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MySQL from the MuleSoft Anypoint Platform to integrate live MySQL into custom reports and dashboards.
-
Access Quickbase Data from MySQL in Amazon QuickSight
Connect to Quickbase and build visualizations of Quickbase using a MySQL Connection in Amazon QuickSight.
-
Import and Visualize Salesforce Data 360 Data in Power View
Create data visualizations based on Salesforce Data 360 in Excel.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Wrike to Power BI dashboards. Simply drag and drop Wrike into data visuals on the Power BI canvas.
-
How to use SQLAlchemy ORM to access Adobe Commerce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Adobe Commerce.
-
How to Visualize SingleStore Data in Python with pandas
Use pandas and other modules to analyze and visualize live SingleStore in Python.
-
Automate Printful Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Printful and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Stream Teamgate Data into Apache Kafka Topics
Access and stream Teamgate in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect the Power BI Service to Pipedrive: Complete Guide
Connect to the CData Software Power BI Connector for Pipedrive from PowerBI.com to provide real-time Pipedrive across the organization.
-
How to connect to Supabase Data with Squirrel SQL client
Connect to Supabase and execute queries in the Squirrel SQL Client.
-
Model, Search, and Visualize Live Redshift Data in ThoughtSpot
Use CData Connect AI to connect to live Amazon Redshift for modeling, searching, and visualizing.
-
Connect to PostgreSQL Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for PostgreSQL and the Script function in FileMaker Pro to connect to PostgreSQL and work with PostgreSQL in your FileMaker application.
-
Automated Continuous Jira Assets Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jira Assets replication to Snowflake.
-
Automate Box Data Replication to Couchbase
Use CData Sync to Customize and automate Box replication to Couchbase.
-
Build a PostgreSQL Interface for LinkedIn Ads Data using the CData JDBC Driver
Use the Remoting features of the LinkedIn Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with LinkedIn Data in JReport Designer
Create charts and reports based on LinkedIn in JReport Designer.
-
Seamlessly Bring Google Analytics Data into Retool Using CData Connect AI
Integrate Google Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Splunk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Splunk from Node.js.
-
Access Live Redis Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Redis through MCP integration.
-
How to Seamlessly Import SAP Ariba Procurement Data into IBM SPSS Modeler
Integrate SAP Ariba Procurement data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Epicor Kinetic Data in the Pentaho Report Designer
Publish reports based on Epicor Kinetic in the Pentaho BI tool.
-
ETL Sybase IQ in Oracle Data Integrator
This article shows how to transfer Sybase IQ into a data warehouse using Oracle Data Integrator.
-
Build Agents in Relevance AI with Access to Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Database within intelligent agent workflows.
-
Query NASA Data from Node.js
Use the OData endpoint of the CData API Server to connect to your NASA and perform CRUD operations on NASA from Node.js.
-
Connect to EmailOctopus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to EmailOctopus and work with EmailOctopus in your FileMaker applications.
-
Automated Continuous Salesforce CRM Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Amazon Redshift.
-
Connect to JSON Services from a Connection Pool in Jetty
The JSON JDBC Driver supports connection pooling: This article shows how to connect faster to JSON from Web apps in Jetty.
-
Build an OLAP Cube in SSAS from Clockify Data
Establish a connection to Clockify data from SQL Server Analysis Services, and use the Clockify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Bridge Zuora Connectivity with Apache NiFi
Access and process Zuora in Apache NiFi using the CData JDBC Driver.
-
Working with Planio Data in LINQPad
Execute LINQ queries to Planio in LINQPad.
-
Access EmailOctopus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live EmailOctopus from HeidiSQL.
-
Publish Crystal Reports on Freshservice Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshservice.
-
Import ServiceNow Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ServiceNow. In this article, you will use the OData format to import ServiceNow into Microsoft Power Query.
-
Automated Continuous MailChimp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MailChimp replication to Amazon Redshift.
-
Connect to Act CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Act CRM in FileMaker Pro to connect to Act CRM and work with Act CRM in your FileMaker applications.
-
Integrating Boomi Agentstudio with Zoho CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho CRM, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Google Drive-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Drive Data from OutSystems and build custom enterprise apps using live Google Drive.
-
Build Semantic Layer Views for Amazon Athena Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Amazon Athena.
-
A PostgreSQL Interface for SAP Hybris C4C Data using the CData ODBC Driver
Use the SQL Gateway and SAP Hybris C4C ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Spark Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Spark data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Migrating data from Vimeo to Databricks using CData SSIS Components.
Easily push Vimeo to Databricks using the CData SSIS Tasks for Vimeo and Databricks.
-
Create a Data Access Object for Aha! Data using JDBI
A brief overview of creating a SQL Object API for Aha! in JDBI.
-
How to Connect to & Open BigQuery Data in Microsoft Excel
This article uses the CData ODBC driver for BigQuery to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to and Query ZohoMarketingHub Data in QlikView over ODBC
Create data visualizations with ZohoMarketingHub in QlikView.
-
Consume GetResponse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on GetResponse feeds that reflect any changes in SAP Lumira.
-
How to Easily Query Microsoft Planner Data in OpenOffice Base
Connect to Microsoft Planner data in OpenOffice Base using the CData ODBC Driver for Microsoft Planner and generate reports with live data insights.
-
How to import Instantly Data into Apache Solr
Use the CData Software JDBC Driver for Instantly in Data Import Handler and create an automated import of Instantly to Apache Solr Enterprise Search platform.
-
How to work with XML Data in Apache Spark using SQL
Access and process XML Data in Apache Spark using the CData Software JDBC Driver.
-
Rapidly Develop CouchDB-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 CouchDB.
-
How to Access Live Optimizely Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Optimizely enables you to integrate Optimizely into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Google Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Analytics replication to Oracle.
-
Connect Phoenix to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Phoenix with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Tableau Connector for Parallel
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish Facebook-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Facebook.
-
Integrating Boomi Agentstudio with Marketo Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Marketo, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Pipelines with Live Oracle HCM Cloud Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle HCM Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle HCM Cloud into the building and management of effective data pipelines.
-
How to use SQLAlchemy ORM to access Moosend Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Moosend.
-
How to connect to YouTube Analytics Data in DBVisualizer
Integrate YouTube Analytics with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Pinterest Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pinterest replication to AlloyDB.
-
Connect to Zendesk Data in NetBeans
Connect to Zendesk in NetBeans with the data source configuration wizard.
-
Explore Geographical Relationships in Dynamics CRM Data with Power Map
Create data visualizations with Microsoft Dynamics CRM in Power Map.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle Eloqua within intelligent workflows.
-
Connect to Microsoft Entra ID Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Entra ID from HeidiSQL.
-
Connect to Square Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Square to connect to Square and execute queries in PowerBuilder.
-
How to Work with Spotify Data in ETL Validator JDBC
Connect to Spotify from ETL Validator jobs using the CData Software JDBC Driver.
-
Enable the Webex JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Webex.
-
How to Connect to Live Zoom 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 Zoom for you.
-
Build Dashboards with Google Spanner Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Spanner in Dundas BI.