CData Software - Knowledge Base
Recent Articles
-
Integrate Invoiced Data in the Pentaho Report Designer
Publish reports based on Invoiced data in the Pentaho BI tool.
-
Access Amplitude 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 Amplitude data.
-
Create XML-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to XML Data from OutSystems and build custom enterprise apps using live XML data.
-
How to connect and process Pipeliner CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pipeliner CRM data.
-
DataBind Charts to Airtable Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Airtable data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Replicate Multiple Impala Accounts
Replicate multiple Impala accounts to one or many databases.
-
Configure the CData JDBC Driver for Auth0 in a Connection Pool in Tomcat
Connect to Auth0 data from a connection pool in Tomcat.
-
Connect to ZohoMarketingHub Data from HeidiSQL
Use CData Connect AI to connect to and query live ZohoMarketingHub data from HeidiSQL.
-
Integrate Live OneNote Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live OneNote data to Blue Prism using the CData ODBC Driver for OneNote to create automated workflows for repetitive business tasks.
-
How to work with Printful Data in Apache Spark using SQL
Access and process Printful Data in Apache Spark using the CData Software JDBC Driver.
-
How to work with Opsgenie Data in Apache Spark using SQL
Access and process Opsgenie Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous MessageBird Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MessageBird replication to Amazon S3.
-
How to Connect DBeaver to Procore via a JDBC Driver
Manage Procore data with visual tools in DBeaver like the query browser.
-
Create Dynamic Square Grids Using the Infragistics XamDataGrid
Learn how you can connect Square to Infragistics XamDataGrid to build dynamic grids.
-
Visualize HDFS 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 HDFS data into TIBCO Spotfire.
-
Build Automated Freshteam-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshteam data and build automated workflows in Zapier.
-
A PostgreSQL Interface for FormSite Data using the CData ODBC Driver
Use the SQL Gateway and FormSite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate MessageBird Data Replication to Couchbase
Use CData Sync to Customize and automate MessageBird data replication to Couchbase.
-
Automated Continuous Hubstaff Replication to Databricks
Use CData Sync for automated, continuous, customizable Hubstaff replication to Databricks.
-
Integrate LibreChat with Live Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Mailgun data from within the chat interface.
-
Migrating data from Auth0 to Databricks using CData SSIS Components.
Easily push Auth0 data to Databricks using the CData SSIS Tasks for Auth0 and Databricks.
-
Connect PingOne to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PingOne with IBM WebSphere for seamless data integration and connectivity.
-
Build a Simple VCL Application for Sage Intacct Data
How to build a simple VCL Application to view Sage Intacct data in RAD Studio using the CData ODBC Driver for Sage Intacct.
-
Automate SAP HANA XS Advanced Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP HANA XS Advanced data from PowerShell? This article demonstrates how to utilize the SAP HANA XS Advanced Cmdlets for tasks like connecting to SAP HANA XS Advanced data, automating operations, downloading data, and more.
-
How to Visualize Google Directory Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Directory data in Python.
-
Automated Continuous Clockify Replication to SQLite
Use CData Sync for automated, continuous, customizable Clockify replication to SQLite.
-
Connect to Sage Intacct Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Sage Intacct data.
-
How to publish and share Bugsnag Data dashboards with Tableau Server
The CData ODBC driver for Bugsnag enables you integrate Bugsnag data into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for QuickBooks Online
Create an ODBC connection to QuickBooks Online in Informatica and browse and transfer QuickBooks Online data.
-
DataBind Outlook Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Outlook data to a chart.
-
Access Live Neo4J Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Neo4J data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query, Visualize, and Share live MariaDB Data in Redash
Use CData Connect AI to connect to live MariaDB data in Redash for querying, visualizing, and sharing.
-
Load PayPal Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PayPal data to a database.
-
Create Spark Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Spark data access from reports, embedded analytics, and more.
-
Connect to Datadog Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Datadog and the SQL Gateway to access Datadog data from Google Apps Script.
-
Visualize LeadDesk Data in Tableau
The CData ODBC driver for LeadDesk enables you integrate LeadDesk data into Tableau dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for HelloSign
Create HelloSign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating LlamaIndex with Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Salesforce CRM Analytics data in real time.
-
Connect to Wrike Data in DBArtisan
Use wizards in DBArtisan to configure Wrike data as a data source.
-
Getting Started with the CData Python Connector for Dynamics 365
Learn to install and license the CData Python Connector and configure a connection to live Dynamics 365 data.
-
Integrating Humanity Data in Talend Cloud Data Management Platform
Connect Humanity Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Agents in Relevance AI with Access to Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Dropbox data within intelligent agent workflows.
-
Import Real-Time ShipStation Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ShipStation data in ColdFusion.
-
Import Real-Time Supabase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Supabase data in ColdFusion.
-
How to Access Zoho CRM Data Using Entity Framework
This article shows how to access Zoho CRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Easily Query Elorus Data in OpenOffice Base
Connect to Elorus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create SSAS Tabular Models from Xero Data
How to build a SQL Server Analysis Service Tabular Model from Xero data using CData drivers.
-
Extract, Transform, and Load Toggl Data in Informatica PowerCenter
Create a simple Workflow for Toggl data in Informatica PowerCenter.
-
Connect to PingOne Data in Aqua Data Studio
Access PingOne data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Discourse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Discourse data using standard SQL.
-
Connect to Zoho Projects Data in RazorSQL
Connect to Zoho Projects from wizards and query Zoho Projects data from the GUI in the RazorSQL database management tool.
-
Create Instagram-Connected Business Apps in AppSheet
Connect to Instagram Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Instagram data.
-
Use the CData Software ODBC Driver for Google Directory in MicroStrategy Web
Connect to Google Directory data in MicroStrategy Web using the CData Software ODBC Driver for Google Directory.
-
Connect to Real-Time Zoho CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho CRM and Dataflow to import and use Zoho CRM data in Power Apps.
-
Connect to Live Amazon DynamoDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Amazon DynamoDB in CData Connect AI and connect to your Amazon DynamoDB data from PostgreSQL.
-
DataBind Controls to ServiceDesk Plus Data in C++Builder
DataBind to ServiceDesk Plus data in C++Builder with standard components and controls.
-
Build Data Flows from OnePageCrm to SQL Server using SSIS
Easily back up OnePageCrm data to SQL Server using the SSIS components for OnePageCrm.
-
Load Wrike Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Wrike data to a database.
-
Automated Continuous Highrise Replication to Oracle
Use CData Sync for automated, continuous, customizable Highrise replication to Oracle.
-
Analyze SharePoint Excel Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SharePoint Excel Services data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Semantic Layer Views for EmailOctopus Data in APOS Live Data Gateway
Use the CData Connector for EmailOctopus in APOS Live Data Gateway to build Semantic Layer Views for EmailOctopus data.
-
Dotmailer Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dotmailer facts in real time.
-
Extract, Transform, and Load Zoho Recruit Data in Informatica PowerCenter
Create a simple Workflow for Zoho Recruit data in Informatica PowerCenter.
-
Natively Connect to Confluence Data in PHP
The CData ODBC driver for Confluence enables you to create PHP applications with connectivity to Confluence data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for ADP in MicroStrategy Web
Connect to ADP data in MicroStrategy Web using the CData Software JDBC Driver for ADP.
-
Consume CouchDB OData Feeds in PowerBuilder
This article demonstrates how to consume CouchDB data as OData feeds from PowerBuilder using the API Server.
-
Integrate Live Neo4J Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Neo4J data and integrate live Neo4J data into apps built in Microsoft Power Apps.
-
Visualize Bannerbear Data in TIBCO Spotfire through ADO.NET
Integrate Bannerbear data into dashboards in TIBCO Spotfire.
-
Access Live Confluence Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Confluence data into the statistical analysis tools available in SAS JMP. This article shows how to use Confluence data in the Graph Builder and Query Builder.
-
Connect and Query Live Microsoft Entra ID Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Entra ID data into Databricks and enable direct, live querying and analysis without replication.
-
Validate Intercom Data with QuerySurge
Access and validate Intercom data in QuerySurge using the CData JDBC Driver.
-
Automate QuickBooks Data Replication to Azure Data Lake
Use CData Sync to customize and automate QuickBooks data replication to Azure Data Lake.
-
Connect to Splunk Data in DBArtisan
Use wizards in DBArtisan to configure Splunk data as a data source.
-
LINQ to Smartsheet 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 Smartsheet Data Provider.
-
Connect to Postmark Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Postmark data in the Denodo Virtual DataPort Administrator.
-
Visualize Harvest Data in TIBCO Spotfire through ADO.NET
Integrate Harvest data into dashboards in TIBCO Spotfire.
-
Connecting Mastra with Snapchat Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Snapchat Ads data, no replication required.
-
Establish a Live Connection with Smartsheet Data using Tableau Bridge
The CData ODBC Driver for Smartsheet enables you to integrate live Smartsheet data into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Power BI Connector for xBase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for xBase.
-
Integrate Dify with Live Notion Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Notion data.
-
Integrate Contentful Data in Pentaho Data Integration
Build ETL pipelines based on Contentful data in the Pentaho Data Integration tool.
-
Process & Analyze Snowflake Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Snowflake Data.
-
Migrating data from FHIR to Snowflake using CData SSIS Components.
Easily push FHIR data to Snowflake using the CData SSIS Tasks for FHIR and Snowflake.
-
Access Live Salesforce Pardot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesforce Pardot data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Retently Data from a Connection Pool in JBoss
Integrate Retently data into Java servlets: Use the Management Console in JBoss to install the Retently JDBC Driver.
-
Extract, Transform, and Load MariaDB Data in Informatica PowerCenter
Create a simple Workflow for MariaDB data in Informatica PowerCenter.
-
Query Amazon Marketplace Data in DataGrip
Create a Data Source for Amazon Marketplace in DataGrip and use SQL to query live Amazon Marketplace data.
-
Connect to Avalara AvaTax from a Connection Pool in WebLogic
Use the CData JDBC Driver for Avalara AvaTax to connect to Avalara AvaTax data from Web applications running on WebLogic.
-
Automate Microsoft OneDrive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft OneDrive data from PowerShell? This article demonstrates how to utilize the Microsoft OneDrive Cmdlets for tasks like connecting to Microsoft OneDrive data, automating operations, downloading data, and more.
-
Automated Continuous Zoho Creator Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Creator replication to IBM DB2.
-
Connect to Avalara AvaTax Data in ACL Analytics
Connect to Avalara AvaTax data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Avalara AvaTax data.
-
Integrate LibreChat with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live CockroachDB data from within the chat interface.
-
How to Work with Zendesk Data in ETL Validator JDBC
Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy Desktop
Connect to Aircall data in MicroStrategy Desktop using the CData Software JDBC Driver for Aircall.
-
Create Data Visualizations in Cognos BI with SAP Netweaver Gateway Data
Access SAP Netweaver Gateway data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Live Twitter Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Twitter Ads in CData Connect AI and connect to your Twitter Ads data from PostgreSQL.
-
Query Autopilot Data in DataGrip
Create a Data Source for Autopilot in DataGrip and use SQL to query live Autopilot data.
-
Connect CockroachDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CockroachDB data using the CData Python MCP Server.
-
Integrate ZohoMarketingHub with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoMarketingHub with External Services.
-
Getting Started with the CData ODBC Driver for Pingdom
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pingdom.