CData Software - Knowledge Base

Recent Articles

• «
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• »

• Automated Continuous Google Spanner Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Google Spanner replication to Snowflake.

• Azure Data Catalog Reporting in OBIEE with the Azure Data Catalog JDBC Driver

  Deploy the Azure Data Catalog JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to REST in the Denodo Platform

  Use CData driver technologies to create a virtual data source for REST in the Denodo Virtual DataPort Administrator.

• Visualize SingleStore in TIBCO Spotfire through OData

  Integrate SingleStore into dashboards in TIBCO Spotfire.

• Connect to Amazon Athena in Aqua Data Studio

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

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

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

• Automate GitHub Replication to Couchbase

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

• Object-Relational Mapping (ORM) with Typeform Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Typeform into a Java-based ORM framework, Hibernate.

• How to create Visio diagrams from Amazon DynamoDB

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

• How to integrate Zuora with Apache Airflow

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

• Use the CData Software JDBC Driver for Klipfolio in MicroStrategy

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

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

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

• Build Interactive Dashboards from Tally in Amazon QuickSight

  Create a virtual SQL Server database for Tally ERP in CData Software Connect Server and import Tally ERP into Amazon QuickSight SPICE to build interactive dashboards.

• Operational Reporting on SAP SuccessFactors from Spotfire Server

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

• PowerShell Scripting to Replicate Zoho Books to MySQL

  Write a simple PowerShell script to replicate Zoho Books to a MySQL database.

• Connect to Adobe Commerce in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to ADP in RazorSQL

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

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

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

• Automate Azure Blob Storage Replication to Azure Data Lake

  Use CData Sync to customize and automate Azure Blob Storage replication to Azure Data Lake.

• How to connect PolyBase to SAP Hybris C4C

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

• Design BIRT Reports on Teradata

  Provide current Teradata to your embedded analytics.

• How to Work with Azure Analysis Services in AWS Glue Jobs Using JDBC

  Connect to Azure Analysis Services from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Build Dashboards with MYOB AccountRight in DBxtra

  Create dynamic dashboards and perform analytics based on MYOB AccountRight in DBxtra.

• Process & Analyze Adobe Commerce in Databricks (AWS)

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

• Connect to MongoDB as an External Source in Dremio

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

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

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

• Automated Continuous ShipStation Replication to Oracle

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

• Analyze Live Oracle Eloqua in SAS Viya

  Use CData Connect Cloud to connect to Oracle Eloqua from SAS Viya and deploy self-service analytics using live Oracle Eloqua.

• Automate Zoho Books Replication to Couchbase

  Use CData Sync to Customize and automate Zoho Books replication to Couchbase.

• Create Azure DevOps Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Azure DevOps to build custom dashboards in Bold BI.

• Build Google Analytics Visualizations in Tableau Desktop

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

• Access Live SharePoint Excel Services in Coginiti Pro

  Connect to and query live SharePoint Excel Services from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Automated Continuous Amazon Marketplace Replication to MySQL

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

• Object-Relational Mapping (ORM) with Redshift Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Amazon Redshift into a Java-based ORM framework, Hibernate.

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

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

• Visualize Act-On in TIBCO Spotfire through OData

  Integrate Act-On into dashboards in TIBCO Spotfire.

• Query, Visualize, and Share live YouTube Analytics in Redash

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

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

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

• Connect to Certinia in RapidMiner

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

• Connect to Zoom from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Zoom using standard SQL.

• Build Interactive Dashboards from Calendly in Amazon QuickSight

  Create a virtual SQL Server database for Calendly in CData Software Connect Server and import Calendly into Amazon QuickSight SPICE to build interactive dashboards.

• Automated Veeva Vault Replication to Teradata

  Use CData Sync to Customize and automate Veeva Vault & Vault CRM replication to Teradata.

• Integrate Real-Time Access to Zenefits in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zenefits in real time.

• Provide OData Services of Neo4J from a WCF Application

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

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

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

• Build Dashboards with Twitter Ads in DBxtra

  Create dynamic dashboards and perform analytics based on Twitter Ads in DBxtra.

• How to Query MariaDB in MySQL Workbench

  Execute MySQL queries against live MariaDB from MySQL Workbench.

• Use the CData Software ODBC Driver for Google Drive in MicroStrategy Web

  Connect to Google Drive in MicroStrategy Web using the CData Software ODBC Driver for Google Drive.

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

• Analyze FHIR in R via ODBC

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

