CData Software - Knowledge Base
Recent Articles
-
Bind Live OneNote Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live OneNote data
-
How to connect Amazon QuickSight to Jira
Create a connection to Atlassian Jira in CData Connect AI and insert Atlassian Jira into Amazon QuickSight SPICE to build interactive dashboards.
-
Feed Salesforce Data Cloud into FineReport
How to set Salesforce Data Cloud as a JDBC data source in FineReport.
-
DataBind Charts to TaxJar
Use the standard ADO.NET procedures for databinding to provide bidirectional access to TaxJar 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.
-
Access Live Square in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Square from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Salesforce Pardot-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Pardot from Klipfolio and build custom visualizations using live Salesforce Pardot.
-
Create SSAS Tabular Models from Printify
How to build a SQL Server Analysis Service Tabular Model from Printify using CData drivers.
-
Edit and Search External OneNote Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft OneNote to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create OneNote objects that you can access from apps and the dashboard.
-
Connect to TaxJar in RazorSQL
Connect to TaxJar from wizards and query TaxJar from the GUI in the RazorSQL database management tool.
-
Connect to Typeform from PowerBuilder via ADO.NET
This article demonstrates how to access Typeform from Appeon PowerBuilder using the CData ADO.NET Provider for Typeform.
-
Connecting Pipedream with Azure Synapse via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Azure Synapse data in real time.
-
Create SSAS Tabular Models from Drip
How to build a SQL Server Analysis Service Tabular Model from Drip using CData drivers.
-
Connecting Moonlit Workflow with Salesforce Marketing 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 Salesforce Marketing Cloud in real time.
-
Create PingOne Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PingOne data access from reports, embedded analytics, and more.
-
Connect to MongoDB in RapidMiner
Integrate MongoDB with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Query Live SAP Ariba Procurement in Claude Desktop
Connect to and query live SAP Ariba Procurement in Claude Desktop using CData Code Assist MCP.
-
Replicate Adobe Analytics from PowerShell
Write a quick PowerShell script to query Adobe Analytics. Use connectivity to the live data to replicate Adobe Analytics to SQL Server.
-
Integrating Claude Code with Google Sheets via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Sheets within assisted coding and automated development workflows.
-
Build Workday-Connected Apps in Choreo
Use CData Connect AI to connect to Workday from Choreo and build custom apps using live Workday.
-
Connect to SFTP in CloverDX (formerly CloverETL)
Transfer SFTP using the visual workflow in the CloverDX data integration tool.
-
Access Sage Cloud Accounting from MySQL in PHP
Connect to Sage Cloud Accounting through the standard MySQL libraries in PHP.
-
Natively Connect to WooCommerce in PHP
The CData ODBC driver for WooCommerce enables you to create PHP applications with connectivity to WooCommerce. Leverage the native support for ODBC in PHP.
-
Manage SAP Concur in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Concur.
-
Integrate Live Exact Online into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Exact Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Exact Online.
-
How to Work with Sage Intacct in ETL Validator JDBC
Connect to Sage Intacct from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Act-On in Looker
Use CData Connect AI to connect to Act-On from Looker and build custom apps using live Act-On.
-
Viewing Salesloft in RAD Studio Data Explorer
How to view Salesloft in RAD Studio Data Explorer using the CData ODBC Driver for Salesloft.
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy Desktop
Connect to Microsoft Office 365 in MicroStrategy Desktop using the CData Software ODBC Driver for Office 365.
-
Feed Drift into FineReport
How to set Drift as a JDBC data source in FineReport.
-
Integrate GraphQL in Pentaho Data Integration
Build ETL pipelines based on GraphQL in the Pentaho Data Integration tool.
-
Replicate Oracle SCM in Heroku for Use in Salesforce Connect
Replicate Oracle SCM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
PowerShell Scripting to Replicate Adobe Analytics to MySQL
Write a simple PowerShell script to replicate Adobe Analytics to a MySQL database.
-
Connect to SendGrid in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SendGrid in Airbyte.
-
Edit and Search Presto External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Presto to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Presto objects that you can access from apps and the dashboard.
-
Connect Spark to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Spark with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Dataiku with Cosmos DB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Cosmos DB.
-
Model, Search, and Visualize Live Twilio in ThoughtSpot
Use CData Connect AI to connect to live Twilio for modeling, searching, and visualizing.
-
Access Live Microsoft Planner in AWS Lambda
Connect to live Microsoft Planner in AWS Lambda using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Oracle Service Cloud
Access Oracle Service Cloud as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Semantic Layer Views for Email in APOS Live Data Gateway
Use the CData Connector for Email in APOS Live Data Gateway to build Semantic Layer Views for Email.
-
Create Datasets from Adobe Commerce in Domo Workbench and Build Visualizations of Adobe Commerce in Domo
Use the CData Software ODBC Driver for Adobe Commerce to create datasets from Adobe Commerce in Domo Workbench and then build visualizations in the Domo service.
-
Building Dynamic Web Pages with BambooHR Using AngularJS
Create single-page applications with live connectivity to BambooHR using the CData API Server.
-
Back Up Salesloft to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesloft. In this article, we will employ an SSIS workflow to populate a database with Salesloft data.
-
Connect to Odoo from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Odoo ERP from Filemaker Pro on Mac.
-
Connect to SAP SuccessFactors as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP SuccessFactors.
-
Import Oracle Service Cloud into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle Service Cloud and provide access to live Oracle Service Cloud for custom reports in the Power BI Service.
-
Connect to Snowflake from PowerBuilder via JDBC
This article demonstrates how to access Snowflake from PowerBuilder using the Snowflake JDBC Driver.
-
How to connect to HubSpot in DBVisualizer
Integrate HubSpot with visual data analysis tools and data connection wizards in DBVisualizer
-
Import SQL Server into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft SQL Server. In this article, you will use the OData format to import Microsoft SQL Server into Microsoft Power Query.
-
LINQ to Microsoft Planner
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 Microsoft Planner Data Provider.
-
Access Live Microsoft Planner in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft Planner through MCP integration.
-
Connect to Pinterest in Claris FileMaker Pro
-