CData Software - Knowledge Base
Recent Articles
-
How to Query Live Sage Cloud Accounting Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sage Cloud Accounting data data in natural language using Python.
-
Connect to Live Mode Data in MicroStrategy through CData Connect AI
Create a live connection to Mode Data in CData Connect AI and connect to your Mode data from MicroStrategy.
-
Query Google Translate Data in DataGrip
Create a Data Source for Google Translate in DataGrip and use SQL to query live Google Translate data.
-
Analyze AfterShip Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of AfterShip data and visualize live AfterShip data in Infragistics Reveal.
-
How to update Dropbox from Excel
This article explains how to transfer data from Excel to Dropbox using the Excel Add-In for Dropbox.
-
Connect to Pipedrive Data in Claris FileMaker Pro
Use the CData ODBC Driver for Pipedrive in FileMaker Pro to connect to Pipedrive and work with Pipedrive data in your FileMaker applications.
-
Connect to ServiceDesk Plus Data from AWS Glue
Use CData Connect AI to gain access to live ServiceDesk Plus data from your AWS Glue jobs.
-
Connect to OData Services from PowerBuilder via JDBC
This article demonstrates how to access OData services from PowerBuilder using the OData JDBC Driver.
-
Integrate Parallel Data in the Pentaho Report Designer
Publish reports based on Parallel data in the Pentaho BI tool.
-
Replicate MailerLite Data to Multiple Databases
Replicate MailerLite data to disparate databases with a point-and-click configuration.
-
Import Real-Time Google Translate Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Translate data in ColdFusion.
-
Import Real-Time Perigon Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Perigon data in ColdFusion.
-
How to Connect to & Open Attio Data in Microsoft Excel
This article uses the CData ODBC driver for Attio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Microsoft Dataverse 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 Microsoft Dataverse data through MCP integration.
-
Create Data Visualizations in Cognos BI with Dynamics 365 Data
Access Dynamics 365 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Access-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Access data.
-
Visualize Live VWO Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live VWO data.
-
Access Live Oracle Service Cloud Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Service Cloud data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build a Simple VCL Application for AfterShip Data
How to build a simple VCL Application to view AfterShip data in RAD Studio using the CData ODBC Driver for AfterShip.
-
Use Grok to Talk to Your Guru 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 Guru data for you.
-
CloudConvert Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CloudConvert facts in real time.
-
Connect and Query Live SQL Analysis Services Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SQL Analysis Services data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Trae with Live SageHR Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SageHR data from within the AI-powered IDE.
-
Connect to Box from a Connection Pool in WebLogic
Use the CData JDBC Driver for Box to connect to Box data from Web applications running on WebLogic.
-
Connect to Quickbase Data in JRuby
Create a simple JRuby app with access to live Quickbase data.
-
How to Connect DBeaver to ZohoExpense via a JDBC Driver
Manage ZohoExpense data with visual tools in DBeaver like the query browser.
-
Replicate Shortcut Data to Multiple Databases
Replicate Shortcut data to disparate databases with a point-and-click configuration.
-
Connect and Query Live Aweber Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Aweber data into Databricks and enable direct, live querying and analysis without replication.
-
Import SAP ByDesign Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP ByDesign Data and provide access to live SAP ByDesign data for custom reports in the Power BI Service.
-
Replicate Dynamics 365 Business Central Data from PowerShell
Write a quick PowerShell script to query Dynamics 365 Business Central data. Use connectivity to the live data to replicate Dynamics 365 Business Central data to SQL Server.
-
Create WooCommerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to WooCommerce Data from OutSystems and build custom enterprise apps using live WooCommerce data.
-
How to Build an ETL App for Zendesk Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zendesk data in Python with petl and the CData Connect AI Python SDK.
-
How to connect to VWO Data with Squirrel SQL client
Connect to VWO data and execute queries in the Squirrel SQL Client.
-
How to use SQLAlchemy ORM to access Basecamp Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Basecamp data.
-
Integrate Google Sheets with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Sheets with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Sheets data.
-
Viewing Freshservice Data in RAD Studio Data Explorer
How to view Freshservice data in RAD Studio Data Explorer using the CData ODBC Driver for Freshservice.
-
Visualize Live CSV Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CSV data.
-
Connect and Query Live PingOne Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live PingOne data into Databricks and enable direct, live querying and analysis without replication.
-
Publish Reports with Cloudant Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cloudant data.
-
Build Dashboards with ZohoExpense Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoExpense data in DBxtra.
-
Query Zoom Data as a MySQL Database in Node.js
Execute MySQL queries against Zoom data from Node.js.
-
Visualize Live Bitbucket Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bitbucket data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Apollo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apollo data from Node.js.
-
Import and Visualize Oracle SCM Data in Power View
Create data visualizations based on Oracle SCM data in Excel.
-
How to use SQLAlchemy ORM to access Jira Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jira data.
-
Validate SAP BusinessObjects BI Data with QuerySurge
Access and validate SAP BusinessObjects BI data in QuerySurge using the CData JDBC Driver.
-
Visualize OneNote Data in TIBCO Spotfire through OData
Integrate OneNote data into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Shortcut
Create an ODBC connection to Shortcut in Informatica and browse and transfer Shortcut data.
-
Connect to MySQL Data in ACL Analytics
Connect to MySQL data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MySQL data.
-
Integrating Kiro with SharePoint Excel Services 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Vercel
Provide connectivity to Vercel data through an SAP BusinessObjects universe.
-
Migrating data from Postmark to Databricks using CData SSIS Components.
Easily push Postmark data to Databricks using the CData SSIS Tasks for Postmark and Databricks.
-
Create Basecamp Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Basecamp from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access SageHR Data from MySQL in PHP
Connect to SageHR through the standard MySQL libraries in PHP.
-
Connect to QuickBooks Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for QuickBooks data.
-
Integrate Live Salesforce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce data to Blue Prism using the CData ODBC Driver for Salesforce to create automated workflows for repetitive business tasks.
-
Build Visualizations of Microsoft Teams Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Teams data in Birst.
-
Visualize Live Bannerbear Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bannerbear data.
-
Visualize Customer.io 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 Customer.io data into TIBCO Spotfire.
-
How to Work with ZeroBounce Data in ETL Validator JDBC
Connect to ZeroBounce from ETL Validator jobs using the CData Software JDBC Driver.
-
Viewing SQL Server Data in RAD Studio Data Explorer
How to view SQL Server data in RAD Studio Data Explorer using the CData ODBC Driver for SQL Server.
-
How to Connect to Live ShipStation Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your ShipStation data for you.
-
Apollo Reporting in OBIEE with the Apollo JDBC Driver
Deploy the Apollo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Visualizations of MySQL Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MySQL data in Birst.
-
How to connect to FTP Data from IntelliJ
Integrate connectivity to FTP data with wizards in IntelliJ.
-
Connect to Smartsheet 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 Smartsheet data.
-
Create Informatica Mappings From/To an ODBC Data Source for Act CRM
Create an ODBC connection to Act CRM in Informatica and browse and transfer Act CRM data.
-
How to import Quaderno Data into Apache Solr
Use the CData Software JDBC Driver for Quaderno in Data Import Handler and create an automated import of Quaderno data to Apache Solr Enterprise Search platform.
-
Connect to MySQL Data in DBeaver
Use the CData ODBC Driver to connect to MySQL data in DBeaver.
-
How to Access Bitbucket Data Using Entity Framework
This article shows how to access Bitbucket data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import SQL Analysis Services Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SQL Analysis Services Data and provide access to live SQL Analysis Services data for custom reports in the Power BI Service.
-
Getting Started with the CData SSIS Components for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PolarTeamPro.
-
How to Connect to Reckon Accounts Hosted Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon Accounts Hosted data. Leverage the pyodbc module for ODBC in Python.
-
How to Query Guru Data in MySQL Workbench
Execute MySQL queries against live Guru data from MySQL Workbench.
-
Access Live Zoho Projects Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho Projects data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automate CircleCI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CircleCI data from PowerShell? This article demonstrates how to utilize the CircleCI Cmdlets for tasks like connecting to CircleCI data, automating operations, downloading data, and more.
-
Access Outlook Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Outlook data from your Oracle system.
-
A PostgreSQL Interface for ADP Data (MySQL Remoting via JDBC)
Use the Remoting features of the ADP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports from Coda Data in Looker Studio
Use CData Connect AI to gain access to live Coda data and create custom reports in Looker Studio.
-
How to Connect DBeaver to Keap via a JDBC Driver
Manage Keap data with visual tools in DBeaver like the query browser.
-
Access Freshdesk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Freshdesk data from your Oracle system.
-
Moving Data from Attio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Attio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Pipedrive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pipedrive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Sendwithus Data in Looker
Use CData Connect AI to connect to Sendwithus Data from Looker and build custom apps using live Sendwithus data.
-
Feed ConstantContact Data into FineReport
How to set ConstantContact data as a JDBC data source in FineReport.
-
Integrate with Live MongoDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MongoDB from the MuleSoft Anypoint Platform to integrate live MongoDB data into custom reports and dashboards.
-
Validate Outlook Data with QuerySurge
Access and validate Outlook data in QuerySurge using the CData JDBC Driver.
-
Access Live Hive 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 Hive data through MCP integration.
-
Create a Data Access Object for LightSpeedRetail Data using JDBI
A brief overview of creating a SQL Object API for LightSpeedRetail data in JDBI.
-
Build an OLAP Cube in SSAS from Bullhorn CRM Data
Establish a connection to Bullhorn CRM data data from SQL Server Analysis Services, and use the Bullhorn CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build ShipStation-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ShipStation data and build web apps with connectivity to live ShipStation data.
-
Enable the Optimizely JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Optimizely data.
-
Automated Continuous ChargeOver Replication to MongoDB
Use CData Sync for automated, continuous, customizable ChargeOver replication to MongoDB.
-
Connect to Real-Time Short.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Short.io data in Power Apps.
-
Build an OLAP Cube in SSAS from Sugar CRM Data
Establish a connection to Sugar CRM data data from SQL Server Analysis Services, and use the Sugar CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze SuiteCRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SuiteCRM data in Microsoft R Open.
-
Connect to Epicor Kinetic Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Epicor Kinetic Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Back Up Drip data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Drip data data.
-
Build AI/ML Models with Live Zoho Inventory Data using Dataiku
Connect Zoho Inventory Data with Dataiku using the CData JDBC Driver for Zoho Inventory.
-
MailerLite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MailerLite facts in real time.