CData Software - Knowledge Base

Recent Articles

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »

• How to connect PolyBase to Oracle

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Database.

• Build SendGrid-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for SendGrid and create custom apps in Mendix.

• Building Dynamic Web Pages with Printful Using AngularJS

  Create single-page applications with live connectivity to Printful using the CData API Server.

• Analyze Harvest in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Harvest with the CData JDBC Driver for Harvest.

• Query Dynamics NAV through ODBC in Node.js

  Use node-odbc to execute SQL queries against Microsoft Dynamics NAV from Node.js.

• SAP HANA XS Advanced Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SAP HANA XS Advanced facts in real time.

• Create API-Connected Dashboards in Grafana

  Connect to API via CData Connect AI in Grafana and create custom business dashboards with real-time access to API.

• Create WooCommerce-Connected Applications in Appsmith

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

• Connect to Google Calendar from AWS Glue

  Use CData Connect AI to gain access to live Google Calendar from your AWS Glue jobs.

• Access Google Cloud Storage from MySQL in Amazon QuickSight

  Connect to Google Cloud Storage and build visualizations of Google Cloud Storage using a MySQL Connection in Amazon QuickSight.

• Connecting Agentforce with YouTube Analytics via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your YouTube Analytics for you.

• View Reports on Real-Time Jira in Power BI Report Server

  Use the CData ODBC Driver for Jira to visualize Atlassian Jira in Power BI Desktop and then publish them to Power BI Report Server.

• DataBind Blackbaud FE NXT to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Blackbaud FE NXT with the DevExpress Windows Forms and Web controls to provide Blackbaud FE NXT to a chart.

• Integrate with Box using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Box to a JSON file on disk.

• Use the CData ODBC Driver for Salesforce Marketing from SharePoint Excel Services

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

• Import Real-Time Microsoft Project via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Microsoft Project in ColdFusion.

• Integrating Boomi Agentstudio with Azure Table via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Table Storage, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• How to Build an ETL App for Reckon Accounts Hosted in Python with CData

  Create ETL applications and real-time data pipelines for Reckon Accounts Hosted in Python with petl.

• Connect to AlloyDB 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 Google AlloyDB.

• Use Dash to Build to Web Apps on Azure Analysis Services

  Create Python applications that use pandas and Dash to build Azure Analysis Services-connected web apps.

• Automated Continuous Phoenix Replication to MySQL

  Use CData Sync for automated, continuous, customizable Phoenix replication to MySQL.

• Automated Continuous Vertica Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Vertica replication to SQL Server.

• Build a PostgreSQL Interface for JotForm using the CData JDBC Driver

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

• Connect to YouTube Analytics in Aqua Data Studio

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

• Use Biml to Build SSIS Tasks to Replicate Sage 50 UK to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage 50 UK to SQL Server.

• Visualize Live Asana in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Asana into custom reports in Power BI.

• How to Connect the Power BI Service to Marketo: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Build SAP Business One-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SAP Business One and build web apps with connectivity to live SAP Business One.

• Viewing Azure Synapse in RAD Studio Data Explorer

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

• Connect to Jira Service Management in Aqua Data Studio

  Access Atlassian Jira Service Management from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Connect to Twitter Ads in ACL Analytics

  Connect to Twitter Ads via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Twitter Ads.

• How to create Azure Analysis Services federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Analysis Services in MySQL .

• Use the CData ODBC Driver for Gmail in Microsoft Power Query

  You can use the CData Gmail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gmail into Microsoft Power Query.

• Analyze Google Calendar with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Google Calendar from Power Pivot. You will use the Table Import Wizard to load Google Calendar. You can visually build the import query or use any SQL supported by the driver.

• Use the CData ODBC Driver for Microsoft Teams in Microsoft Power Query

  You can use the CData Microsoft Teams ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Teams into Microsoft Power Query.

• How to Query Google Search Results in MySQL Workbench

  Execute MySQL queries against live Google Search from MySQL Workbench.

• Query Printful through ODBC in Node.js

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

• How to Connect to & Open Greenplum in Microsoft Excel

  This article uses the CData ODBC driver for Greenplum to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• How to update Blackbaud FE NXT from Excel

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

• Visualize Zoho Projects in TIBCO Spotfire through ADO.NET

  Integrate Zoho Projects into dashboards in TIBCO Spotfire.

• Vault CRM Reporting in OBIEE with the Vault CRM JDBC Driver

  Deploy the Vault CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to publish and share Zoho Books dashboards with Tableau Server

  The CData ODBC driver for Zoho Books enables you integrate Zoho Books into Tableau dashboards.

• How to publish and share Phoenix dashboards with Tableau Server

  The CData ODBC driver for Phoenix enables you integrate Apache Phoenix into Tableau dashboards.

• Access Live SAP HANA in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live SAP HANA from your Excel spreadsheets.

• Automated Continuous Zoho Creator Replication to Oracle

  Use CData Sync for automated, continuous, customizable Zoho Creator replication to Oracle.

• Replicate Sage Intacct to Multiple Databases

  Replicate Sage Intacct to disparate databases with a point-and-click configuration.

• Connect to Microsoft OneDrive in RazorSQL

  Connect to Microsoft OneDrive from wizards and query Microsoft OneDrive from the GUI in the RazorSQL database management tool.

• Access Live RSS Feeds in AWS Lambda

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

• Automated Continuous Azure Active Directory Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to SQL Server.

• Automated Continuous Basecamp Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Basecamp replication to IBM DB2.

