CData Software - Knowledge Base

Recent Articles

• «
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• »

• Build Interactive Dashboards from eBay Analytics in Amazon QuickSight

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

• Visualize Azure Data Catalog in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure Data Catalog into TIBCO Spotfire.

• Integrate Real-Time Access to Google Analytics in SAPUI5 MVC Apps

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

• Access ClickUp in PHP through Connect Server

  Connect to ClickUp through the standard SQL Server libraries in PHP.

• How to Connect to & Open SAP BusinessObjects BI in Microsoft Excel

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

• Visualize Workday in TIBCO Spotfire through ODBC

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

• Enable the Certinia JDBC Driver in KNIME

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

• Connect to Marketo in Google Apps Script

  Use the ODBC Driver for Marketo and the SQL Gateway to access Marketo from Google Apps Script.

• Provide OData Services of Cassandra from a WCF Application

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

• Automated Continuous Twitter Ads Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Twitter Ads replication to Microsoft Access.

• Analyze Azure Data Lake Storage in Looker

  Use CData Connect Cloud to connect to Azure Data Lake Storage from Looker and build custom apps using live Azure Data Lake Storage.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Replicate Multiple Square Accounts

  Replicate multiple Square accounts to one or many databases.

• Query Okta through ODBC in Node.js

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

• How to Visualize Zoom Data in Python with pandas

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

• LINQ to BambooHR

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

• Connect to Epicor Kinetic in CloverDX (formerly CloverETL)

  Transfer Epicor Kinetic using the visual workflow in the CloverDX data integration tool.

• Integrate Real-Time Access to Sage 300 in SAPUI5 MVC Apps

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

• Build MVC Applications with Connectivity to IBM Cloud Data Engine

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

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

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

• Create a Data Access Object for Adobe Commerce using JDBI

  A brief overview of creating a SQL Object API for Adobe Commerce in JDBI.

• Build Asana Visualizations in Tableau Desktop

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

• Visualize Live Microsoft Project of Power BI Report Builder in Power BI Service

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

• Access Live Azure Data Lake Storage in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Azure Data Lake Storage from your Excel spreadsheets.

• Visualize Oracle Financials Cloud in Sisense

  Create an ElastiCube in Sisense app with access to Oracle Financials Cloud.

• Create Tally-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Tally from Klipfolio and build custom visualizations using live Tally ERP.

• Access Live YouTube Analytics in AWS Lambda (with IntelliJ IDEA)

  Connect to live YouTube Analytics in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to Work with Elasticsearch in AWS Glue Jobs Using JDBC

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

• How to Import Aha into SQL Server using SSIS

  Easily back up Aha! to SQL Server using the SSIS components for Aha.

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

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

• Operational Reporting on Sybase from Spotfire Server

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

• Access Live Excel in Coginiti Pro

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

• Visualize Dropbox from Tableau

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

• Automated Continuous Kintone Replication to MySQL

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

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

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

• Integrate with WooCommerce in SnapLogic

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

• Build an OLAP Cube in SSAS from Facebook Ads

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

• Build MailChimp Visualizations in Tableau Desktop

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

• Analyze SingleStore in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of SingleStore and visualize SingleStore in SAP Analytics Cloud.

• Connect to Databricks from Filemaker Pro (Mac)

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

• Automated Continuous Amazon S3 Replication to Apache Cassandra

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

• Create Data Visualizations in Cognos BI with Google Search Results

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

• How to Connect the Power BI Service to Adobe Commerce: Complete Guide

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

• Use Dash to Build to Web Apps on Google Ad Manager

  Create Python applications that use pandas and Dash to build Google Ad Manager-connected web apps.

• Connect to Parquet in SpagoBI

  Create reports featuring live Apache Parquet in SpagoBI Studio. Host Parquet reports on SpagoBI Server.

• A PostgreSQL Interface for eBay

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

• Export Data from SQL Server to Blackbaud FE NXT through SSIS

  Easily push SQL Server data to Blackbaud FE NXT using the CData SSIS Tasks for Blackbaud FE NXT.

• Visualize Sage 300 in TIBCO Spotfire through ADO.NET

  Integrate Sage 300 into dashboards in TIBCO Spotfire.

• How to Visualize Amazon Marketplace Data in Python with pandas

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

• DataBind Wijmo Grid to Kafka

  Provide real-time Apache Kafka to interactive controls.

• Access Invoiced from MySQL in PHP

  Connect to Invoiced through the standard MySQL libraries in PHP.

• Object-Relational Mapping (ORM) with Excel Online 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 Microsoft Excel Online into a Java-based ORM framework, Hibernate.

