CData Software - Knowledge Base

Recent Articles

• «
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• »

• How to Connect to Live Oracle HCM Cloud in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Oracle HCM Cloud for you.

• Build SAP Ariba Source-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for SAP Ariba Source and create custom apps in Bubble.

• Connect to Spark in CloverDX (formerly CloverETL)

  Transfer Apache Spark SQL using the visual workflow in the CloverDX data integration tool.

• How to Connect to Oracle Financials Cloud in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Oracle Financials Cloud. Leverage the pyodbc module for ODBC in Python.

• Integrate with SAS xpt using Apache Camel2

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

• Build Redis Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Redis and build visualizations in Tableau.

• Design BIRT Reports on Dropbox

  Provide current Dropbox to your embedded analytics.

• How to connect and process Google Campaign Manager 360 from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Google Campaign Manager 360.

• A Comparison of JDBC & ODBC Drivers for Amazon Athena

  A performance comparison of the CData JDBC Driver and ODBC Driver for Amazon Athena and the Amazon-supported Athena JDBC Driver and ODBC Driver.

• Publish Twitter Ads-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Twitter Ads.

• Choosing the Best Method to Connect Yahoo! Japan Data Solution to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Yahoo! Japan Data Solution from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Connect to Salesforce Data Cloud in SpagoBI

  Create reports featuring live Salesforce Data Cloud in SpagoBI Studio. Host Salesforce Data Cloud reports on SpagoBI Server.

• Automated Continuous eBay Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable eBay replication to Google Cloud SQL.

• Visualize Trello in Sisense

  Create an ElastiCube in Sisense app with access to Trello.

• How to create Visio diagrams from Blackbaud FE NXT

  Automatically update Blackbaud FE NXT with the changes you make to Visio master shapes.

• Build Data Flows from SQL Server to Airtable through SSIS

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

• Automated Continuous Cosmos DB Replication to IBM DB2

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

• How to pipe Act-On to CSV in PowerShell

  Use standard PowerShell cmdlets to access Act-On tables.

• Automated Continuous Kintone Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Kintone replication to Amazon S3.

• How to Connect to & Open HDFS in Microsoft Excel

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

• Enable the BigCommerce JDBC Driver in KNIME

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

• Build MVC Applications with Connectivity to GitHub

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

• Build Automated Workflows with Live BigCommerce in Workato

  Use CData Connect Cloud to connect to live BigCommerce and build automated workflows in Workato.

• Connect to PingOne in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to BCart from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from BCart, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Build Smaregi-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Smaregi from Zoho Analytics and import live Smaregi.

• How to Connect to & Open Microsoft Exchange in Microsoft Excel

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

• Access Live Greenplum in Coginiti Pro

  Connect to and query live Pivotal GreenPlum from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Query Jira Assets through ODBC in Node.js

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

• Deploy the ADO.NET Provider for Azure Active Directory on an SSRS Report Server

  Connect to Azure Active Directory 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.

• How to Query Live EnterpriseDB in Claude Desktop

  Connect to and query live EnterpriseDB in Claude Desktop using the CData MCP Server.

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

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

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

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

• Consume Asana OData Feeds in PowerBuilder

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

• Consume Zoho Projects OData Feeds in PowerBuilder

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

• Automated Continuous Asana Replication to Azure SQL Database

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

• Rapidly Develop RSS-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Automated Continuous Sugar CRM Replication to MySQL

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

• Integrate Live Sansan into Amazon SageMaker Canvas with RDS

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

• ETL SAP HANA in Oracle Data Integrator

  This article shows how to transfer SAP HANA into a data warehouse using Oracle Data Integrator.

• Natively Connect to Odoo in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Odoo ERP. Leverage the native support for ODBC in PHP.

• Publish Reports with LinkedIn Ads in SAP Crystal Reports

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

• Rapidly Develop Trello-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Automated Continuous Reckon Accounts Hosted Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to MongoDB.

• Integrate MailChimp in Pentaho Data Integration

  Build ETL pipelines based on MailChimp in the Pentaho Data Integration tool.

• How to Access Confluence Using Entity Framework

  This article shows how to access Atlassian Confluence using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Building Dynamic Web Pages with WordPress Using AngularJS

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

• Automate SAP SuccessFactors Replication to Azure Synapse

  Use CData Sync to customize and automate SAP SuccessFactors replication to Azure Synapse.

• Automated Continuous TaxJar Replication to SQL Server

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

