CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for Google Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Ads.
-
Bind Live SQL Server Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SQL Server data
-
Working with Landbot Data in LINQPad
Execute LINQ queries to Landbot in LINQPad.
-
Access Workday Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Workday from your Oracle system.
-
Explore Geographical Relationships in Webex Data with Power Map
Create data visualizations with Webex in Power Map.
-
How to Create Power BI Visual Reports with Real-Time Superchat Data
Use CData Power BI Connectors to visualize Superchat in Power BI.
-
Analyze Dynamics 365 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Dynamics 365 with the CData JDBC Driver for Dynamics 365.
-
Access Tally 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 Tally ERP.
-
Automated Continuous Coinbase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Coinbase replication to PostgreSQL.
-
Create Informatica Mappings From/To an ODBC Data Source for ZeroBounce
Create an ODBC connection to ZeroBounce in Informatica and browse and transfer ZeroBounce.
-
Replicate Dynamics NAV Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Dynamics NAV to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a Singer.io Tap for AdRoll With the CData Python Connector
Learn how to easily build a Singer.io Tap for live AdRoll data using
-
Build Charts with Paymo Data in Clear Analytics
Create dynamic charts and perform analytics based on Paymo in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Drift
Provide connectivity to Drift through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Coda in MicroStrategy
Connect to Coda in MicroStrategy Developer using the CData Software JDBC Driver for Coda.
-
Automated Continuous Freshteam Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Freshteam replication to Azure SQL Database.
-
Build Agents in Relevance AI with Access to Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Power BI XMLA within intelligent agent workflows.
-
Replicate Productboard Data from PowerShell
Write a quick PowerShell script to query Productboard. Use connectivity to the live data to replicate Productboard to SQL Server.
-
Connect to Clockify Data in NetBeans
Connect to Clockify in NetBeans with the data source configuration wizard.
-
Visualize Live SAP SuccessFactors Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP SuccessFactors into custom reports in Power BI.
-
Build a PostgreSQL Interface for Bugsnag Data using the CData JDBC Driver
Use the Remoting features of the Bugsnag JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI Agents with Redis 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 Redis through CData Connect AI.
-
Getting Started with the CData Python Connector for IBM Informix
Learn to install and license the CData Python Connector
-
How to Use a Microsoft Access Database to Update Jira Assets Data in Real Time
Update Jira Assets data by creating a linked table in Microsoft Access with the CData Jira Assets ODBC Driver.
-
Analyze Active Directory Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Active Directory and visualize live Active Directory in Infragistics Reveal.
-
Automated Continuous Teamgate Replication to MongoDB
Use CData Sync for automated, continuous, customizable Teamgate replication to MongoDB.
-
Moving Data from Google Translate to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Translate data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build an OLAP Cube in SSAS from AdRoll Data
Establish a connection to AdRoll data from SQL Server Analysis Services, and use the AdRoll Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Oracle Service Cloud Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Oracle Service Cloud for you.
-
Analyze Pinterest Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Pinterest and visualize live Pinterest in Infragistics Reveal.
-
Seamlessly Bring Avro Data into Retool Using CData Connect AI
Integrate Avro data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData SSIS Components to Insert New or Update Existing Redshift Records from SQL Server
Easily push SQL Server data to Redshift using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Redshift or update existing records with data from a SQL Server database.
-
How to Use a Microsoft Access Database to Update SAP Business One Data in Real Time
Update SAP Business One data by creating a linked table in Microsoft Access with the CData SAP Business One ODBC Driver.
-
Create Reports with EmailOctopus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date EmailOctopus.
-
Replicate BenchmarkEmail Data to Multiple Databases
Replicate BenchmarkEmail to disparate databases with a point-and-click configuration.
-
How to Connect ADP Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live ADP data in real time using natural language.
-
Add Sage 300 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sage 300 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Back Up PDFMonkey 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 PDFMonkey data.
-
Build Dashboards with MarkLogic Data in Dundas BI
Create dynamic dashboards and perform analytics based on MarkLogic in Dundas BI.
-
Use Databricks Agent Bricks to Talk to Your Elasticsearch Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Elasticsearch for you.
-
Build Oracle SCM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle SCM and build Oracle SCM-connected web apps with Axios.
-
Connect to and Visualize Live Lakebase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Lakebase.
-
Automate Act-On Data Replication to Couchbase
Use CData Sync to Customize and automate Act-On replication to Couchbase.
-
How to work with Marketo Data in Apache Spark using SQL
Access and process Marketo Data in Apache Spark using the CData Software JDBC Driver.
-
Bridge Toggl Connectivity with Apache NiFi
Access and process Toggl in Apache NiFi using the CData JDBC Driver.
-
Build SharePoint-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft SharePoint and build web apps with connectivity to live Microsoft SharePoint.
-
Build a Singer.io Tap for Clio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Clio data using
-
Manage Box Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Box.
-
Connect to Google Ad Manager Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Ad Manager as an External Source in Dremio.
-
How to Visualize Google Ad Manager Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Ad Manager in Python.
-
Connect to SingleStore Data from PowerBuilder via JDBC
This article demonstrates how to access SingleStore from PowerBuilder using the SingleStore JDBC Driver.
-
Natively Connect to Impala Data in PHP
The CData ODBC driver for Impala enables you to create PHP applications with connectivity to Apache Impala. Leverage the native support for ODBC in PHP.
-
Build Automated Workflows with Live Dynamics 365 Data in Workato
Use CData Connect AI to connect to live Microsoft Dynamics 365 and build automated workflows in Workato.
-
How to Build an ETL App for HBase Data in Python with CData Connect AI
Build ETL pipelines that read and write live Apache HBase in Python with petl and the CData Connect AI Python SDK.
-
Using the CData Software ODBC Driver for Jira Assets in PyCharm
Connect to Jira Assets as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jira Assets.
-
Create Data Visualizations in Cognos BI with Freshdesk Data
Access Freshdesk as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Gong Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gong with the CData JDBC Driver for Gong.
-
Create Data Visualizations in Cognos BI with SAP Business Warehouse Data
Access SAP Business Warehouse as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import and Visualize IBM Informix Data in Power View
Create data visualizations based on IBM Informix in Excel.
-
Build Apps with Live Auth0 Data Using the Low-Code Development Platform of Mendix
Connect Auth0 with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Pushbullet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pushbullet with External Services.
-
Connect to Gong Data in DBeaver
Use the CData ODBC Driver to connect to Gong in DBeaver.
-
Integrate Live Smartsheet Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to ZohoExpense Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoExpense as an External Source in Dremio.
-
Build Semantic Layer Views for Google Search Results in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Search.
-
How to load Oracle Financials Cloud data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Financials Cloud data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect SharePoint with Suadeo Data through external lists
Provide Suadeo to SharePoint users as an external list.
-
Automated Continuous Pipedrive Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pipedrive replication to delimited files (CSV/TSV).
-
Extend Google Sheets with Microsoft Dataverse Data
Make calls to Microsoft Dataverse from Google Apps Script via the API Server.
-
Replicate SAS Data Sets Data from PowerShell
Write a quick PowerShell script to query SAS Data Sets. Use connectivity to the live data to replicate SAS Data Sets to SQL Server.
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks
Create QuickBooks data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Work with Typeform Data in AWS Glue Jobs Using JDBC
Connect to Typeform from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Intercom Replication to Databricks
Use CData Sync for automated, continuous, customizable Intercom replication to Databricks.
-
Create Power BI Reports on Real-Time Procore Data
Use the CData ODBC Driver for Procore to visualize Procore in Power BI Desktop.
-
Bidirectional Access to SAP Business One Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Business One in Filemaker Pro for Mac or Windows.
-
Back Up PagerDuty 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 PagerDuty data.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Google Cloud SQL.
-
Publish PabblySubscriptions-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PabblySubscriptions.
-
Import and Visualize ZohoSubscriptions Data in Power View
Create data visualizations based on ZohoSubscriptions in Excel.
-
Getting Started with the CData Tableau Connector for Templated
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Discourse from Asprova with CData Software ODBC Driver for Discourse
This article shows how to connect faster to Discourse data from Asprova.
-
Automate AdRoll Data Replication to SAP HANA
Use CData Sync to customize and automate AdRoll replication to SAP HANA.
-
Visualize Microsoft Exchange Data in Tableau
The CData ODBC driver for Microsoft Exchange enables you integrate Microsoft Exchange into Tableau dashboards.
-
Establish a Live Connection with Shopify Data using Tableau Bridge
The CData ODBC Driver for Shopify enables you to integrate live Shopify into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Informatica Mappings From/To an ODBC Data Source for Omnisend
Create an ODBC connection to Omnisend in Informatica and browse and transfer Omnisend.
-
ServiceNow Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ServiceNow through CData Connect AI using different applications and tools.
-
Add CircleCI Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CircleCI with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous FHIR Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable FHIR replication to Google BigQuery.
-
Automated Continuous SAP ByDesign Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Apache Kafka.
-
Connect to Live Confluence Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Confluence in CData Connect AI and connect to your Atlassian Confluence from PostgreSQL.
-
Getting Started with the CData ADO.NET Provider for Keap
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Manage ServiceDesk Plus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ServiceDesk Plus.
-
Integrate Cline with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Okta from within your IDE.
-
Connect to and Query Office 365 Data in QlikView over ODBC
Create data visualizations with Microsoft Office 365 in QlikView.
-
Enable the Certinia JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Certinia.
-
Integrating Antigravity CLI with ZohoMarketingHub via CData CLI
Connect ZohoMarketingHub to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Hubstaff-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Hubstaff.
-
Build Microsoft Ads-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Microsoft Ads to explore live Microsoft Ads Data in Cursor to assist with building Microsoft Ads-powered applications.
-
Integrate SuiteCRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SuiteCRM with External Services.
-
Connect to PDFMonkey Data in Ruby
Connect to PDFMonkey in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.