CData Software - Knowledge Base
Recent Articles
-
Back Up IBM DB2 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for DB2. In this article, we will employ an SSIS workflow to populate a database with IBM DB2 data.
-
Connect to Freshdesk from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshdesk using standard SQL.
-
Build a PostgreSQL Interface for Google Cloud Storage using the CData JDBC Driver
Use the Remoting features of the Google Cloud Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access JSON Services from MySQL in Amazon QuickSight
Connect to JSON and build visualizations of JSON using a MySQL Connection in Amazon QuickSight.
-
Viewing Amazon S3 in RAD Studio Data Explorer
How to view Amazon S3 in RAD Studio Data Explorer using the CData ODBC Driver for Amazon S3.
-
Create Datasets from Aha in Domo Workbench and Build Visualizations of Aha in Domo
Use the CData Software ODBC Driver for Aha to create datasets from Aha! in Domo Workbench and then build visualizations in the Domo service.
-
Access Live SAP Fieldglass in Coginiti Pro
Connect to and query live SAP Fieldglass from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live Google Directory in the Power BI Service
Use CData Connect AI to connect to live Google Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
ETL Google Analytics in Oracle Data Integrator
This article shows how to transfer Google Analytics into a data warehouse using Oracle Data Integrator.
-
Back Up PayPal to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for PayPal. In this article, we will employ an SSIS workflow to populate a database with PayPal data.
-
Access Live Greenplum in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Pivotal GreenPlum from your Excel spreadsheets.
-
Connecting Agentforce with eBay 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 eBay for you.
-
Connect to Oracle Service Cloud in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Service Cloud in Airbyte.
-
Write a Simple Go Application to work with Coinbase on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Coinbase.
-
How to Connect DBeaver to Access via a JDBC Driver
Manage Microsoft Access with visual tools in DBeaver like the query browser.
-
Configure the CData JDBC Driver for Snowflake in a Connection Pool in Tomcat
Connect to Snowflake from a connection pool in Tomcat.
-
Bridge Zendesk Connectivity with Apache NiFi
Access and process Zendesk in Apache NiFi using the CData JDBC Driver.
-
Connect to Zuora through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zuora using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze Amazon Marketplace in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon Marketplace with the CData JDBC Driver for Amazon Marketplace.
-
Build Data Flows from Drip to SQL Server using SSIS
Easily back up Drip to SQL Server using the SSIS components for Drip.
-
How to connect to Power BI XMLA from Spring Boot
Connect to Power BI XMLA in a Spring Boot Application using CData JDBC Power BI XMLA Driver
-
Automated Continuous Tally Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tally replication to Azure SQL Database.
-
Feed QuickBooks Time into FineReport
How to set QuickBooks Time as a JDBC data source in FineReport.
-
Connect to Shippo in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shippo in the Denodo Virtual DataPort Administrator.
-
Natively Connect to Twitter in PHP
The CData ODBC driver for Twitter enables you to create PHP applications with connectivity to Twitter. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Spark from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Apache Spark SQL for you.
-
Create Datasets from Azure Data Lake Storage in Domo Workbench and Build Visualizations of Azure Data Lake Storage in Domo
Use the CData Software ODBC Driver for Azure Data Lake Storage to create datasets from Azure Data Lake Storage in Domo Workbench and then build visualizations in the Domo service.
-
Build Dashboards with Printify in DBxtra
Create dynamic dashboards and perform analytics based on Printify in DBxtra.
-
Create a Data Access Object for Workday using JDBI
A brief overview of creating a SQL Object API for Workday in JDBI.
-
How to connect and process Asana from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Asana.
-
ETL Google Directory in Oracle Data Integrator
This article shows how to transfer Google Directory into a data warehouse using Oracle Data Integrator.
-
How to Work with TaxJar in ETL Validator JDBC
Connect to TaxJar from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous CockroachDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CockroachDB replication to delimited files (CSV/TSV).
-
Trigger SharePoint IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Automated Continuous Google Spanner Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Spanner replication to OneLake in Microsoft Fabric.
-
Connect to Google Campaign Manager 360 in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Campaign Manager 360 in Airbyte.
-
Validate ServiceNow with QuerySurge
Access and validate ServiceNow in QuerySurge using the CData JDBC Driver.
-
Automated Continuous SAP Business One Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Business One replication to IBM DB2.
-
How to create Visio diagrams from Dynamics CRM
Automatically update Microsoft Dynamics CRM with the changes you make to Visio master shapes.
-
Write a Simple Go Application to work with SAP ByDesign on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Business ByDesign.
-
Access Live HubDB in AWS Lambda (with IntelliJ IDEA)
Connect to live HubDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Manage REST in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for REST.
-
Seamlessly Bring Zuora into Retool Using CData Connect AI
Integrate Zuora data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect to Trello from IntelliJ
Integrate connectivity to Trello with wizards in IntelliJ.
-
How to work with Google Ads in Apache Spark using SQL
Access and process Google Ads in Apache Spark using the CData Software JDBC Driver.
-
How to connect to Google Cloud Storage from IntelliJ
Integrate connectivity to Google Cloud Storage with wizards in IntelliJ.
-
Connect to Facebook in RapidMiner
Integrate Facebook with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate xBase Replication to Azure Data Lake
Use CData Sync to customize and automate xBase replication to Azure Data Lake.
-
Connect Azure Table to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Table with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Odoo in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Odoo ERP through MCP integration.
-
Create Data Visualizations in Cognos BI with IBM Informix
Access IBM Informix as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to ServiceNow from a Connection Pool in JBoss
Integrate ServiceNow into Java servlets: Use the Management Console in JBoss to install the ServiceNow JDBC Driver.
-
Automate Marketo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Marketo from PowerShell? This article demonstrates how to utilize the Marketo Cmdlets for tasks like connecting to Marketo, automating operations, downloading data, and more.
-
Integrating Boomi Agentstudio with Oracle SCM via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle SCM, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Quickbase as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Quickbase.
-
Integrating Shippo in Talend Cloud Data Management Platform
-