CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load GitLab Data in Informatica PowerCenter
Create a simple Workflow for GitLab data in Informatica PowerCenter.
-
Visualize Live RSS Feeds of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live RSS feeds using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Mailjet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mailjet data with the CData JDBC Driver for Mailjet.
-
Prepare, Blend, and Analyze BigQuery Data in Alteryx Designer (Connect AI)
Build workflows to access live BigQuery data for self-service data analytics.
-
Object-Relational Mapping (ORM) with Sybase 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 Sybase data into a Java-based ORM framework, Hibernate.
-
Build GetResponse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live GetResponse data.
-
Build Apps with Live Lakebase Data Using the Low-Code Development Platform of Mendix
Connect Lakebase data with Mendix to build apps using the CData JDBC Driver for Lakebase.
-
Create Dynamic Instagram Grids Using the Infragistics XamDataGrid
Learn how you can connect Instagram to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Productboard Data in Aqua Data Studio
Access Productboard data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Design BIRT Reports on HubSpot Data
Provide current HubSpot data to your embedded analytics.
-
Configure the CData JDBC Driver for Brex in a Connection Pool in Tomcat
Connect to Brex data from a connection pool in Tomcat.
-
How to Connect the Power BI Service to Datadog: Complete Guide
Connect to the CData Software Power BI Connector for Datadog from PowerBI.com to provide real-time Datadog data across the organization.
-
Connect to and Query Opsgenie Data in QlikView over ODBC
Create data visualizations with Opsgenie data in QlikView.
-
Automated Continuous Productboard Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Productboard replication to IBM DB2.
-
Build Visualizations of Reckon Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Reckon data in Birst.
-
Automated Continuous Helpscout Replication to MongoDB
Use CData Sync for automated, continuous, customizable Helpscout replication to MongoDB.
-
Easily Integrate Adobe Target Data in Lazarus Pascal IDE
Learn how to easily integrate live Adobe Target data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Samanage Data from Crystal Reports
Use CData Connect AI to connect to and report on live Samanage data from Crystal Reports.
-
Connect to Wave Financial Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Wave Financial data.
-
Build Semantic Layer Views for Mistral AI Data in APOS Live Data Gateway
Use the CData Connector for Mistral AI in APOS Live Data Gateway to build Semantic Layer Views for Mistral AI data.
-
Integrate SAP HANA XS Advanced Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP HANA XS Advanced data from Informatica Cloud.
-
Automated Continuous Nuclia Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Nuclia data replication to OneLake in Microsoft Fabric.
-
Integrating Codex with Scrapfly data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Access ADP Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ADP data from your Oracle system.
-
Integrating Boomi Agentstudio with Discord Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Discord data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Act-On Data from PowerShell
Write a quick PowerShell script to query Act-On data. Use connectivity to the live data to replicate Act-On data to SQL Server.
-
Automate ServiceNow Data Replication to SAP HANA
Use CData Sync to customize and automate ServiceNow data replication to SAP HANA.
-
Load Google Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Analytics data to a database.
-
Integrate Facebook Data into Power Automate Desktop using CData Connect
CData Connect for Facebook Data enables you to integrate Facebook data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous ZohoInvoice Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Vertica.
-
Use Biml to Build SSIS Tasks to Replicate Dynamics 365 Business Central Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dynamics 365 Business Central data to SQL Server.
-
Build a PostgreSQL Interface for Cloudflare Data using the CData JDBC Driver
Use the Remoting features of the Cloudflare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Load Exa Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Exa data to a database.
-
Build Apps with Live Cvent Data Using the Low-Code Development Platform of Mendix
Connect Cvent data with Mendix to build apps using the CData JDBC Driver for Cvent.
-
Automated Continuous Wave Financial Replication to SQL Server
Use CData Sync for automated, continuous, customizable Wave Financial replication to SQL Server.
-
Build Agents in Relevance AI with Access to Live Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Notion data within intelligent agent workflows.
-
Use ChatGPT to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Ads data for you.
-
Connect to Apify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Apify.
-
Back Up Beeminder data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Beeminder data data.
-
How to Connect to Live Lakebase 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 Lakebase data for you.
-
Integrating OpenCode with Zoho Creator data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
How to publish and share Snapchat Ads Data dashboards with Tableau Server
The CData ODBC driver for Snapchat Ads enables you integrate Snapchat Ads data into Tableau dashboards.
-
Analyze Microsoft Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Ads data and visualize live Microsoft Ads data in Infragistics Reveal.
-
Integrate Live ConstantContact Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ConstantContact data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating Cursor with Azure Table Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to ChartMogul Data from PowerBuilder via ADO.NET
This article demonstrates how to access ChartMogul data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Object-Relational Mapping (ORM) with Outreach.io 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 Outreach.io data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData JDBC Driver for Webflow
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Webflow.
-
Use the CData ODBC Driver for SparkPost in Microsoft Power Query
You can use the CData SparkPost ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SparkPost data into Microsoft Power Query.
-
Integrate SAS xpt Data into Power Automate Desktop using CData Connect
CData Connect for SAS xpt Data enables you to integrate SAS xpt data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to & Open Apollo Data in Microsoft Excel
This article uses the CData ODBC driver for Apollo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Google's Vertex AI Agent with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Cassandra data within intelligent workflows.
-
How to import Excel Online Data into Apache Solr
Use the CData Software JDBC Driver for Excel Online in Data Import Handler and create an automated import of Excel Online data to Apache Solr Enterprise Search platform.
-
Process & Analyze Parquet Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Parquet Data.
-
Create PolarTeamPro-Connected Applications in Appsmith
Connect to PolarTeamPro Data via CData Connect AI in Appsmith and create custom business applications with real-time access to PolarTeamPro data.
-
Migrating data from Box to Snowflake using CData SSIS Components.
Easily push Box data to Snowflake using the CData SSIS Tasks for Box and Snowflake.
-
Use the CData Software JDBC Driver for Couchbase in MicroStrategy Web
Connect to Couchbase data in MicroStrategy Web using the CData Software JDBC Driver for Couchbase.
-
Connect to Mode Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mode data.
-
Getting Started with the CData ODBC Driver for Clari
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Clari.
-
Automated Continuous Google Tasks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Tasks replication to Amazon Redshift.
-
SendInBlue Reporting in OBIEE with the SendInBlue JDBC Driver
Deploy the SendInBlue JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Intercom Data in Pentaho Data Integration
Build ETL pipelines based on Intercom data in the Pentaho Data Integration tool.
-
Connect to Google Directory Data in Ruby
Connect to Google Directory data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating ConstantContact Data in Talend Cloud Data Management Platform
Connect ConstantContact Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Pushbullet Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pushbullet data replication to OneLake in Microsoft Fabric.
-
Integrating Cursor with Placid Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Automated Salesforce Pardot Data Replication to Teradata
Use CData Sync to Customize and automate Salesforce Pardot data replication to Teradata.
-
Visualize Neo4J Data in Sisense
Create an ElastiCube in Sisense app with access to Neo4J data.
-
Import Real-Time SharePoint Excel Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SharePoint Excel Services data in ColdFusion.
-
Create SSAS Tabular Models from Wrike Data
How to build a SQL Server Analysis Service Tabular Model from Wrike data using CData drivers.
-
Getting Started with the CData Python Connector for Reckon
Learn to install and license the CData Python Connector and configure a connection to live Reckon data.
-
Automated Continuous Tanda Replication to Databricks
Use CData Sync for automated, continuous, customizable Tanda replication to Databricks.
-
Connect to Jira Data in ACL Analytics
Connect to Jira data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Jira data.
-
How to create an RPA flow for Todoist Data in UiPath Studio
Use the Todoist ODBC Driver to create workflows that access real-time Todoist data without any coding.
-
Create Datasets from SQL Analysis Services in Domo Workbench and Build Visualizations of SQL Analysis Services Data in Domo
Use the CData Software ODBC Driver for SQL Analysis Services to create datasets from SQL Analysis Services data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect DBeaver to GetResponse via a JDBC Driver
Manage GetResponse data with visual tools in DBeaver like the query browser.
-
Import Real-Time Intercom Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Intercom data in ColdFusion.
-
Migrating data from Redshift to Google BigQuery using CData SSIS Components.
Easily push Redshift data to Google BigQuery using the CData SSIS Tasks for Redshift and Google BigQuery.
-
DataBind Controls to Jodoo Data in Delphi
DataBind to Jodoo data in Delphi with standard data access components and controls.
-
Analyze OneNote Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze OneNote data in Microsoft R Open.
-
Connect to Hubstaff Data from a Connection Pool in Jetty
The Hubstaff JDBC Driver supports connection pooling: This article shows how to connect faster to Hubstaff data from Web apps in Jetty.
-
Build SAP Concur-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Concur data.
-
Connect to SQL Analysis Services Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SQL Analysis Services data from Filemaker Pro on Mac.
-
Automate Bright Data Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bright Data data from PowerShell? This article demonstrates how to utilize the Bright Data Cmdlets for tasks like connecting to Bright Data data, automating operations, downloading data, and more.
-
Analyze FreeAgent Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FreeAgent from Power Pivot. You will use the Table Import Wizard to load FreeAgent data. You can visually build the import query or use any SQL supported by the driver.
-
Manage Sage Cloud Accounting Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sage Cloud Accounting.
-
Connect to Zoho Inventory Data in Aqua Data Studio
Access Zoho Inventory data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Dynamic VWO Grids Using the Infragistics XamDataGrid
Learn how you can connect VWO to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Basecamp Data in Alteryx Designer (Connect AI)
Build workflows to access live Basecamp data for self-service data analytics.
-
Import Real-Time Highrise Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Highrise data in ColdFusion.
-
Query Raisers Edge NXT Data in DataGrip
Create a Data Source for Raisers Edge NXT in DataGrip and use SQL to query live Raisers Edge NXT data.
-
Analyze Suadeo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Suadeo data in Microsoft R Open.
-
Query Wave Financial Data in ColdFusion
Write standard ColdFusion data access code to connect to Wave Financial data.
-
Visualize Redshift Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Redshift data.
-
Migrating data from SAP HANA to Google BigQuery using CData SSIS Components.
Easily push SAP HANA data to Google BigQuery using the CData SSIS Tasks for SAP HANA and Google BigQuery.
-
How to connect to Amazon Marketplace Data in DBVisualizer
Integrate Amazon Marketplace data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Basecamp 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 Basecamp data through MCP integration.
-
How to connect Amazon QuickSight to Gong Data
Create a connection to Gong data in CData Connect AI and insert Gong data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Microsoft Exchange Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Exchange and the SQL Gateway to access Microsoft Exchange data from Google Apps Script.
-
How to connect and process Attio data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Attio data.