CData Software - Knowledge Base
Recent Articles
-
Process & Analyze Qualaroo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Qualaroo Data.
-
Automated Continuous Insightly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Insightly replication to Amazon S3.
-
Load NASA Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load NASA to a database.
-
Connect Ontraport Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Ontraport using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Missive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Missive in the Denodo Virtual DataPort Administrator.
-
Connect to Couchbase Data in CloverDX (formerly CloverETL)
Transfer Couchbase using the visual workflow in the CloverDX data integration tool.
-
Build a PostgreSQL Interface for ZohoMarketingHub Data using the CData JDBC Driver
Use the Remoting features of the ZohoMarketingHub JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Import Data from Bitbucket into Google Sheets
Import Bitbucket into a Google spreadsheet that is automatically refreshed.
-
Migrating data from Confluence to Snowflake using CData SSIS Components.
Easily push Atlassian Confluence to Snowflake using the CData SSIS Tasks for Confluence and Snowflake.
-
Automated Continuous Pingdom Replication to Databricks
Use CData Sync for automated, continuous, customizable Pingdom replication to Databricks.
-
Automated Continuous Salesforce Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesforce replication to Apache Cassandra.
-
Connect to ServiceNow Data in Ruby
Connect to ServiceNow in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Boomi Agentstudio with Google Contacts Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Contacts, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to SFTP Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SFTP in the Denodo Virtual DataPort Administrator.
-
Process & Analyze Factorial Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Factorial Data.
-
Integrate LibreChat with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Analysis Services from within the chat interface.
-
Build Hive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Hive.
-
Stream REST Data into Apache Kafka Topics
Access and stream REST in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Google Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Analytics from Node.js.
-
Automated Continuous Zoho Creator Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho Creator replication to AlloyDB.
-
How to Create Power BI Visual Reports with Real-Time Eventbrite Data
Use CData Power BI Connectors to visualize Eventbrite in Power BI.
-
How to Connect the Power BI Service to Pipeline CRM: Complete Guide
Connect to the CData Software Power BI Connector for Pipeline CRM from PowerBI.com to provide real-time Pipeline CRM across the organization.
-
Create SSAS Tabular Models from QuickBooks Online Data
How to build a SQL Server Analysis Service Tabular Model from QuickBooks Online using CData drivers.
-
Automated Continuous MySQL Replication to Snowflake
Use CData Sync for automated, continuous, customizable MySQL replication to Snowflake.
-
Access MessageBird Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MessageBird from HeidiSQL.
-
Model, Search, and Visualize Live Oracle SCM Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle SCM for modeling, searching, and visualizing.
-
Use Biml to Build SSIS Tasks to Replicate Retently Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Retently to SQL Server.
-
How to Connect to Live Excel Online 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 Microsoft Excel Online for you.
-
Automated Continuous SAP Business One Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Business One replication to Azure SQL Database.
-
Use the CData ODBC Driver for ClickTime from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ClickTime to connect to ClickTime from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ClickTime in Excel.
-
Integrate Procore with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Procore with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Procore.
-
Build Dashboards with Klaviyo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Klaviyo in Dundas BI.
-
Replicate Everhour Data in Heroku for Use in Salesforce Connect
Replicate Everhour to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for Humanity in MicroStrategy
Connect to Humanity in MicroStrategy Developer using the CData Software JDBC Driver for Humanity.
-
Integrate Clari with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Clari with External Services.
-
Build Data Flows from PagerDuty to SQL Server using SSIS
Easily back up PagerDuty to SQL Server using the SSIS components for PagerDuty.
-
How to Connect to Live Pipedrive Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Pipedrive without replication.
-
Connect to Zoho Books Data in CloverDX (formerly CloverETL)
Transfer Zoho Books using the visual workflow in the CloverDX data integration tool.
-
Connect to Auth0 Data in HULFT Integrate
Connect to Auth0 as a JDBC data source in HULFT Integrate
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Act-On using the Model Context Protocol.
-
How to work with ConvertKit Data in Apache Spark using SQL
Access and process ConvertKit Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Delighted Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Delighted replication to PostgreSQL.
-
Explore Geographical Relationships in Notion Data with Power Map
Create data visualizations with Notion in Power Map.
-
Integrate HelloSign Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HelloSign from Informatica Cloud.
-
Establish a Live Connection with Instantly Data using Tableau Bridge
The CData ODBC Driver for Instantly enables you to integrate live Instantly into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create Visio diagrams from Act-On Data
Automatically update Act-On with the changes you make to Visio master shapes.
-
Natively Connect to Mode Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mode. Leverage the native support for ODBC in PHP.
-
Create Dashboards and Visualize Live FHIR Data in Geckoboard
Use CData Connect AI to connect to live FHIR and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Migrating data from Postmark to Google BigQuery using CData SSIS Components.
Easily push Postmark to Google BigQuery using the CData SSIS Tasks for Postmark and Google BigQuery.
-
Building Dynamic Web Pages with Adobe Commerce Data Using AngularJS
Create single-page applications with live connectivity to Adobe Commerce using the CData API Server.
-
Access Live BigCommerce Data 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 BigCommerce through MCP integration.
-
Connect to ZohoExpense Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZohoExpense and work with ZohoExpense in your FileMaker application.
-
Create a Data Access Object for ZohoMarketingHub Data using JDBI
A brief overview of creating a SQL Object API for ZohoMarketingHub in JDBI.
-
Connect to Teamgate Data from a Connection Pool in JBoss
Integrate Teamgate into Java servlets: Use the Management Console in JBoss to install the Teamgate JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Smartsheet
Provide connectivity to Smartsheet through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for GitLab
Create an ODBC connection to GitLab in Informatica and browse and transfer GitLab.
-
Access Pushbullet Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Pushbullet.
-
How to Access IBM Informix Data Using Entity Framework
This article shows how to access IBM Informix using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Edit and Search ADP External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of ADP to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create ADP objects that you can access from apps and the dashboard.
-
Connect to TaxJar Data in DBArtisan
Use wizards in DBArtisan to configure TaxJar as a data source.
-
Build Dashboards with Cohere Data in DBxtra
Create dynamic dashboards and perform analytics based on Cohere in DBxtra.
-
Build Active Directory-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Active Directory.
-
Replicate Multiple SharePoint Excel Services Accounts
Replicate multiple SharePoint Excel Services accounts to one or many databases.
-
How to Access Live CSV Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CSV enables you to integrate CSV/TSV Files into workflows built using Microsoft Power Automate Desktop.
-
Analyze Oracle Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Oracle Database and visualize live Oracle Database in Infragistics Reveal.
-
How to Query Live Jodoo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Jodoo data in natural language using Python.
-
Automate Amazon Marketplace Data Replication to Azure Synapse
Use CData Sync to customize and automate Amazon Marketplace replication to Azure Synapse.
-
Integrate Microsoft Entra ID Data in the Pentaho Report Designer
Publish reports based on Microsoft Entra ID in the Pentaho BI tool.
-
Integrate ShipEngine Data in Pentaho Data Integration
Build ETL pipelines based on ShipEngine in the Pentaho Data Integration tool.
-
Connect to Real-Time Active Directory Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Active Directory and Dataflow to import and use Active Directory in Power Apps.
-
How to use SQLAlchemy ORM to access SageHR Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SageHR.
-
Query SAP ByDesign Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Business ByDesign from Node.js.
-
Access SAS Data Sets Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAS Data Sets from your Oracle system.
-
Automate Google Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Analytics from PowerShell? This article demonstrates how to utilize the Google Analytics Cmdlets for tasks like connecting to Google Analytics, automating operations, downloading data, and more.
-
ETL Zoom in Oracle Data Integrator
This article shows how to transfer Zoom into a data warehouse using Oracle Data Integrator.
-
Connect to Snapchat Ads Data in Google Apps Script via Connect AI
Use CData Connect AI to access Snapchat Ads in Google Apps Script.
-
Use Databricks Agent Bricks to Talk to Your SurveyMonkey Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SurveyMonkey for you.
-
Automated Continuous Bannerbear Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bannerbear replication to MongoDB.
-
Query Oracle Financials Cloud Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Financials Cloud.
-
Build Data Flows from Klaviyo to SQL Server using SSIS
Easily back up Klaviyo to SQL Server using the SSIS components for Klaviyo.
-
Connect to Oracle Eloqua Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Eloqua as an External Source in Dremio.
-
Access Live Grafana Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Grafana in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Establish a Live Connection with Brex Data using Tableau Bridge
The CData ODBC Driver for Brex enables you to integrate live Brex into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Real-Time Google Search Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Search and Dataflow to import and use Google Search in Power Apps.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live QuickBooks Time within intelligent workflows.
-
Connect Freshservice to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Freshservice with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Spark 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 Apache Spark SQL for you.
-
Bridge Guru Connectivity with Apache NiFi
Access and process Guru in Apache NiFi using the CData JDBC Driver.
-
Connect Avaza to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Avaza with IBM WebSphere for seamless data integration and connectivity.
-
How to connect SharePoint with Act CRM Data through external lists
Provide Act CRM to SharePoint users as an external list.
-
Manage Jodoo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Jodoo.
-
How to create an RPA flow for Keap Data in UiPath Studio
Use the Keap ODBC Driver to create workflows that access real-time Keap without any coding.
-
Automated Continuous QuickBooks Time Replication to MySQL
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to MySQL.
-
Connect to Sugar CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sugar CRM using standard SQL.
-
Bridge GraphQL Connectivity with Apache NiFi
Access and process GraphQL in Apache NiFi using the CData JDBC Driver.
-
Query ZohoExpense Data in DataGrip
Create a Data Source for ZohoExpense in DataGrip and use SQL to query live ZohoExpense.
-
A PostgreSQL Interface for Freshteam Data using the CData ODBC Driver
Use the SQL Gateway and Freshteam ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Query Live Dynamics CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Dynamics CRM into Databricks
-
Build Hive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apache Hive and build Hive-connected web apps with Axios.
-
Publish BenchmarkEmail-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live BenchmarkEmail.