Manual performance optimization in Denodo – Most relevant and most used techniques

by Manju Das Manual performance optimization in Denodo – Most relevant and most used techniques 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.

Posted on: 24 August 2020 | 7:46 am

Migrating To AWS Aurora? Things to Consider!

by Mohit Mathur Not 100% convinced of migrating to AWS Aurora? – READ ME  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. According to the survey done by Gartner in last quarter of 2018: Organizations of all sizes are moving to cloud solutions, such as core financial applications, for transactional systems of record. Cloud momentum is consistently higher across financial business applications year over year. Business analytics and enterprise business applications continue as top investment initiatives for senior financial executives.

Posted on: 17 April 2019 | 12:45 pm

Traditional vs. Agile Software Development Methodologies

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.

Posted on: 22 June 2018 | 6:13 pm

Integration of OBIEE with an External Web Application - SAML SSO

by Siva Kumar Mopuri Security Implementation Benefits 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.

Posted on: 13 June 2018 | 11:25 am

How to Setup Dependencies between Load Plans in Oracle Data Integrator

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.

Posted on: 11 June 2018 | 11:53 am

How to Setup Oracle Analytics Cloud Service

by Dindima Mahesh Jami 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. What is OACS? 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.

Posted on: 15 February 2018 | 1:39 pm

Google Data Studio - Initial Impressions

by Rushendra Prasad 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.

Posted on: 6 October 2017 | 11:54 am

Informatica SAP Connector Explained

by Balaswamy Kaladi This blog describes how to configure Informatica’s SAP NetWeaver R/3 to connect with SAP BW, extracting data directly from SAP transparent tables. It details setup steps on Informatica and BW servers, as well as what’s required from a developer’s perspective. It’s also important to note that there are two ways to connect SAP BW from Informatica, i.e. Using Informatica’s SAP BW Connector – this extraction is driven by an Infospoke and extracts data via the Open Hub Services (OHS) Using Informatica’s SAP NetWeaver R/3 Connector – this allows data extraction directly from a SAP transparent table This blog details the second method i.e. using Informatica's SAP NetWeaver R/3 Connector.

Posted on: 20 October 2016 | 12:10 pm

Data Warehousing and Analytics Using Amazon Redshift

by Balaswamy Kaladi In today’s world of big data, analytics, and data warehousing, data volumes continue to grow, seemingly only matched by businesses’ appetite to exploit data for commercial advantage, and do so ever more quickly. Historically, to deal with the kind of large data volumes that are now becoming commonplace, expensive and heavyweight technologies from vendors such as Teradata, Netezza and Vertica were needed. These typically cost millions of dollars, and required hardware, software, and consulting.

Posted on: 14 October 2016 | 1:33 pm

Cassandra Installation, Configuration and Multi-Data Center Clustering

by Santoshkumar Lakkanagaon What are the different types of Cassandra distributions available? Open Source Apache Cassandra (GitHub) DataStax Community Edition (free for development and production) DataStax Enterprise with OpsCenter, DevCenter and Drivers (free for development and license required for production)

Posted on: 14 September 2016 | 11:39 am