CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Printify in Domo Workbench and Build Visualizations of Printify in Domo
Use the CData Software ODBC Driver for Printify to create datasets from Printify in Domo Workbench and then build visualizations in the Domo service.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage Cloud Accounting
Provide connectivity to Sage Business Cloud Accounting through an SAP BusinessObjects universe.
-
How to Connect DBeaver to Adobe Target via a JDBC Driver
Manage Adobe Target with visual tools in DBeaver like the query browser.
-
Automated Continuous Facebook Replication to MongoDB
Use CData Sync for automated, continuous, customizable Facebook replication to MongoDB.
-
Consume HubSpot OData Feeds in PowerBuilder
This article demonstrates how to consume HubSpot as OData feeds from PowerBuilder using the API Server.
-
Build a PostgreSQL Interface for SAP Concur using the CData JDBC Driver
Use the Remoting features of the SAP Concur JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Import Data from Confluence into Google Sheets
Import Atlassian Confluence into a Google spreadsheet that is automatically refreshed.
-
Building Dynamic Web Pages with Oracle Sales Using AngularJS
Create single-page applications with live connectivity to Oracle Sales using the CData API Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP HANA XS Advanced
Provide connectivity to SAP HANA XS Advanced through an SAP BusinessObjects universe.
-
How to Work with Twilio in AWS Glue Jobs Using JDBC
Connect to Twilio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Odoo through ODBC in Node.js
Use node-odbc to execute SQL queries against Odoo ERP from Node.js.
-
Back Up Google BigQuery to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for BigQuery. In this article, we will employ an SSIS workflow to populate a database with Google BigQuery data.
-
Create Apps from ActiveCampaign in Qlik Sense Cloud
Use CData Connect AI to connect to ActiveCampaign and build apps from live ActiveCampaign in Qlik Sense Cloud.
-
Use ChatGPT to Talk to Your Adobe Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Adobe Analytics for you.
-
Add Coinbase to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Coinbase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Exact Online in ACL Analytics
Connect to Exact Online via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Exact Online.
-
Access Google Spanner from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Spanner from HeidiSQL.
-
Migrating data from SurveyMonkey to Snowflake using CData SSIS Components.
Easily push SurveyMonkey to Snowflake using the CData SSIS Tasks for SurveyMonkey and Snowflake.
-
Analyze Paylocity in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Paylocity in Microsoft R Open.
-
Work with Live Reckon in Power Query
Use CData Connect AI to connect to Reckon and work with live Reckon in Microsoft Power Query.
-
Prepare, Blend, and Analyze SAP Concur in Alteryx Designer (Connect AI)
Build workflows to access live SAP Concur for self-service data analytics.
-
Build Data Flows from SAP Netweaver Gateway to SQL Server using SSIS
Easily back up SAP Netweaver Gateway to SQL Server using the SSIS components for SAP Netweaver Gateway.
-
How to connect to SAP Business One from Spring Boot
Connect to SAP Business One in a Spring Boot Application using CData JDBC SAP Business One Driver
-
Connect to Adobe Analytics as an External Source in Dremio
Use the CData JDBC Driver to connect to Adobe Analytics as an External Source in Dremio.
-
Build MVC Applications with Connectivity to SAP ByDesign
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP ByDesign from an ASP.NET MVC application.
-
Connecting GenSpark with FHIR via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Access Live Amazon Marketplace in Coginiti Pro
Connect to and query live Amazon Marketplace from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Building Dynamic Web Pages with Asana Using AngularJS
Create single-page applications with live connectivity to Asana using the CData API Server.
-
Build a PostgreSQL Interface for Google Campaign Manager 360 using the CData JDBC Driver
Use the Remoting features of the Google Campaign Manager 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Azure Table in AWS Glue Jobs Using JDBC
Connect to Azure Table from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Adobe Analytics in Aqua Data Studio
Access Adobe Analytics from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Google Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Analytics replication to Apache Kafka.
-
Create SAP Ariba Source-Connected Dashboards in Grafana
Connect to SAP Ariba Source via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Ariba Source.
-
Automate Google Search Results Replication to Couchbase
Use CData Sync to Customize and automate Google Search replication to Couchbase.
-
Rapidly Develop IBM Informix-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.
-
Connect to and Visualize Live Dynamics CRM in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics CRM.
-
How to connect to Couchbase in DBVisualizer
Integrate Couchbase with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Biml to Build SSIS Tasks to Replicate TaxJar to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate TaxJar to SQL Server.
-
Integrate Microsoft Planner into Power Automate Desktop using CData Connect
CData Connect for Microsoft Planner enables you to integrate Microsoft Planner into workflows built using Microsoft Power Automate Desktop.
-
Build Voice Agents in ElevenLabs with access to Live Facebook Ads
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Facebook Ads.
-
How to Visualize Amazon Marketplace Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon Marketplace in Python.
-
Bridge Klaviyo Connectivity with Apache NiFi
Access and process Klaviyo in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Kintone in a Connection Pool in Tomcat
Connect to Kintone from a connection pool in Tomcat.
-
Access Live OData Services in AWS Lambda
Connect to live OData in AWS Lambda using the CData JDBC Driver.
-
DataBind Controls to Dropbox in C++Builder
DataBind to Dropbox in C++Builder with standard components and controls.
-
How to use SQLAlchemy ORM to access Cloudant in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Cloudant.
-
How to Work with WooCommerce in ETL Validator JDBC
Connect to WooCommerce from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Pinterest from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pinterest to connect to Pinterest from Web applications running on WebLogic.
-
Getting Started with the CData JDBC Driver for Email
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Email.
-
Build an OLAP Cube in SSAS from Google Drive
Establish a connection to Google Drive data from SQL Server Analysis Services, and use the Google Drive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Working with Raisers Edge NXT in LINQPad
Execute LINQ queries to Raisers Edge NXT in LINQPad.
-
Analyze SFTP with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SFTP from Power Pivot. You will use the Table Import Wizard to load SFTP. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect the Power BI Service to PayPal: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to Connect to & Open Microsoft Teams in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Teams to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Build an ETL App for Cassandra in Python with CData
Create ETL applications and real-time data pipelines for Apache Cassandra in Python with petl.
-
Automate SingleStore Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SingleStore from PowerShell? This article demonstrates how to utilize the SingleStore Cmdlets for tasks like connecting to SingleStore, automating operations, downloading data, and more.
-
Operational Reporting on Oracle Service Cloud from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Service Cloud.
-
Use Agno to Talk to Your Jira Service Management 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 Atlassian Jira Service Management for you.
-
Automate Excel Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Excel replication to SAP HANA.
-
Visualize Live MySQL in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MySQL into custom reports in Power BI.
-
Getting Started with the CData PowerShell Cmdlets for Amazon Athena
-