CData Software - Knowledge Base
Recent Articles
-
Connect to Pipedrive Data in RazorSQL
Connect to Pipedrive from wizards and query Pipedrive from the GUI in the RazorSQL database management tool.
-
Connect to Samanage Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Samanage as an External Source in Dremio.
-
How to import PDFMonkey Data into Apache Solr
Use the CData Software JDBC Driver for PDFMonkey in Data Import Handler and create an automated import of PDFMonkey to Apache Solr Enterprise Search platform.
-
How to Connect to & Open Factorial Data in Microsoft Excel
This article uses the CData ODBC driver for Factorial to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Kiro CLI with HBase 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 publish and share SAP Ariba Source Data dashboards with Tableau Server
The CData ODBC driver for SAP Ariba Source enables you integrate SAP Ariba Source into Tableau dashboards.
-
DataBind Charts to Google Translate Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Translate 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.
-
Integrate with SAP Fieldglass Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Fieldglass in SnapLogic.
-
Load Guru Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Guru to a database.
-
Explore Geographical Relationships in ZohoSubscriptions Data with Power Map
Create data visualizations with ZohoSubscriptions in Power Map.
-
Integrating OpenCode Terminal with Microsoft OneDrive 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.
-
Working with HCL Domino Data in LINQPad
Execute LINQ queries to HCL Domino in LINQPad.
-
Connect to Outlook Data from a Connection Pool in JBoss
Integrate Outlook into Java servlets: Use the Management Console in JBoss to install the Outlook JDBC Driver.
-
Visualize Live Asana Data in the Power BI Service
Use CData Connect AI to connect to live Asana and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Supabase to Google BigQuery using CData SSIS Components.
Easily push Supabase to Google BigQuery using the CData SSIS Tasks for Supabase and Google BigQuery.
-
Work with Zoho Books Data in FoxPro
Load Zoho Books into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Oracle-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Database and build Oracle-connected web apps with Axios.
-
Integrating Antigravity CLI with Salesforce Data 360 via CData CLI
Connect Salesforce Data 360 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to and Query Tavily Data in QlikView over ODBC
Create data visualizations with Tavily in QlikView.
-
How to connect PolyBase to Redis
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Redis.
-
Integrate Live Zoho Inventory Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Inventory to Blue Prism using the CData ODBC Driver for Zoho Inventory to create automated workflows for repetitive business tasks.
-
Connect to Neo4J Data from Crystal Reports
Use CData Connect AI to connect to and report on live Neo4J from Crystal Reports.
-
Stream FreeAgent Data into Apache Kafka Topics
Access and stream FreeAgent in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating PingOne Data in Talend Cloud Data Management Platform
Connect PingOne Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PingOne.
-
Analyze Workday Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Workday and visualize Workday in SAP Analytics Cloud.
-
Connect to Tanda Data in Ruby
Connect to Tanda in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Google Contacts Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Contacts replication to IBM DB2.
-
Connect to JobNimbus Data in HULFT Integrate
Connect to JobNimbus as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy Desktop
Connect to AfterShip in MicroStrategy Desktop using the CData Software JDBC Driver for AfterShip.
-
How to Query Amazon DynamoDB Data in MySQL Workbench
Execute MySQL queries against live Amazon DynamoDB from MySQL Workbench.
-
Integrate Certinia Data in Pentaho Data Integration
Build ETL pipelines based on Certinia in the Pentaho Data Integration tool.
-
Provide OData Services of MessageBird Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MessageBird by developing a WCF Service Application.
-
Natively Connect to PostgreSQL Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PostgreSQL. Leverage the native support for ODBC in PHP.
-
Analyze SAP SuccessFactors LMS Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP SuccessFactors LMS and visualize SAP SuccessFactors LMS in SAP Analytics Cloud.
-
Build Dashboards with Xero Data in DBxtra
Create dynamic dashboards and perform analytics based on Xero Accounting in DBxtra.
-
Integrating Claude Code CLI with Azure Synapse 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.
-
Getting Started with the CData ADO.NET Provider for SAP Business One
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Business One.
-
Automated Continuous Salesforce Marketing Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Google Cloud SQL.
-
Use Agno to Talk to Your Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Instagram for you.
-
Extract, Transform, and Load Productboard Data in Informatica PowerCenter
Create a simple Workflow for Productboard in Informatica PowerCenter.
-
Publish Freshsales-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshsales.
-
Create Power BI Reports on Real-Time Dotmailer Data
Use the CData ODBC Driver for Dotmailer to visualize Dotmailer in Power BI Desktop.
-
Integrate Live Confluence Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use ChatGPT to Talk to Your Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Atlassian Jira for you.
-
Integrate Landbot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Landbot with External Services.
-
Migrating data from Drift to Databricks using CData SSIS Components.
Easily push Drift to Databricks using the CData SSIS Tasks for Drift and Databricks.
-
Query, Visualize, and Share live Freshdesk Data in Redash
Use CData Connect AI to connect to live Freshdesk in Redash for querying, visualizing, and sharing.
-
Build an OLAP Cube in SSAS from Grafana Data
Establish a connection to Grafana data from SQL Server Analysis Services, and use the Grafana Data Provider to build OLAP cubes for use in analytics and reporting.
-
Extract, Transform, and Load Shippo Data in Informatica PowerCenter
Create a simple Workflow for Shippo in Informatica PowerCenter.
-
Prepare, Blend, and Analyze Sybase Data in Alteryx Designer (ODBC)
Build workflows to access live Sybase for self-service data analytics.
-
Create Dynamic Landbot Grids Using the Infragistics XamDataGrid
Learn how you can connect Landbot to Infragistics XamDataGrid to build dynamic grids.
-
Access SAP Business Warehouse Data from MySQL in PHP
Connect to SAP Business Warehouse through the standard MySQL libraries in PHP.
-
Automated Continuous HubDB Replication to MySQL
Use CData Sync for automated, continuous, customizable HubDB replication to MySQL.
-
Import Real-Time Wrike Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Wrike in ColdFusion.
-
Migrating data from GetResponse to Databricks using CData SSIS Components.
Easily push GetResponse to Databricks using the CData SSIS Tasks for GetResponse and Databricks.
-
Create Datasets from Azure Analysis Services in Domo Workbench and Build Visualizations of Azure Analysis Services Data in Domo
Use the CData Software ODBC Driver for Azure Analysis Services to create datasets from Azure Analysis Services in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Accelo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Accelo to connect to Accelo and execute queries in PowerBuilder.
-
Build SAP SuccessFactors-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP SuccessFactors to explore live SAP SuccessFactors Data in Gemini Code Assist to assist with building SAP SuccessFactors-powered applications.
-
Automated Continuous Mailgun Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mailgun replication to PostgreSQL.
-
Automate PayPal Data Replication to SAP HANA
Use CData Sync to customize and automate PayPal replication to SAP HANA.
-
How to Connect DBeaver to Harvest via a JDBC Driver
Manage Harvest with visual tools in DBeaver like the query browser.
-
Connect to Klaviyo Data in RazorSQL
Connect to Klaviyo from wizards and query Klaviyo from the GUI in the RazorSQL database management tool.
-
Access Live Highrise Data in AWS Lambda
Connect to live Highrise CRM in AWS Lambda using the CData JDBC Driver.
-
Connect to LightSpeedRetail Data in DBArtisan
Use wizards in DBArtisan to configure LightSpeedRetail as a data source.
-
Getting Started with the CData Python Connector for FreshBooks
Learn to install and license the CData Python Connector
-
Build Charts with ElevenLabs Data in Clear Analytics
Create dynamic charts and perform analytics based on ElevenLabs in Clear Analytics.
-
Use the CData ODBC Driver for Sentry in Microsoft Power Query
You can use the CData Sentry ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sentry into Microsoft Power Query.
-
Replicate Multiple SendPulse Accounts
Replicate multiple SendPulse accounts to one or many databases.
-
Connecting Agentforce with Elasticsearch Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Elasticsearch for you.
-
Connect to Klipfolio Data from a Connection Pool in Jetty
The Klipfolio JDBC Driver supports connection pooling: This article shows how to connect faster to Klipfolio from Web apps in Jetty.
-
Access Live Power BI XMLA Data in Excel 365 Online (Excel for the web)
Connect to Power BI XMLA from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Live OpenWeatherMap Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live OpenWeatherMap to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Visualize Act-On Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Act-On in Python.
-
Automated Continuous Lakebase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Lakebase replication to Google BigQuery.
-
How to connect PolyBase to Greenhouse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Greenhouse.
-
Consume Gmail OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Gmail feeds that reflect any changes in SAP Lumira.
-
Connect to Greenhouse 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 Greenhouse.
-
Automated Continuous Retently Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Retently replication to Amazon Redshift.
-
Build Visualizations of Drift Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Drift in Birst.
-
Import SAP Netweaver Gateway Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Netweaver Gateway. In this article, you will use the OData format to import SAP Netweaver Gateway into Microsoft Power Query.
-
Automate Google Drive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Drive from PowerShell? This article demonstrates how to utilize the Google Drive Cmdlets for tasks like connecting to Google Drive, automating operations, downloading data, and more.
-
Choosing the Best Method to Connect SAP SuccessFactors to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP SuccessFactors from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Trello Data in AWS Lambda
Connect to live Trello in AWS Lambda using the CData JDBC Driver.
-
Visualize WooCommerce Data in Sisense
Create an ElastiCube in Sisense app with access to WooCommerce.
-
Build Apps with Live Elasticsearch Data Using the Low-Code Development Platform of Mendix
Connect Elasticsearch with Mendix to build apps using the CData JDBC Driver for Elasticsearch.
-
Getting Started with the CData Power BI Connector for Splunk
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Splunk.
-
How to publish and share Cvent Data dashboards with Tableau Server
The CData ODBC driver for Cvent enables you integrate Cvent into Tableau dashboards.
-
Use the CData Software ODBC Driver for CampaignMonitor in MicroStrategy Desktop
Connect to CampaignMonitor in MicroStrategy Desktop using the CData Software ODBC Driver for CampaignMonitor.
-
Access Live PostgreSQL Data in Coginiti Pro
Connect to and query live PostgreSQL from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Microsoft Exchange Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Exchange into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Exchange in the Graph Builder and Query Builder.
-
Rapidly Develop Freshteam-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 Freshteam.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle SCM using the Model Context Protocol.
-
Analyze CSV Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of CSV/TSV Files and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to SingleStore Data from HeidiSQL
Use CData Connect AI to connect to and query live SingleStore from HeidiSQL.
-
Work with Moosend Data in FoxPro
Load Moosend into a FoxPro database. This article includes full code and a walk-through of the process.
-
Manage Act CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Act CRM.
-
Integrate with SharePoint Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft SharePoint to a JSON file on disk.
-
How to Connect Adobe Commerce 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 Adobe Commerce data in real time using natural language.
-
Create Dashboards and Visualize Live Bullhorn CRM Data in Geckoboard
Use CData Connect AI to connect to live Bullhorn CRM and create dashboards for real-time monitoring and visualization in Geckoboard.
-
DataBind Controls to ZendeskSell Data in C++Builder
DataBind to ZendeskSell in C++Builder with standard components and controls.