CData Software - Knowledge Base
Recent Articles
-
Automated Continuous HDFS Replication to Snowflake
Use CData Sync for automated, continuous, customizable HDFS replication to Snowflake.
-
Connect to Google Contacts in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to create an RPA flow for Greenhouse in UiPath Studio
Use the Greenhouse ODBC Driver to create workflows that access real-time Greenhouse without any coding.
-
Explore Geographical Relationships in FTP with Power Map
Create data visualizations with FTP Servers in Power Map.
-
Visualize Live Excel Online in the Power BI Service
Use CData Connect AI to connect to live Microsoft Excel Online and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect DBeaver to QuickBooks Time via a JDBC Driver
Manage QuickBooks Time with visual tools in DBeaver like the query browser.
-
Automated Continuous Vertica Replication to SingleStore
Use CData Sync for automated, continuous, customizable Vertica replication to SingleStore.
-
Connect to Google Search Results from PowerBuilder via JDBC
This article demonstrates how to access Google Search from PowerBuilder using the Google Search JDBC Driver.
-
ETL Cloudant in Oracle Data Integrator
This article shows how to transfer IBM Cloudant into a data warehouse using Oracle Data Integrator.
-
How to Query Live Certinia Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Certinia data in natural language using Python.
-
Visualize PostgreSQL from Tableau
Use the Tableau Desktop business intelligence tool to connect to PostgreSQL.
-
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.
-
Connect to Bitbucket in DBeaver
Use the CData ODBC Driver to connect to Bitbucket in DBeaver.
-
Build Data Flows from Paylocity to SQL Server using SSIS
Easily back up Paylocity to SQL Server using the SSIS components for Paylocity.
-
Visualize PayPal in TIBCO Spotfire through ADO.NET
Integrate PayPal into dashboards in TIBCO Spotfire.
-
Integrating Dataiku with SAP ByDesign via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Business ByDesign.
-
Create WooCommerce Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Azure Data Lake Storage-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Data Lake Storage and build Azure Data Lake Storage-connected web apps with Axios.
-
Trigger Access IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Airtable
Create an ODBC connection to Airtable in Informatica and browse and transfer Airtable.
-
Automate SAP ByDesign Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Business ByDesign and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Boomi Agentstudio with SendGrid via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SendGrid, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Oracle HCM Cloud in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle HCM Cloud from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build a PostgreSQL Interface for Amazon Marketplace using the CData JDBC Driver
Use the Remoting features of the Amazon Marketplace JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Snapchat Ads in SnapLogic
Use CData Connect AI to connect to and integrate with live Snapchat Ads in SnapLogic.
-
A PostgreSQL Interface for SharePoint Excel Services using the CData ODBC Driver
Use the SQL Gateway and SharePoint Excel Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to HDFS via a JDBC Driver
Manage Apache HDFS with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Python Connector for Vault CRM
Learn to install and license the CData Python Connector
-
How to update LDAP from Excel
This article explains how to transfer data from Excel to LDAP using the Excel Add-In for LDAP.
-
ETL Microsoft Dataverse in Oracle Data Integrator
This article shows how to transfer Microsoft Dataverse (CDS) into a data warehouse using Oracle Data Integrator.
-
Integrating Dataiku with Asana via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Asana.
-
Automated Continuous Drip Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Drip replication to IBM DB2.
-
Build a PostgreSQL Interface for Avalara AvaTax using the CData JDBC Driver
Use the Remoting features of the Avalara AvaTax JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Bullhorn CRM Accounts via the CData Sync CLI
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
How to publish and share Unbounce dashboards with Tableau Server
The CData ODBC driver for Unbounce enables you integrate Unbounce into Tableau dashboards.
-
Viewing MYOB AccountRight in RAD Studio Data Explorer
How to view MYOB AccountRight in RAD Studio Data Explorer using the CData ODBC Driver for MYOB AccountRight.
-
Connect to ConstantContact in DBArtisan
Use wizards in DBArtisan to configure ConstantContact as a data source.
-
Access Live Microsoft Exchange Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Exchange data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Object-Relational Mapping (ORM) with Google Calendar Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Calendar into a Java-based ORM framework, Hibernate.
-
Connect to Azure Synapse from AWS Glue
Use CData Connect AI to gain access to live Azure Synapse from your AWS Glue jobs.
-
Connect to Google Drive in DBeaver
Use the CData ODBC Driver to connect to Google Drive in DBeaver.
-
Connect to and Visualize Live Twilio in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Twilio.
-
Access Live Zendesk in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zendesk from your Google Sheets.
-
How to Connect to & Open Amazon S3 in Microsoft Excel
This article uses the CData ODBC driver for Amazon S3 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Kintone Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Kintone replication to IBM DB2.
-
Automated Continuous Procore Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Procore replication to Google Cloud SQL.
-
How to connect PolyBase to Authorize.Net
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Authorize.Net.
-
Transfer Company File Data using the CData Excel Add-In
This article shows how to use the CData Excel Add-In for QuickBooks to transfer data from one company file to another. You will use the Excel Add-In to manage multiple connections and transfer customer records from one company file to another.
-
Connect to Coinbase from Asprova with CData Software ODBC Driver for Coinbase
This article shows how to connect faster to Coinbase data from Asprova.
-
Integrating LangGraph with Google Campaign Manager 360 via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Campaign Manager 360 within automated workflows.
-
How to integrate Metabase with Couchbase
Use CData Connect AI to connect to live Couchbase and create an interactive dashboard in Metabase from Couchbase.
-
Import Azure Synapse into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Azure Synapse. In this article, you will use the OData format to import Azure Synapse into Microsoft Power Query.
-
Create SSAS Tabular Models from SuiteCRM
How to build a SQL Server Analysis Service Tabular Model from SuiteCRM using CData drivers.
-
How to Connect to Live WooCommerce from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your WooCommerce for you.
-
Build Automated SAP SuccessFactors-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP SuccessFactors and build automated workflows in Zapier.
-
Automated Continuous SAP ByDesign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to delimited files (CSV/TSV).
-
Query SAP BusinessObjects BI through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP BusinessObjects BI from Node.js.
-
How to work with Exact Online in Apache Spark using SQL
Access and process Exact Online in Apache Spark using the CData Software JDBC Driver.
-
How to connect to Acumatica from IntelliJ
Integrate connectivity to Acumatica ERP with wizards in IntelliJ.
-
Build Azure Synapse-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure Synapse and create custom apps in Mendix.
-
Build Dashboards with Dropbox in DBxtra
Create dynamic dashboards and perform analytics based on Dropbox in DBxtra.
-
How to Work with ShipStation in AWS Glue Jobs Using JDBC
Connect to ShipStation from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Sybase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sybase.
-
Use ChatGPT to Talk to Your Splunk via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Splunk for you.
-
Extend Google Sheets with IBM Cloud Object Storage
Make calls to the API Server from Google Apps Script.
-
Automated Continuous SingleStore Replication to MySQL
Use CData Sync for automated, continuous, customizable SingleStore replication to MySQL.
-
Create Dynamic SAS Data Sets Grids Using the Infragistics XamDataGrid
Learn how you can connect SAS Data Sets to Infragistics XamDataGrid to build dynamic grids.
-
Create Dashboards and Visualize Live Amazon DynamoDB in Geckoboard
Use CData Connect AI to connect to live Amazon DynamoDB and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build MVC Applications with Connectivity to Azure Active Directory
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Active Directory from an ASP.NET MVC application.
-
Visualize SAS xpt from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAS XPORT.
-
Add JDBC-ODBC Bridge to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JDBC-ODBC Bridge with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData ODBC Driver for Paylocity from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Paylocity to connect to Paylocity from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Paylocity in Excel.
-
Replicate HBase in Heroku for Use in Salesforce Connect
Replicate Apache HBase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate with Jira Assets using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jira Assets to a JSON file on disk.
-
Stream SAS xpt into Apache Kafka Topics
Access and stream SAS XPORT in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a PostgreSQL Interface for Coinbase using the CData JDBC Driver
Use the Remoting features of the Coinbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Easily Query SAS xpt in OpenOffice Base
-