CData Software - Knowledge Base
Recent Articles
-
Access Live Oracle Sales Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Sales in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to QuickBooks Time 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 QuickBooks Time.
-
How to Query Live Jira Data in Claude Desktop
Connect to and query live Jira Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Sybase IQ Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sybase IQ replication to OneLake in Microsoft Fabric.
-
Create AlloyDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to AlloyDB Data from Klipfolio and build custom visualizations using live Google AlloyDB.
-
Connect to SAP HANA Data in Jaspersoft Studio
Execute SQL to remote SAP HANA in Jaspersoft Studio.
-
How to Connect to Live Quickbase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Quickbase securely in real time.
-
Create GraphQL Dataflows on PowerBI.com
Connect to the CData Power BI Connector for GraphQL from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Work with Oracle Financials Cloud Data in ETL Validator JDBC
Connect to Oracle Financials Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live Avaza Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Avaza using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to import Front Data into Apache Solr
Use the CData Software JDBC Driver for Front in Data Import Handler and create an automated import of Front to Apache Solr Enterprise Search platform.
-
Connect to Google Ad Manager Data in Ruby
Connect to Google Ad Manager in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating OpenCode Terminal with RSS Feeds 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.
-
Edit and Search External Pipedrive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Pipedrive to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Pipedrive Data objects that you can access from apps and the dashboard.
-
Connect to ZendeskSell Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZendeskSell.
-
Use the CData Software ODBC Driver for Avaza in SAS for Real-Time Reporting and Analytics
Connect to real-time Avaza in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Avaza.
-
Integrate Live Sugar CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Query Live Office 365 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Office 365 data in natural language using Python.
-
Connect AlloyDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AlloyDB with IBM WebSphere for seamless data integration and connectivity.
-
Integrate with Drip Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Drip to a JSON file on disk.
-
Connect to CircleCI Data in NetBeans
Connect to CircleCI in NetBeans with the data source configuration wizard.
-
Integrating Gumloop with Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Airtable within automated workflows.
-
Connect to PingOne Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PingOne as an External Source in Dremio.
-
Query Gorgias Data as a MySQL Database in Node.js
Execute MySQL queries against Gorgias from Node.js.
-
Create GetResponse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GetResponse data access from reports, embedded analytics, and more.
-
Access Live Google Contacts Data in Coginiti Pro
Connect to and query live Google Contacts from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live HBase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache HBase securely in real time.
-
Rapidly Develop Elorus-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 Elorus.
-
Analyze Oracle SCM Data in Looker
Use CData Connect AI to connect to Oracle SCM Data from Looker and build custom apps using live Oracle SCM.
-
Amazon Marketplace Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon Marketplace through CData Connect AI using different applications and tools.
-
Access Microsoft Dataverse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dataverse (CDS) from your Oracle system.
-
Prepare, Blend, and Analyze Chargebee Data in Alteryx Designer (ODBC)
Build workflows to access live Chargebee for self-service data analytics.
-
Getting Started with the CData Power BI Connector for Planio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to publish and share Azure Data Catalog Data dashboards with Tableau Server
The CData ODBC driver for Azure Data Catalog enables you integrate Azure Data Catalog into Tableau dashboards.
-
Query Greenhouse Data in DataGrip
Create a Data Source for Greenhouse in DataGrip and use SQL to query live Greenhouse.
-
How to Connect to Live API Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your API through natural language.
-
Automate DocuSign Data Replication to Azure Data Lake
Use CData Sync to customize and automate DocuSign replication to Azure Data Lake.
-
Connect to ShipStation Data in Jaspersoft Studio
Execute SQL to remote ShipStation in Jaspersoft Studio.
-
Integrate Live SAP Concur Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Concur from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Concur.
-
Integrate with Cassandra Data in JReport Designer
Create charts and reports based on Apache Cassandra in JReport Designer.
-
Build Microsoft Planner Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Planner and build visualizations in Tableau.
-
How to Easily Query Azure Data Lake Storage Data in OpenOffice Base
Connect to Azure Data Lake Storage data in OpenOffice Base using the CData ODBC Driver for Azure Data Lake Storage and generate reports with live data insights.
-
Use Dash to Build Web Apps on Greenhouse Data via CData Connect AI
Build interactive Dash web apps on live Greenhouse using pandas and the CData Connect AI Python SDK.
-
Integrating Dataiku with BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google BigQuery.
-
Integrate Figshare with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Figshare with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Figshare.
-
Import Real-Time Guru Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Guru in ColdFusion.
-
Connect to Cassandra Data in Ruby
Connect to Apache Cassandra in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create an RPA flow for Delighted Data in UiPath Studio
Use the Delighted ODBC Driver to create workflows that access real-time Delighted without any coding.
-
Visualize Live Exact Online Data in the Power BI Service
Use CData Connect AI to connect to live Exact Online and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Cosmos DB Data from AWS Glue
Use CData Connect AI to gain access to live Azure Cosmos DB from your AWS Glue jobs.
-
Configure the CData JDBC Driver for Monday.com in a Connection Pool in Tomcat
Connect to Monday.com from a connection pool in Tomcat.
-
How to Access LaunchDarkly Data Using Entity Framework
This article shows how to access LaunchDarkly using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
View Reports on Real-Time CircleCI Data in Power BI Report Server
Use the CData ODBC Driver for CircleCI to visualize CircleCI in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Dynamics 365 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Dynamics 365 in the Denodo Virtual DataPort Administrator.
-
Manage Smartsheet Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Smartsheet.
-
Create Informatica Mappings From/To an ODBC Data Source for Elorus
Create an ODBC connection to Elorus in Informatica and browse and transfer Elorus.
-
Access Xero Data from MySQL in Amazon QuickSight
Connect to Xero and build visualizations of Xero Accounting using a MySQL Connection in Amazon QuickSight.
-
How to connect to CapsuleCRM Data from IntelliJ
Integrate connectivity to CapsuleCRM with wizards in IntelliJ.
-
Connect to Zoho CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho CRM in Google Apps Script.
-
Load PagerDuty Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PagerDuty to a database.
-
Connect to FreshBooks from Asprova with CData Software ODBC Driver for FreshBooks
This article shows how to connect faster to FreshBooks data from Asprova.
-
Visualize Live Office 365 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Office 365 into custom reports in Power BI.
-
Explore Geographical Relationships in SQL Analysis Services Data with Power Map
Create data visualizations with SQL Analysis Services in Power Map.
-
Analyze Bitbucket Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bitbucket with the CData JDBC Driver for Bitbucket.
-
Integrating Claude Code CLI with Google Ad Manager 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 SSAS Tabular Models from REST Data
How to build a SQL Server Analysis Service Tabular Model from REST using CData drivers.
-
Integrate Cursor with Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live IBM Informix from within the editor.
-
Object-Relational Mapping (ORM) with Webflow 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 Webflow into a Java-based ORM framework, Hibernate.
-
Build Apps with Live Beeminder Data Using the Low-Code Development Platform of Mendix
Connect Beeminder with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Calendly Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Calendly replication to AlloyDB.
-
Replicate Multiple SAP Hybris C4C Accounts
Replicate multiple SAP Hybris C4C accounts to one or many databases.
-
Choosing the Best Method to Connect Drip to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Drip from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Clockify Data in TIBCO Spotfire through ADO.NET
Integrate Clockify into dashboards in TIBCO Spotfire.
-
Connect to Tanda from a Connection Pool in WebLogic
Use the CData JDBC Driver for Tanda to connect to Tanda from Web applications running on WebLogic.
-
Query, Visualize, and Share live Twilio Data in Redash
Use CData Connect AI to connect to live Twilio in Redash for querying, visualizing, and sharing.
-
Configure the CData JDBC Driver for Parquet in a Connection Pool in Tomcat
Connect to Apache Parquet from a connection pool in Tomcat.
-
How to Seamlessly Import Factorial Data into IBM SPSS Modeler
Integrate Factorial data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData ODBC Driver for Exact Online
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Exact Online.
-
Create Data Visualizations in Cognos BI with PabblySubscriptions Data
Access PabblySubscriptions as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query, Visualize, and Share live Zoom Data in Redash
Use CData Connect AI to connect to live Zoom in Redash for querying, visualizing, and sharing.
-
Use Azure AI Foundry to Talk to Your Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Email for you.
-
Connect to Cloudflare Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Cloudflare and work with Cloudflare in your FileMaker application.
-
Build a PostgreSQL Interface for SendInBlue Data using the CData JDBC Driver
Use the Remoting features of the SendInBlue JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData JDBC Driver for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CampaignMonitor.
-
Query MariaDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MariaDB entities in PHP by modeling them as objects.
-
A PostgreSQL Interface for ClickTime Data (MySQL Remoting via JDBC)
Use the Remoting features of the ClickTime JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to CircleCI Data in RapidMiner
Integrate CircleCI with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Exa Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Exa to a chart.
-
Object-Relational Mapping (ORM) with Parallel 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 Parallel into a Java-based ORM framework, Hibernate.
-
Automated Continuous Zoho Inventory Replication to MySQL
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to MySQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Active Directory
Provide connectivity to Active Directory through an SAP BusinessObjects universe.
-
Feed GitHub Data into FineReport
How to set GitHub as a JDBC data source in FineReport.
-
How to connect to Amplitude Data from Spring Boot
Connect to Amplitude in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Bitbucket Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Bitbucket replication to Azure SQL Database.
-
Build Dashboards with Google Sheets Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Sheets in DBxtra.
-
Cloudant Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to IBM Cloudant through CData Connect AI using different applications and tools.
-
Build Agents in Relevance AI with Access to Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP SuccessFactors within intelligent agent workflows.
-
Use Dash to Build to Web Apps on Webflow Data
Create Python applications that use pandas and Dash to build Webflow-connected web apps.
-
Connect to Yelp Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Yelp to connect to Yelp and execute queries in PowerBuilder.
-
How to create Visio diagrams from Impala Data
Automatically update Apache Impala with the changes you make to Visio master shapes.