CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for TaxJar in MicroStrategy Desktop
Connect to TaxJar in MicroStrategy Desktop using the CData Software JDBC Driver for TaxJar.
-
Integrate SAP HANA XS Advanced Data in the Pentaho Report Designer
Publish reports based on SAP HANA XS Advanced in the Pentaho BI tool.
-
Create Datasets from PhantomBuster in Domo Workbench and Build Visualizations of PhantomBuster Data in Domo
Use the CData Software ODBC Driver for PhantomBuster to create datasets from PhantomBuster in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Redis Data into Power Automate Desktop using CData Connect
CData Connect for Redis Data enables you to integrate Redis into workflows built using Microsoft Power Automate Desktop.
-
Back Up LinkedIn to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn. In this article, we will employ an SSIS workflow to populate a database with LinkedIn data.
-
Automated Continuous DB2 for i Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable DB2 for i replication to PostgreSQL.
-
Build Timely-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Timely and build web apps with connectivity to live Timely.
-
How to connect Amazon QuickSight to IBM Cloud Object Storage Data
Create a connection to IBM Cloud Object Storage in CData Connect AI and insert IBM Cloud Object Storage into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Reports with ConstantContact Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConstantContact.
-
How to load Azure Data Lake Storage data into Elasticsearch via Logstash
Introducing a simple method to load Azure Data Lake Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Databricks-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Databricks Data from Klipfolio and build custom visualizations using live Databricks.
-
Connect to Bitly Data in DBeaver
Use the CData ODBC Driver to connect to Bitly in DBeaver.
-
Migrating data from Yelp to Snowflake using CData SSIS Components.
Easily push Yelp to Snowflake using the CData SSIS Tasks for Yelp and Snowflake.
-
Model, Search, and Visualize Live GitHub Data in ThoughtSpot
Use CData Connect AI to connect to live GitHub for modeling, searching, and visualizing.
-
Query Slack Data in DataGrip
Create a Data Source for Slack in DataGrip and use SQL to query live Slack.
-
Connect to Adobe Commerce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Commerce.
-
Import Dynamics 365 Business Central Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Dynamics 365 Business Central Data and provide access to live Dynamics 365 Business Central for custom reports in the Power BI Service.
-
Deploy the ADO.NET Provider for Oracle Eloqua Reporting on an SSRS Report Server
Connect to Oracle Eloqua Reporting 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 Avalara AvaTax Data from a Connection Pool in Jetty
The Avalara AvaTax JDBC Driver supports connection pooling: This article shows how to connect faster to Avalara AvaTax from Web apps in Jetty.
-
Automated Continuous Clockify Replication to MySQL
Use CData Sync for automated, continuous, customizable Clockify replication to MySQL.
-
Use JayDeBeApi to access SAP Ariba Procurement Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Ariba Procurement.
-
How to Work with TaxJar Data in ETL Validator JDBC
Connect to TaxJar from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Visualizations of Exact Online Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Exact Online in Birst.
-
How to Work with SingleStore Data in ETL Validator JDBC
Connect to SingleStore from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create an RPA flow for Pipeline CRM Data in UiPath Studio
Use the Pipeline CRM ODBC Driver to create workflows that access real-time Pipeline CRM without any coding.
-
Query RSS Feeds as a MySQL Database in Node.js
Execute MySQL queries against RSS Feeds from Node.js.
-
Building Dynamic Web Pages with PayPal Data Using AngularJS
Create single-page applications with live connectivity to PayPal using the CData API Server.
-
How to Seamlessly Import Zoho Recruit Data into IBM SPSS Modeler
Integrate Zoho Recruit data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to PostgreSQL Data in HULFT Integrate
Connect to PostgreSQL as a JDBC data source in HULFT Integrate
-
Use the CData Software ODBC Driver for AlloyDB in SAS for Real-Time Reporting and Analytics
Connect to real-time Google AlloyDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for AlloyDB.
-
How to Connect DBeaver to Apify via a JDBC Driver
Manage Apify with visual tools in DBeaver like the query browser.
-
Creating Microsoft Entra ID-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Entra ID to Unqork and build custom business apps.
-
Analyze Stripe Data in Looker
Use CData Connect AI to connect to Stripe Data from Looker and build custom apps using live Stripe.
-
Prepare, Blend, and Analyze Power BI XMLA Data in Alteryx Designer (ODBC)
Build workflows to access live Power BI XMLA for self-service data analytics.
-
Use the CData Software JDBC Driver for Vimeo in MicroStrategy Desktop
Connect to Vimeo in MicroStrategy Desktop using the CData Software JDBC Driver for Vimeo.
-
Integrating OpenCode Terminal with LeadDesk 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.
-
DataBind Controls to Sugar CRM Data in C++Builder
DataBind to Sugar CRM in C++Builder with standard components and controls.
-
Query Act CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Act CRM from Node.js.
-
Access Live Dynamics 365 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 Microsoft Dynamics 365 through MCP integration.
-
Build Apps with Live eBay Data Using the Low-Code Development Platform of Mendix
Connect eBay with Mendix to build apps using the CData JDBC Driver for eBay.
-
Connect to CSV from Asprova with CData Software ODBC Driver for CSV
This article shows how to connect faster to CSV data from Asprova.
-
Deploy the ADO.NET Provider for Bullhorn CRM on an SSRS Report Server
Connect to Bullhorn CRM 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.
-
Automated Continuous Zoho Books Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Books replication to Snowflake.
-
Build AI Agents with ServiceNow Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live ServiceNow through CData Connect AI.
-
Extract, Transform, and Load Google Drive Data in Informatica PowerCenter
Create a simple Workflow for Google Drive in Informatica PowerCenter.
-
View Reports on Real-Time Greenhouse Data in Power BI Report Server
Use the CData ODBC Driver for Greenhouse to visualize Greenhouse in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Klipfolio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Klipfolio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live Figshare Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Figshare.
-
Access Live Reply.io Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Reply.io in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
A PostgreSQL Interface for Harvest Data (MySQL Remoting via JDBC)
Use the Remoting features of the Harvest JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SAP Hybris C4C Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Azure SQL Database.
-
Working with Productboard Data in LINQPad
Execute LINQ queries to Productboard in LINQPad.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Fieldglass
Create an ODBC connection to SAP Fieldglass in Informatica and browse and transfer SAP Fieldglass.
-
Connect to EnterpriseDB Data in RazorSQL
Connect to EnterpriseDB from wizards and query EnterpriseDB from the GUI in the RazorSQL database management tool.
-
Connect to Zoho Projects Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Projects and the SQL Gateway to access Zoho Projects from Google Apps Script.
-
Create Power BI Reports on Real-Time Airtable Data
Use the CData ODBC Driver for Airtable to visualize Airtable in Power BI Desktop.
-
Integrating Shortcut Data in Talend Cloud Data Management Platform
Connect Shortcut Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Google Ad Manager 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 Google Ad Manager through MCP integration.
-
Connect to Real-Time Paddle Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Paddle in Power Apps.
-
Using the CData Software ODBC Driver for FormSite in PyCharm
Connect to FormSite as an ODBC data source in PyCharm using the CData Software ODBC Driver for FormSite.
-
Use the CData Software ODBC Driver for Clari in MicroStrategy
Connect to Clari in MicroStrategy Developer using the CData Software ODBC Driver for Clari.
-
Query Miro Data in ColdFusion
Write standard ColdFusion data access code to connect to Miro.
-
Create SSAS Tabular Models from RabbitMQ Data
How to build a SQL Server Analysis Service Tabular Model from RabbitMQ using CData drivers.
-
Automate HBase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache HBase replication to Azure Data Lake.
-
Integrating LlamaIndex with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Power BI XMLA in real time.
-
Create SSAS Tabular Models from Asana Data
How to build a SQL Server Analysis Service Tabular Model from Asana using CData drivers.
-
Connect to Instantly Data from a Connection Pool in JBoss
Integrate Instantly into Java servlets: Use the Management Console in JBoss to install the Instantly JDBC Driver.
-
How to Connect DBeaver to Mailjet via a JDBC Driver
Manage Mailjet with visual tools in DBeaver like the query browser.
-
How to Import Data from HBase into Google Sheets
Import Apache HBase into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous SharePoint Excel Services Replication to Oracle
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Oracle.
-
How to import Spark Data into Apache Solr
Use the CData Software JDBC Driver for Spark in Data Import Handler and create an automated import of Apache Spark SQL to Apache Solr Enterprise Search platform.
-
DataBind Controls to Simplesat Data in Delphi
DataBind to Simplesat in Delphi with standard data access components and controls.
-
Easily Integrate Freshservice Data in Lazarus Pascal IDE
Learn how to easily integrate live Freshservice in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Manage Facebook Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Facebook Ads.
-
Connect to SharePoint Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft SharePoint from Appeon PowerBuilder using the CData ADO.NET Provider for SharePoint.
-
Use the CData Software ODBC Driver for RSS in MicroStrategy
Connect to RSS Feeds in MicroStrategy Developer using the CData Software ODBC Driver for RSS.
-
Getting Started with the CData Tableau Connector for Datadog
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Office 365 Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Office 365 in Google Apps Script.
-
Integrate Cursor with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAS Data Sets from within the editor.
-
Automated Continuous SAP Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP replication to SingleStore.
-
Visualize Live MailerSend Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MailerSend.
-
Connect to GraphQL Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software JDBC Driver for JSON in MicroStrategy Desktop
Connect to JSON in MicroStrategy Desktop using the CData Software JDBC Driver for JSON.
-
Migrating data from Google Spanner to Databricks using CData SSIS Components.
Easily push Google Spanner to Databricks using the CData SSIS Tasks for Google Spanner and Databricks.
-
How to Create Power BI Visual Reports with Real-Time WooCommerce Data
Use CData Power BI Connectors to visualize WooCommerce in Power BI.
-
Explore Geographical Relationships in Brex Data with Power Map
Create data visualizations with Brex in Power Map.
-
Automated Continuous Campaigner Replication to SQLite
Use CData Sync for automated, continuous, customizable Campaigner replication to SQLite.
-
Excel Spreadsheet Automation on IBM Cloud Object Storage Data with the QUERY Formula
Pull data from IBM Cloud Object Storage, automate spreadsheets, and more with the QUERY formula.
-
Integrating Codex CLI with Toggl 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 Google Contacts Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Contacts and build visualizations in Tableau.
-
Create Informatica Mappings From/To an ODBC Data Source for Cvent
Create an ODBC connection to Cvent in Informatica and browse and transfer Cvent.
-
Use the CData ODBC Driver for BigCommerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for BigCommerce to connect to BigCommerce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring BigCommerce in Excel.
-
Access Live SharePoint Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft SharePoint into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft SharePoint in the Graph Builder and Query Builder.
-
Working with Microsoft Ads Data in LINQPad
Execute LINQ queries to Microsoft Ads in LINQPad.
-
Import Real-Time Nethunt Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Nethunt in ColdFusion.
-
Connect to OneNote Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft OneNote as a data source.
-
Automated Continuous ShipStation Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ShipStation replication to AlloyDB.
-
How to Easily Query Mailgun Data in OpenOffice Base
Connect to Mailgun data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Visualize HBase Data in Sisense
Create an ElastiCube in Sisense app with access to Apache HBase.
-
Getting Started with the CData ODBC Driver for Teradata
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Teradata.