CData Software - Knowledge Base
Recent Articles
-
Access Live Blackbaud FE NXT Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Blackbaud FE NXT from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software JDBC Driver for PostgreSQL in MicroStrategy Web
Connect to PostgreSQL in MicroStrategy Web using the CData Software JDBC Driver for PostgreSQL.
-
Work with Live Vertica Data in Power Query
Use CData Connect AI to connect to Vertica and work with live Vertica in Microsoft Power Query.
-
Automate Authorize.Net Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Authorize.Net from PowerShell? This article demonstrates how to utilize the Authorize.Net Cmdlets for tasks like connecting to Authorize.Net, automating operations, downloading data, and more.
-
Import and Visualize ChartMogul Data in Power View
Create data visualizations based on ChartMogul in Excel.
-
Validate Twitter Ads Data with QuerySurge
Access and validate Twitter Ads in QuerySurge using the CData JDBC Driver.
-
How to Access Parallel Data Using Entity Framework
This article shows how to access Parallel using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Dashboards with Jumpseller Data in Dundas BI
Create dynamic dashboards and perform analytics based on Jumpseller in Dundas BI.
-
Connect to Real-Time Gmail Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Gmail and Dataflow to import and use Gmail in Power Apps.
-
Visualize HDFS Data in Tableau
The CData ODBC driver for HDFS enables you integrate Apache HDFS into Tableau dashboards.
-
Connect to Dynamics CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics CRM and the SQL Gateway to access Microsoft Dynamics CRM from Google Apps Script.
-
How to Access Live Google Search Results in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Search enables you to integrate Google Search into workflows built using Microsoft Power Automate Desktop.
-
Visualize FHIR 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 FHIR into TIBCO Spotfire.
-
Build Semantic Layer Views for Salesforce Pardot Data in APOS Live Data Gateway
Use the CData Connector for Salesforce Pardot in APOS Live Data Gateway to build Semantic Layer Views for Salesforce Pardot.
-
How to Query Live Hive Data in Perplexity MacOS Desktop
Connect to and query live Hive Data in Perplexity Desktop using CData MCP Server.
-
Query Splunk Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Splunk entities in PHP by modeling them as objects.
-
Query Live Paylocity Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Paylocity directly from the development environment.
-
A PostgreSQL Interface for Clari Data using the CData ODBC Driver
Use the SQL Gateway and Clari ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from Power BI XMLA Data in Qlik Sense Cloud
Use CData Connect AI to connect to Power BI XMLA Data and build apps from live Power BI XMLA in Qlik Sense Cloud.
-
Create Datasets from Spark in Domo Workbench and Build Visualizations of Spark Data in Domo
Use the CData Software ODBC Driver for Spark to create datasets from Apache Spark SQL in Domo Workbench and then build visualizations in the Domo service.
-
Enable the JobNimbus JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with JobNimbus.
-
Publish Insightly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Insightly.
-
Natively Connect to SparkPost Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SparkPost. Leverage the native support for ODBC in PHP.
-
Connect to Zendesk Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zendesk in Google Apps Script.
-
Query iContact Data in DataGrip
Create a Data Source for iContact in DataGrip and use SQL to query live iContact.
-
Integrating OpenCode Terminal with Kintone 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 Connect DBeaver to Deel via a JDBC Driver
Manage Deel with visual tools in DBeaver like the query browser.
-
Access Live Salesforce CRM Analytics Data in TIBCO Data Virtualization
Use the Salesforce CRM Analytics Tibco DV Adapter to create a Salesforce CRM Analytics data source in TIBCO Data Virtualization Studio and gain access to live Salesforce CRM Analytics from your TDV Server.
-
Connect to Notion Data in NetBeans
Connect to Notion in NetBeans with the data source configuration wizard.
-
Migrating data from Excel Online to Databricks using CData SSIS Components.
Easily push Microsoft Excel Online to Databricks using the CData SSIS Tasks for Excel Online and Databricks.
-
Explore Geographical Relationships in Pipeliner CRM Data with Power Map
Create data visualizations with Pipeliner CRM in Power Map.
-
Build Data Flows from Presto to SQL Server using SSIS
Easily back up Presto to SQL Server using the SSIS components for Presto.
-
How to Work with Webflow Data in AWS Glue Jobs Using JDBC
Connect to Webflow from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connecting Pipedream with SurveyMonkey Data 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 SurveyMonkey data in real time.
-
Import Oracle HCM Cloud Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle HCM Cloud. In this article, you will use the OData format to import Oracle HCM Cloud into Microsoft Power Query.
-
Use Dash to Build Web Apps on BigCommerce Data via CData Connect AI
Build interactive Dash web apps on live BigCommerce using pandas and the CData Connect AI Python SDK.
-
How to use SQLAlchemy ORM to access DocuSign Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of DocuSign.
-
Use the CData Software JDBC Driver for Spotify in MicroStrategy Web
Connect to Spotify in MicroStrategy Web using the CData Software JDBC Driver for Spotify.
-
Automate XML Data Replication to Azure Synapse
Use CData Sync to customize and automate XML Files replication to Azure Synapse.
-
Migrating data from Tally to Databricks using CData SSIS Components.
Easily push Tally ERP to Databricks using the CData SSIS Tasks for Tally and Databricks.
-
How to create an RPA flow for Cloudant Data in UiPath Studio
Use the Cloudant ODBC Driver to create workflows that access real-time IBM Cloudant without any coding.
-
How to Connect DBeaver to SurveyMonkey via a JDBC Driver
Manage SurveyMonkey with visual tools in DBeaver like the query browser.
-
DataBind Charts to Outreach.io Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Outreach.io 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.
-
Create LinkedIn-Connected Applications in Appsmith
Connect to LinkedIn Data via CData Connect AI in Appsmith and create custom business applications with real-time access to LinkedIn.
-
How to Create Power BI Visual Reports with Real-Time Freshservice Data
Use CData Power BI Connectors to visualize Freshservice in Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for ServiceDesk Plus
Create an ODBC connection to ServiceDesk Plus in Informatica and browse and transfer ServiceDesk Plus.
-
Create Dynamic Oracle Eloqua Reporting Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle Eloqua Reporting to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Aha! Data in Sisense
Create an ElastiCube in Sisense app with access to Aha!.
-
Build a Simple VCL Application for Short.io Data
How to build a simple VCL Application to view Short.io in RAD Studio using the CData ODBC Driver for Short.io.
-
LINQ to Reckon 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 Reckon Data Provider.
-
Connect to QuickBooks Time Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for QuickBooks Time in Airbyte.
-
Deploy the ADO.NET Provider for Azure DevOps on an SSRS Report Server
Connect to Azure DevOps from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Deel Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Deel and work with Deel in your FileMaker applications.
-
Create SSAS Tabular Models from Notion Data
How to build a SQL Server Analysis Service Tabular Model from Notion using CData drivers.
-
How to connect and process SAS XPORT from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAS XPORT.
-
Integrate Live LaunchDarkly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LaunchDarkly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Highrise Data from HeidiSQL
Use CData Connect AI to connect to and query live Highrise CRM from HeidiSQL.
-
Query Clari Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Clari from Node.js.
-
Connect to Apify Data in RazorSQL
Connect to Apify from wizards and query Apify from the GUI in the RazorSQL database management tool.
-
Use Dash to Build to Web Apps on Box Data
Create Python applications that use pandas and Dash to build Box-connected web apps.
-
Use Databricks Agent Bricks to Talk to Your Microsoft OneDrive Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft OneDrive for you.
-
Build Visualizations of MarkLogic Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MarkLogic in Birst.
-
How to connect PolyBase to BigCommerce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live BigCommerce.
-
How to publish and share BigQuery Data dashboards with Tableau Server
The CData ODBC driver for BigQuery enables you integrate Google BigQuery into Tableau dashboards.
-
How to Query Live SAP Business One Data in Claude Desktop
Connect to and query live SAP Business One Data in Claude Desktop using CData MCP Server.
-
Use the CData Software ODBC Driver for SAP ByDesign in MicroStrategy Web
Connect to SAP Business ByDesign in MicroStrategy Web using the CData Software ODBC Driver for SAP ByDesign.
-
Manage Oracle Service Cloud Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle Service Cloud.
-
Working with SharePoint Excel Services Data in LINQPad
Execute LINQ queries to SharePoint Excel Services in LINQPad.
-
Visualize Rootly Data in TIBCO Spotfire through ADO.NET
Integrate Rootly into dashboards in TIBCO Spotfire.
-
Migrating data from Facebook Ads to Databricks using CData SSIS Components.
Easily push Facebook Ads to Databricks using the CData SSIS Tasks for Facebook Ads and Databricks.
-
Moving Data from HBase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HBase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
View Reports on Real-Time HelloSign Data in Power BI Report Server
Use the CData ODBC Driver for HelloSign to visualize HelloSign in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Reckon Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Reckon from Power Pivot. You will use the Table Import Wizard to load Reckon. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Azure Blob Storage Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Databricks.
-
Connect to Pinecone Data in RapidMiner
Integrate Pinecone with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Beeminder Data in the Pentaho Report Designer
Publish reports based on Beeminder in the Pentaho BI tool.
-
Connect to and Visualize Live Nuclia Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Nuclia.
-
Create Power BI Reports on Real-Time Microsoft Ads Data
Use the CData ODBC Driver for Microsoft Ads to visualize Microsoft Ads in Power BI Desktop.
-
Create Data Visualizations in Cognos BI with VWO Data
Access VWO as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Supabase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Supabase to connect to Supabase and execute queries in PowerBuilder.
-
Integrating Codex CLI with ZohoPeople 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 Bitly Data in TIBCO Spotfire through ADO.NET
Integrate Bitly into dashboards in TIBCO Spotfire.
-
DataBind CampaignMonitor Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CampaignMonitor to a chart.
-
Connect to Workable Data in CloverDX (formerly CloverETL)
Transfer Workable using the visual workflow in the CloverDX data integration tool.
-
How to connect SharePoint with Microsoft Teams Data through external lists
Provide Microsoft Teams to SharePoint users as an external list.
-
Query, Visualize, and Share live WooCommerce Data in Redash
Use CData Connect AI to connect to live WooCommerce in Redash for querying, visualizing, and sharing.
-
Process & Analyze PivotalTracker Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PivotalTracker Data.
-
Connect to Amazon DynamoDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon DynamoDB.
-
Access Live Amazon DynamoDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon DynamoDB from your Excel spreadsheets.
-
Publish SAP Fieldglass-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Fieldglass.
-
Rapidly Develop OpenWeatherMap-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 OpenWeatherMap.
-
Manage Phoenix Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Phoenix.
-
Connecting GenSpark with SAP Hybris C4C Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Hybris C4C without any replication or custom integration required.
-
How to Query Live Google Campaign Manager 360 Data in Claude Desktop
Connect to and query live Google Campaign Manager 360 Data in Claude Desktop using CData MCP Server.
-
Replicate YouTube Analytics Data to Multiple Databases via the CData Sync CLI
Replicate YouTube Analytics to disparate databases with a single configuration.
-
Rapidly Develop Optimizely-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 Optimizely.
-
Access Reckon 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 Reckon.
-
How to create Splunk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Splunk in MySQL .
-
Create Sage Intacct-Connected Applications in Appsmith
Connect to Sage Intacct Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sage Intacct.
-
Connect to Instagram Data in Google Apps Script via Connect AI
Use CData Connect AI to access Instagram in Google Apps Script.