CData Software - Knowledge Base
Recent Articles
-
How to import HDFS Data into Apache Solr
Use the CData Software JDBC Driver for HDFS in Data Import Handler and create an automated import of Apache HDFS to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Python Connector for Outlook
Learn to install and license the CData Python Connector
-
Replicate Multiple NetSuite SuiteAnalytics Accounts via the CData Sync CLI
Replicate multiple NetSuite SuiteAnalytics accounts to one or many databases.
-
Create Informatica Mappings From/To an ODBC Data Source for Outlook
Create an ODBC connection to Outlook in Informatica and browse and transfer Outlook.
-
Use Biml to Build SSIS Tasks to Replicate FormSite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FormSite to SQL Server.
-
Automate PivotalTracker Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PivotalTracker from PowerShell? This article demonstrates how to utilize the PivotalTracker Cmdlets for tasks like connecting to PivotalTracker, automating operations, downloading data, and more.
-
Connect to TaxJar Data in CloverDX (formerly CloverETL)
Transfer TaxJar using the visual workflow in the CloverDX data integration tool.
-
Connect to CSV Data in RazorSQL
Connect to CSV from wizards and query CSV/TSV Files from the GUI in the RazorSQL database management tool.
-
Use Dash to Build to Web Apps on SAP HANA XS Advanced Data
Create Python applications that use pandas and Dash to build SAP HANA XS Advanced-connected web apps.
-
Connect to Salesforce Marketing Data from a Connection Pool in Jetty
The Salesforce Marketing JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Marketing Cloud from Web apps in Jetty.
-
Getting Started with the CData JDBC Driver for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for RabbitMQ.
-
Access Spotify Data from MySQL in Amazon QuickSight
Connect to Spotify and build visualizations of Spotify using a MySQL Connection in Amazon QuickSight.
-
Bidirectional Access to AlloyDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google AlloyDB in Filemaker Pro for Mac or Windows.
-
Build Semantic Layer Views for MySQL Data in APOS Live Data Gateway
Use the CData Connector for MySQL in APOS Live Data Gateway to build Semantic Layer Views for MySQL.
-
How to create Visio diagrams from CockroachDB Data
Automatically update CockroachDB with the changes you make to Visio master shapes.
-
Replicate Hive Data from PowerShell
Write a quick PowerShell script to query Apache Hive. Use connectivity to the live data to replicate Apache Hive to SQL Server.
-
Analyze HBase Data in Looker
Use CData Connect AI to connect to HBase Data from Looker and build custom apps using live Apache HBase.
-
Mode Reporting in OBIEE with the Mode JDBC Driver
Deploy the Mode JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Bitly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bitly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Creating YouTube Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed YouTube Analytics to Unqork and build custom business apps.
-
Connect to ZohoPeople Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoPeople using standard SQL.
-
How to Seamlessly Import Productboard Data into IBM SPSS Modeler
Integrate Productboard data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to create an RPA flow for Intercom Data in UiPath Studio
Use the Intercom ODBC Driver to create workflows that access real-time Intercom without any coding.
-
Object-Relational Mapping (ORM) with MailerLite 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 MailerLite into a Java-based ORM framework, Hibernate.
-
Automated Continuous AgileCRM Replication to SQLite
Use CData Sync for automated, continuous, customizable AgileCRM replication to SQLite.
-
Build AI/ML Models with Live Suadeo Data using Dataiku
Connect Suadeo Data with Dataiku using the CData JDBC Driver for Suadeo.
-
Automate Quickbase Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Quickbase and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Printify
Provide connectivity to Printify through an SAP BusinessObjects universe.
-
Analyze Dynamics CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dynamics CRM from Power Pivot. You will use the Table Import Wizard to load Microsoft Dynamics CRM. You can visually build the import query or use any SQL supported by the driver.
-
Use Databricks Agent Bricks to Talk to Your SQL Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SQL Analysis Services for you.
-
Build Dashboards with OpenWeatherMap Data in Dundas BI
Create dynamic dashboards and perform analytics based on OpenWeatherMap in Dundas BI.
-
How to create Power BI XMLA federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Power BI XMLA in MySQL .
-
Publish Crystal Reports on Mailgun Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mailgun.
-
Create Power BI Reports on Real-Time Reckon Data
Use the CData ODBC Driver for Reckon to visualize Reckon in Power BI Desktop.
-
Build Cvent-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Cvent and build Cvent-connected web apps with Axios.
-
Replicate Discord Data to Multiple Databases
Replicate Discord to disparate databases with a point-and-click configuration.
-
Connect to LaunchDarkly Data from a Connection Pool in JBoss
Integrate LaunchDarkly into Java servlets: Use the Management Console in JBoss to install the LaunchDarkly JDBC Driver.
-
Integrate Real-Time Access to SAP BusinessObjects BI in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP BusinessObjects BI in real time.
-
Access Live Sage Intacct Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Sage Intacct through MCP integration.
-
How to Create Power BI Visual Reports with Real-Time PingOne Data
Use CData Power BI Connectors to visualize PingOne in Power BI.
-
DataBind Controls to Monday.com Data in Delphi
DataBind to Monday.com in Delphi with standard data access components and controls.
-
Use Databricks Agent Bricks to Talk to Your Snowflake Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Snowflake for you.
-
Connect to Paymo 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 Paymo and work with Paymo in your FileMaker application.
-
Use Azure AI Foundry to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central for you.
-
Automated Amazon Marketplace Data Replication to Teradata
Use CData Sync to Customize and automate Amazon Marketplace replication to Teradata.
-
How to connect to AgileCRM Data in DBVisualizer
Integrate AgileCRM with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Smartsheet Data with Squirrel SQL client
Connect to Smartsheet and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on ZendeskSell Data
Create Python applications that use pandas and Dash to build ZendeskSell-connected web apps.
-
Bridge Freshservice Connectivity with Apache NiFi
Access and process Freshservice in Apache NiFi using the CData JDBC Driver.
-
Use the CData ODBC Driver for Mailjet in Microsoft Power Query
You can use the CData Mailjet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mailjet into Microsoft Power Query.
-
How to Connect to Telegram Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Telegram. Leverage the pyodbc module for ODBC in Python.
-
How to create an RPA flow for Microsoft Planner Data in UiPath Studio
Use the Microsoft Planner ODBC Driver to create workflows that access real-time Microsoft Planner without any coding.
-
Natively Connect to ZohoExpense Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoExpense. Leverage the native support for ODBC in PHP.
-
Access Live Redis Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Redis data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Provide OData Services of Short.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Short.io by developing a WCF Service Application.
-
Connect to Printify Data in CloverDX (formerly CloverETL)
Transfer Printify using the visual workflow in the CloverDX data integration tool.
-
Build Visualizations of Instantly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Instantly in Birst.
-
Import Square Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Square Data and provide access to live Square for custom reports in the Power BI Service.
-
Getting Started with the CData SSIS Components for Google Tasks
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Tasks.
-
Automated Continuous Salesforce Pardot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Google Cloud SQL.
-
Deploy the ADO.NET Provider for MongoDB on an SSRS Report Server
Connect to MongoDB from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Live SAP ByDesign Data in MicroStrategy through CData Connect AI
Create a live connection to SAP ByDesign Data in CData Connect AI and connect to your SAP Business ByDesign from MicroStrategy.
-
Integrate ZarMoney Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZarMoney from Informatica Cloud.
-
Integrate with SAP Concur Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Concur in SnapLogic.
-
Getting Started with the CData Excel Add-In for Pingdom
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pingdom.
-
Integrating GitHub Copilot CLI with ChartMogul 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.
-
Getting Started with the CData Python Connector for SAS Data Sets
Learn to install and license the CData Python Connector
-
Feed FreshBooks Data into FineReport
How to set FreshBooks as a JDBC data source in FineReport.
-
How to Connect DBeaver to Sendwithus via a JDBC Driver
Manage Sendwithus with visual tools in DBeaver like the query browser.
-
Integrate LDAP Objects in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LDAP from Informatica Cloud.
-
Query SQL Analysis Services Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SQL Analysis Services from Node.js.
-
How to Connect to Reply.io Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reply.io. Leverage the pyodbc module for ODBC in Python.
-
Build Visualizations of Autopilot Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Autopilot in Birst.
-
Integrate Open WebUI with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Salesforce Pardot from within the chat interface.
-
Connect to Live Power BI XMLA Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Power BI XMLA in CData Connect AI and connect to your Power BI XMLA from PostgreSQL.
-
Query Gmail Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Gmail from Node.js.
-
Build a PostgreSQL Interface for Hive Data using the CData JDBC Driver
Use the Remoting features of the Hive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for Tavily in PyCharm
Connect to Tavily as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tavily.
-
Connect to Freshdesk from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Freshdesk, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to ZohoPeople Data in DBVisualizer
Integrate ZohoPeople with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Oracle Sales-Connected Business Apps in AppSheet
Connect to Oracle Sales Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Sales.
-
Object-Relational Mapping (ORM) with Microsoft Entra ID 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 Microsoft Entra ID into a Java-based ORM framework, Hibernate.
-
Build PostgreSQL-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PostgreSQL.
-
Access LightSpeedRetail Data from MySQL in PHP
Connect to LightSpeedRetail through the standard MySQL libraries in PHP.
-
Create SSAS Tabular Models from Neo4J Data
How to build a SQL Server Analysis Service Tabular Model from Neo4J using CData drivers.
-
Build JDBC-ODBC Bridge-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live JDBC-ODBC Bridge.
-
Connect to Real-Time Splunk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Splunk and Dataflow to import and use Splunk in Power Apps.
-
Automated BenchmarkEmail Data Replication to Teradata
Use CData Sync to Customize and automate BenchmarkEmail replication to Teradata.
-
Replicate GetResponse Data from PowerShell
Write a quick PowerShell script to query GetResponse. Use connectivity to the live data to replicate GetResponse to SQL Server.
-
Automated Continuous Zoho CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Amazon Redshift.
-
Integrating Antigravity CLI with Nuclia via CData CLI
Connect Nuclia to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Landbot Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Landbot using standard SQL.
-
Connect to Coinbase Data in HULFT Integrate
Connect to Coinbase as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To a JDBC Data Source for Kintone
Create Kintone data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Google Contacts-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Contacts Data and create custom apps in Bubble.
-
How to connect to ServiceDesk Plus Data from Spring Boot
Connect to ServiceDesk Plus in a Spring Boot Application using the CData API Driver for JDBC
-
How to publish and share JobNimbus Data dashboards with Tableau Server
The CData ODBC driver for JobNimbus enables you integrate JobNimbus into Tableau dashboards.
-
Connect to MarkLogic Data in RazorSQL
Connect to MarkLogic from wizards and query MarkLogic from the GUI in the RazorSQL database management tool.
-
Connect to FHIR Data from PowerBuilder via ADO.NET
This article demonstrates how to access FHIR from Appeon PowerBuilder using the CData ADO.NET Provider for FHIR.
-
Import Real-Time Pushbullet Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pushbullet in ColdFusion.