Pentaho Sebagai Solusi Masalah Pengolahan Database

Information is the result of data processing plays an important role in anorganization, especially in decision-making process. Pentaho application of Intelligent Business Products is one of the technologies for collecting, storing, analyzing, and providing access to data to help enterprise users make better business decisions. Pentaho has a function as reporting, analysis, dashboards, data integration (ETL) and data mining. Pentaho is better to manage large and complex data and be able to complete the functional organization

Perancangan Aplikasi Business Intelligence pada Sistem Informasi Distribusi PT Pertamina Lubricant Menggunakan Pentaho

Business intelligence adalah suatu sistem aplikasi yang berfungsi untuk mengelola dan menganalisis data suatu Perusahaan atau organisasi untuk menghasilkan suatu informasi. Salah satu bentuk informasi yang dapat diberikan dari pengaplikasian business intelligence tersebut adalah dengan adanya dashboard reporting yang dapat memberikan informasi analisis data secara interaktif. Pada penelitian ini perancangan yang dilakukan pada sistem informasi distribusi PT Pertamina Lubricant, dimana dengan mengaplikasikan business intelligence tersebut dapat memberikan value added pada sistem informasi existing yang ada. Hasil dari perancangan ini adalah suatu aplikasi business intelligence yang dapat melakukan analisis data dan memberikan laporan secara otomatis dalam bentuk dashboard reporting yang dapat memberikan informasi berupa pengetahuan untuk menanggulangi kurangnya report penjualan dari sistem informasi distibusi PT Pertamina Lubricant

Uso da ferramenta Pentaho BI-Server para obtenção de informações gerenciais do Sistema Aberto e Integrado de Informação em Agricultura (Sabiia).

Nesse contexto de ambiente de informação, acesso e extração de informações gerenciais da base de dados do sistema Sabiia, o projeto definiu como objetivo estratégico o uso de soluções livres de BI para obtenção de informações e respostas gerenciais, tais como: Quantos provedores de dados estão sendo coletados ? Quais são os provedores de dados coletados em cada país ? Qual é a quantidade de consultas efetuadas por ano, mês e país no sistema ? Quais são as buscas mais efetuadas no sistema ? Devido à maior experiência da Embrapa Informática Agropecuária no uso de soluções livres e arquitetura Java Enterprise Edition (Java EE)4 em projetos de pesquisa, o projeto Sabiia optou pelo uso da ferramenta Pentaho-BI Server5 como solução de (BI) para obtenção de informações gerenciais

Plataforma para visualização de dados clínicos baseada em software open source

Healthcare providers are faced with the challenge of going through large amounts of data in search of answers to complex questions. On top of that, medical sta typically don't have database knowledge, and so, it is necessary to provide them with tools that allows the visualization of reports, charts and dashboards, without having to interact or even see query languages, ideally on the same platforms where data is generated. Embedding Business Intelligence (BI) has emerged as a possible solution to this issue, providing end-user with tools that enables them to explore data in a simpli ed way. Thus, the application where the solution was embedded not only is enhanced, but the necessity for data analysis stand-alone tools is eliminated. This thesis starts by analyzing if integrating a BI solution into medical platforms is plausible, by presenting the main characteristics of clinical data, followed by an overview of the state of the art on open-source Business Intelligence software. Then, a solution proposal is presented where the development of an embedded solution is pragmatically addressed. Finally, case studies where the integration of the work developed was integrated will be presented, in order to evaluate its applicability and integrability.Os profissionais de saúde enfrentam constantemente o desafio de analisar grandes quantidades de dados médicos na procura de respostas para questões complexas. Além disso, estes profissionais não têm conhecimentos de linguagens para consultas de bases de dados. Portanto, é necessário providenciar aos profissionais de saúde ferramentas que lhes permitam visualizar relatórios, gráficos e dashboards, sem que seja necessário interagir com linguagens de consulta, idealmente nas plataformas onde os dados são gerados. Integrar soluções de Business Intelligence (BI) em aplicações já existentes surge como uma possível solução para este problema, providenciando recursos aos utilizadores finais que lhes permitam explorar dados de uma forma simplificada. Deste modo, não só é valorizada a aplicação onde ocorre a integração, como é eliminada a necessidade de plataformas destacadas para análise de dados. Esta dissertação começa por analisar se a integração de soluções BI na área da saúde é viável, apresentando as principais caracteristicas de dados clínicos, bem como um estado de arte das soluções Business Intelligence existentes. De seguida, é apresentada uma proposta de solução, onde o desenvolvimento de uma solução integrável é detalhadamente descrito. Por fim, serão apresentados casos de estudo onde a integração do trabalho desenvolvido ocorreu, de forma a avaliar a sua aplicabilidade e integrabilidade.Mestrado em Engenharia Informátic

