CData Software - Knowledge Base
Recent Articles
-
Access Live Cloudflare Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Cloudflare into the statistical analysis tools available in SAS JMP. This article shows how to use Cloudflare in the Graph Builder and Query Builder.
-
Connect to Teamgate Data in JRuby
Create a simple JRuby app with access to live Teamgate.
-
Create Data Visualizations in Cognos BI with Miro Data
Access Miro as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect and process Reckon Accounts Hosted from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Reckon Accounts Hosted.
-
Rapidly Develop Snapchat Ads-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 Snapchat Ads.
-
Analyze SAP Business One Data in Cognos Analytics
Use CData Connect AI to connect to SAP Business One Data from Cognos Analytics and analyze live SAP Business One.
-
Configure the CData JDBC Driver for Klaviyo in a Connection Pool in Tomcat
Connect to Klaviyo from a connection pool in Tomcat.
-
Connecting GenSpark with Office 365 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Office 365 without any replication or custom integration required.
-
Consume Basecamp OData Feeds in PowerBuilder
This article demonstrates how to consume Basecamp as OData feeds from PowerBuilder using the API Server.
-
How to import ScrapingBee Data into Apache Solr
Use the CData Software JDBC Driver for ScrapingBee in Data Import Handler and create an automated import of ScrapingBee to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for Coda Data in APOS Live Data Gateway
Use the CData Connector for Coda in APOS Live Data Gateway to build Semantic Layer Views for Coda.
-
Build Salesforce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce Data and create custom apps in Bubble.
-
Replicate Multiple Samanage Accounts via the CData Sync CLI
Replicate multiple Samanage accounts to one or many databases.
-
Build a Singer.io Tap for Simplesat With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Simplesat data using
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Elasticsearch to Power BI dashboards. Simply drag and drop Elasticsearch into data visuals on the Power BI canvas.
-
How to Query Live Act-On Data in Claude Desktop
Connect to and query live Act-On Data in Claude Desktop using CData MCP Server.
-
Visualize Microsoft Entra ID Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Entra ID.
-
Automated Continuous Google Contacts Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Contacts replication to Snowflake.
-
Integrate Samanage with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Samanage with External Services.
-
Configure the CData JDBC Driver for Sendwithus in a Connection Pool in Tomcat
Connect to Sendwithus from a connection pool in Tomcat.
-
Getting Started with the CData JDBC Driver for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho CRM.
-
Build a PostgreSQL Interface for Planio Data using the CData JDBC Driver
Use the Remoting features of the Planio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize eBay Analytics Data in TIBCO Spotfire through OData
Integrate eBay Analytics into dashboards in TIBCO Spotfire.
-
Integrating Kiro CLI with Microsoft Ads 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.
-
Visualize Discord Data in TIBCO Spotfire through ADO.NET
Integrate Discord into dashboards in TIBCO Spotfire.
-
Integrate SAP HANA with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP HANA with External Services.
-
Use the CData Software ODBC Driver for LDAP in SAS for Real-Time Reporting and Analytics
Connect to real-time LDAP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LDAP.
-
How to use SQLAlchemy ORM to access Float Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Float.
-
Build Kintone-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Kintone.
-
Replicate Sage 200 Data to Multiple Databases via the CData Sync CLI
Replicate Sage 200 to disparate databases with a single configuration.
-
Connect to Sage Cloud Accounting from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sage Business Cloud Accounting, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Reports from Amazon DynamoDB Data in Looker Studio
Use CData Connect AI to gain access to live Amazon DynamoDB and create custom reports in Looker Studio.
-
Connect to MongoDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MongoDB.
-
Automate Teradata Data Replication to Couchbase
Use CData Sync to Customize and automate Teradata replication to Couchbase.
-
Automated Continuous Google Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Analytics replication to OneLake in Microsoft Fabric.
-
Access SFTP Data from MySQL in Amazon QuickSight
Connect to SFTP and build visualizations of SFTP using a MySQL Connection in Amazon QuickSight.
-
How to Query Live SAS xpt Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAS XPORT data in natural language using Python.
-
Build Semantic Layer Views for Twitter Ads Data in APOS Live Data Gateway
Use the CData Connector for Twitter Ads in APOS Live Data Gateway to build Semantic Layer Views for Twitter Ads.
-
Migrating data from JotForm to Databricks using CData SSIS Components.
Easily push JotForm to Databricks using the CData SSIS Tasks for JotForm and Databricks.
-
Integrate HubSpot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HubSpot from Informatica Cloud.
-
Build a Singer.io Tap for MariaDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MariaDB data using
-
Connect Anaplan to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Anaplan with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Pipedrive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pipedrive.
-
Access Perplexity Data from MySQL in PHP
Connect to Perplexity through the standard MySQL libraries in PHP.
-
Create Dynamic Codat Grids Using the Infragistics XamDataGrid
Learn how you can connect Codat to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Smartsheet from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Smartsheet, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Live ServiceDesk Plus Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ServiceDesk Plus using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for Box
Create Box data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Excel Data in DBVisualizer
Integrate Microsoft Excel with visual data analysis tools and data connection wizards in DBVisualizer
-
How to publish and share SharePoint Excel Services Data dashboards with Tableau Server
The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for Tickspot
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ActiveCampaign to Power BI dashboards. Simply drag and drop ActiveCampaign into data visuals on the Power BI canvas.
-
Use the CData Software ODBC Driver for WooCommerce in MicroStrategy Web
Connect to WooCommerce in MicroStrategy Web using the CData Software ODBC Driver for WooCommerce.
-
Access Live Notion Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Notion into the statistical analysis tools available in SAS JMP. This article shows how to use Notion in the Graph Builder and Query Builder.
-
Automated Continuous Omnisend Replication to MySQL
Use CData Sync for automated, continuous, customizable Omnisend replication to MySQL.
-
Migrating data from Discourse to Databricks using CData SSIS Components.
Easily push Discourse to Databricks using the CData SSIS Tasks for Discourse and Databricks.
-
Getting Started with the CData Python Connector for BigQuery
Learn to install and license the CData Python Connector
-
Create Data Visualizations Based On CSV Data in Mode
Use CData Connect AI to connect to CSV Data from Mode and build visualizations using live
-
Query TaxJar Data in DataGrip
Create a Data Source for TaxJar in DataGrip and use SQL to query live TaxJar.
-
Airtable Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Airtable through CData Connect AI using different applications and tools.
-
Connect to SharePoint Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft SharePoint using standard SQL.
-
Use the CData Software JDBC Driver for Jira in MicroStrategy Web
Connect to Atlassian Jira in MicroStrategy Web using the CData Software JDBC Driver for Jira.
-
Consume Trello OData Feeds in PowerBuilder
This article demonstrates how to consume Trello as OData feeds from PowerBuilder using the API Server.
-
Query Exact Online Data as a MySQL Database in Node.js
Execute MySQL queries against Exact Online from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Forms
Create an ODBC connection to Google Forms in Informatica and browse and transfer Google Forms.
-
Connect to Amplitude Data in CloverDX (formerly CloverETL)
Transfer Amplitude using the visual workflow in the CloverDX data integration tool.
-
Visualize Live Tanda Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Tanda.
-
Connect to Mixpanel Data in HULFT Integrate
Connect to Mixpanel as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To a JDBC Data Source for Hacker News
Create Hacker News data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize SAS xpt Data in TIBCO Spotfire through OData
Integrate SAS XPORT into dashboards in TIBCO Spotfire.
-
How to Connect DBeaver to SAP HANA XS Advanced via a JDBC Driver
Manage SAP HANA XS Advanced with visual tools in DBeaver like the query browser.
-
Import Real-Time SQL Server Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft SQL Server in ColdFusion.
-
Automated Continuous SAP Concur Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Concur replication to Apache Kafka.
-
A PostgreSQL Interface for Google Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to CircleCI Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CircleCI to connect to CircleCI and execute queries in PowerBuilder.
-
Use the CData API Server to Access FHIR Data in Microsoft PowerPivot
Use the CData API Server to connect to live FHIR in the Power Pivot business intelligence tool.
-
How to integrate Adobe Commerce with Apache Airflow
Access and process Adobe Commerce in Apache Airflow using the CData JDBC Driver.
-
Use the CData ODBC Driver for SAP BusinessObjects BI in Microsoft Power Query
You can use the CData SAP BusinessObjects BI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP BusinessObjects BI into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Vault CRM
Provide connectivity to Veeva Vault & Vault CRM through an SAP BusinessObjects universe.
-
How to Work with ClickTime Data in AWS Glue Jobs Using JDBC
Connect to ClickTime from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Choosing the Best Method to Connect Google Campaign Manager 360 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Campaign Manager 360 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Validate Datadog Data with QuerySurge
Access and validate Datadog in QuerySurge using the CData JDBC Driver.
-
Integrating Codex CLI with Mailgun 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.
-
How to Query Live OpenWeatherMap Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OpenWeatherMap data in natural language using Python.
-
Connect to Cvent Data from HeidiSQL
Use CData Connect AI to connect to and query live Cvent from HeidiSQL.
-
Integrate Printify Data in the Pentaho Report Designer
Publish reports based on Printify in the Pentaho BI tool.
-
Getting Started with the CData SSIS Components for Keap
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Keap.
-
Query BigCommerce Data from Node.js
Use the OData endpoint of the CData API Server to connect to your BigCommerce and perform CRUD operations on BigCommerce from Node.js.
-
Access Live FHIR Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FHIR from your Excel spreadsheets.
-
Access Live Bitbucket Data in AWS Lambda
Connect to live Bitbucket in AWS Lambda using the CData JDBC Driver.
-
Create Todoist Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Todoist data access from reports, embedded analytics, and more.
-
Use the CData Software ODBC Driver for Act CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Act CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Act CRM.
-
Import Real-Time HBase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache HBase in ColdFusion.
-
Automated Continuous Reckon Accounts Hosted Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Google BigQuery.
-
Build Data Flows from SQL Server to HubDB through SSIS
Easily push SQL Server data to HubDB using the CData SSIS Tasks for HubDB.
-
Connect to and Query Planio Data in QlikView over ODBC
Create data visualizations with Planio in QlikView.
-
Connect to MariaDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access MariaDB in Google Apps Script.
-
Extract, Transform, and Load Jira Assets Data in Informatica PowerCenter
Create a simple Workflow for Jira Assets in Informatica PowerCenter.
-
Create Informatica Mappings From/To an ODBC Data Source for Kintone
Create an ODBC connection to Kintone in Informatica and browse and transfer Kintone.
-
Connect to Amazon Athena Data in HULFT Integrate
Connect to Amazon Athena as a JDBC data source in HULFT Integrate