• Connect to ShipStation from Asprova with CData Software ODBC Driver for ShipStation

  This article shows how to connect faster to ShipStation data from Asprova.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SingleStore

  Provide connectivity to SingleStore through an SAP BusinessObjects universe.

• Build AI Agents with LinkedIn Ads Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can

• Build Office 365-Connected Apps in Choreo

  Use CData Connect AI to connect to Office 365 from Choreo and build custom apps using live Microsoft Office 365.

• Automated Continuous Avalara AvaTax Replication to Databricks

  Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Databricks.

• Use the CData Software ODBC Driver for Power BI XMLA in SAS for Real-Time Reporting and Analytics

  Connect to real-time Power BI XMLA in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Power BI XMLA.

• Connect to Odoo from Crystal Reports

  Use CData Connect AI to connect to and report on live Odoo ERP from Crystal Reports.

• Build a PostgreSQL Interface for Email using the CData JDBC Driver

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

• Create Reckon Accounts Hosted-Connected Applications in Appsmith

  Connect to Reckon Accounts Hosted via CData Connect AI in Appsmith and create custom business applications with real-time access to Reckon Accounts Hosted.

• Prepare, Blend, and Analyze Amazon DynamoDB in Alteryx Designer (ODBC)

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

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

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

• Working with Monday.com in LINQPad

  Execute LINQ queries to Monday.com in LINQPad.

• Build Azure Data Lake Storage Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Azure Data Lake Storage and build visualizations in Tableau Cloud.

• Build Visualizations of Sage 50 UK in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sage 50 UK in Birst.

• Create SAP Concur Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Automated Continuous Tableau CRM Analytics Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to OneLake in Microsoft Fabric.

• Analyze Zoho Creator in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Zoho Creator with the CData JDBC Driver for Zoho Creator.

• Query Exact Online through ODBC in Node.js

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

• Integrate Live Smartsheet into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Smartsheet from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Smartsheet.

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

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

• Analyze Tableau CRM Analytics in Cognos Analytics

  Use CData Connect AI to connect to Tableau CRM Analytics from Cognos Analytics and analyze live Tableau CRM Analytics.

• How to Query Live SAP Business One in Perplexity MacOS Desktop

  Connect to and query live SAP Business One in Perplexity Desktop using the CData MCP Server.

• Replicate Google Directory from PowerShell

  Write a quick PowerShell script to query Google Directory. Use connectivity to the live data to replicate Google Directory to SQL Server.

• Connect and Query Live Oracle Sales Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Oracle Sales into Databricks

• How to integrate eBay Analytics with Apache Airflow

  Access and process eBay Analytics in Apache Airflow using the CData JDBC Driver.

• Connect to and Visualize Live Databricks in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Databricks.

• Work with Live NetSuite in Power Query

  Use CData Connect AI to connect to NetSuite CRM & ERP and work with live NetSuite CRM & ERP in Microsoft Power Query.

• Validate Act-On with QuerySurge

  Access and validate Act-On in QuerySurge using the CData JDBC Driver.

• How to Connect to Live Adobe Analytics from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Adobe Analytics for you.

• Stream IBM Cloud Object Storage into Apache Kafka Topics

  Access and stream IBM Cloud Object Storage in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to Zoho Creator from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Zoho Creator to connect to Zoho Creator and execute queries in PowerBuilder.

• Visualize Live Basecamp in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Basecamp.

• Visualize Microsoft Planner from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Microsoft Planner.

• Connect to Trello in Ruby

  Connect to Trello in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Build Data Flows from SQL Server to XML through SSIS

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

• Model, Search, and Visualize Live Azure Table in ThoughtSpot

  Use CData Connect AI to connect to live Azure Table Storage for modeling, searching, and visualizing.

• How to create an RPA flow for FHIR in UiPath Studio

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

• Use Azure AI Foundry to Talk to Your Adobe Commerce via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Adobe Commerce for you.

• Connect to QuickBooks Online in Aqua Data Studio

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

• Create Dynamic JotForm Grids Using the Infragistics XamDataGrid

  Learn how you can connect JotForm to Infragistics XamDataGrid to build dynamic grids.

• How to load Cloudant data into Elasticsearch via Logstash

  Introducing a simple method to load Cloudant data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Bridge Facebook Connectivity with Apache NiFi

  Access and process Facebook in Apache NiFi using the CData JDBC Driver.

• Access Live ConstantContact in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate ConstantContact into the statistical analysis tools available in SAS JMP. This article shows how to use ConstantContact in the Graph Builder and Query Builder.

• Access Live SendGrid Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live SendGrid data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Working with PayPal in LINQPad

  Execute LINQ queries to PayPal in LINQPad.

• Use Biml to Build SSIS Tasks to Replicate GitHub to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate GitHub to SQL Server.

• Visualize SQL Analysis Services in TIBCO Spotfire through ADO.NET

  Integrate SQL Analysis Services into dashboards in TIBCO Spotfire.

• Connect to Azure Data Lake Storage in NetBeans

  Connect to Azure Data Lake Storage in NetBeans with the data source configuration wizard.

• Connect to Live Odoo in MicroStrategy through CData Connect AI

  Create a live connection to Odoo in CData Connect AI and connect to your Odoo ERP from MicroStrategy.

• Consume Bing Ads OData Feeds in PowerBuilder

  This article demonstrates how to consume Bing Ads as OData feeds from PowerBuilder using the API Server.

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »