Extract transformation loading from OLTP to OLAP data using pentaho data integration

Salaki, R J; Waworuntu, Jimmy; Tangkawarow, I R H T

doi:10.1088/1757-899x/128/1/012020

Cited by 8 publications

(2 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Nurul Hidayat dan kawankawan menyebutkan bahwa analisis desain data warehouse merupakan sesuatu yang penting untuk dapat meminimalisasi human error dan inkonsistensi data [7]. Dua penelitian lain mengatakan bahwa adanya data yang beragam dan variatif dapat diolah dengan menggunakan Pentaho karena dapat menghasilkan bentuk tabel yang lebih teratur sehingga akan mudah untuk diolah [8] [9]. Adapun yang membedakan penelitian ini dengan penelitian sebelumnya tersebut adalah data warehouse dirancang dengan mendetilkan langkah demi langkah dalam metode Kimball kemudian menghasilkan sebuah data warehouse dimana data yang disajikan tidak hanya digunakan sebagai laporan atau data monitoring tetapi juga dapat digunakan sebagai sumber data yang akan disajikan dalam pengelolaan sistem yang terpusat yang akan diimplementasikan pada SOC.…”

Section: Pendahuluanunclassified

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Asmita,

Henny,

Samidi

2023

J. Tek. Inform. (JUTIF)

View full text Add to dashboard Cite

Central Government, is a government agency that manages important and confidential state data and information. The data that is managed needs to be maintained for reliability and security in order to avoid the risk of loss, leakage and misuse of information. To maintain this data, an optimal information security device is needed. Information security tools used today have a variety of functions resulting in many important logs that must be managed, analyzed and evaluated. The log data from each of these information security devices is still separate and must be processed manually to obtain simpler and more efficient data so that it can be monitored and presented to management. The purpose of this research is to make the right data warehouse modeling in order to assist in the process of presenting information quickly and accurately related to the processing of data logs of information security devices as a report that will be given to management in support of the Zero Tollerance data security policy. The method used in designing this data warehouse is using the Kimball 9 step method. The results obtained are in the form of a starflake schema and a data warehouse log of information security devices consisting of a malware fact table, intrusion facts and attack facts that can be used as centralized data monitoring that will be implemented at the Security Operation Center. Testing is done using Pentaho software tools. This data warehouse is expected to provide a quick, accurate, and continuous summary of information so that it can assist management in the decision-making process and policy making for the future.

show abstract

Section: Pendahuluanunclassified

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Asmita,

Henny,

Samidi

2023

J. Tek. Inform. (JUTIF)

View full text Add to dashboard Cite

show abstract

“…The data was taken from operational databases and Excel files obtained from the Marketing staff, which was then combined to become data that was meaningful in DW. Data Warehouse is a special database that is used as a "data warehouse" or data which has been consolidated from various data sources of existing information systems in an organization/company (Salaki, Tangkawarow, & Waworuntu, 2015).…”

Section: Phase-3: Designmentioning

confidence: 99%

Tableau Business Intelligence Using the 9 Steps of Kimball’s Data Warehouse & Extract Transform Loading of the Pentaho Data Integration Process Approach in Higher Education

Lokaadinugroho

Girsang²,

Burhanudin³

2021

EMACS Journal

View full text Add to dashboard Cite

This paper discusses about how to build a data warehouse (DW) in business intelligence (BI) for a typical marketing division in a university. This study uses a descriptive method that attempts to describe the object or subject under study as it is, with the aim of systematically describing the facts and characteristics of the object under study precisely. In the elaboration of the methodology, there are four phases that include the identification and source data collection phase, the analysis phase, the design phase, and then the results phase of each detail in accordance with the nine steps of Kimball’s data warehouse and the Pentaho Data Integration (PDI). The result is a tableau as a tool of BI that does not have complete ETL tools. So, the process approach in combining PDI and DW as a data source certainly makes a tableau as a BI tool more useful in presenting data thus minimizing the time needed to obtain strategic data from 2-3 weeks to 77 minutes.

show abstract

Utilization Extract, Transform, Load For Developing Data Warehouse In Education Using Pentaho Data Integration

Barahama

Wardani

2021

J. Phys.: Conf. Ser.

View full text Add to dashboard Cite

The utilization of data warehouses in various fields is an absolute necessity. A data warehouse is a database that contains large amounts of data that aims to help organizations, fields, and institutions specifically for decision making. Data warehouses can produce important information in the future. Loading data from various sources and processed through an ETL (Extract, Transform, Load) process that displays data consistently is the basis for creating a data warehouse architecture. The development of a data warehouse in education will provide significant benefits for the progress of education. Integration of data and processing results stored in the data warehouse can be the basis for evaluating better planning. Development of data warehouse adopt the multidimensional modelling method which consists of four stages: select the business process, declare the grain, select dimensions, and identify facts. This stage produces a data warehouse architecture and influences and contributes to the advanced information technology in education.

show abstract

Extract transformation loading from OLTP to OLAP data using pentaho data integration

Cited by 8 publications

References 2 publications

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Tableau Business Intelligence Using the 9 Steps of Kimball’s Data Warehouse & Extract Transform Loading of the Pentaho Data Integration Process Approach in Higher Education

Utilization Extract, Transform, Load For Developing Data Warehouse In Education Using Pentaho Data Integration

Contact Info

Product

Resources

About