CData Software - Knowledge Base

Recent Articles

• «
• 455
• 456
• 457
• 458
• 459
• 460
• 461
• 462
• 463
• 464
• »

• Integrate Zoho Inventory into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Zoho Inventory and integrate live Zoho Inventory into your Power Automate tasks.

• ETL RSS in Oracle Data Integrator

  This article shows how to transfer RSS Feeds into a data warehouse using Oracle Data Integrator.

• 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 from PowerShell? This article demonstrates how to utilize the SAP HANA XS Advanced Cmdlets for tasks like connecting to SAP HANA XS Advanced, automating operations, downloading data, and more.

• How to pipe Bitbucket to CSV in PowerShell

  Use standard PowerShell cmdlets to access Bitbucket tables.

• Choosing the Best Method to Connect SAP Ariba Source to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use SAP Ariba Source from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Connect to Redis in ACL Analytics

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

• Visualize LDAP Objects from Tableau

  Use the Tableau Desktop business intelligence tool to connect to LDAP.

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

  Create an ODBC connection to Twilio in Informatica and browse and transfer Twilio.

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

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

• Automated Continuous Oracle Eloqua Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to AlloyDB.

• Connect to SAP Netweaver Gateway as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Netweaver Gateway.

• Build Charts with DocuSign in Clear Analytics

  Create dynamic charts and perform analytics based on DocuSign in Clear Analytics.

• Visualize Live Zendesk of Power BI Report Builder in Power BI Service

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

• How to integrate Google Spanner with Apache Airflow

  Access and process Google Spanner in Apache Airflow using the CData JDBC Driver.

• Access SAP Fieldglass from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SAP Fieldglass from HeidiSQL.

• Analyze SAP Ariba Source in R via JDBC

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

• How to Connect to Live SAP BusinessObjects BI from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SAP BusinessObjects BI for you.

• Automated Continuous ClickUp Replication to MySQL

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

• Publish Crystal Reports on Todoist

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

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

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

• How to Use a Microsoft Access Database to Update Oracle in Real Time

  Update Oracle data by creating a linked table in Microsoft Access with the CData Oracle ODBC Driver.

• Access Live Oracle HCM Cloud in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Oracle HCM Cloud from your Excel spreadsheets.

• Analyze Presto in R via ODBC

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

• Automate Sybase Tasks in Power Automate Using CData API Server

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

• Build Azure Active Directory-Connected Apps in Choreo

  Use CData Connect AI to connect to Azure Active Directory from Choreo and build custom apps using live Azure Active Directory.

• Operational Reporting on Printify from Spotfire Server

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

• Analyze Couchbase in R via JDBC

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

• Connect to Confluence through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Confluence using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Import SAP HANA XS Advanced into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP HANA XS Advanced. In this article, you will use the OData format to import SAP HANA XS Advanced into Microsoft Power Query.

• Write a Simple Go Application to work with SAS xpt on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAS XPORT.

• How to load Teradata data into Elasticsearch via Logstash

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

• How to work with Printify in Apache Spark using SQL

  Access and process Printify in Apache Spark using the CData Software JDBC Driver.

• Query CockroachDB through ODBC in Node.js

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

• Use the CData ODBC Driver for IBM Cloud Object Storage from SharePoint Excel Services

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

• Access Live Exact Online in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Exact Online from your Excel spreadsheets.

• Query Active Directory in ColdFusion

  Write standard ColdFusion data access code to connect to Active Directory.

• Using the CData Software ODBC Driver for Google Ad Manager in PyCharm

  Connect to Google Ad Manager as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Ad Manager.

• How to connect to Drip from Spring Boot

  Connect to Drip in a Spring Boot Application using CData JDBC Drip Driver

• Bridge Databricks Connectivity with Apache NiFi

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

• Access Live SAS Data Sets in SAS JMP via ODBC

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

• Build Oracle Financials Cloud Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Oracle Financials Cloud and build visualizations in Tableau.

• Replicate Excel in Heroku for Use in Salesforce Connect

  Replicate Microsoft Excel to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to BigQuery as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Google BigQuery.

• How to import Cvent into Apache Solr

  Use the CData Software JDBC Driver for Cvent in Data Import Handler and create an automated import of Cvent to Apache Solr Enterprise Search platform.

• Automate MarkLogic Replication to SAP HANA

  Use CData Sync to customize and automate MarkLogic replication to SAP HANA.

• Write a Simple Go Application to work with SAP Hybris C4C on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Hybris C4C.

• Automated Continuous Azure Data Catalog Replication to Local Delimited Files

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

• Automated Continuous BambooHR Replication to Oracle

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

• Build Agents in Relevance AI with Access to Live Raisers Edge NXT via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Raisers Edge NXT within intelligent agent workflows.

• Access YouTube Analytics as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access YouTube Analytics from your Oracle system.

• Building Dynamic Web Pages with LDAP Objects Using AngularJS

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

• Enable the Parquet JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Apache Parquet.

• Replicate Dynamics NAV from PowerShell

  Write a quick PowerShell script to query Microsoft Dynamics NAV. Use connectivity to the live data to replicate Microsoft Dynamics NAV to SQL Server.

• Connect to Greenhouse from PowerBuilder via JDBC

  This article demonstrates how to access Greenhouse from PowerBuilder using the Greenhouse JDBC Driver.

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

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

• Integrate with Live Avalara AvaTax in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Avalara AvaTax from the MuleSoft Anypoint Platform to integrate live Avalara AvaTax into custom reports and dashboards.

• Bridge SAS xpt Connectivity with Apache NiFi

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

• How to Build an ETL App for HubDB in Python with CData

  Create ETL applications and real-time data pipelines for HubDB in Python with petl.

• Access Vault CRM 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 Veeva Vault & Vault CRM.

• Query Printful as a MySQL Database in Node.js

  Execute MySQL queries against Printful from Node.js.

• Extract, Transform, and Load xBase in Informatica PowerCenter

  Create a simple Workflow for xBase in Informatica PowerCenter.

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

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

• Integrate GitHub into Power Automate Desktop using CData Connect

  CData Connect for GitHub enables you to integrate GitHub into workflows built using Microsoft Power Automate Desktop.

• Use Dash to Build to Web Apps on Procore

  Create Python applications that use pandas and Dash to build Procore-connected web apps.

• How to connect SharePoint with Smartsheet through external lists

  Provide Smartsheet to SharePoint users as an external list.

• Create Data Visualizations in Cognos BI with Neo4J

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

• 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.

• Migrating data from Snapchat Ads to Snowflake using CData SSIS Components.

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

• How to connect and process Azure Data Lake Storage from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Data Lake Storage.

• Query JotForm in DataGrip

  Create a Data Source for JotForm in DataGrip and use SQL to query live JotForm.

• Create CockroachDB-Connected Nintex Workflows

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

• Create Freshdesk-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Freshdesk from Klipfolio and build custom visualizations using live Freshdesk.

• Build Dashboards with Parquet in DBxtra

  Create dynamic dashboards and perform analytics based on Apache Parquet in DBxtra.

• Access Live API in Excel (Desktop) via Connect AI

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

• Build Apps with Live Paylocity in Adalo using CData Connect AI

  Use CData Connect AI to integrate live Paylocity into the Adalo platform and build custom mobile and web applications with real-time Paylocity.

• How to Visualize Lakebase Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Lakebase in Python.

• Automated Continuous Salesforce Marketing Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to AlloyDB.

• Connect to RSS Feeds in RapidMiner

  Integrate RSS Feeds with standard components and data source configuration wizards in RapidMiner Studio.

• Create a Data Access Object for Microsoft OneDrive using JDBI

  A brief overview of creating a SQL Object API for Microsoft OneDrive in JDBI.

• Add SAP Ariba Procurement to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for SAP Ariba Procurement with the Informatica Enterprise Data Catalog to classify and organize data.

• Automated Continuous Spark Replication to Amazon Redshift

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

• Create Reports with Airtable in SAP Crystal Reports

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

• Access Live SharePoint Excel Services in TIBCO Data Virtualization

• «
• 455
• 456
• 457
• 458
• 459
• 460
• 461
• 462
• 463
• 464
• »