• How to connect PolyBase to SFTP

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

• Build Hive-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Hive from Choreo and build custom apps using live Apache Hive.

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

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

• Access Live Access in Coginiti Pro

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

• Analyze Snowflake in Cognos Analytics

  Use CData Connect Cloud to connect to Snowflake from Cognos Analytics and analyze live Snowflake.

• How to load Dynamics 365 data into Elasticsearch via Logstash

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

• Load Quickbase to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Quickbase to a database.

• How to work with Greenhouse in Apache Spark using SQL

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

• Visualize Live Bullhorn CRM in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Bullhorn CRM.

• Visualize XML in TIBCO Spotfire through OData

  Integrate XML Files into dashboards in TIBCO Spotfire.

• Automate Google Search Results Replication to SAP HANA

  Use CData Sync to customize and automate Google Search replication to SAP HANA.

• How to load TigerGraph data into Elasticsearch via Logstash

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

• Rapidly Develop Google Ad Manager-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.

• Bridge Oracle SCM Connectivity with Apache NiFi

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

• Working with Dynamics 365 Business Central in LINQPad

  Execute LINQ queries to Dynamics 365 Business Central in LINQPad.

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

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

• Create HubSpot Reports on JasperReports Server

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

• Create Datasets from SAP Business One in Domo Workbench and Build Visualizations of SAP Business One in Domo

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

• Connect to Tableau CRM Analytics in JRuby

  Create a simple JRuby app with access to live Tableau CRM Analytics.

• How to Query Greenplum in MySQL Workbench

  Execute MySQL queries against live Pivotal GreenPlum from MySQL Workbench.

• Validate Monday.com with QuerySurge

  Access and validate Monday.com in QuerySurge using the CData JDBC Driver.

• Perform Batch Operations with HBase in Apache NiFi

  Connect to Apache HBase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Bidirectional Access to Couchbase from FileMaker Pro

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

• Access Live MongoDB in Excel (Desktop) through Connect Spreadsheets

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

• Natively Connect to MarkLogic in PHP

  The CData ODBC driver for MarkLogic enables you to create PHP applications with connectivity to MarkLogic. Leverage the native support for ODBC in PHP.

• How to Seamlessly Import Raisers Edge NXT Data into IBM SPSS Modeler

  Integrate Raisers Edge NXT data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to create Visio diagrams from Active Directory

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

• Automate SAP Concur Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP Concur replication to Azure Data Lake.

• Deploy the ADO.NET Provider for Azure Analysis Services on an SSRS Report Server

  Connect to Azure Analysis Services 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 Connect to & Open Veeva Vault in Microsoft Excel

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

• Integrate with Live Azure Table in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Azure Table from the MuleSoft Anypoint Platform to integrate live Azure Table Storage into custom reports and dashboards.

• How to load Google Directory data into Elasticsearch via Logstash

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

• Access Live Google Contacts in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Google Contacts from your Google Sheets.

• Access Live Acumatica in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Acumatica ERP from your Google Sheets.

• LINQ to Procore

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

• Automated Continuous TaxJar Replication to Azure SQL

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

• How to connect and process Epicor Kinetic from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Epicor Kinetic

• Integrate with Greenplum in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Pivotal GreenPlum in SnapLogic.

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

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

• REST Easy with CData Drivers

  Our Drivers offer unmatched utility in connecting to and integrating with REST resources as databases.

• Automate PingOne Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access PingOne from PowerShell? This article demonstrates how to utilize the PingOne Cmdlets for tasks like connecting to PingOne, automating operations, downloading data, and more.

• Query eBay as a MySQL Database in Node.js

  Execute MySQL queries against eBay from Node.js.

• Design BIRT Reports on QuickBooks

  Provide current QuickBooks Desktop to your embedded analytics.

• DataBind Controls to RSS Feeds in C++Builder

  DataBind to RSS Feeds in C++Builder with standard components and controls.

• Build Dynamics CRM-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Microsoft Dynamics CRM and build Dynamics CRM-connected web apps with Axios.

• Stream HarperDB into Apache Kafka Topics

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

• Replicate Multiple HDFS Accounts

  Replicate multiple HDFS accounts to one or many databases.

• Create Informatica Mappings From/To a JDBC Data Source for Reckon Accounts Hosted

  Create Reckon Accounts Hosted data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Create Reports from Acumatica in Looker Studio

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

• Integrate Salesforce Marketing with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Salesforce Marketing with External Services.

• «
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• »