Category: Oracle Reports

Overview of Active and Idle Databases in Informatica


In pushdown optimization the Informatica Integration Service pushes the transformation logic to a database called active database and when it does not process then it is called idle database. ● When using full optimization in Informatica the target database will be active whereas the source database will be idle. ● In sessions which contain lookup transformation the source or target database is active whereas the lookup database will be idle. ● In sessions which contain joiner transformation in Informatica the source in the detail pipeline is active whereas the source in the master pipeline is idle. ● In a session which contains Union transformation the source in the first input group is active whereas the source in other input groups will be idle. 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 +

What Is “HCM” And How Can It Help Your Business?

Oracle Fusion HCM helps aid your business in and increase ROI, but what is Human Capital Management? Read our blog to find out more about the latest Oracle Business Intelligence Tools that help global and small businesses.

Read More +

Classic and Interactive reports in Oracle Apex

Oracle Apex

Interactive reports: Interactive reports is a formatted result of a SQL query. Interactive reports can be created with both Create Application Wizard and Create Page Wizard. It supports only Desktop applications. Users can customize the report layout and data displayed. Multiple interactive reports per page can be included and developers can restrict the capabilities available to end users. In the application Report functionality, is the same across all reports. End users can customize how and what data displays while viewing an interactive report. By default, in the first column of each row, interactive reports include a search bar, an Actions menu, column heading menus, and edit icons. Classic Reports: A classic report is a formatted result of a SQL query. Classic report creation is supported by both the Create Application Wizard and Create Page Wizard. End users cannot customize a classic report except for sorting and simple filtering. To create a classic report, developers either select a table or provide a SQL statement. Classic reports support general keyword search capability, the ability to specify the number of rows that display, and basic column sorting. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more […]

Read More +

Report filling process in Jaspersoft Reports

jaspersoft reports

The main objective of any reporting tool is to produce high-quality documents. Report filling process helps reporting tool to achieve this by manipulating sets of data. The main inputs required for the report-filling process are – • Report Template: Its actual JasperReport file. • Report Parameters : These are basically named values that are passed at the report filling time to the engine. • Data Source: User can fill a Jasper file from a range of data sources like an SQL query, an XML file, a CSV file, an HQL (Hibernate Query Language) query, a collection of Java Beans, etc. The output generated by this process is a .jrprint document which is ready to be viewed, printed, or exported to other formats. The facade class net.sf.jasperreports.engine.JasperFillManager is usually used for filling a report template with data. This class has various fillReportXXX() methods that fill report templates. There are two categories of fillReportXXX() methods in the façade class – • The first type receives a java.sql.Connection object as the third parameter. Most of the times, reports are filled with data from a relational database. This is achieved by – Connect to the database through JDBC. Include an SQL query inside the report […]

Read More +

Frames in Jaspersoft Reports

Jaspersoft reports

A frame is an element that can contain other elements and optionally draw a border around them. Since a frame is a container of other elements, in the document outline view the frame is represented as a node containing other elements. A frame can contain other frames, and so on recursively. To add an element to a frame, just drag the new element from the palette inside the frame. Alternatively, the user can use the outline view and drag elements from a band into the frame and so on. The position of an element is always relative to the container position. If the container is a band, the element position is relative to the top of the band and to the left margin. If the container is a frame, the element coordinates are relative to the top left corner of the frame. Since an element dragged from a container to another does not change its top/left properties, when moving an element from a container to another its position is recalculated based on the new container location. Advantages of using a frame: • When the user moves a frame, all the elements contained in the frame move. • While using a […]

Read More +

How Cloud-based Business Intelligence Tools improve Healthcare Delivery

Oracle Fusion HCM

With the onslaught of COVID-19, healthcare organizations can have a hard time keeping up in tracking the patient care processes. Enterprise Business intelligence platforms like OAC (Oracle Analytics Cloud) and OBIEE, Microsoft Power BI, IBM Cognos, TIBCO Jaspersoft can provide organizations with the data tools necessary to rationalize data, comply with industry standards and improve productivity. These are the major areas where Business Intelligence platforms can help: Data Visualisation and dashboards – Web-based dashboards provide a visual interface of a critical patient, clinical, financial, and performance data points for making calculated decisions. Tools like Oracle Data Visualisation help us to spot patterns and trends, that otherwise might go unnoticed in traditional reports, tables, or spreadsheets. Analytics and Reporting – Business intelligence analytics and reporting tools can assist organizations with the data needed to quickly implement effective ways to identify, measure, and monitor the quality of service and patient care. The reports would also help in adhering to the compliance standards. Data sharing and eliminating redundancy – Having a single Business Intelligence platform would provide a single source of truth and help healthcare providers to share information across medical departments which will significantly improve medical decision outcomes and evidence-based clinical decision-making […]

Read More +