IMPLEMENTASI REPLIKASI DATABASE MICROSOFT SQL SERVER – POSTGRESQL UNTUK PENERAPAN SINGLE SIGN ON (SSO)

Penyimpanan dan pertukaran informasi menjadi hal yang perlu dalam dunia teknologi. Databasepun menjadi sebuah hal penting keberadaannya dalam perjalanan pertukaran informasi, hal ini membuat DBMS(Database Management System) di buat bermacam-macam jenis, dengan banyaknya jenis DBMS hal ini menjadi halangan dalam hubungan antar DBMS. Hubungan antar DBMS sendiri umumnya di butuhkan karena perlunya salinandatadari database utama untuk menjaga atau menyelamatkan database atas kehilangandatamaupun kerusakan database. Hal semacam ini biasa disebut dengan Replikasi. Replikasi databasedengan DBMS berbeda jenis dilakukan dengan Pentaho Data Integration. Untuk menjaga konsistensi data, pemanfaatan sumber datacadangan pada aplikasi berbasis webdengan Single Sign On (SSO)juga dilakukan, karna dengan adanya replikasikedua databasememiliki datayang sama. Implementasi Replikasipada databasedengan DBMS berbeda yakni MS.SQL Server – PostgreSQL, memberikan jawaban atas integrasidari dua databasedengan DBMS berbeda jenis, Memudahkan userdalam membuat salinandatapada databaseberbeda DBMS. Penerapan Single Sign On (SSO) pada system loginaplikasi berbasis webdengan datayang di ambil dari databasehasil replikasi, menjadi jawaban untuk meminimalisir dampak buruk bagi jalannya kegiatan apabila terjadi gangguan pada salah satu databasetersebut. Karena Data salinan / hasil replikasimemiliki datayang sama pada keduanya

Demo abstract: Towards IoT service deployments on edge community network microclouds

Internet of Things (IoT) services for personal devices and smart homes provided by commercial solutions are typically proprietary and closed. These services provide little control to the end users, for instance to take ownership of their data and enabling services, which hinders these solutions' wider acceptance. In this demo paper, we argue for an approach to deploy professional IoT services on user-controlled infrastructure at the network edge. The users would benefit from the ability to choose the most suitable service from different IoT service offerings, like the one which satisfies their privacy requirements, and third-party service providers could offer more tailored IoT services at customer premises. We conduct the demonstration on microclouds, which have been built with the Cloudy platform in the Guifi.net community network. The demonstration is conducted from the perspective of end users, who wish to deploy professional IoT data management and analytics services in volunteer microclouds.Peer ReviewedPostprint (author's final draft

Transformation of WSDL files using ETL in the E-orientation domain

The E-orientations platforms become an essential space for students to base their choice on tangible elements, as they offer a macroscopic view of the different academic and professional fields. In this context the Center for Engineering Sciences and Applied Sciences “SISA” funded the MMS Orientation project to focus on student orientation in Morocco. With respect to the peculiarity and the different characteristics of the E-orientation platforms, a comparative study is essential. In this article we will proceed by a comparative study of a sample of platforms in order to highlight the major functionalities that we will model through descriptive files. The work is divided into two parts: The first part will be a comparison and description of existing platforms using descriptive language (WSDL), the second part will use ETL as a transformation technology in order to highlight generic files that will serve as a basis for work. the expected meta model