• How to connect Amazon QuickSight to Sage Intacct

  Create a connection to Sage Intacct in CData Connect Cloud and insert Sage Intacct into Amazon QuickSight SPICE to build interactive dashboards.

• Analyze eBay in Looker

  Use CData Connect Cloud to connect to eBay from Looker and build custom apps using live eBay.

• Import Sage 300 into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Sage 300. In this article, you will use the OData format to import Sage 300 into Microsoft Power Query.

• Visualize Live Adobe Commerce in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Commerce.

• Integrate with Redshift in JReport Designer

  Create charts and reports based on Amazon Redshift in JReport Designer.

• Manage ShipStation in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for ShipStation.

• Analyze PostgreSQL with Power Pivot

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

• Visualize Live Pinterest in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Pinterest and create custom reports in the Power BI Service.

• Create Calendly Reports on JasperReports Server

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

• Replicate Office 365 to Multiple Databases

  Replicate Microsoft Office 365 to disparate databases with a point-and-click configuration.

• Replicate Azure DevOps for Use in Salesforce Connect

  Replicate Azure DevOps to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Build an OLAP Cube in SSAS from MongoDB

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

• How to connect to Unbounce from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Unbounce and work with Unbounce in Microsoft Excel on Mac OS X.

• Configure the CData JDBC Driver for LinkedIn in a Connection Pool in Tomcat

  Connect to LinkedIn from a connection pool in Tomcat.

• Connect to DB2 in Jaspersoft Studio

  Execute SQL to remote IBM DB2 in Jaspersoft Studio.

• How to Connect DBeaver to Aha via a JDBC Driver

  Manage Aha! with visual tools in DBeaver like the query browser.

• Extract, Transform, and Load Teradata in Informatica PowerCenter

  Create a simple Workflow for Teradata in Informatica PowerCenter.

• Connect to Acumatica from a Connection Pool in Jetty

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

• Perform Batch Operations with Reckon in Apache NiFi

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

• Build Apps with Live Microsoft Dataverse (CDS) in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Microsoft Dataverse (CDS) into the Adalo platform and build custom mobile and web applications with real-time Microsoft Dataverse (CDS).

• Create Dynamic Google Analytics Grids Using the Infragistics XamDataGrid

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

• ETL XML in Oracle Data Integrator

  This article shows how to transfer XML Files into a data warehouse using Oracle Data Integrator.

• Connect to ADP as a Linked Server

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

• Integrate Bing Ads in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bing Ads from Informatica Cloud.

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

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

• Natively Connect to Microsoft Project in PHP

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

• Visualize FHIR in Sisense

  Create an ElastiCube in Sisense app with access to FHIR.

• How to connect to SAP Hybris C4C from IntelliJ

  Integrate connectivity to SAP Hybris C4C with wizards in IntelliJ.

• Connect to Kafka in RazorSQL

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

• Automated Continuous ClickUp Replication to AlloyDB

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

• Connect to Bitbucket from PowerBuilder

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

• Automated Continuous Box Replication to Apache Cassandra

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

• How to Connect DBeaver to Oracle SCM via a JDBC Driver

  Manage Oracle SCM with visual tools in DBeaver like the query browser.

• Access Live SAP Netweaver Gateway in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for SAP Netweaver Gateway to create a SAP Netweaver Gateway source in TIBCO Data Virtualization Studio and gain access to live SAP Netweaver Gateway from your TDV Server.

• Connect to Printify from PowerBuilder

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

• Connect to Zenefits in DBeaver

  Use the CData ODBC Driver to connect to Zenefits in DBeaver.

• LINQ to Azure Active Directory

  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 Azure Active Directory Data Provider.

• Use JayDeBeApi to access Printify in Python

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

• Publish Redis-Connected Dashboards in Tableau Server

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

• Visualize Adobe Analytics in Tableau

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

• Analyze Jira in Cognos Analytics

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

• Access Live Pinterest in AWS Lambda (with IntelliJ IDEA)

  Connect to live Pinterest in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to Connect DBeaver to Sybase IQ via a JDBC Driver

  Manage Sybase IQ with visual tools in DBeaver like the query browser.

• Automated Continuous Sage Cloud Accounting Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Microsoft Access.

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

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

• Access Hive from MySQL in Amazon QuickSight

  Connect to Hive and build visualizations of Apache Hive using a MySQL Connection in Amazon QuickSight.

• How to connect to Airtable from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Airtable and work with Airtable in Microsoft Excel on Mac OS X.

• Manage Raisers Edge NXT in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Raisers Edge NXT.

• «
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• »