CData Software - Knowledge Base
Recent Articles
-
Connect Calendly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Calendly with IBM WebSphere for seamless data integration and connectivity.
-
Create Informatica Mappings From/To a JDBC Data Source for HubSpot
Create HubSpot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Seamlessly Import GraphQL Data into IBM SPSS Modeler
Integrate GraphQL data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous GraphQL Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable GraphQL replication to Azure SQL Database.
-
Build Neo4J-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Neo4J and build Neo4J-connected web apps with Axios.
-
LINQ to Odoo 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 Odoo Data Provider.
-
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.
-
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.
-
How to connect to Customer.io Data from Spring Boot
Connect to Customer.io in a Spring Boot Application using the CData API Driver for JDBC
-
Create Apps from Facebook Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Facebook Ads Data and build apps from live Facebook Ads in Qlik Sense Cloud.
-
Connect to Pipedrive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pipedrive to connect to Pipedrive from Web applications running on WebLogic.
-
Automated Continuous Clockify Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Clockify replication to Apache Cassandra.
-
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.
-
Integrate Bugsnag Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bugsnag from Informatica Cloud.
-
Build Exact Online Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Exact Online and build visualizations in Tableau.
-
Integrating Cursor CLI with Exact Online 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.
-
Integrate Jumpseller Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Jumpseller from Informatica Cloud.
-
Automated Continuous Salesforce CRM Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Amazon Redshift.
-
Integrate Live Smartsheet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Smartsheet to Blue Prism using the CData ODBC Driver for Smartsheet to create automated workflows for repetitive business tasks.
-
Visualize Live Tally Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Tally ERP into custom reports in Power BI.
-
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.
-
Working with Planio Data in LINQPad
Execute LINQ queries to Planio in LINQPad.
-
Integrating Codex CLI with SAP ERP/NetWeaver 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.
-
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.
-
ETL Mistral AI in Oracle Data Integrator
This article shows how to transfer Mistral AI into a data warehouse using Oracle Data Integrator.
-
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.
-
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.
-
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.
-
Query Freshdesk Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Freshdesk entities in PHP by modeling them as objects.
-
Migrating data from Vimeo to Databricks using CData SSIS Components.
Easily push Vimeo to Databricks using the CData SSIS Tasks for Vimeo and Databricks.
-
Connect to Gorgias Data in DBeaver
Use the CData ODBC Driver to connect to Gorgias in DBeaver.
-
Operational Reporting on Short.io Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Short.io.
-
Create a Data Access Object for Aha! Data using JDBI
A brief overview of creating a SQL Object API for Aha! in JDBI.
-
Create CircleCI Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CircleCI data access from reports, embedded analytics, and more.
-
Integrate Instantly Data in the Pentaho Report Designer
Publish reports based on Instantly in the Pentaho BI tool.
-
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.
-
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.
-
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.
-
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
-
Seamlessly Bring Microsoft Dataverse Data into Retool Using CData Connect AI
Integrate Microsoft Dataverse data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Pinterest Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pinterest replication to AlloyDB.
-
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.
-
Enable the Webex JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Webex.
-
Design BIRT Reports on Workday Data
Provide current Workday to your embedded analytics.
-
Create SSAS Tabular Models from ZohoInvoice Data
How to build a SQL Server Analysis Service Tabular Model from ZohoInvoice using CData drivers.
-
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.
-
Create Dashboards and Visualize Live Snapchat Ads Data in Geckoboard
Use CData Connect AI to connect to live Snapchat Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to work with ZohoMarketingHub Data in Apache Spark using SQL
Access and process ZohoMarketingHub Data in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Aha! Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Aha! in ColdFusion.
-
Automated Continuous Freshdesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Freshdesk replication to Snowflake.
-
Access Live BenchmarkEmail Data in Coginiti Pro
Connect to and query live BenchmarkEmail from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Antigravity CLI with Oracle Eloqua via CData CLI
Connect Oracle Eloqua to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind Controls to JobNimbus Data in Delphi
DataBind to JobNimbus in Delphi with standard data access components and controls.
-
How to Connect to Live Adobe Analytics Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Adobe Analytics without replication.
-
Automated Continuous EnterpriseDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to delimited files (CSV/TSV).
-
Analyze Google Spanner Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Spanner with the CData JDBC Driver for Google Spanner.
-
Automated Continuous Amazon Athena Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Google BigQuery.
-
Build an OLAP Cube in SSAS from Todoist Data
Establish a connection to Todoist data from SQL Server Analysis Services, and use the Todoist Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Phoenix Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Phoenix into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Phoenix in the Graph Builder and Query Builder.
-
Build Charts with Greenhouse Data in Clear Analytics
Create dynamic charts and perform analytics based on Greenhouse in Clear Analytics.
-
Use Grok to Talk to Your Amazon Marketplace 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 Amazon Marketplace for you.
-
Automated Continuous Typeform Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Typeform replication to Azure SQL Database.
-
Access Live Tickspot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Tickspot in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Charts with Jira Data in Clear Analytics
Create dynamic charts and perform analytics based on Atlassian Jira in Clear Analytics.
-
Access Oracle Sales Data from MySQL in Amazon QuickSight
Connect to Oracle Sales and build visualizations of Oracle Sales using a MySQL Connection in Amazon QuickSight.
-
Build SendInBlue-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SendInBlue.
-
Connect to Webex Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Webex using standard SQL.
-
Connect and Query Live OData Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live OData into Databricks
-
DataBind Sage Intacct Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sage Intacct with the DevExpress Windows Forms and Web controls to provide Sage Intacct to a chart.
-
Write a Simple Go Application to work with Everhour Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Everhour.
-
How to Connect to Live SQL Analysis Services Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SQL Analysis Services securely in real time.
-
Connect to Perplexity Data in RazorSQL
Connect to Perplexity from wizards and query Perplexity from the GUI in the RazorSQL database management tool.
-
Connect to Snapchat Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Snapchat Ads as an External Source in Dremio.
-
How to import Azure Synapse Data into Apache Solr
Use the CData Software JDBC Driver for Azure Synapse in Data Import Handler and create an automated import of Azure Synapse to Apache Solr Enterprise Search platform.
-
Build Voice Agents in ElevenLabs with access to Live API Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live API.
-
Integrate TigerGraph Data in the Pentaho Report Designer
Publish reports based on TigerGraph in the Pentaho BI tool.
-
Integrate with Shortcut Data in JReport Designer
Create charts and reports based on Shortcut in JReport Designer.
-
Feed Gmail Data into FineReport
How to set Gmail as a JDBC data source in FineReport.
-
Analyze Pipedrive Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Pipedrive and visualize Pipedrive in SAP Analytics Cloud.
-
View Reports on Real-Time SendGrid Data in Power BI Report Server
Use the CData ODBC Driver for SendGrid to visualize SendGrid in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Cassandra Data in ACL Analytics
Connect to Apache Cassandra via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Cassandra.
-
Natively Connect to Trello Data in PHP
The CData ODBC driver for Trello enables you to create PHP applications with connectivity to Trello. Leverage the native support for ODBC in PHP.
-
How to Access Live eBay Data in Visual Studio Code via Cline
Run CData MCP Server for eBay on Windows Subsytem for Linux (WSL) and connect to live eBay from the Cline extension in Visual Studio Code.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ConstantContact
Provide connectivity to ConstantContact through an SAP BusinessObjects universe.