Category: Report Conversion

SaaS connectors in Amazon Quicksight

Amazon Quicksight

SaaS connectors can be used to access data directly from Amazon QuickSight for analysing and reporting. ● The SaaS connectors simplify accessing third-party application sources using OAuth, without any need to export the data to an intermediate data store.● SaaS applications can be used on either cloud-based or server-based instances.● If Amazon QuickSight can’t access the application, it will generate an unknown host error.● Organizations can integrate with Adobe Analytics to build consolidated dashboards to visualize their online and web marketing data.● The SaaS source must support REST API operations for Amazon QuickSight to connect to it. `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 +

Expedite Peoplesoft Reports to Oracle HCM Migration Using Pre-Built Reports

Most of the big enterprises have started migrating their Peoplesoft system to Oracle Fusion HCM. After the migration process, one of the important challenges faced by the Users is that they would be not able to have the reports in Oracle Fusion HCM that they were previously using in Peoplesoft Environment. Oracle provides a bundle of pre-built reports which users can make use for viewing the required Payroll/HR/Compensation data from Fusion. In certain scenarios, users would like to have their existing PeopleSoft report replicated in Oracle Fusion HCM for requirements such as tax filing or other internal audit purposes. DataTerrainhas created a variety of pre-built Oracle HCM reports which are similar to Peoplesoft reports in report functionality and formatting features such as page breaks and totals. These reports can be quickly rolled out with minimal customization, saving significant time and cost. Some of the useful Peoplesoft reports that are already pre-built in Oracle Fusion HCM are: • PAY007 – Deduction in Arrears • PAY013(CN) – Employee Earnings Snapshot • TAX010FD – Tax Summary – Federal (can be run for a date range) • TAX010ST – Tax Summary – State (can be run for a date range) • TAX900 – Tax […]

Read More +

Guidelines to create Key Ranges in Informatica


The key range partitioning in Informatica distributes rows of data based on a port or set of ports that you define as the partition key. Guidelines to create key ranges are mentioned below. ● The partition key must contain at least one port. ● The range for each port in the partition key should be specified. ● The Informatica PowerCenter standard date format can be used to enter dates in key ranges. ● The workflow manager does not validate overlapping string, numeric ranges, the gaps, or missing ranges. When you define key range partitioning at a source qualifier transformation, the Informatica Integration Service defaults to pass-through partitioning if you change the SQL statement in the Source Qualifier transformation. If a row contains a null value in any column or falls outside of the key ranges then the integration service sends that row to the first partition. 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 +

An Overview of Jasper Reports Scriptlet Class

Scriplets in Jaspersoft

Scriptlets are sequences of Java code that are executed every time a report event occurs. Values of report variables can be affected through scriptlets. A scriptlet is a java class, which must extend either of the following classes: • net.sf.jasperreports.engine.JRAbstractScriptlet − This class contains a few abstract methods that must be overridden in every implementation. These methods are called automatically by JasperReports at the appropriate moment. The developer must implement all the abstract methods. • net.sf.jasperreports.engine.JRDefaultScriptlet − This class contains default empty implementations of every method in JRAbstractScriptlet. A developer is only required to implement those methods depends upon the needs of their project. The following table lists some of the methods in the above class. These methods will be called by the report engine at the appropriate time, during the report filling phase. Method Description public void beforeReportInit() Called before report initialization public void afterReportInit() Called after report initialization. public void beforePageInit() Called before each page is initialized. public void afterPageInit() Called after each page is initialized. public void beforeColumnInit() Called before each column is initialized. Any number of scriptlets can be specified per report. If no scriptlet is specified for a report, the engine still creates a single […]

Read More +