• Analyze Jira Service Management in Cognos Analytics

  Use CData Connect Cloud to connect to Jira Service Management from Cognos Analytics and analyze live Atlassian Jira Service Management.

• Integrate Live Elasticsearch into Amazon SageMaker Canvas with RDS

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

• Build an OLAP Cube in SSAS from YouTube Analytics

  Establish a connection to YouTube Analytics data from SQL Server Analysis Services, and use the YouTube Analytics Data Provider to build OLAP cubes for use in analytics and reporting.

• Connect to Slack as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Slack.

• Validate Facebook with QuerySurge

  Access and validate Facebook in QuerySurge using the CData JDBC Driver.

• Access Live ActiveCampaign in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to ActiveCampaign from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Connect to Spark from AWS Glue

  Use CData Connect Cloud to gain access to live Apache Spark SQL from your AWS Glue jobs.

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

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

• Access Tally from MySQL in PHP

  Connect to Tally through the standard MySQL libraries in PHP.

• ETL HDFS in Oracle Data Integrator

  This article shows how to transfer Apache HDFS into a data warehouse using Oracle Data Integrator.

• How to publish and share Twitter dashboards with Tableau Server

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

• A PostgreSQL Interface for Snapchat Ads (MySQL Remoting via JDBC)

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

• Deploy the ADO.NET Provider for Act CRM on an SSRS Report Server

  Connect to Act CRM 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.

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

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

• Connect to Act CRM from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Act CRM to connect to Act CRM from Web applications running on WebLogic.

• Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy Desktop

  Connect to Microsoft Dynamics NAV in MicroStrategy Desktop using the CData Software JDBC Driver for Dynamics NAV.

• Analyze SAP Ariba Source in Looker

  Use CData Connect Cloud to connect to SAP Ariba Source from Looker and build custom apps using live SAP Ariba Source.

• Automated Continuous Zoho Creator Replication to Local Delimited Files

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

• Build Apps with Live Azure Data Lake Storage in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Azure Data Lake Storage into the Adalo platform and build custom mobile and web applications with real-time Azure Data Lake Storage.

• Build MVC Applications with Connectivity to Kafka

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

• Integrate Google Data Catalog in the Pentaho Report Designer

  Publish reports based on Google Data Catalog in the Pentaho BI tool.

• Work with Active Directory in FoxPro

  Load Active Directory into a FoxPro database. This article includes full code and a walk-through of the process.

• Publish Oracle Eloqua-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Oracle Eloqua.

• Provide OData Services of MarkLogic from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for MarkLogic by developing a WCF Service Application.

• How to Query CockroachDB in MySQL Workbench

  Execute MySQL queries against live CockroachDB from MySQL Workbench.

• Integrate with Zoho CRM using Apache Camel2

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

• Replicate Amazon Marketplace to Multiple Databases

  Replicate Amazon Marketplace to disparate databases with a point-and-click configuration.

• How to use SQLAlchemy ORM to access Azure DevOps in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure DevOps.

• Prepare, Blend, and Analyze Azure Data Catalog in Alteryx Designer (ODBC)

  Build workflows to access live Azure Data Catalog for self-service data analytics.

• How to connect PolyBase to Clio

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

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

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

• How to create Visio diagrams from Workday

  Automatically update Workday with the changes you make to Visio master shapes.

• How to connect to Sybase in DBVisualizer

  Integrate Sybase with visual data analysis tools and data connection wizards in DBVisualizer

• Build Gmail Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Gmail and build visualizations in Tableau Cloud.

• Automated Continuous Amazon Marketplace Replication to SQL Server

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

• How to integrate Metabase with Jira Service Management

  Use CData Connect Cloud to connect to live Atlassian Jira Service Management and create an interactive dashboard in Metabase from Atlassian Jira Service Management.

• Analyze Google Ads in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Google Ads and visualize live Google Ads in Ingragistics Reveal.

• How to connect PolyBase to Greenplum

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

• Use the CData ODBC Driver for Google Cloud Storage in Microsoft Power Query

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

• Build Semantic Layer Views for Google Ads in APOS Live Data Gateway

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

• Automated Continuous Avalara AvaTax Replication to Apache Cassandra

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

• Write a Simple Go Application to work with SingleStore on Linux

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

• How to create JSON federated tables in MySQL

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

• Stream Oracle SCM into Apache Kafka Topics

  Access and stream Oracle SCM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automate Paylocity Replication to Couchbase

  Use CData Sync to Customize and automate Paylocity replication to Couchbase.

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

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

• Integrate Live SQL Analysis Services into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• »