CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Campaigner Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Campaigner replication to PostgreSQL.
-
Connect to Oracle Financials Cloud Data from a Connection Pool in JBoss
Integrate Oracle Financials Cloud data into Java servlets: Use the Management Console in JBoss to install the Oracle Financials Cloud JDBC Driver.
-
How to integrate Metabase with PingOne Data
Use CData Connect AI to connect to live PingOne data and create an interactive dashboard in Metabase from PingOne data.
-
Visualize ZohoPeople Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ZohoPeople data into TIBCO Spotfire.
-
Automated Continuous Google Campaign Manager 360 Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MySQL.
-
How to Connect to & Open Discourse Data in Microsoft Excel
This article uses the CData ODBC driver for Discourse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Azure Data Catalog Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure Data Catalog data from Filemaker Pro on Mac.
-
Automated Continuous Moosend Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Moosend replication to AlloyDB.
-
Connect to Microsoft Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Microsoft Ads.
-
How to Connect to & Open EmailOctopus Data in Microsoft Excel
This article uses the CData ODBC driver for EmailOctopus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate with Live Blackbaud FE NXT Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Blackbaud FE NXT from the MuleSoft Anypoint Platform to integrate live Blackbaud FE NXT data into custom reports and dashboards.
-
How to Access MarkLogic Data Using Entity Framework
This article shows how to access MarkLogic data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Smartsheet Data in JRuby
Create a simple JRuby app with access to live Smartsheet data.
-
Access Live JotForm Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate JotForm data into the statistical analysis tools available in SAS JMP. This article shows how to use JotForm data in the Graph Builder and Query Builder.
-
Automated Continuous Zoho Recruit Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Apache Cassandra.
-
Design BIRT Reports on SparkPost Data
Provide current SparkPost data to your embedded analytics.
-
Use Dash to Build to Web Apps on Certinia Data
Create Python applications that use pandas and Dash to build Certinia-connected web apps.
-
Enable the HCL Domino JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HCL Domino data.
-
How to Build an ETL App for Neo4J Data in Python with CData
Create ETL applications and real-time data pipelines for Neo4J data in Python with petl.
-
Create SAP ByDesign-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP ByDesign Data from Klipfolio and build custom visualizations using live SAP ByDesign data.
-
Visualize Live IBM Informix Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Informix data.
-
Build Redshift Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Redshift data and build visualizations in Tableau.
-
Query Rebilly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Rebilly data from Node.js.
-
Integrate with Live SAP Business One Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Business One from the MuleSoft Anypoint Platform to integrate live SAP Business One data into custom reports and dashboards.
-
Query Google Contacts Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Contacts data.
-
Excel Spreadsheet Automation on Salesforce Data 360 Data with the QUERY Formula
Pull data from Salesforce Data 360, automate spreadsheets, and more with the QUERY formula.
-
Connect to GetResponse Data from a Connection Pool in Jetty
The GetResponse JDBC Driver supports connection pooling: This article shows how to connect faster to GetResponse data from Web apps in Jetty.
-
Automate Presto Data Replication to Azure Synapse
Use CData Sync to customize and automate Presto data replication to Azure Synapse.
-
Publish Grafana-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Grafana data.
-
Build Dashboards with ServiceDesk Plus Data in Dundas BI
Create dynamic dashboards and perform analytics based on ServiceDesk Plus data in Dundas BI.
-
Connect to Dynamics NAV Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dynamics NAV data using standard SQL.
-
Use Grok to Talk to Your SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP SuccessFactors data for you.
-
Replicate XML Data from PowerShell
Write a quick PowerShell script to query XML data. Use connectivity to the live data to replicate XML data to SQL Server.
-
Back Up Adobe Analytics data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Adobe Analytics. In this article, we will employ an SSIS workflow to populate a database with Adobe Analytics data data.
-
Integrate Oracle Eloqua Reporting Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Eloqua Reporting data in the Pentaho Data Integration tool.
-
Automated Continuous Cvent Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Cvent replication to Google BigQuery.
-
Build a Singer.io Tap for Google Campaign Manager 360 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Campaign Manager 360 data using the CData Python Connector.
-
How to Connect to Amazon DynamoDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon DynamoDB data. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData SSIS Components for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SurveyMonkey.
-
Use Manus AI to Talk to Your API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on API data.
-
Integrate Cloudflare Data into Power Automate Desktop using CData Connect
CData Connect for Cloudflare Data enables you to integrate Cloudflare data into workflows built using Microsoft Power Automate Desktop.
-
How to connect to QuickBooks Time Data in DBVisualizer
Integrate QuickBooks Time data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to publish and share ZohoMarketingHub Data dashboards with Tableau Server
The CData ODBC driver for ZohoMarketingHub enables you integrate ZohoMarketingHub data into Tableau dashboards.
-
How to work with Epicor Kinetic Data in Apache Spark using SQL
Access and process Epicor Kinetic Data in Apache Spark using the CData Software JDBC Driver.
-
Provide OData Services of Monday.com Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Monday.com data by developing a WCF Service Application.
-
Automated Continuous Teradata Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Teradata replication to Amazon S3.
-
Consume IBM Cloud Object Storage OData Feeds in SAP Lumira
Use the API Server to create data visualizations on IBM Cloud Object Storage feeds that reflect any changes in SAP Lumira.
-
Choosing the Best Method to Connect CockroachDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CockroachDB data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Google Calendar Data in Excel 365 Online (Excel for the web)
Connect to Google Calendar data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Power BI Connector for Exact Online
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Exact Online.
-
Connect to Box Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Box data using standard SQL.
-
Moving Data from CockroachDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CockroachDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create ZendeskSell Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZendeskSell from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Work with Gumroad Data in ETL Validator JDBC
Connect to Gumroad from ETL Validator jobs using the CData Software JDBC Driver.
-
Stream GitHub Data into Apache Kafka Topics
Access and stream GitHub data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Connect AI Python SDK for RSS
Install the CData Connect AI Python SDK to read live RSS feeds with standard DB-API 2.0 Python code.
-
Automated Continuous Foursquare Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Foursquare replication to Google Cloud SQL.
-
Building Dynamic Web Pages with SQL Server Data Using AngularJS
Create single-page applications with live connectivity to SQL Server using the CData API Server.
-
Build Semantic Layer Views for LinkedIn Data in APOS Live Data Gateway
Use the CData Connector for LinkedIn in APOS Live Data Gateway to build Semantic Layer Views for LinkedIn data.
-
Automated Continuous Strava Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Strava replication to IBM DB2.
-
Create Sage Cloud Accounting-Connected Business Apps in AppSheet
Connect to Sage Cloud Accounting Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sage Cloud Accounting data.
-
Automated Continuous SAP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP replication to Amazon S3.
-
Getting Started with the CData ODBC Driver for Klipfolio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Klipfolio.
-
Connecting Agentforce with SQL Analysis Services Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SQL Analysis Services data for you.
-
Establish a Live Connection with Quaderno Data using Tableau Bridge
The CData ODBC Driver for Quaderno enables you to integrate live Quaderno data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access ZeroBounce Data from MySQL in PHP
Connect to ZeroBounce through the standard MySQL libraries in PHP.
-
Integrate Microsoft Teams Data in the Pentaho Report Designer
Publish reports based on Microsoft Teams data in the Pentaho BI tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Certinia
Create Certinia data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Create Power BI Visual Reports with Real-Time Telegram Data
Use CData Power BI Connectors to visualize Telegram data in Power BI.
-
Build an OLAP Cube in SSAS from Unbounce Data
Establish a connection to Unbounce data data from SQL Server Analysis Services, and use the Unbounce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Agents in Relevance AI with Access to Live eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on eBay Analytics data within intelligent agent workflows.
-
Connecting Agentforce with Pipedrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Pipedrive data for you.
-
Integrate Factorial with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Factorial with External Services.
-
How to Build an ETL App for Dynamics CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Dynamics CRM data in Python with petl and the CData Connect AI Python SDK.
-
DataBind Controls to Bright Data Data in Delphi
DataBind to Bright Data data in Delphi with standard data access components and controls.
-
Integrating Codex with Xero 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 Datasets from MailerLite in Domo Workbench and Build Visualizations of MailerLite Data in Domo
Use the CData Software ODBC Driver for MailerLite to create datasets from MailerLite data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Trae with Live Teradata Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Teradata data from within the AI-powered IDE.
-
How to create Visio diagrams from Zoho Projects Data
Automatically update Zoho Projects data with the changes you make to Visio master shapes.
-
How to work with ShipStation Data in Apache Spark using SQL
Access and process ShipStation Data in Apache Spark using the CData Software JDBC Driver.
-
A PostgreSQL Interface for MariaDB Data using the CData ODBC Driver
Use the SQL Gateway and MariaDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ODBC Driver for Codat
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Codat.
-
How to connect to Salesforce Marketing Data from Spring Boot
Connect to Salesforce Marketing in a Spring Boot Application using the CData JDBC Driver for Salesforce Marketing
-
Integrate Stack Exchange with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Stack Exchange with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Stack Exchange data.
-
Use the CData Software ODBC Driver for Placid in MicroStrategy Web
Connect to Placid data in MicroStrategy Web using the CData Software ODBC Driver for Placid.
-
Use Biml to Build SSIS Tasks to Replicate Greenplum Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Greenplum data to SQL Server.
-
How to work with Mode Data in Apache Spark using SQL
Access and process Mode Data in Apache Spark using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from Dropbox Data
How to build a SQL Server Analysis Service Tabular Model from Dropbox data using CData drivers.
-
Using the CData Software ODBC Driver for Google Calendar in PyCharm
Connect to Google Calendar as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Calendar.
-
Query Bugsnag Data in ColdFusion
Write standard ColdFusion data access code to connect to Bugsnag data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Tasks
Provide connectivity to Google Tasks data through an SAP BusinessObjects universe.
-
How to Create Power BI Visual Reports with Real-Time LinkedIn Ads Data
Use CData Power BI Connectors to visualize LinkedIn Ads data in Power BI.
-
Automated Continuous PhantomBuster Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PhantomBuster replication to delimited files (CSV/TSV).
-
Query Live QuickBooks Online Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live QuickBooks Online data through a conversational interface.
-
Publish Google Directory-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Directory data.
-
Integrate Real-Time Access to Avro in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Avro data in real time.
-
Integrate Live Klipfolio Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Klipfolio data and integrate live Klipfolio data into apps built in Microsoft Power Apps.
-
Migrating data from Calendly to Google BigQuery using CData SSIS Components.
Easily push Calendly data to Google BigQuery using the CData SSIS Tasks for Calendly and Google BigQuery.
-
Load Onfleet Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Onfleet data to a database.
-
Connect to ZeroBounce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZeroBounce data.