CData Software - Knowledge Base
Recent Articles
-
Connect to Google Analytics Data in RazorSQL
Connect to Google Analytics from wizards and query Google Analytics from the GUI in the RazorSQL database management tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Wistia
Create Wistia data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to import Slack Data into Apache Solr
Use the CData Software JDBC Driver for Slack in Data Import Handler and create an automated import of Slack to Apache Solr Enterprise Search platform.
-
Import Real-Time Webflow Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Webflow in ColdFusion.
-
Use the CData Software JDBC Driver for Basecamp in MicroStrategy
Connect to Basecamp in MicroStrategy Developer using the CData Software JDBC Driver for Basecamp.
-
Integrate with QuickBooks Online Data in JReport Designer
Create charts and reports based on QuickBooks Online in JReport Designer.
-
Connect to Real-Time Productboard Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Productboard in Power Apps.
-
Bridge SendGrid Connectivity with Apache NiFi
Access and process SendGrid in Apache NiFi using the CData JDBC Driver.
-
How to Connect to & Open SharePoint Data in Microsoft Excel
This article uses the CData ODBC driver for SharePoint to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Publish Crystal Reports on Amazon Marketplace Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon Marketplace.
-
How to create an RPA flow for Tanda Data in UiPath Studio
Use the Tanda ODBC Driver to create workflows that access real-time Tanda without any coding.
-
How to Connect to Apify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apify. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Workable Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Workable. Leverage the native support for ODBC in PHP.
-
Add Trello Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Trello with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Teradata Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Teradata replication to AlloyDB.
-
How to connect to AgileCRM Data with Squirrel SQL client
Connect to AgileCRM and execute queries in the Squirrel SQL Client.
-
How to publish and share Deel Data dashboards with Tableau Server
The CData ODBC driver for Deel enables you integrate Deel into Tableau dashboards.
-
Getting Started with the CData Tableau Connector for Mocean
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Natively Connect to IBM Informix Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to IBM Informix. Leverage the native support for ODBC in PHP.
-
Build Microsoft Ads-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Microsoft Ads to explore live Microsoft Ads Data in Claude Code to assist with building Microsoft Ads-powered applications.
-
Integrate LightSpeedRetail Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LightSpeedRetail from Informatica Cloud.
-
Create Couchbase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Couchbase data access from reports, embedded analytics, and more.
-
Connect to Hugging Face Data from PowerBuilder via ADO.NET
This article demonstrates how to access Hugging Face from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Visualize Marketo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Marketo in Python.
-
Migrating data from Azure Data Catalog to Snowflake using CData SSIS Components.
Easily push Azure Data Catalog to Snowflake using the CData SSIS Tasks for Azure Data Catalog and Snowflake.
-
Using the CData Software ODBC Driver for DB2 in PyCharm
Connect to DB2 as an ODBC data source in PyCharm using the CData Software ODBC Driver for DB2.
-
Visualize Grafana 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 Grafana into TIBCO Spotfire.
-
ETL Coinbase in Oracle Data Integrator
This article shows how to transfer Coinbase into a data warehouse using Oracle Data Integrator.
-
Connect to Azure DevOps Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure DevOps Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Microsoft Ads Data from a Connection Pool in Jetty
The Microsoft Ads JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Ads from Web apps in Jetty.
-
Validate OneNote Data with QuerySurge
Access and validate Microsoft OneNote in QuerySurge using the CData JDBC Driver.
-
Validate Kintone Data with QuerySurge
Access and validate Kintone in QuerySurge using the CData JDBC Driver.
-
How to Work with Teamwork Data in AWS Glue Jobs Using JDBC
Connect to Teamwork from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Process & Analyze Odoo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Odoo Data.
-
Integrate with Office 365 Data in JReport Designer
Create charts and reports based on Microsoft Office 365 in JReport Designer.
-
Integrate with live Elasticsearch Data in Jitterbit
Use CData Connect AI to connect to and integrate live Elasticsearch in Jitterbit.
-
Automated Continuous SAP BusinessObjects BI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to AlloyDB.
-
Replicate Slack Data in Heroku for Use in Salesforce Connect
Replicate Slack to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Antigravity CLI with Atlassian Jira via CData CLI
Connect Atlassian Jira to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to work with Exact Online Data in Apache Spark using SQL
Access and process Exact Online Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Pinterest Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Cursor CLI with Microsoft Exchange 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.
-
How to Work with SAS xpt Data in AWS Glue Jobs Using JDBC
Connect to SAS xpt from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Webex Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Webex facts in real time.
-
Publish Oracle HCM Cloud-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle HCM Cloud.
-
How to update Azure Table from Excel
This article explains how to transfer data from Excel to Azure Table using the Excel Add-In for Azure Table.
-
Use the CData Software JDBC Driver for ShipEngine in MicroStrategy Web
Connect to ShipEngine in MicroStrategy Web using the CData Software JDBC Driver for ShipEngine.
-
Use Claude to Talk to Your Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Asana for you.
-
Build Automated Workflows with Live Azure Analysis Services Data in Workato
Use CData Connect AI to connect to live Azure Analysis Services and build automated workflows in Workato.
-
Build Reckon Accounts Hosted-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Reckon Accounts Hosted and build Reckon Accounts Hosted-connected web apps with Axios.
-
Automated Continuous PolarTeamPro Replication to Oracle
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Oracle.
-
Build Dashboards with Elasticsearch Data in Dundas BI
Create dynamic dashboards and perform analytics based on Elasticsearch in Dundas BI.
-
Getting Started with the CData Power BI Connector for Databricks
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Databricks.
-
ETL Excel in Oracle Data Integrator
This article shows how to transfer Microsoft Excel into a data warehouse using Oracle Data Integrator.
-
How to Work with Freshsales Data in AWS Glue Jobs Using JDBC
Connect to Freshsales from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous SharePoint Replication to Oracle
Use CData Sync for automated, continuous, customizable SharePoint replication to Oracle.
-
Build Sage 300-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Sage 300 to explore live Sage 300 Data in Gemini Code Assist to assist with building Sage 300-powered applications.
-
How to connect Amazon QuickSight to Azure Table Data
Create a connection to Azure Table Storage in CData Connect AI and insert Azure Table Storage into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Python Connector for Hugging Face
Learn to install and license the CData Python Connector
-
Connect to FHIR Data in JRuby
Create a simple JRuby app with access to live FHIR.
-
Access Live Exact Online Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Exact Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Write a Simple Go Application to work with Workable Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Workable.
-
Create a Data Access Object for Superchat Data using JDBI
A brief overview of creating a SQL Object API for Superchat in JDBI.
-
Build LinkedIn Ads-Connected Apps in Choreo
Use CData Connect AI to connect to LinkedIn Ads Data from Choreo and build custom apps using live LinkedIn Ads.
-
Use the CData Software ODBC Driver for CloudConvert in MicroStrategy
Connect to CloudConvert in MicroStrategy Developer using the CData Software ODBC Driver for CloudConvert.
-
Connect to Amazon Marketplace Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon Marketplace.
-
Use Dash to Build to Web Apps on LinkedIn Data
Create Python applications that use pandas and Dash to build LinkedIn-connected web apps.
-
Use the CData Software ODBC Driver for PabblySubscriptions in MicroStrategy Web
Connect to PabblySubscriptions in MicroStrategy Web using the CData Software ODBC Driver for PabblySubscriptions.
-
Create Dynamic AgileCRM Grids Using the Infragistics XamDataGrid
Learn how you can connect AgileCRM to Infragistics XamDataGrid to build dynamic grids.
-
How to Create Power BI Visual Reports with Real-Time Teamwork Data
Use CData Power BI Connectors to visualize Teamwork in Power BI.
-
Build MVC Applications with Connectivity to Stack Exchange Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Stack Exchange from an ASP.NET MVC application.
-
Build Semantic Layer Views for SAP Hybris C4C Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Hybris C4C.
-
Query Parquet Data in DataGrip
Create a Data Source for Parquet in DataGrip and use SQL to query live Apache Parquet.
-
How to Connect the Power BI Service to Discourse: Complete Guide
Connect to the CData Software Power BI Connector for Discourse from PowerBI.com to provide real-time Discourse across the organization.
-
Publish Crystal Reports on Office 365 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Office 365.
-
Automated Continuous Blackbaud FE NXT Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Apache Cassandra.
-
How to use SQLAlchemy ORM to access CloudConvert Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CloudConvert.
-
Getting Started with the CData ADO.NET Provider for Snowflake
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Snowflake.
-
Build Pipelines with Live SingleStore Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SingleStore from Google Cloud Data Fusion, enabling the integration of live SingleStore into the building and management of effective data pipelines.
-
How to connect SharePoint with Google Campaign Manager 360 Data through external lists
Provide Google Campaign Manager 360 to SharePoint users as an external list.
-
Connect to Wave Financial Data from a Connection Pool in Jetty
The Wave Financial JDBC Driver supports connection pooling: This article shows how to connect faster to Wave Financial from Web apps in Jetty.
-
Connect to Egnyte Data in JRuby
Create a simple JRuby app with access to live Egnyte.
-
Integrate Live Vertica Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrating OpenCode Terminal with Elasticsearch 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.
-
Analyze Live Snapchat Ads Data in SAS Viya
Use CData Connect AI to connect to Snapchat Ads from SAS Viya and deploy self-service analytics using live Snapchat Ads.
-
Viewing Quickbase Data in RAD Studio Data Explorer
How to view Quickbase in RAD Studio Data Explorer using the CData ODBC Driver for Quickbase.
-
Query Insightly Data in DataGrip
Create a Data Source for Insightly in DataGrip and use SQL to query live Insightly.
-
Use JayDeBeApi to access Box Data in Python
Use standard Python scripting and the development environment of your choice to access live Box.
-
Consume LDAP OData Feeds in PowerBuilder
This article demonstrates how to consume LDAP as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData ADO.NET Provider for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Twilio Data into Power Automate Desktop using CData Connect
CData Connect for Twilio Data enables you to integrate Twilio into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Sage 200 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sage 200 replication to Apache Kafka.
-
Build Apps with Live eBay Analytics Data Using the Low-Code Development Platform of Mendix
Connect eBay Analytics with Mendix to build apps using the CData JDBC Driver for eBay Analytics.
-
Integrating Kiro CLI with Google Directory 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.
-
Build Sybase IQ-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sybase IQ and build web apps with connectivity to live Sybase IQ.
-
Visualize Quaderno Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Quaderno.
-
Getting Started with the CData ODBC Driver for Acumatica
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Acumatica.
-
Migrating data from Office 365 to Snowflake using CData SSIS Components.
Easily push Microsoft Office 365 to Snowflake using the CData SSIS Tasks for Office 365 and Snowflake.
-
Build Zuora-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zuora.
-
Connect to and Query GitLab Data in QlikView over ODBC
Create data visualizations with GitLab in QlikView.