CData Software - Knowledge Base

Recent Articles

• «
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• »

• Connect to LinkedIn Ads from a Connection Pool in JBoss

  Integrate LinkedIn Ads into Java servlets: Use the Management Console in JBoss to install the LinkedIn Ads JDBC Driver.

• Use JayDeBeApi to access Certinia in Python

  Use standard Python scripting and the development environment of your choice to access live Certinia.

• How to integrate TaxJar with Apache Airflow

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

• Create Reports with Smartsheet in SAP Crystal Reports

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

• Analyze Azure Data Catalog in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Azure Data Catalog and visualize live Azure Data Catalog in Ingragistics Reveal.

• Import and Visualize Printify in Power View

  Create data visualizations based on Printify in Excel.

• Provide OData Services of ClickUp from a WCF Application

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

• Connect to Oracle SCM from Excel & GoogleSheets!

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

• Extract, Transform, and Load eBay in Informatica PowerCenter

  Create a simple Workflow for eBay in Informatica PowerCenter.

• Deploy the ADO.NET Provider for Salesforce Data Cloud on an SSRS Report Server

  Connect to Salesforce Data Cloud 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.

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

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

• Connect Microsoft OneDrive to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Microsoft OneDrive using the CData Python MCP Server.

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

  Connect to Apache Spark SQL 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.

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

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

• Creating Zoho CRM-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Zoho CRM to Unqork and build custom business apps.

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

  Connect to real-time Salesforce & Force.com in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce.

• Analyze Salesloft in R via ODBC

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

• Seamlessly Bring MailChimp into Retool Using CData Connect Cloud

  Integrate MailChimp data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

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

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

• Build API-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live API.

• Access Live Excel Online in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live Microsoft Excel Online from your Excel spreadsheets.

• Connect to Amazon Marketplace from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Amazon Marketplace to connect to Amazon Marketplace from Web applications running on WebLogic.

• Build MVC Applications with Connectivity to Active Directory

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

• Publish Crystal Reports on DocuSign

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

• Integrate Splunk into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Splunk and integrate live Splunk into your Power Automate tasks.

• Visualize Dynamics NAV in Tableau

  The CData ODBC driver for Dynamics NAV enables you integrate Microsoft Dynamics NAV into Tableau dashboards.

• Connect to SAP Ariba Source as a Linked Server via SQL Gateway

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

• LINQ to Klaviyo

  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 Klaviyo Data Provider.

• How to Build an ETL App for Tableau CRM Analytics in Python with CData

  Create ETL applications and real-time data pipelines for Tableau CRM Analytics in Python with petl.

• Automated Continuous Shopify Replication to Azure SQL Database

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

• How to pipe Google Sheets to CSV in PowerShell

  Use standard PowerShell cmdlets to access Google Sheets tables.

• Feed NetSuite into FineReport

  How to set NetSuite CRM & ERP as a JDBC data source in FineReport.

• How to create Visio diagrams from HubDB

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

• Publish Shopify-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Shopify.

• Use Dash to Build to Web Apps on eBay

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

• Automated Continuous Twitter Replication to MySQL

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

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

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

• How to load HCL Domino data into Elasticsearch via Logstash

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

• Automated Continuous eBay Replication to SQL Server

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

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

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

• A PostgreSQL Interface for Act CRM (MySQL Remoting via JDBC)

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

• Create SSAS Tabular Models from Dynamics 365 Business Central

  How to build a SQL Server Analysis Service Tabular Model from Dynamics 365 Business Central using CData drivers.

• Connect to Databricks from a Connection Pool in WebLogic

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

• Query Smartsheet using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Smartsheet entities in PHP by modeling them as objects.

• Automated Continuous Azure Blob Storage Replication to Oracle

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Oracle.

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

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

• Working with SAP Ariba Source in LINQPad

  Execute LINQ queries to SAP Ariba Source in LINQPad.

• Use JayDeBeApi to access SAP Hybris C4C in Python

  Use standard Python scripting and the development environment of your choice to access live SAP Hybris C4C.

• Query Google Drive using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Google Drive entities in PHP by modeling them as objects.

• Trigger eBay IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• How to Visualize Presto Data in Python with pandas

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

• Building Dynamic Web Pages with Redshift Using AngularJS

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

