CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Dynamics 365 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Google BigQuery.
-
How to Easily Query Opsgenie Data in OpenOffice Base
Connect to Opsgenie data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Getting Started with the CData Python Connector for Aha!
Learn to install and license the CData Python Connector and configure a connection to live Aha! data.
-
Create NetSuite-Connected Applications in Appsmith
Connect to NetSuite Data via CData Connect AI in Appsmith and create custom business applications with real-time access to NetSuite data.
-
Access Vault CRM Data from MySQL in Amazon QuickSight
Connect to Vault CRM and build visualizations of Vault CRM data using a MySQL Connection in Amazon QuickSight.
-
Analyze Drip Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Drip from Power Pivot. You will use the Table Import Wizard to load Drip data. You can visually build the import query or use any SQL supported by the driver.
-
Bridge TaxJar Connectivity with Apache NiFi
Access and process TaxJar data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to & Open Amplitude Data in Microsoft Excel
This article uses the CData ODBC driver for Amplitude to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with Billsby Data in DBxtra
Create dynamic dashboards and perform analytics based on Billsby data in DBxtra.
-
Feed SurveyMonkey Data into FineReport
How to set SurveyMonkey data as a JDBC data source in FineReport.
-
How to Work with Sybase IQ Data in ETL Validator JDBC
Connect to Sybase IQ from ETL Validator jobs using the CData Software JDBC Driver.
-
Add Exact Online Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Exact Online with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect and process Freshsales data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Freshsales data.
-
Integrating Kiro with SAP Business Warehouse 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.
-
Integrate with Lakebase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Lakebase data in SnapLogic.
-
Connect to Brex Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Brex.
-
How to publish and share SAP ByDesign Data dashboards with Tableau Server
The CData ODBC driver for SAP ByDesign enables you integrate SAP ByDesign data into Tableau dashboards.
-
Build Apps with Live Missive Data Using the Low-Code Development Platform of Mendix
Connect Missive data with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for Okta in MicroStrategy
Connect to Okta data in MicroStrategy Developer using the CData Software ODBC Driver for Okta.
-
Prepare, Blend, and Analyze Salesforce Data 360 Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce Data 360 data for self-service data analytics.
-
Build Elasticsearch-Connected Apps in Choreo
Use CData Connect AI to connect to Elasticsearch Data from Choreo and build custom apps using live Elasticsearch data.
-
Link PagerDuty with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PagerDuty data in Filemaker Pro for Mac or Windows.
-
Use JayDeBeApi to access MYOB AccountRight Data in Python
Use standard Python scripting and the development environment of your choice to access live MYOB AccountRight data.
-
Migrating data from Retently to Snowflake using CData SSIS Components.
Easily push Retently data to Snowflake using the CData SSIS Tasks for Retently and Snowflake.
-
Connect FreshBooks to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FreshBooks with IBM WebSphere for seamless data integration and connectivity.
-
How to Work with Pipedrive Data in ETL Validator JDBC
Connect to Pipedrive from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Epicor Kinetic Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Epicor Kinetic data using standard SQL.
-
How to connect to FormSite Data from Spring Boot
Connect to FormSite in a Spring Boot Application using the CData API Driver for JDBC
-
Build a Singer.io Tap for Productboard With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Productboard data using the CData Python Connector.
-
How to connect and process AfterShip data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live AfterShip data.
-
Getting Started with the CData JDBC Driver for Telegram
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Telegram.
-
Working with Salesforce CRM Analytics Data in LINQPad
Execute LINQ queries to Salesforce CRM Analytics data in LINQPad.
-
Build a Simple VCL Application for CampaignMonitor Data
How to build a simple VCL Application to view CampaignMonitor data in RAD Studio using the CData ODBC Driver for CampaignMonitor.
-
Build Charts with Foursquare Data in Clear Analytics
Create dynamic charts and perform analytics based on Foursquare data in Clear Analytics.
-
Use the CData Software JDBC Driver for Webex in MicroStrategy
Connect to Webex data in MicroStrategy Developer using the CData Software JDBC Driver for Webex.
-
Access Live Databricks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Databricks data into the statistical analysis tools available in SAS JMP. This article shows how to use Databricks data in the Graph Builder and Query Builder.
-
Rapidly Develop MessageBird-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by MessageBird.
-
How to create Snapchat Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Snapchat Ads data in MySQL .
-
Integrating GitHub Copilot with SAP ByDesign 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.
-
Build ZohoSubscriptions-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ZohoSubscriptions data and build ZohoSubscriptions-connected web apps with Axios.
-
Use the CData ODBC Driver for Autopilot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Autopilot to connect to Autopilot data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Autopilot data in Excel.
-
How to Access Live OData Services in Power Automate Desktop via ODBC
The CData ODBC Driver for OData enables you to integrate OData services into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Tableau Connector for ClickUp
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Back Up CouchDB data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CouchDB. In this article, we will employ an SSIS workflow to populate a database with CouchDB data data.
-
Connect to Testmonitor Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Testmonitor.
-
Validate LeadDesk Data with QuerySurge
Access and validate LeadDesk data in QuerySurge using the CData JDBC Driver.
-
How to connect to Qualaroo Data in DBVisualizer
Integrate Qualaroo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous PayPal Replication to MongoDB
Use CData Sync for automated, continuous, customizable PayPal replication to MongoDB.
-
Model Raisers Edge NXT Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Raisers Edge NXT, enabling the direct import of real-time Raisers Edge NXT data.
-
Query Dynamics NAV Data in ColdFusion
Write standard ColdFusion data access code to connect to Dynamics NAV data.
-
Work with SAP ByDesign Data in FoxPro
Load SAP ByDesign data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate ZohoInvoice Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZohoInvoice data replication to Azure Data Lake.
-
Automated Continuous Hacker News Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Hacker News replication to Amazon Redshift.
-
Integrate Monday.com Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Monday.com data from Informatica Cloud.
-
Import Real-Time Outlook Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Outlook data in ColdFusion.
-
Authorize.Net Reporting in OBIEE with the Authorize.Net JDBC Driver
Deploy the Authorize.Net JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Provide OData Services of Marketo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Marketo data by developing a WCF Service Application.
-
Create SAS xpt Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAS xpt from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to AdRoll Data in DBArtisan
Use wizards in DBArtisan to configure AdRoll data as a data source.
-
Build Facebook-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Facebook data.
-
Replicate SAP Concur Data to Multiple Databases
Replicate SAP Concur data to disparate databases with a point-and-click configuration.
-
How to create an RPA flow for Zoho Inventory Data in UiPath Studio
Use the Zoho Inventory ODBC Driver to create workflows that access real-time Zoho Inventory data without any coding.
-
How to publish and share Redis Data dashboards with Tableau Server
The CData ODBC driver for Redis enables you integrate Redis data into Tableau dashboards.
-
Create a Data Access Object for Freshteam Data using JDBI
A brief overview of creating a SQL Object API for Freshteam data in JDBI.
-
Explore Geographical Relationships in Wrike Data with Power Map
Create data visualizations with Wrike data in Power Map.
-
Integrating Claude Code CLI with Browserless 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.
-
Create Databricks Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Databricks from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Sage 300-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage 300 Data from OutSystems and build custom enterprise apps using live Sage 300 data.
-
Getting Started with the CData ADO.NET Provider for Act CRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Act CRM.
-
Integrate Bullhorn CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bullhorn CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bullhorn CRM data.
-
Connect to Jira Assets Data in RazorSQL
Connect to Jira Assets from wizards and query Jira Assets data from the GUI in the RazorSQL database management tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Moosend
Create Moosend data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Onfleet Data in CloverDX (formerly CloverETL)
Transfer Onfleet data using the visual workflow in the CloverDX data integration tool.
-
Load Google Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Ads data to a database.
-
Use Claude to Talk to Your BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your BigQuery data for you.
-
Working with Adobe Target Data in LINQPad
Execute LINQ queries to Adobe Target data in LINQPad.
-
Connect to and Visualize Live SingleStore Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SingleStore data.
-
Getting Started with the CData ADO.NET Provider for Okta
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Okta.
-
Build a PostgreSQL Interface for SuiteCRM Data using the CData JDBC Driver
Use the Remoting features of the SuiteCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Microsoft OneDrive Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft OneDrive from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft OneDrive data.
-
Connect to IBM Informix Data from PowerBuilder via JDBC
This article demonstrates how to access IBM Informix data from PowerBuilder using the IBM Informix JDBC Driver.
-
How to Connect Flowise AI Agents to Live Reckon Accounts Hosted Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Reckon Accounts Hosted data without replication.
-
Automated Continuous Instantly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Instantly replication to Azure SQL Database.
-
Link Opsgenie with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Opsgenie data in Filemaker Pro for Mac or Windows.
-
Connect to and Visualize Live Notion Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Notion data.
-
Use Azure AI Foundry to Talk to Your Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Spark data for you.
-
Use Databricks Agent Bricks to Talk to Your Lakebase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Lakebase data for you.
-
Automated Continuous Retently Replication to MySQL
Use CData Sync for automated, continuous, customizable Retently replication to MySQL.
-
Getting Started with the CData Power BI Connector for MongoDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MongoDB.
-
Integrating Webflow Data in Talend Cloud Data Management Platform
Connect Webflow Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Design BIRT Reports on Dynamics NAV Data
Provide current Dynamics NAV data to your embedded analytics.
-
Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy
Connect to Amazon Marketplace data in MicroStrategy Developer using the CData Software ODBC Driver for Amazon Marketplace.
-
Build Oracle HCM Cloud Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle HCM Cloud data and build visualizations in Tableau.
-
Connect to ZohoInvoice Data from a Connection Pool in Jetty
The ZohoInvoice JDBC Driver supports connection pooling: This article shows how to connect faster to ZohoInvoice data from Web apps in Jetty.
-
Create Dynamic Wistia Grids Using the Infragistics XamDataGrid
Learn how you can connect Wistia to Infragistics XamDataGrid to build dynamic grids.
-
Integrating GitHub Copilot with ClickUp 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.
-
Create Reports with Salesforce Data 360 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce Data 360 data.
-
Analyze PingOne Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PingOne data in Microsoft R Open.
-
Use the CData Software JDBC Driver for WordPress in MicroStrategy Web
Connect to WordPress data in MicroStrategy Web using the CData Software JDBC Driver for WordPress.
-
Design BIRT Reports on PostgreSQL Data
Provide current PostgreSQL data to your embedded analytics.