CData Software - Knowledge Base
Recent Articles
-
Connect to Workday from PowerBuilder via ADO.NET
This article demonstrates how to access Workday from Appeon PowerBuilder using the CData ADO.NET Provider for Workday.
-
DataBind Controls to DocuSign in C++Builder
DataBind to DocuSign in C++Builder with standard components and controls.
-
Easily Integrate Google Data Catalog in Lazarus Pascal IDE
Learn how to easily integrate live Google Data Catalog in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Greenhouse from PowerBuilder via ADO.NET
This article demonstrates how to access Greenhouse from Appeon PowerBuilder using the CData ADO.NET Provider for Greenhouse.
-
A PostgreSQL Interface for Microsoft OneDrive (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft OneDrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Access from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Access from HeidiSQL.
-
Analyze SingleStore with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SingleStore from Power Pivot. You will use the Table Import Wizard to load SingleStore. You can visually build the import query or use any SQL supported by the driver.
-
Create Data Visualizations in Cognos BI with Neo4J
Access Neo4J as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Creating Google Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Google Ads to Unqork and build custom business apps.
-
Connect Oracle SCM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle SCM using the CData Python MCP Server.
-
Use Dash to Build to Web Apps on Google Contacts
Create Python applications that use pandas and Dash to build Google Contacts-connected web apps.
-
Connect to Impala in Google Apps Script via SQL Gateway
Use the ODBC Driver for Impala and the SQL Gateway to access Apache Impala from Google Apps Script.
-
Query SAP as a MySQL Database in Node.js
Execute MySQL queries against SAP ERP/NetWeaver from Node.js.
-
Connect to Tableau CRM Analytics in RapidMiner
Integrate Tableau CRM Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SAP Fieldglass in Ruby
Connect to SAP Fieldglass in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Extract, Transform, and Load Microsoft Dataverse in Informatica PowerCenter
Create a simple Workflow for Microsoft Dataverse (CDS) in Informatica PowerCenter.
-
Connect to Shopify in DBArtisan
Use wizards in DBArtisan to configure Shopify as a data source.
-
Integrate Cursor with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Business ByDesign from within the editor.
-
Query Trello in DataGrip
Create a Data Source for Trello in DataGrip and use SQL to query live Trello.
-
How to connect to BigQuery with Squirrel SQL client
Connect to Google BigQuery and execute queries in the Squirrel SQL Client.
-
Automated Continuous SharePoint Excel Services Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to delimited files (CSV/TSV).
-
Automated Continuous Oracle Service Cloud Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to delimited files (CSV/TSV).
-
Act-On Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Act-On facts in real time.
-
Automated Continuous Xero Replication to SQL Server
Use CData Sync for automated, continuous, customizable Xero replication to SQL Server.
-
Publish Reports with Microsoft Project in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Project.
-
Operational Reporting on Oracle SCM from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle SCM.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Replicate Dropbox from PowerShell
Write a quick PowerShell script to query Dropbox. Use connectivity to the live data to replicate Dropbox to SQL Server.
-
Automate Tableau CRM Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tableau CRM Analytics from PowerShell? This article demonstrates how to utilize the Tableau CRM Analytics Cmdlets for tasks like connecting to Tableau CRM Analytics, automating operations, downloading data, and more.
-
Create Reports from Azure Table in Looker Studio
Use CData Connect AI to gain access to live Azure Table Storage and create custom reports in Looker Studio.
-
Connect Azure Analysis Services to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Analysis Services with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Splunk in Jaspersoft Studio
Execute SQL to remote Splunk in Jaspersoft Studio.
-
How to Connect to Live Google Drive 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 Google Drive for you.
-
Automated Continuous Google Spanner Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Spanner replication to Apache Kafka.
-
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Web
Connect to MariaDB in MicroStrategy Web using the CData Software JDBC Driver for MariaDB.
-
Load Gmail to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gmail to a database.
-
Automated Continuous Parquet Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Parquet replication to Amazon Redshift.
-
Build Data Flows from Google Cloud Storage to SQL Server using SSIS
Easily back up Google Cloud Storage to SQL Server using the SSIS components for Google Cloud Storage.
-
Use Manus AI to Talk to Your Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Search.
-
Publish Wave Financial-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Wave Financial.
-
Automated Continuous CockroachDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable CockroachDB replication to SingleStore.
-
Connect Odoo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Odoo with IBM WebSphere for seamless data integration and connectivity.
-
Access Amazon Athena from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Athena from HeidiSQL.
-
How to create an RPA flow for Microsoft Teams in UiPath Studio
Use the Microsoft Teams ODBC Driver to create workflows that access real-time Microsoft Teams without any coding.
-
How to Connect to & Open TaxJar in Microsoft Excel
This article uses the CData ODBC driver for TaxJar to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Seamlessly Import HCL Domino Data into IBM SPSS Modeler
Integrate HCL Domino data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Kintone in AWS Lambda (with IntelliJ IDEA)
Connect to live Kintone in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Using the CData Software ODBC Driver for Adobe Experience Manager in PyCharm
Connect to Adobe Experience Manager as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Experience Manager.
-
Import Real-Time Monday.com via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Monday.com in ColdFusion.
-
Automate Kafka Replication to Azure Synapse
Use CData Sync to customize and automate Apache Kafka replication to Azure Synapse.
-
Use Agno to Talk to Your Power BI XMLA 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 Power BI XMLA for you.
-
Connect to SAP Ariba Source from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Ariba Source to connect to SAP Ariba Source and execute queries in PowerBuilder.
-
Getting Started with the CData Power BI Connector for Todoist
-