CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from Demio Data
How to build a SQL Server Analysis Service Tabular Model from Demio using CData drivers.
-
Create Dynamic Procore Grids Using the Infragistics XamDataGrid
Learn how you can connect Procore to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Jira Assets Replication to Vertica
Use CData Sync for automated, continuous, customizable Jira Assets replication to Vertica.
-
Viewing ZohoDesk Data in RAD Studio Data Explorer
How to view ZohoDesk in RAD Studio Data Explorer using the CData ODBC Driver for ZohoDesk.
-
Connect to NetSuite Data in HULFT Integrate
Connect to NetSuite as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ODBC Driver for Reckon
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Reckon.
-
Getting Started with the CData Excel Add-In for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BenchmarkEmail.
-
Import BambooHR Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to BambooHR Data and provide access to live BambooHR for custom reports in the Power BI Service.
-
Visualize Live Codat Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Codat.
-
Replicate Printful Data from PowerShell
Write a quick PowerShell script to query Printful. Use connectivity to the live data to replicate Printful to SQL Server.
-
Getting Started with the CData Tableau Connector for Productboard
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Access Live SAP ByDesign Data in Visual Studio Code via Cline
Run CData MCP Server for SAP ByDesign on Windows Subsytem for Linux (WSL) and connect to live SAP Business ByDesign from the Cline extension in Visual Studio Code.
-
Seamlessly Bring Phoenix Data into Retool Using CData Connect AI
Integrate Phoenix data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Microsoft OneDrive-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft OneDrive Data from Klipfolio and build custom visualizations using live Microsoft OneDrive.
-
Publish PagerDuty-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PagerDuty.
-
Publish Crystal Reports on Foursquare Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Foursquare.
-
Migrating data from Presto to Google BigQuery using CData SSIS Components.
Easily push Presto to Google BigQuery using the CData SSIS Tasks for Presto and Google BigQuery.
-
Analyze Twilio Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Twilio and visualize live Twilio in Infragistics Reveal.
-
Integrate with SAS xpt Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAS XPORT in SnapLogic.
-
Explore Geographical Relationships in QuickBooks Data with Power Map
Create data visualizations with QuickBooks Desktop in Power Map.
-
Publish Reports with SAP HANA Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP HANA.
-
DataBind Charts to Short.io Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Short.io from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer
Build workflows to access live Salesforce data for self-service data analytics.
-
Visualize Okta Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Okta.
-
How to connect and process Supabase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Supabase.
-
Explore Geographical Relationships in ConvertKit Data with Power Map
Create data visualizations with ConvertKit in Power Map.
-
Create Clockify Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Clockify from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Freshteam Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshteam to connect to Freshteam and execute queries in PowerBuilder.
-
Load EnterpriseDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load EnterpriseDB to a database.
-
Access MailerSend Data from MySQL in PHP
Connect to MailerSend through the standard MySQL libraries in PHP.
-
Automate Avaza Data Replication to SAP HANA
Use CData Sync to customize and automate Avaza replication to SAP HANA.
-
Automated Continuous Mode Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mode replication to PostgreSQL.
-
Visualize Reckon Data in Sisense
Create an ElastiCube in Sisense app with access to Reckon.
-
Connect to Drip Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Drip to connect to Drip and execute queries in PowerBuilder.
-
Connect to Dynamics 365 Business Central Data in Jaspersoft Studio
Execute SQL to remote Dynamics 365 Business Central in Jaspersoft Studio.
-
Automated Continuous BambooHR Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable BambooHR replication to Azure SQL Database.
-
Integrate with Clockify Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clockify to a JSON file on disk.
-
Integrating Codex CLI with Wave Financial 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 Supabase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Supabase as an External Source in Dremio.
-
Access CircleCI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CircleCI from HeidiSQL.
-
Connect to Amazon Athena Data in RazorSQL
Connect to Amazon Athena from wizards and query Amazon Athena from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Teradata in MicroStrategy
Connect to Teradata in MicroStrategy Developer using the CData Software ODBC Driver for Teradata.
-
Integrate with Elasticsearch Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Elasticsearch to a JSON file on disk.
-
Integrate PDFMonkey with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PDFMonkey with External Services.
-
Access Live SAP Hybris C4C Data in TIBCO Data Virtualization
Use the SAP Hybris C4C Tibco DV Adapter to create a SAP Hybris C4C data source in TIBCO Data Virtualization Studio and gain access to live SAP Hybris C4C from your TDV Server.
-
Create Apps from ADP Data in Qlik Sense Cloud
Use CData Connect AI to connect to ADP Data and build apps from live ADP in Qlik Sense Cloud.
-
Connect to AfterShip Data in Jaspersoft Studio
Execute SQL to remote AfterShip in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for BenchmarkEmail in SAS for Real-Time Reporting and Analytics
Connect to real-time BenchmarkEmail in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for BenchmarkEmail.
-
Query NetSuite Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume NetSuite entities in PHP by modeling them as objects.
-
Back Up Sybase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase. In this article, we will employ an SSIS workflow to populate a database with Sybase data.
-
Integrate Live CSV Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CSV from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live CSV/TSV Files.
-
Configure the CData JDBC Driver for Apify in a Connection Pool in Tomcat
Connect to Apify from a connection pool in Tomcat.
-
Access Live Superchat Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Superchat in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to work with Front Data in Apache Spark using SQL
Access and process Front Data in Apache Spark using the CData Software JDBC Driver.
-
Build Semantic Layer Views for Reckon Data in APOS Live Data Gateway
Use the CData Connector for Reckon in APOS Live Data Gateway to build Semantic Layer Views for Reckon.
-
Publish Active Directory-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Active Directory.
-
Integrating Boomi Agentstudio with Google Campaign Manager 360 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Campaign Manager 360, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Process & Analyze iContact Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live iContact Data.
-
Configure the CData JDBC Driver for Smartsheet in a Connection Pool in Tomcat
Connect to Smartsheet from a connection pool in Tomcat.
-
Integrate Live Snowflake Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Snowflake and integrate live Snowflake into apps built in Microsoft Power Apps.
-
Access Oracle Service Cloud Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle Service Cloud from your Oracle system.
-
How to publish and share Basecamp Data dashboards with Tableau Server
The CData ODBC driver for Basecamp enables you integrate Basecamp into Tableau dashboards.
-
Integrating GitHub Copilot CLI with Mouseflow 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.
-
Google Sheets Reporting in OBIEE with the Google Sheets JDBC Driver
Deploy the Google Sheets JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build MVC Applications with Connectivity to CSV Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CSV from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Web
Connect to Dynamics 365 Business Central in MicroStrategy Web using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Connect to Landbot Data in CloverDX (formerly CloverETL)
Transfer Landbot using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Parquet to Databricks using CData SSIS Components.
Easily push Apache Parquet to Databricks using the CData SSIS Tasks for Parquet and Databricks.
-
Replicate FreeAgent Data to Multiple Databases via the CData Sync CLI
Replicate FreeAgent to disparate databases with a single configuration.
-
Automated Continuous SparkPost Replication to MongoDB
Use CData Sync for automated, continuous, customizable SparkPost replication to MongoDB.
-
Connect to RSS Feeds in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Access Pinterest Data Using Entity Framework
This article shows how to access Pinterest using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build a Singer.io Tap for REST With the CData Python Connector
Learn how to easily build a Singer.io Tap for live REST data using
-
How to connect to Rebilly Data in DBVisualizer
Integrate Rebilly with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect the Power BI Service to Okta: Complete Guide
Connect to the CData Software Power BI Connector for Okta from PowerBI.com to provide real-time Okta across the organization.
-
Create DocuSign-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to DocuSign Data from OutSystems and build custom enterprise apps using live DocuSign.
-
Access Microsoft OneDrive 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 Microsoft OneDrive.
-
Add Chargebee Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Chargebee with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Airtable Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Automated Freshdesk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshdesk and build automated workflows in Zapier.
-
How to Query Live Outreach.io Data in Claude Desktop
Connect to and query live Outreach.io Data in Claude Desktop using CData MCP Server.
-
Use the CData Software JDBC Driver for Google Directory in MicroStrategy
Connect to Google Directory in MicroStrategy Developer using the CData Software JDBC Driver for Google Directory.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft OneDrive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft OneDrive.
-
Connect to BenchmarkEmail Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BenchmarkEmail to connect to BenchmarkEmail and execute queries in PowerBuilder.
-
Integrating Boomi Agentstudio with Reckon Accounts Hosted Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Reckon Accounts Hosted, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Reports with Twitter Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twitter Ads.
-
Analyze Zoho Creator Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho Creator and visualize Zoho Creator in SAP Analytics Cloud.
-
Manage ElevenLabs Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ElevenLabs.
-
Model, Search, and Visualize Live Azure Synapse Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Synapse for modeling, searching, and visualizing.
-
Access Shortcut Data from MySQL in PHP
Connect to Shortcut through the standard MySQL libraries in PHP.
-
How to Access Retently Data Using Entity Framework
This article shows how to access Retently using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate HDFS Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache HDFS replication to Azure Synapse.
-
Use Biml to Build SSIS Tasks to Replicate Invoiced Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Invoiced to SQL Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Anaplan to Power BI dashboards. Simply drag and drop Anaplan into data visuals on the Power BI canvas.
-
How to Connect to & Open Samanage Data in Microsoft Excel
This article uses the CData ODBC driver for Samanage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind Charts to Oracle Eloqua Reporting Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Eloqua Reporting from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
ETL Amazon S3 in Oracle Data Integrator
This article shows how to transfer Amazon S3 into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Teamgate Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teamgate replication to Snowflake.
-
Create a Data Access Object for Bitly Data using JDBI
A brief overview of creating a SQL Object API for Bitly in JDBI.
-
Connect to Microsoft Ads Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Ads in DBeaver.