CData Software - Knowledge Base
Recent Articles
-
Analyze Odoo Data in Cognos Analytics
Use CData Connect AI to connect to Odoo Data from Cognos Analytics and analyze live Odoo data.
-
How to Connect DBeaver to Eventbrite via a JDBC Driver
Manage Eventbrite data with visual tools in DBeaver like the query browser.
-
Integrating OpenCode with Google Directory 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.
-
Build Charts with Zoho Projects Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho Projects data in Clear Analytics.
-
Build a Singer.io Tap for Microsoft Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Ads data using the CData Python Connector.
-
Back Up Microsoft Entra ID data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Entra ID. In this article, we will employ an SSIS workflow to populate a database with Microsoft Entra ID data data.
-
Automated Continuous Campaigner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Campaigner replication to SingleStore.
-
Process & Analyze SAP ByDesign Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP ByDesign Data.
-
Choosing the Best Method to Connect SendInBlue to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SendInBlue data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Power BI Reports on Real-Time Adobe Target Data
Use the CData ODBC Driver for Adobe Target to visualize Adobe Target data in Power BI Desktop.
-
Automated Continuous Procore Replication to Oracle
Use CData Sync for automated, continuous, customizable Procore replication to Oracle.
-
DataBind Charts to DB2 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to DB2 data 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.
-
Access Live Freshservice Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Freshservice data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Snowflake Data in DBeaver
Use the CData ODBC Driver to connect to Snowflake data in DBeaver.
-
How to Connect to Live Salesforce Data 360 Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Salesforce Data 360 data for you.
-
How to load ClickTime data into Elasticsearch via Logstash
Introducing a simple method to load ClickTime data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Twitter Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Twitter Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating LangChain with Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Teradata data within automated workflows.
-
Bridge Twitter Ads Connectivity with Apache NiFi
Access and process Twitter Ads data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Omnisend Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Omnisend replication to Google BigQuery.
-
Use the CData Software JDBC Driver for Smartsheet in MicroStrategy Desktop
Connect to Smartsheet data in MicroStrategy Desktop using the CData Software JDBC Driver for Smartsheet.
-
Automated Continuous Zoho Recruit Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Vertica.
-
Prepare, Blend, and Analyze Google Sheets Data in Alteryx Designer (ODBC)
Build workflows to access live Google Sheets data for self-service data analytics.
-
Analyze Omnisend Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Omnisend data with the CData JDBC Driver for Omnisend.
-
Build SAP HANA-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP HANA data.
-
Integrate LibreChat with Live Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Wave Financial data from within the chat interface.
-
Publish Reports with MySQL Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MySQL data.
-
Deploy the ADO.NET Provider for SAP SuccessFactors on an SSRS Report Server
Connect to SAP SuccessFactors data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Analyze Teradata Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Teradata data with the CData JDBC Driver for Teradata.
-
Use the CData Software JDBC Driver for ZohoDesk in MicroStrategy
Connect to ZohoDesk data in MicroStrategy Developer using the CData Software JDBC Driver for ZohoDesk.
-
Operational Reporting on xBase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote xBase data.
-
Integrating Kiro with Pinecone 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.
-
How to Easily Query SingleStore Data in OpenOffice Base
Connect to SingleStore data in OpenOffice Base using the CData ODBC Driver for SingleStore and generate reports with live data insights.
-
Connect and Visualize Live ZohoInvoice Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ZohoInvoice data into the Databricks platform and create visualization dashboards with real-time ZohoInvoice data.
-
Integrating GitHub Copilot with Gorgias 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.
-
Build Pipelines with Live Highrise Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Highrise from Google Cloud Data Fusion, enabling the integration of live Highrise data into the building and management of effective data pipelines.
-
How to Work with Freshsales Data in ETL Validator JDBC
Connect to Freshsales from ETL Validator jobs using the CData Software JDBC Driver.
-
Consume DocuSign OData Feeds in SAP Lumira
Use the API Server to create data visualizations on DocuSign feeds that reflect any changes in SAP Lumira.
-
Build a Simple VCL Application for Zoho Projects Data
How to build a simple VCL Application to view Zoho Projects data in RAD Studio using the CData ODBC Driver for Zoho Projects.
-
Create Freshteam-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Freshteam Data from OutSystems and build custom enterprise apps using live Freshteam data.
-
How to create an RPA flow for Pipeliner CRM Data in UiPath Studio
Use the Pipeliner CRM ODBC Driver to create workflows that access real-time Pipeliner CRM data without any coding.
-
How to connect to Basecamp Data from Spring Boot
Connect to Basecamp in a Spring Boot Application using the CData JDBC Driver for Basecamp
-
Use JayDeBeApi to access OpenWeatherMap Data in Python
Use standard Python scripting and the development environment of your choice to access live OpenWeatherMap data.
-
Connect and Query Live SAP Concur Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Concur data into Databricks and enable direct, live querying and analysis without replication.
-
Write a Simple Go Application to work with Pinecone Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pinecone data.
-
Connect to OnePageCrm in SpagoBI
Create reports featuring live OnePageCrm data in SpagoBI Studio. Host OnePageCrm reports on SpagoBI Server.
-
Create Reports with Paddle Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paddle data.
-
Access AdRoll Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access AdRoll data from your Oracle system.
-
Prepare, Blend, and Analyze Act-On Data in Alteryx Designer (Connect AI)
Build workflows to access live Act-On data for self-service data analytics.
-
Build Hive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Hive data.
-
Choosing the Best Method to Connect Insightly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Insightly data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Everhour Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Everhour data from PowerShell? This article demonstrates how to utilize the Everhour Cmdlets for tasks like connecting to Everhour data, automating operations, downloading data, and more.
-
Automated Continuous Zoho Inventory Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to PostgreSQL.
-
Automated Continuous Sybase Replication to Vertica
Use CData Sync for automated, continuous, customizable Sybase replication to Vertica.
-
Integrating LlamaIndex with Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Bitly data in real time.
-
Working with Google Directory Data in LINQPad
Execute LINQ queries to Google Directory data in LINQPad.
-
Automated Continuous ClickTime Replication to SQLite
Use CData Sync for automated, continuous, customizable ClickTime replication to SQLite.
-
Query Live Kafka Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Kafka data through a conversational interface.
-
Connect to BigCommerce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BigCommerce and the SQL Gateway to access BigCommerce data from Google Apps Script.
-
Automated Continuous ClickTime Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ClickTime data replication to OneLake in Microsoft Fabric.
-
Analyze WooCommerce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of WooCommerce data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Elasticsearch Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Elasticsearch to connect to Elasticsearch data and execute queries in PowerBuilder.
-
Integrate Microsoft OneDrive Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft OneDrive data in the Pentaho Data Integration tool.
-
Add Webex Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Webex with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bidirectional Access to Salesforce CRM Analytics Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce CRM Analytics data in Filemaker Pro for Mac or Windows.
-
Connect to FreeAgent Data in JRuby
Create a simple JRuby app with access to live FreeAgent data.
-
How to connect to Jira Data with Squirrel SQL client
Connect to Jira data and execute queries in the Squirrel SQL Client.
-
How to Connect Flowise AI Agents to Live Cosmos DB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Cosmos DB data without replication.
-
Replicate Oracle Service Cloud Data in Heroku for Use in Salesforce Connect
Replicate Oracle Service Cloud data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for PDFMonkey in MicroStrategy Desktop
Connect to PDFMonkey data in MicroStrategy Desktop using the CData Software JDBC Driver for PDFMonkey.
-
Back Up Reckon data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Reckon. In this article, we will employ an SSIS workflow to populate a database with Reckon data data.
-
How to Connect to Live Timely Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Timely data for you.
-
View Reports on Real-Time MYOB AccountRight Data in Power BI Report Server
Use the CData ODBC Driver for MYOB AccountRight to visualize MYOB AccountRight data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access AfterShip Data from MySQL in Amazon QuickSight
Connect to AfterShip and build visualizations of AfterShip data using a MySQL Connection in Amazon QuickSight.
-
DataBind Charts to Landbot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Landbot data 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.
-
Build Apps with Live Optimizely Data Using the Low-Code Development Platform of Mendix
Connect Optimizely data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Impala Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Impala data.
-
Getting Started with the CData Power BI Connector for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Sales.
-
How to connect PolyBase to Samanage
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Samanage data.
-
Explore Geographical Relationships in Amazon Athena Data with Power Map
Create data visualizations with Amazon Athena data in Power Map.
-
Create Gorgias Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Gorgias data access from reports, embedded analytics, and more.
-
How to Seamlessly Import Azure DevOps Data into IBM SPSS Modeler
Integrate Azure DevOps data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to IBM Cloud Object Storage Data from Crystal Reports
Use CData Connect AI to connect to and report on live IBM Cloud Object Storage data from Crystal Reports.
-
How to publish and share ClickTime Data dashboards with Tableau Server
The CData ODBC driver for ClickTime enables you integrate ClickTime data into Tableau dashboards.
-
Publish Zoho Inventory-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Inventory data.
-
How to Connect to & Open Paddle Data in Microsoft Excel
This article uses the CData ODBC driver for Paddle to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Model, Search, and Visualize Live SAP HANA Data in ThoughtSpot
Use CData Connect AI to connect to live SAP HANA data for modeling, searching, and visualizing.
-
How to Access Live FTP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FTP enables you to integrate FTP data into workflows built using Microsoft Power Automate Desktop.
-
Integrate with Live Attio Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Attio from the MuleSoft Anypoint Platform to integrate live Attio data into custom reports and dashboards.
-
Getting Started with the CData ODBC Driver for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Fieldglass.
-
Replicate Superchat Data to Multiple Databases via the CData Sync CLI
Replicate Superchat data to disparate databases with a single configuration.
-
ETL Flowlu in Oracle Data Integrator
This article shows how to transfer Flowlu data into a data warehouse using Oracle Data Integrator.
-
Quickbase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Quickbase facts in real time.
-
Building Dynamic Web Pages with DocuSign Data Using AngularJS
Create single-page applications with live connectivity to DocuSign using the CData API Server.
-
How to Connect the Power BI Service to Gumroad: Complete Guide
Connect to the CData Software Power BI Connector for Gumroad from PowerBI.com to provide real-time Gumroad data across the organization.
-
Model, Search, and Visualize Live Tavily Data in ThoughtSpot
Use CData Connect AI to connect to live Tavily data for modeling, searching, and visualizing.
-
Automated Continuous Stack Exchange Replication to SQLite
Use CData Sync for automated, continuous, customizable Stack Exchange replication to SQLite.
-
Visualize Live MailerSend Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MailerSend data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze SAP SuccessFactors LMS Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP SuccessFactors LMS from Power Pivot. You will use the Table Import Wizard to load SAP SuccessFactors LMS data. You can visually build the import query or use any SQL supported by the driver.
-
Build ZohoExpense-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ZohoExpense Data and create custom apps in Mendix.