Category: Business Intelligence

Integration services in Informatica

Informatica Powercenter

PowerCenter integration service in Informatica moves data from sources to targets based on workflow, session and mapping related metadata stored in the repository. The Integration Service can combine data from different platforms and source types. The Integration service also performs certain tasks such as  Managing workflow schedule. Lock and read the workflow. Reading the parameter file. Creating the workflow log. Run workflow tasks and evaluate the conditional links connecting tasks. Start the Data Transformation Manager (DTM) process or processes to run the session. Write historical run information to the repository. Send post-­session email in the event of a DTM failure. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Major benefits of Amazon QuickSight

Amazon Quicksight

Amazon QuickSight is an Amazon Web Services which enables businesses to upgrade from a spreadsheet based reporting to an interactive tool that can analyze the data. The main purpose of this tool is to convert the unstructured data into actionable intelligence. Data source Compatibility – Almost all types of data sources can be accessed and in fact any form of data stored in an internet accessible environment can be worked with QuickSight. SPICE engine – It is a super fast, parallel, in-memory, calculation engine and it is quick and easy to use. It is designed to be more powerful with enormous amounts of data readily available through its replication process. Portability – This tool can be accessed from anywhere such as laptop, desktop, smart phone, tablets and even offline after installing offline mode. Flexibility – QuickSight is designed in such a way that users can play around with massive data with a world class data engine and flexibility of the tool which increases the usage. Smart visualizations – The feature such as ‘Autograph’ accurately predicts the data and analyses it based on your analytical patterns and comes out with a solution. Self-service analyses – The data can be separated as […]

Read More +

Overview of Security Features in Jaspersoft Reports server

Jasper Reports Server has built-in security that ensures that users can only access the data they are allowed to view. The following are the major Jaspersoft Server security features. • Jaspersoft Server provides Security configuration in User level, Application level and Domain level. • Jaspersoft offers setting up Authentication and Authorization. These steps can be configured through the “Manage Security” option will be visible to the Admin users in the Jaspersoft server. • Authentication includes creating users and roles from Jaspersoft server using the “Add user” option. Once users are created, roles can be assigned to specific users. Also, a user may belong to any number of roles. The administrator can create, modify and delete Users and Roles. • Authorization includes control over Menu options and pages, Organization scope, Resource permissions, Administrator privileges, Data-level security and Profile attributes. • Row-level security and Column level security can be applied to the Domains security file in XML format configured in Jaspersoft Server Commercial edition. • Application level security can be achieved in configuration level which includes protection against SQL injection, password encryptions in configuration files, restriction of file uploading, disabling Unused HTTP verbs, etc. DataTerrain with years of experience and reliable experts […]

Read More +

The Revolution of HR Analytics Relies on HCM Tools

human capital management resources

Oracle Human Capital Management HR is more often than not the department that suffers most when it comes to getting funds. This has worked against it-system-wise-rendering it the poor relation and often leading to complex, heavily-adapted legacy systems functioning on outdated technology and with massive data volumes safeguarded in uncontrollable silos.

Read More +

Data extraction in Tableau

Tableau Data Extraction

Data extraction in Tableau is useful in increasing performance by applying filters. It also helps in applying some features of Tableau to data which may not be available in the data source like finding the distinct values in the data. However, the data extract feature is most frequently used for creating an extract to be stored in the local drive for offline access by Tableau. Creating an ExtractExtraction of data in Tableau is done by following the menu – Data → Extract Data. It creates many options such as applying limits to how many rows to be extracted and whether to aggregate data for dimensions.Applying Extract FiltersTo extract a subset of data from the data source, you can create filters which will return only the relevant rows. Let’s consider the Sample Superstore data set and create an extract. In the filter option, choose Select from list and tick mark the checkbox value for which you need to pull the data from the source.Adding New Data to ExtractTo add more data for an already created extract, you can choose the option Data → Extract → Append Data from File. In this case, browse the file containing the data and click OK […]

Read More +