CData Software - Knowledge Base
Recent Articles
-
Connect to Mailgun from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mailgun to connect to Mailgun from Web applications running on WebLogic.
-
LINQ to Snowflake Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Snowflake Data Provider.
-
How to connect to ZohoExpense Data in DBVisualizer
Integrate ZohoExpense with visual data analysis tools and data connection wizards in DBVisualizer
-
Spotify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Spotify facts in real time.
-
How to use SQLAlchemy ORM to access Dropbox Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dropbox.
-
Create Datasets from OnePageCrm in Domo Workbench and Build Visualizations of OnePageCrm Data in Domo
Use the CData Software ODBC Driver for OnePageCrm to create datasets from OnePageCrm in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Zoom Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoom.
-
Automated Continuous Autopilot Replication to Databricks
Use CData Sync for automated, continuous, customizable Autopilot replication to Databricks.
-
Process & Analyze FormSite Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FormSite Data.
-
Publish SharePoint Excel Services-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SharePoint Excel Services.
-
How to Work with Pushbullet Data in ETL Validator JDBC
Connect to Pushbullet from ETL Validator jobs using the CData Software JDBC Driver.
-
Create GitLab Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GitLab data access from reports, embedded analytics, and more.
-
Access Telegram 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 Telegram.
-
Build Semantic Layer Views for Act-On Data in APOS Live Data Gateway
Use the CData Connector for Act-On in APOS Live Data Gateway to build Semantic Layer Views for Act-On.
-
How to Connect to Live Raisers Edge NXT Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Raisers Edge NXT without replication.
-
Create SSAS Tabular Models from Phoenix Data
How to build a SQL Server Analysis Service Tabular Model from Apache Phoenix using CData drivers.
-
Choosing the Best Method to Connect Mailjet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mailjet from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use JayDeBeApi to access Auth0 Data in Python
Use standard Python scripting and the development environment of your choice to access live Auth0.
-
Connect SAS Data Sets to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAS Data Sets with IBM WebSphere for seamless data integration and connectivity.
-
How to Easily Query DocuSign Data in OpenOffice Base
Connect to DocuSign data in OpenOffice Base using the CData ODBC Driver for DocuSign and generate reports with live data insights.
-
Connect to Oracle SCM Data in JRuby
Create a simple JRuby app with access to live Oracle SCM.
-
Visualize Pinecone Data in TIBCO Spotfire through ADO.NET
Integrate Pinecone into dashboards in TIBCO Spotfire.
-
Working with Azure DevOps Data in LINQPad
Execute LINQ queries to Azure DevOps in LINQPad.
-
Creating SendGrid-Connected Applications in Unqork
You can use CData Connect AI to feed SendGrid to Unqork and build custom business apps.
-
Connect to Webex Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Webex and work with Webex in your FileMaker application.
-
Connect to OnePageCrm Data from PowerBuilder via ADO.NET
This article demonstrates how to access OnePageCrm from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Timely Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Timely from Informatica Cloud.
-
Automated Continuous GraphQL Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GraphQL replication to Amazon Redshift.
-
Integrating LangGraph with Smartsheet Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Smartsheet within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Autopilot
Create an ODBC connection to Autopilot in Informatica and browse and transfer Autopilot.
-
How to Visualize Cosmos DB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Azure Cosmos DB in Python.
-
Automated Continuous Planio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Planio replication to Amazon S3.
-
Use CData Connect AI to Access Redshift Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Amazon Redshift in the Power Pivot business intelligence tool.
-
Process & Analyze MongoDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MongoDB Data.
-
Integrating Codex CLI with Microsoft Planner 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 connect to SingleStore Data in DBVisualizer
Integrate SingleStore with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Tally Data from MySQL in Amazon QuickSight
Connect to Tally and build visualizations of Tally ERP using a MySQL Connection in Amazon QuickSight.
-
Integrate LDAP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LDAP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LDAP.
-
Build Dashboards with Vercel Data in DBxtra
Create dynamic dashboards and perform analytics based on Vercel in DBxtra.
-
Access ZohoDesk Data from MySQL in PHP
Connect to ZohoDesk through the standard MySQL libraries in PHP.
-
Connect to Twitter Ads Data in HULFT Integrate
Connect to Twitter Ads as a JDBC data source in HULFT Integrate
-
Integrate with Bugsnag Data in JReport Designer
Create charts and reports based on Bugsnag in JReport Designer.
-
Integrating Antigravity CLI with Slack via CData CLI
Connect Slack to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Viewing SpaceX Data in RAD Studio Data Explorer
How to view SpaceX in RAD Studio Data Explorer using the CData ODBC Driver for SpaceX.
-
Connect to Clockify Data in RapidMiner
Integrate Clockify with standard components and data source configuration wizards in RapidMiner Studio.
-
Create a Data Access Object for ServiceDesk Plus Data using JDBI
A brief overview of creating a SQL Object API for ServiceDesk Plus in JDBI.
-
Stream Azure Data Lake Storage Data into Apache Kafka Topics
Access and stream Azure Data Lake Storage in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build SAS Data Sets-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAS Data Sets to explore live SAS Data Sets Data in Claude Code to assist with building SAS Data Sets-powered applications.
-
Automated Continuous FreshBooks Replication to MySQL
Use CData Sync for automated, continuous, customizable FreshBooks replication to MySQL.
-
DataBind Controls to PabblySubscriptions Data in C++Builder
DataBind to PabblySubscriptions in C++Builder with standard components and controls.
-
Automated Continuous Blackbaud FE NXT Replication to Oracle
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Oracle.
-
Add QuickBooks Online Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks Online with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish SuiteCRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SuiteCRM.
-
How to Build an ETL App for Simplesat Data in Python with CData
Create ETL applications and real-time data pipelines for Simplesat in Python with petl.
-
Use Microsoft Copilot Studio to talk to your HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your HubSpot for you.
-
Build FHIR-Connected Apps in Choreo
Use CData Connect AI to connect to FHIR Data from Choreo and build custom apps using live FHIR.
-
Automated Continuous Azure Data Lake Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to SQLite.
-
How to connect to ADP Data from IntelliJ
Integrate connectivity to ADP with wizards in IntelliJ.
-
Integrate Shopify Data in the Pentaho Report Designer
Publish reports based on Shopify in the Pentaho BI tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for WordPress
Provide connectivity to WordPress through an SAP BusinessObjects universe.
-
How to Connect DBeaver to SageHR via a JDBC Driver
Manage SageHR with visual tools in DBeaver like the query browser.
-
Integrate with Databricks Data in JReport Designer
Create charts and reports based on Databricks in JReport Designer.
-
Integrate SurveyMonkey with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SurveyMonkey with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SurveyMonkey.
-
Automated Continuous Paylocity Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Paylocity replication to IBM DB2.
-
Automated Continuous LDAP Replication to MySQL
Use CData Sync for automated, continuous, customizable LDAP replication to MySQL.
-
Migrating data from Oracle Eloqua to Snowflake using CData SSIS Components.
Easily push Oracle Eloqua to Snowflake using the CData SSIS Tasks for Oracle Eloqua and Snowflake.
-
Consume Highrise OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Highrise feeds that reflect any changes in SAP Lumira.
-
Create Informatica Mappings From/To a JDBC Data Source for Float
Create Float data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData SSIS Components for Onfleet
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Onfleet.
-
Access Live JobNimbus Data in AWS Lambda
Connect to live JobNimbus in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy
Connect to Microsoft Dynamics NAV in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics NAV.
-
Extract, Transform, and Load Apollo Data in Informatica PowerCenter
Create a simple Workflow for Apollo in Informatica PowerCenter.
-
Connect to SAP Ariba Source Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Ariba Source to connect to SAP Ariba Source and execute queries in PowerBuilder.
-
Automated Continuous Insightly Replication to Oracle
Use CData Sync for automated, continuous, customizable Insightly replication to Oracle.
-
Analyze Amazon S3 Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Amazon S3 and visualize live Amazon S3 in Infragistics Reveal.
-
Use the CData Software ODBC Driver for Exa in MicroStrategy Desktop
Connect to Exa in MicroStrategy Desktop using the CData Software ODBC Driver for Exa.
-
How to load HubSpot data into Elasticsearch via Logstash
Introducing a simple method to load HubSpot data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Short.io-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Short.io.
-
Automated Continuous Planio Replication to MySQL
Use CData Sync for automated, continuous, customizable Planio replication to MySQL.
-
Connect to Vault CRM Data in JRuby
Create a simple JRuby app with access to live Veeva Vault & Vault CRM.
-
Build Semantic Layer Views for Auth0 Data in APOS Live Data Gateway
Use the CData Connector for Auth0 in APOS Live Data Gateway to build Semantic Layer Views for Auth0.
-
Integrate with SingleStore Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SingleStore in SnapLogic.
-
Visualize SAP Business One Data in TIBCO Spotfire through ADO.NET
Integrate SAP Business One into dashboards in TIBCO Spotfire.
-
How to Connect to Live Microsoft Entra ID Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft Entra ID for you.
-
Automated Continuous Act CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Act CRM replication to SQLite.
-
Replicate PagerDuty Data to Multiple Databases
Replicate PagerDuty to disparate databases with a point-and-click configuration.
-
Use Dash to Build to Web Apps on Google Drive Data
Create Python applications that use pandas and Dash to build Google Drive-connected web apps.
-
Connect to ZohoInvoice Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoInvoice and work with ZohoInvoice in your FileMaker applications.
-
How to Visualize Impala Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache Impala in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for DocuSign
Provide connectivity to DocuSign through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to Oracle Sales: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Sales from PowerBI.com to provide real-time Oracle Sales across the organization.
-
Notion Reporting in OBIEE with the Notion JDBC Driver
Deploy the Notion JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Dash to Build to Web Apps on MailerSend Data
Create Python applications that use pandas and Dash to build MailerSend-connected web apps.
-
Provide OData Services of SAP HANA XS Advanced Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP HANA XS Advanced by developing a WCF Service Application.
-
Replicate Humanity Data from PowerShell
Write a quick PowerShell script to query Humanity. Use connectivity to the live data to replicate Humanity to SQL Server.
-
Visualize Live QuickBooks Time Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks Time.
-
Access Live ActiveCampaign Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live ActiveCampaign data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connecting Moonlit Workflow with Oracle SCM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle SCM in real time.
-
Build AI/ML Models with Live PagerDuty Data using Dataiku
Connect PagerDuty Data with Dataiku using the CData API Driver for JDBC.
-
Access Live Snowflake Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Snowflake from your Excel spreadsheets.