CData Software - Knowledge Base

Recent Articles

---

• «
• 879
• 880
• 881
• 882
• 883
• 884
• 885
• 886
• 887
• 888
• »

• Build FHIR Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live FHIR and build visualizations in Tableau.

• LINQ to Foursquare 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 Foursquare Data Provider.

• Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy

  Connect to Microsoft Teams in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Teams.

• Create SSAS Tabular Models from ZarMoney Data

  How to build a SQL Server Analysis Service Tabular Model from ZarMoney using CData drivers.

• Access Live SAP Netweaver Gateway Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SAP Netweaver Gateway from your Google Sheets.

• Query CloudConvert Data in ColdFusion

  Write standard ColdFusion data access code to connect to CloudConvert.

• A PostgreSQL Interface for JDBC-ODBC Bridge Data (MySQL Remoting via JDBC)

  Use the Remoting features of the JDBC-ODBC Bridge JDBC Driver to create a PostgreSQL entry-point for data access.

• Integrate Goose with Live ADP Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ADP from within the local AI agent.

• Manage Salesforce Pardot Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Salesforce Pardot.

• Analyze Stripe Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Stripe and visualize live Stripe in Infragistics Reveal.

• Query Facebook Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Facebook from Node.js.

• Import Gmail Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Gmail Data and provide access to live Gmail for custom reports in the Power BI Service.

• Connect and Query Live Procore Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Procore into Databricks

• Automated Continuous Azure DevOps Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Azure DevOps replication to delimited files (CSV/TSV).

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Acumatica ERP to Power BI dashboards. Simply drag and drop Acumatica ERP into data visuals on the Power BI canvas.

• How to update Redis from Excel

  This article explains how to transfer data from Excel to Redis using the Excel Add-In for Redis.

• Integrating Codex CLI with Microsoft Dataverse (CDS) 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 Automated Oracle HCM Cloud-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Oracle HCM Cloud and build automated workflows in Zapier.

• Build SAP ByDesign-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Business ByDesign.

• Connect to Epicor Kinetic Data in HULFT Integrate

  Connect to Epicor Kinetic as a JDBC data source in HULFT Integrate

• Create SingleStore Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time SingleStore data access from reports, embedded analytics, and more.

• Use the CData SSIS Components to Insert New or Update Existing DB2 Records from SQL Server

  Easily push SQL Server data to DB2 using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into DB2 or update existing records with data from a SQL Server database.

• Automated Continuous Paylocity Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Paylocity replication to Amazon Redshift.

• Use the CData Software JDBC Driver for Teradata in MicroStrategy Web

  Connect to Teradata in MicroStrategy Web using the CData Software JDBC Driver for Teradata.

• Connect to Live Salesforce Marketing Data in MicroStrategy through CData Connect AI

  Create a live connection to Salesforce Marketing Data in CData Connect AI and connect to your Salesforce Marketing Cloud from MicroStrategy.

• Use the CData ODBC Driver for Deel from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Deel to connect to Deel from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Deel in Excel.

• Model FreshBooks Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and FreshBooks, enabling the direct import of real-time FreshBooks.

• Automate eBay Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live eBay and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• How to Query Live Onfleet Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Onfleet data in natural language using Python.

• Bind Live Asana Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Asana data

• Automated Continuous Typeform Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Typeform replication to Apache Kafka.

• Create Oracle SCM-Connected Applications in Appsmith

  Connect to Oracle SCM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle SCM.

• Use the CData Software JDBC Driver for Recurly in MicroStrategy

  Connect to Recurly in MicroStrategy Developer using the CData Software JDBC Driver for Recurly.

• Migrating data from LaunchDarkly to Databricks using CData SSIS Components.

  Easily push LaunchDarkly to Databricks using the CData SSIS Tasks for LaunchDarkly and Databricks.

• Create SAP BusinessObjects BI Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP BusinessObjects BI data access from reports, embedded analytics, and more.

• Build Autopilot-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Autopilot and build web apps with connectivity to live Autopilot.

