1 / 8

TrueSight Server Automation ETL Integration Overview

Download and view this presentation as a slide show for an interactive experience. Learn about ETL workflows, repositories, TrueSight Server Automation, and Smart Reporting. Understand how data is transferred and interacted within the ecosystem.

mccorkle
Download Presentation

TrueSight Server Automation ETL Integration Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Download this presentation and view it as a slide show for an interactive experience. ETL work repository ETL master repository TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 Authentication server TrueSight Server Automation – Data Warehouse TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

  2. ETL work repository ETL master repository A site is a TrueSight Automation Server database. Site 1 is the primary site. The sites send data to the extract, transform, and load (ETL) tool. TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 Authentication server TrueSight Server Automation – Data Warehouse TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

  3. The ETL tool integrates with the master and work repositories to perform its operations. ETL work repository ETL master repository TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 Authentication server TrueSight Server Automation – Data Warehouse TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

  4. ETL work repository ETL master repository The ETL tool transfers the data to TrueSight Automation Server – Data Warehouse database. TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 Authentication server TrueSight Server Automation – Data Warehouse TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

  5. ETL work repository ETL master repository TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 The TrueSight Automation Server – Data Warehouse database interacts with the Authentication server for user authentication. Authentication server TrueSight Server Automation – Data Warehouse TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

  6. ETL work repository ETL master repository TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 Authentication server TrueSight Server Automation – Data Warehouse A web application for authentication is hosted on the web server. TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

  7. ETL work repository ETL master repository TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 Authentication server TrueSight Server Automation – Data Warehouse The web application interacts with TrueSight Smart Reporting for cross-launch. TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

  8. ETL work repository ETL master repository TrueSight Smart Reporting interacts with these databases to obtain data. TrueSight Smart Reporting repository database TrueSight Server Automation – Data Warehouse database ETL (Oracle Data Integrator) TrueSight Server Automation Site 1 TrueSight Server Automation Site 2 Authentication server TrueSight Server Automation – Data Warehouse TrueSight Server Automation Site 3 Web application on the web server TrueSight Smart Reporting

More Related