CData Software - Knowledge Base
Recent Articles
-
Create a Data Access Object for MarkLogic Data using JDBI
A brief overview of creating a SQL Object API for MarkLogic data in JDBI.
-
How to Connect Basecamp Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Basecamp data in real time using natural language.
-
Automate NetSuite SuiteAnalytics Data Replication to SAP HANA
Use CData Sync to customize and automate NetSuite SuiteAnalytics data replication to SAP HANA.
-
How to Connect to Live Salesforce Pardot Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Salesforce Pardot data for you.
-
Load Snowflake Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Snowflake data to a database.
-
Automate Teradata Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teradata data replication to Azure Data Lake.
-
Integrate Live Apify Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Apify from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apify data.
-
Publish AdRoll-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live AdRoll data.
-
Back Up Airtable data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Airtable. In this article, we will employ an SSIS workflow to populate a database with Airtable data data.
-
How to create an RPA flow for PostgreSQL Data in UiPath Studio
Use the PostgreSQL ODBC Driver to create workflows that access real-time PostgreSQL data without any coding.
-
Integrate Live Everhour Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Everhour data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Build an ETL App for Shortcut Data in Python with CData Connect AI
Extract and transform live Shortcut data in Python with petl and the CData Connect AI Python SDK.
-
Object-Relational Mapping (ORM) with Sage 300 Data 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 Sage 300 data into a Java-based ORM framework, Hibernate.
-
Create SAP Ariba Source-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Ariba Source Data from Klipfolio and build custom visualizations using live SAP Ariba Source data.
-
Integrate ZohoInvoice Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoInvoice data from Informatica Cloud.
-
Build eBay Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live eBay Analytics data.
-
How to load Google Calendar data into Elasticsearch via Logstash
Introducing a simple method to load Google Calendar data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to Cohere Data with Squirrel SQL client
Connect to Cohere data and execute queries in the Squirrel SQL Client.
-
Connect to Bannerbear Data in DBArtisan
Use wizards in DBArtisan to configure Bannerbear data as a data source.
-
Access Live HCL Domino Data in AWS Lambda (with IntelliJ IDEA)
Connect to live HCL Domino data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to DB2 Data in JRuby
Create a simple JRuby app with access to live DB2 data.
-
Connect to Perigon Data in CloverDX (formerly CloverETL)
Transfer Perigon data using the visual workflow in the CloverDX data integration tool.
-
Connect to Gong Data in RazorSQL
Connect to Gong from wizards and query Gong data from the GUI in the RazorSQL database management tool.
-
How to Connect to Bugsnag Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bugsnag data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect DBeaver to NASA via a JDBC Driver
Manage NASA data with visual tools in DBeaver like the query browser.
-
Getting Started with the CData ADO.NET Provider for Greenhouse
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Greenhouse.
-
Integrate with RSS Feeds using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy RSS feeds to a JSON file on disk.
-
How to integrate Metabase with Greenplum Data
Use CData Connect AI to connect to live Greenplum data and create an interactive dashboard in Metabase from Greenplum data.
-
How to Seamlessly Import Sage 300 Data into IBM SPSS Modeler
Integrate Sage 300 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData ADO.NET Provider for MarkLogic
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MarkLogic.
-
Build Semantic Layer Views for Exact Online Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Exact Online data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Ontraport
Provide connectivity to Ontraport data through an SAP BusinessObjects universe.
-
Migrating data from eBay to Google BigQuery using CData SSIS Components.
Easily push eBay data to Google BigQuery using the CData SSIS Tasks for eBay and Google BigQuery.
-
Integrate Mailjet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mailjet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mailjet data.
-
Connect and Visualize Live Quickbase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Quickbase data into the Databricks platform and create visualization dashboards with real-time Quickbase data.
-
Replicate WooCommerce Data to Multiple Databases via the CData Sync CLI
Replicate WooCommerce data to disparate databases with a single configuration.
-
Connect to SageHR Data from PowerBuilder via ADO.NET
This article demonstrates how to access SageHR data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze Live Procore Data in SAS Viya
Use CData Connect AI to connect to Procore data from SAS Viya and deploy self-service analytics using live Procore data.
-
How to connect PolyBase to Reply.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reply.io data.
-
Manage MarkLogic Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MarkLogic.
-
How to Connect to Live Snapchat Ads Data 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 Snapchat Ads data for you.
-
How to use SQLAlchemy ORM to access Azure Table Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Table data.
-
Visualize Live Apify Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apify data.
-
Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy Web
Connect to SQL Analysis Services data in MicroStrategy Web using the CData Software ODBC Driver for SQL Analysis Services.
-
Automated Continuous Brex Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Brex replication to AlloyDB.
-
How to Build an ETL App for Reckon Data in Python with CData Connect AI
Build ETL pipelines that read and write live Reckon data in Python with petl and the CData Connect AI Python SDK.
-
Publish Reports with Zoom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoom data.
-
Integrate Missive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Missive data from Informatica Cloud.
-
Connect to Strava Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Strava and the SQL Gateway to access Strava data from Google Apps Script.
-
Getting Started with the CData Excel Add-In for eBay
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for eBay.
-
Manage Planio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Planio.
-
Automated Continuous Perplexity Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Perplexity data replication to OneLake in Microsoft Fabric.
-
Use the CData SSIS Components to Insert New or Update Existing eBay Records from SQL Server
Easily push SQL Server data to eBay using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into eBay or update existing records with data from a SQL Server database.
-
Enable the Yelp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Yelp data.
-
Integrate Smartsheet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Smartsheet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Smartsheet data.
-
Visualize GitHub Data in Sisense
Create an ElastiCube in Sisense app with access to GitHub data.
-
Create Act CRM-Connected Business Apps in AppSheet
Connect to Act CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Act CRM data.
-
Connect to Amazon Marketplace from Asprova with CData Software ODBC Driver for Amazon Marketplace
This article shows how to connect faster to Amazon Marketplace data from Asprova.
-
Build an OLAP Cube in SSAS from Sage 200 Data
Establish a connection to Sage 200 data data from SQL Server Analysis Services, and use the Sage 200 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Building Dynamic Web Pages with SAP Concur Data Using AngularJS
Create single-page applications with live connectivity to SAP Concur using the CData API Server.
-
Connect to and Query SparkPost Data in QlikView over ODBC
Create data visualizations with SparkPost data in QlikView.
-
How to Work with Placid Data in ETL Validator JDBC
Connect to Placid from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Teamgate Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Teamgate data. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for ZohoExpense in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoExpense data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoExpense.
-
Connect to GitHub Data in Ruby
Connect to GitHub data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous GraphQL Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GraphQL data replication to OneLake in Microsoft Fabric.
-
Easily Integrate ADP Data in Lazarus Pascal IDE
Learn how to easily integrate live ADP data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build a PostgreSQL Interface for Optimizely Data using the CData JDBC Driver
Use the Remoting features of the Optimizely JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live MYOB AccountRight Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your MYOB AccountRight data for you.
-
Publish Reports with Odoo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Odoo data.
-
Create Informatica Mappings From/To a JDBC Data Source for RabbitMQ
Create RabbitMQ data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live Google Spanner Data in the Power BI Service
Use CData Connect AI to connect to live Google Spanner data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Wave Financial to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Wave Financial with IBM WebSphere for seamless data integration and connectivity.
-
Query Miro Data as a MySQL Database in Node.js
Execute MySQL queries against Miro data from Node.js.
-
Smartsheet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Smartsheet facts in real time.
-
Visualize Blackbaud FE NXT Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Blackbaud FE NXT data.
-
How to Build an ETL App for Google Contacts Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Contacts data in Python with petl and the CData Connect AI Python SDK.
-
How to connect to SendInBlue Data with Squirrel SQL client
Connect to SendInBlue data and execute queries in the Squirrel SQL Client.
-
Connect to Pingdom Data in Jaspersoft Studio
Execute SQL to remote Pingdom data in Jaspersoft Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Gmail
Create Gmail data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Reports with MariaDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MariaDB data.
-
Connect to BenchmarkEmail Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live BenchmarkEmail data.
-
Migrating data from Google Sheets to Snowflake using CData SSIS Components.
Easily push Google Sheets data to Snowflake using the CData SSIS Tasks for Google Sheets and Snowflake.
-
Connecting Agentforce with Shopify Data 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 Shopify data for you.
-
Build MVC Applications with Connectivity to DB2 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access DB2 from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for Accelo in MicroStrategy Desktop
Connect to Accelo data in MicroStrategy Desktop using the CData Software ODBC Driver for Accelo.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Xero
Provide connectivity to Xero data through an SAP BusinessObjects universe.
-
Create Dashboards and Visualize Live SAS xpt Data in Geckoboard
Use CData Connect AI to connect to live SAS xpt data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Ontraport Data in CloverDX (formerly CloverETL)
Transfer Ontraport data using the visual workflow in the CloverDX data integration tool.
-
Publish Sage 200-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage 200 data.
-
Analyze Reckon Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Reckon data and visualize Reckon data in SAP Analytics Cloud.
-
How to publish and share Blackbaud FE NXT Data dashboards with Tableau Server
The CData ODBC driver for Blackbaud FE NXT enables you integrate Blackbaud FE NXT data into Tableau dashboards.
-
Connecting Moonlit Workflow with Act-On Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Act-On data in real time.
-
Excel Spreadsheet Automation on Google Ad Manager Data with the QUERY Formula
Pull data from Google Ad Manager, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Facebook Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Facebook replication to Google BigQuery.
-
Connecting GenSpark with ADP Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ADP data without any replication or custom integration required.
-
How to Connect to Live PolarTeamPro Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your PolarTeamPro data through natural language.
-
Automated Continuous Eventbrite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Eventbrite replication to Apache Cassandra.
-
Visualize XML Data in Tableau
The CData ODBC driver for XML enables you integrate XML data into Tableau dashboards.
-
How to connect to Jumpseller Data in DBVisualizer
Integrate Jumpseller data with visual data analysis tools and data connection wizards in DBVisualizer