CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Zoho Projects on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Projects.
-
Build MariaDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MariaDB.
-
Connect to HCL Domino in Aqua Data Studio
Access HCL Domino from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Consume Klipfolio OData Feeds in PowerBuilder
This article demonstrates how to consume Klipfolio as OData feeds from PowerBuilder using the API Server.
-
Build Data Flows from Coinbase to SQL Server using SSIS
Easily back up Coinbase to SQL Server using the SSIS components for Coinbase.
-
Connect Oracle Financials Cloud to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Financials Cloud with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to Google Directory from Spring Boot
Connect to Google Directory in a Spring Boot Application using CData JDBC Google Directory Driver
-
Connect to CockroachDB in Google Apps Script via Connect AI
Use CData Connect AI to access CockroachDB in Google Apps Script.
-
Create Bitbucket Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build OneNote-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for OneNote and create custom apps in Bubble.
-
Integrate with live Elasticsearch in Jitterbit
Use CData Connect AI to connect to and integrate live Elasticsearch in Jitterbit.
-
Automated Continuous Paylocity Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Paylocity replication to Amazon Redshift.
-
Connect to Azure Analysis Services in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Analysis Services in the Denodo Virtual DataPort Administrator.
-
Access Live Paylocity in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Paylocity through MCP integration.
-
Query SAP ByDesign in DataGrip
Create a Data Source for SAP ByDesign in DataGrip and use SQL to query live SAP Business ByDesign.
-
Excel Spreadsheet Automation on Slack with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to & Open Zoho Projects in Microsoft Excel
This article uses the CData ODBC driver for Zoho Projects to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Validate HDFS with QuerySurge
Access and validate Apache HDFS in QuerySurge using the CData JDBC Driver.
-
Model Google Contacts Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Contacts, enabling the direct import of real-time Google Contacts.
-
Connect to Oracle HCM Cloud in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle HCM Cloud in the Denodo Virtual DataPort Administrator.
-
Choosing the Best Method to Connect Klipfolio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Klipfolio from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
A PostgreSQL Interface for IBM Informix (MySQL Remoting via JDBC)
Use the Remoting features of the IBM Informix JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to Epicor Kinetic via a JDBC Driver
Manage Epicor Kinetic with visual tools in DBeaver like the query browser.
-
Integrate with live Stripe in Jitterbit
Use CData Connect AI to connect to and integrate live Stripe in Jitterbit.
-
Integrating LangGraph with Microsoft Dataverse via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dataverse (CDS) within automated workflows.
-
Use Microsoft Copilot Studio to talk to your Google Sheets via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Sheets for you.
-
Analyze Sugar CRM with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sugar CRM from Power Pivot. You will use the Table Import Wizard to load Sugar CRM. You can visually build the import query or use any SQL supported by the driver.
-
Bridge Spark Connectivity with Apache NiFi
Access and process Apache Spark SQL in Apache NiFi using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time SAP Business One
Use CData Power BI Connectors to visualize SAP Business One in Power BI.
-
Connect to Real-Time Basecamp Data in Power Apps Using Dataflows to Build Custom Applications
-