• Query Aircall Data in ColdFusion

  Write standard ColdFusion data access code to connect to Aircall.

• LINQ to SurveyMonkey 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 SurveyMonkey Data Provider.

• Connect to SpaceX Data in Aqua Data Studio

  Access SpaceX from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Build Salesforce Marketing-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Salesforce Marketing Cloud and build web apps with connectivity to live Salesforce Marketing Cloud.

• Visualize Live Asana Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Asana using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Build Data Flows from SQL Server to FTP through SSIS

  Easily push SQL Server data to FTP using the CData SSIS Tasks for FTP.

• How to Connect Flowise AI Agents to Live Sybase IQ Data via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Sybase IQ without replication.

• How to connect and process Factorial from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Factorial.

• Create Airtable-Connected Nintex Workflows

  Use CData Connect AI to connect to Airtable Data from Nintex Workflow Cloud and build custom workflows using live Airtable.

• Publish Crystal Reports on Discourse Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Discourse.

• A PostgreSQL Interface for TaxJar Data using the CData ODBC Driver

  Use the SQL Gateway and TaxJar ODBC Driver to create a PostgreSQL entry-point for data access.

• Edit and Search External Reckon Accounts Hosted Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Reckon Accounts Hosted to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Reckon Accounts Hosted Data objects that you can access from apps and the dashboard.

• Analyze Short.io Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Short.io in Microsoft R Open.

• Automated Continuous SAS xpt Replication to SQLite

  Use CData Sync for automated, continuous, customizable SAS xpt replication to SQLite.

• Integrate Live Presto Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Presto to Blue Prism using the CData ODBC Driver for Presto to create automated workflows for repetitive business tasks.

• Migrating data from REST to Databricks using CData SSIS Components.

  Easily push REST to Databricks using the CData SSIS Tasks for REST and Databricks.

• Bidirectional Access to XML Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate XML Files in Filemaker Pro for Mac or Windows.

• Automate Pingdom Data Replication to Azure Synapse

  Use CData Sync to customize and automate Pingdom replication to Azure Synapse.

• Prepare, Blend, and Analyze SendGrid Data in Alteryx Designer (Connect AI)

  Build workflows to access live SendGrid for self-service data analytics.

• Excel Spreadsheet Automation on Optimizely Data with the QUERY Formula

  Pull data from Optimizely, automate spreadsheets, and more with the QUERY formula.

• Build Automated Workflows with Live Salesforce Pardot Data in Workato

  Use CData Connect AI to connect to live Salesforce Pardot and build automated workflows in Workato.

• Create Reports from Reckon Accounts Hosted Data in Looker Studio

  Use CData Connect AI to gain access to live Reckon Accounts Hosted and create custom reports in Looker Studio.

• Migrating data from Clari to Snowflake using CData SSIS Components.

  Easily push Clari to Snowflake using the CData SSIS Tasks for Clari and Snowflake.

• Connect to Avalara AvaTax Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Avalara AvaTax as an External Source in Dremio.

• Connect to Real-Time Shopify Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for Shopify and Dataflow to import and use Shopify in Power Apps.

• Connect to LinkedIn Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for LinkedIn Data and connect to LinkedIn in Akorbi Digital RunMyProcess.

• Automated Continuous Excel Online Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Excel Online replication to OneLake in Microsoft Fabric.

• Build Semantic Layer Views for LionDesk Data in APOS Live Data Gateway

  Use the CData Connector for LionDesk in APOS Live Data Gateway to build Semantic Layer Views for LionDesk.

• Viewing Campaigner Data in RAD Studio Data Explorer

  How to view Campaigner in RAD Studio Data Explorer using the CData ODBC Driver for Campaigner.

• Getting Started with the CData ADO.NET Provider for Webex

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Connect to Excel Data from a Connection Pool in Jetty

  The Excel JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Excel from Web apps in Jetty.

• Create Informatica Mappings From/To an ODBC Data Source for Zoho Creator

  Create an ODBC connection to Zoho Creator in Informatica and browse and transfer Zoho Creator.

