We are going to discuss how to optimize the Denodo query to make the most of the optimization in the Denodo platform. Below are the most powerful query optimization techniques that we can apply in Denodo platform manually which will increase the performance significantly.
Tags: Blog, Manju Das, Denodo, Most relevant and most used techniques, Manual performance optimization in Denodo, Denodo platform, query optimizer, data virtualization tools, performance tuning in sql, denodo data virtualization
by Mohit Mathur
According to latest reports released in February 2019 by leading market research companies, 94% of respondents now leverage cloud technologies. Public cloud adoption is at 91 percent and private cloud adoption is at 72 percent, according to Right scale – A Cloud Management Company.
Tags: Migrations, Blog, AWS, Amazon Aurora, Mohit Mathur, Migrating To AWS Aurora
by Sristi Raj
With the advent of cloud data warehouse and analytics tools, concepts like data lake, in-place querying, schema on read and data mashup have become a critical and integral part of an organization’s analytics capabilities. Consequently, new tools and features like AWS Redshift spectrum, Athena, Presto, Hive etc. are now playing a game changing role for data analysts to explore and mine data and get value out of existing data assets lying unused within the organization. Although, with so many options to choose from, it becomes utterly necessary to understand the subtle differences between each of them and advantages of each, to select the right tool of choice for a particular use case. With this blog, we will explore some capabilities of Redshift spectrum and advantages of using it in some of the use cases, while keeping the comparison and differences between different tool of choice to a separate blog post.
Tags: Blog, Sristi Raj, Advantages of using Redshift Spectrum, AWS Redshift
by Indusree Mavuru
Most companies today focus on delivering quality and gaining customer satisfaction and in order to accomplish this, the challenge lies in choosing between traditional development methodologies and agile development methodologies.
Tags: Blog, agile software development methodology, traditional vs agile, traditional software development methodology
by Siva Kumar Mopuri
This solution is beneficial in OLTP applications like Oracle EBS that are integrated with OBIEE. In such scenarios, all the responsibilities/groups from OLTP source would be forwarded to OBIEE. Instead of having all the responsibilities in OBIEE, the user has the privilege to select the required responsibilities at runtime and those would be passed to OBIEE.
Note: This blog post considers Oracle EBS as an OLTP source which is integrated with OBIEE.
by Chaithanya Kumar Taduvai
ODI developers usually deal with load plans and mismanaged dependencies between multiple-load plans are typically a cause of data corruption in the system. An ideal Informatica warehouse implementation has multiple execution processes dependent on other execution processes which run automatically without any manual intervention. Here is how we can overcome this issue using the load plan dependency feature of ODI.
Tags: ODI, Oracle Data Integrator (ODI), Blog, ODI Load Plans
This blog post is intended for those who are familiar with OBIEE or have previously worked on it. It contains step by step instructions on how to setup OACS using a trial account.
Oracle Analytics Cloud Service (OACS) is a new Platform as a Service (PaaS) offering comprehensive analytics capabilities at any scale, in any environment, and on any device. This was first announced on Sep 30, 2014 at Oracle OpenWorld and was officially launched on Apr 4, 2017.
Tags: Blog, oacs, Oracle Analytics Cloud Service, Dindima Mahesh Jami
This blog post offers an insight into the features and functionalities of Google Data Studio and compares it with popular data analysis tools like Tableau, QlikView and new entrants like Power BI.
Disclaimer: This article and all features assessed are as on Sep, 2017 and subject to modifications / enhancements by Google.
Tags: OBIEE, Rushendra Prasad, Tableau, Blog, Power BI, Google Data Studio
To read part 1 of this blog post, please click here.
This blog post discusses how to integrate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.
This is applicable for 8.2, 8.3, 9.0 and later versions.
Tags: OBIEE, Rushendra Prasad, Tableau, Oracle BI, Blog, Oracle BI Server
.png)
This blog post discusses how to integrate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.
This is applicable for 8.2, 8.3, 9.0 and later versions.
Tags: OBIEE, Rushendra Prasad, Tableau, Oracle BI, Blog, Oracle BI Server
