CData Software - Knowledge Base
Recent Articles
-
Create Monday.com-Connected Applications in Appsmith
Connect to Monday.com via CData Connect AI in Appsmith and create custom business applications with real-time access to Monday.com.
-
Connect to Google Directory in Aqua Data Studio
Access Google Directory from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Feed Monday.com into FineReport
How to set Monday.com as a JDBC data source in FineReport.
-
Explore Geographical Relationships in Box with Power Map
Create data visualizations with Box in Power Map.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Elasticsearch
Provide connectivity to Elasticsearch through an SAP BusinessObjects universe.
-
Access SAS xpt from MySQL in PHP
Connect to SAS xpt through the standard MySQL libraries in PHP.
-
Add HCL Domino to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HCL Domino with the Informatica Enterprise Data Catalog to classify and organize data.
-
Extend Google Sheets with Azure Table
Make calls to the API Server from Google Apps Script.
-
How to Query MongoDB in MySQL Workbench
Execute MySQL queries against live MongoDB from MySQL Workbench.
-
Automated Continuous SAP Concur Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Concur replication to Azure SQL Database.
-
Build Semantic Layer Views for Reckon Accounts Hosted in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Reckon Accounts Hosted.
-
GitHub Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on GitHub facts in real time.
-
Connect to Gmail in Jaspersoft Studio
Execute SQL to remote Gmail in Jaspersoft Studio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Smartsheet within intelligent workflows.
-
Import HBase into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache HBase. In this article, you will use the OData format to import Apache HBase into Microsoft Power Query.
-
How to Connect to Live Oracle HCM Cloud Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle HCM Cloud securely in real time.
-
Automate Oracle HCM Cloud Replication to Couchbase
Use CData Sync to Customize and automate Oracle HCM Cloud replication to Couchbase.
-
How to Connect DBeaver to Google Campaign Manager 360 via a JDBC Driver
Manage Google Campaign Manager 360 with visual tools in DBeaver like the query browser.
-
Connect to Avro from a Connection Pool in WebLogic
Use the CData JDBC Driver for Avro to connect to Apache Avro from Web applications running on WebLogic.
-
Getting Started with the CData JDBC Driver for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle Eloqua.
-
Automate Zoho Creator Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Creator replication to Azure Synapse.
-
Create Dynamic Klaviyo Grids Using the Infragistics XamDataGrid
Learn how you can connect Klaviyo to Infragistics XamDataGrid to build dynamic grids.
-
Build Data Flows from Excel to SQL Server using SSIS
Easily back up Microsoft Excel to SQL Server using the SSIS components for Excel.
-
Natively Connect to Presto in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Presto. Leverage the native support for ODBC in PHP.
-
Model, Search, and Visualize Live Zoho Inventory in ThoughtSpot
Use CData Connect AI to connect to live Zoho Inventory for modeling, searching, and visualizing.
-
Analyze Zoho CRM in Looker
Use CData Connect AI to connect to Zoho CRM from Looker and build custom apps using live Zoho CRM.
-
Create Informatica Mappings From/To a JDBC Data Source for Todoist
Create Todoist data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sybase IQ
Provide connectivity to Sybase IQ through an SAP BusinessObjects universe.
-
Replicate Paylocity to Multiple Databases
Replicate Paylocity to disparate databases with a point-and-click configuration.
-
Automated Continuous Google Contacts Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Contacts replication to Vertica.
-
Build Automated Workflows with Live Microsoft Project in Workato
Use CData Connect AI to connect to live Microsoft Project and build automated workflows in Workato.
-
How to Import Data from Microsoft Exchange into Google Sheets
Import Microsoft Exchange into a Google spreadsheet that is automatically refreshed.
-
Excel Spreadsheet Automation on Cassandra with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Integrating Gumloop with Facebook via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Facebook within automated workflows.
-
How to Create Power BI Visual Reports with Real-Time Slack
Use CData Power BI Connectors to visualize Slack in Power BI.
-
Build Automated Workflows with Live MailChimp in Workato
Use CData Connect AI to connect to live MailChimp and build automated workflows in Workato.
-
Integrate with Live Snapchat Ads in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Snapchat Ads from the MuleSoft Anypoint Platform to integrate live Snapchat Ads into custom reports and dashboards.
-
Integrate Real-Time Access to Shippo in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Shippo in real time.
-
Build Google Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Ads and build visualizations in Tableau.
-
Build Dashboards with SAP HANA XS Advanced in Dundas BI
Create dynamic dashboards and perform analytics based on SAP HANA XS Advanced in Dundas BI.
-
Rapidly Develop Oracle SCM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Build Visualizations of EventBrite in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Eventbrite in Birst.
-
Use the CData Software ODBC Driver for Klipfolio in SAS for Real-Time Reporting and Analytics
Connect to real-time Klipfolio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Klipfolio.
-
Connect to LDAP Objects from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LDAP using standard SQL.
-
Create Power BI XMLA-Connected Nintex Workflows
Use CData Connect AI to connect to Power BI XMLA from Nintex Workflow Cloud and build custom workflows using live Power BI XMLA.
-
Perform Batch Operations with Kafka in Apache NiFi
Connect to Apache Kafka and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Planner.
-
Access Live SAP HANA in Excel 365 Online (Excel for the web)
Connect to SAP HANA from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Live Snapchat Ads 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 Snapchat Ads for you.
-
Connect to Reckon Accounts Hosted from a Connection Pool in Jetty
The Reckon Accounts Hosted JDBC Driver supports connection pooling: This article shows how to connect faster to Reckon Accounts Hosted from Web apps in Jetty.
-
Connect to Power BI XMLA from Asprova with CData Software ODBC Driver for Power BI XMLA
This article shows how to connect faster to Power BI XMLA data from Asprova.
-
Perform Batch Operations with YouTube Analytics in Apache NiFi
Connect to YouTube Analytics and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Provide OData Services of HubDB from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for HubDB by developing a WCF Service Application.
-
Easily Integrate Redshift in Lazarus Pascal IDE
Learn how to easily integrate live Amazon Redshift in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Work with Google Data Catalog in ETL Validator JDBC
Connect to Google Data Catalog from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to IBM Informix from HeidiSQL
Use CData Connect AI to connect to and query live IBM Informix from HeidiSQL.
-
Build CockroachDB-Connected Apps in Choreo
Use CData Connect AI to connect to CockroachDB from Choreo and build custom apps using live CockroachDB.
-
Replicate Sugar CRM to Multiple Databases
Replicate Sugar CRM to disparate databases with a point-and-click configuration.
-
Automated Continuous SurveyMonkey Replication to Oracle
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Oracle.
-
Connect to Sage Cloud Accounting in ACL Analytics
Connect to Sage Business Cloud Accounting via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage Business Cloud Accounting.
-
Visualize Live Zoho CRM of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live ShipStation in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ShipStation from your Google Sheets.
-
Create Oracle SCM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle SCM from OutSystems and build custom enterprise apps using live Oracle SCM.
-
Integrate LDAP Objects in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LDAP from Informatica Cloud.
-
Connect to Calendly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Calendly to connect to Calendly from Web applications running on WebLogic.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Adobe Commerce using the Model Context Protocol.
-
Create Power BI Reports on Real-Time Bing Ads
Use the CData ODBC Driver for Bing Ads to visualize Bing Ads in Power BI Desktop.
-
Automated Continuous ADP Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ADP replication to Azure SQL Database.
-
How to pipe SFTP to CSV in PowerShell
Use standard PowerShell cmdlets to access SFTP tables.
-
Replicate HubSpot to Multiple Databases
Replicate HubSpot to disparate databases with a point-and-click configuration.
-
Use JayDeBeApi to access Oracle in Python
Use standard Python scripting and the development environment of your choice to access live Oracle Database.
-
Use the CData ODBC Driver for Impala in Microsoft Power Query
You can use the CData Impala ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Impala into Microsoft Power Query.
-
Automated Continuous Jira Service Management Replication to SQL Server
Use CData Sync for automated, continuous, customizable Jira Service Management replication to SQL Server.
-
Replicate GitHub to Multiple Databases via the CData Sync CLI
Replicate GitHub to disparate databases with a single configuration.
-
How to Work with Bitbucket in AWS Glue Jobs Using JDBC
Connect to Bitbucket from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Easily Query Redshift in OpenOffice Base
-