• Create Datasets from Sybase IQ in Domo Workbench and Build Visualizations of Sybase IQ Data in Domo

  Use the CData Software ODBC Driver for Sybase IQ to create datasets from Sybase IQ in Domo Workbench and then build visualizations in the Domo service.

• Getting Started with the CData SSIS Components for Sage Intacct

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage Intacct.

• Operational Reporting on ConstantContact Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote ConstantContact.

• Build MVC Applications with Connectivity to Greenhouse Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Greenhouse from an ASP.NET MVC application.

• Publish Reports with SAP Fieldglass Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Fieldglass.

• Connect to SAP Ariba Procurement Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for SAP Ariba Procurement in Airbyte.

• Integrating Codex CLI with Codat 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.

• Work with Live OData Services in Power Query

  Use CData Connect AI to connect to OData and work with live OData in Microsoft Power Query.

• Automated Continuous Blackbaud FE NXT Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to MongoDB.

• How to create an RPA flow for Invoiced Data in UiPath Studio

  Use the Invoiced ODBC Driver to create workflows that access real-time Invoiced without any coding.

• Automated Continuous Kafka Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Kafka replication to Azure SQL Database.

• Automated Continuous Google Calendar Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Google Calendar replication to Apache Cassandra.

• Build Active Directory-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Active Directory.

• Connect TigerGraph Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your TigerGraph using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• How to integrate Azure Table with Apache Airflow

  Access and process Azure Table Storage in Apache Airflow using the CData JDBC Driver.

• How to Easily Query Cloudant Data in OpenOffice Base

  Connect to Cloudant data in OpenOffice Base using the CData ODBC Driver for Cloudant and generate reports with live data insights.

• Integrate LibreChat with Live MongoDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MongoDB from within the chat interface.

• Connect to Snapchat Ads Data in DBArtisan

  Use wizards in DBArtisan to configure Snapchat Ads as a data source.

• How to Access Live Cloudant Data in Visual Studio Code via Cline

  Run CData MCP Server for Cloudant on Windows Subsytem for Linux (WSL) and connect to live IBM Cloudant from the Cline extension in Visual Studio Code.

• How to Easily Query Nuclia Data in OpenOffice Base

  Connect to Nuclia data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• Access Live Todoist Data in AWS Lambda

  Connect to live Todoist in AWS Lambda using the CData JDBC Driver.

• Integrating Cursor CLI with Google Forms 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.

• Create Data Visualizations in Cognos BI with Procore Data

  Access Procore as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Use the CData Software ODBC Driver for BambooHR in MicroStrategy

  Connect to BambooHR in MicroStrategy Developer using the CData Software ODBC Driver for BambooHR.

• Prepare, Blend, and Analyze Sugar CRM Data in Alteryx Designer (Connect AI)

  Build workflows to access live Sugar CRM for self-service data analytics.

• Build CouchDB-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Apache CouchDB and build web apps with connectivity to live Apache CouchDB.

• How to Access Live Databricks Data in Visual Studio Code via Cline

  Run CData MCP Server for Databricks on Windows Subsytem for Linux (WSL) and connect to live Databricks from the Cline extension in Visual Studio Code.

• Connect to QuickBooks Online Data from a Connection Pool in Jetty

  The QuickBooks Online JDBC Driver supports connection pooling: This article shows how to connect faster to QuickBooks Online from Web apps in Jetty.

• Access Live Odoo Data 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 Odoo ERP through MCP integration.

• How to connect to Egnyte Data from Spring Boot

  Connect to Egnyte in a Spring Boot Application using the CData API Driver for JDBC

• Getting Started with the CData SSIS Components for Foursquare

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Foursquare.

• How to publish and share CSV Data dashboards with Tableau Server

  The CData ODBC driver for CSV enables you integrate CSV/TSV Files into Tableau dashboards.

• «
• 879
• 880
• 881
• 882
• 883
• 884
• 885
• 886
• 887
• 888
• »