• Connect to SAP Concur in HULFT Integrate

  Connect to SAP Concur as a JDBC data source in HULFT Integrate

• How to integrate Metabase with LinkedIn

  Use CData Connect Cloud to connect to live LinkedIn and create an interactive dashboard in Metabase from LinkedIn.

• Connect to Drip in Aqua Data Studio

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

• Work with Slack in FoxPro

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

• Use JayDeBeApi to access CockroachDB in Python

  Use standard Python scripting and the development environment of your choice to access live CockroachDB.

• Create Reports with SAP HANA in SAP Crystal Reports

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

• Integrate with live Smaregi in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Smaregi in Jitterbit.

• Access Live Power BI XMLA in Excel 365 Online (Excel for the web)

  Connect to Power BI XMLA from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Automate HarperDB Tasks in Power Automate Using CData API Server

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

• Create Reports from MailChimp in Looker Studio

  Use CData Connect Cloud to gain access to live MailChimp and create custom reports in Looker Studio.

• LINQ to Google Sheets

  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 Google Sheets Data Provider.

• Connect to Shopify from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Shopify from Filemaker Pro on Mac.

• Analyze GitHub in Infragistics Reveal

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

• How to connect PolyBase to TigerGraph

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

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

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

• Connect IBM Cloud Object Storage to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live IBM Cloud Object Storage using the CData Python MCP Server.

• Create BigQuery Reports on JasperReports Server

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

• Extract, Transform, and Load Aha in Informatica PowerCenter

  Create a simple Workflow for Aha! in Informatica PowerCenter.

• Query Klaviyo in DataGrip

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

• Use Claude to Talk to Your Azure Active Directory via CData Connect Cloud

  Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Azure Active Directory for you.

• Query, Visualize, and Share live Backlog in Redash

  Use CData Connect Cloud to connect to live Backlog in Redash for querying, visualizing, and sharing.

• Use the CData ODBC Driver for Adobe Analytics from SharePoint Excel Services

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

• Create Apps from Xero in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Xero and build apps from live Xero Accounting in Qlik Sense Cloud.

• How to Connect to & Open Authorize.Net in Microsoft Excel

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

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

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

• Add Microsoft Teams to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Microsoft Teams with the Informatica Enterprise Data Catalog to classify and organize data.

• Access Epicor Kinetic from MySQL in Amazon QuickSight

  Connect to Epicor Kinetic and build visualizations of Epicor Kinetic using a MySQL Connection in Amazon QuickSight.

• Connect to Shopify from a Connection Pool in Jetty

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

• Import and Visualize SAP Ariba Source in Power View

  Create data visualizations based on SAP Ariba Source in Excel.

• Create Reports with Power BI XMLA in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Power BI XMLA.

• Analyze MariaDB in Infragistics Reveal

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

• Automated Continuous Procore Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Procore replication to MongoDB.

• Model, Search, and Visualize Live Jira in ThoughtSpot

  Use CData Connect Cloud to connect to live Atlassian Jira for modeling, searching, and visualizing.

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

  Connect to PingOne 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 Invoiced in Ruby

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

• Process & Analyze ADP in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live ADP .

• Automate SQL Server Replication to Azure Synapse

  Use CData Sync to customize and automate Microsoft SQL Server replication to Azure Synapse.

• Establish a Live Connection with Stripe using Tableau Bridge

  The CData ODBC Driver for Stripe enables you to integrate live Stripe into Tableau Cloud dashboards using the Tableau Bridge.

• Create Data Visualizations Based On Backlog in Mode

  Use CData Connect Cloud to connect to Backlog from Mode and build visualizations using live

• Connect to WooCommerce from Crystal Reports

  Use CData Connect Cloud to connect to and report on live WooCommerce from Crystal Reports.

• Automated Continuous ShipStation Replication to MySQL

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

• Visualize Wave Financial in TIBCO Spotfire through OData

  Integrate Wave Financial into dashboards in TIBCO Spotfire.

• DataBind Charts to Oracle

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Database 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.

• How to publish and share MarkLogic dashboards with Tableau Server

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

• How to Access Live Presto in Visual Studio Code via Cline

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

• Visualize Blackbaud FE NXT in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Blackbaud FE NXT into TIBCO Spotfire.

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

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Google Directory.

• Build Zuora-Connected Web Apps in Servoy

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

• «
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• »