Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE on AWS

Hi All,

I'm a BI developer having experience in ETL tools like Informatica and ODI and BI reporting tool like OBIEE. Currently, I'm working on having OBIEE setup on AWS. I have created free account on AWS and trying to figure out how to install Oracle DB and OBIEE on AWS.

Have tried with many google help available, but none of them have given step by step process. Also, most of them have corporate account, which make it easy for them to go with.

Appreciate, if someone has done same and can help me with setting up. This is purely for learning purpose.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Depending on what your target is, you could start here: OBIEE SampleApp v406 Amazon EC2 AMI - available for public use - Rittman Mead Consulting

AceNovice

Thank you Christian,

Is there any possibility, I can setup OBIEE (or any other tool) on AWS my own?

[Deleted User]

A whole score of options actually. Here's some links:

https://aws.amazon.com/testdrive/oracle/ (Vlamis a bit further down the page)

http://www.rittmanmead.com/2014/09/obiee-sampleapp-in-the-cloud-importing-virtualbox-machines-to-aws-ec2/

OBIEE on Amazon RDS for Oracle database => Using Non-Oracle, and Cloud-Hosted Databases with OBIEE 11g - Rittman Mead Consulting

Gianni Ceresa

Hi,

Honestly I don't really think you can setup and run OBIEE + DB on AWS using the free tier.

The free part give you access to a t2.micro instance (or more than one of that kind). The t2.micro is 1 vCPU and 1Gb or memory.

After running the OS (linux ideally) you will still have 800-900 Mb or memory, but you have no chances to be able to install the DB and OBIEE and run them. They are enterprise level tools, requiring at 6-8 or more Gb or memory. I guess 4Gb is the really minimum to be able to run OBIEE.

If you pay for a bigger instance like a t2.large for example (remember that OS + DB + OBIEE in 4Gb is really short, so target 8 ideally) the install process is just like a standard linux or Windows install (depending on the kind of OS you choose).

803253

We currently conduct all of our OBIEE training using AWS that houses OBIEE and Oracle DB and have no issues at all. Key is to setup the correct security group. Once you have all that worked out, it is a simple install. We have our users RDP into the server, but also have OHTTP installed so you can reach it from any browser.

Cheers Screen Shot 2016-03-07 at 12.40.32 PM.png

803253

Also, we use m3.large instances and works fine.

Simon.D

I agree with @Gianni Ceresa. Due to the memory restrictions of the AWS free tier instances I don't think there will be enough resources on that machine to support a DB and OBIEE installation. That's not to say that it can't be done, it can actually be done just as easily as any other machine, you just need a bigger instance to be able to run it.

AceNovice

Can you please share steps on how you installed and what instance you took?

803253

We use the Windows Server 2008 R2 instance from Amazon. For the hardware options, we use m3.large (2 CPUs, 7.5 GB of RAM, 32GB SSD) instances for all of our AMIs, but you're more than welcome to use others. They vary in price as well.

On step 3, I only change the Availability Zone to be the correct timezone (east 1b for me).

Step 4: Screen Shot 2016-03-07 at 2.16.00 PM.png

Step 5: Name your instance

Step 6: Pick your OBIEE security group you created before hand. See my previous post.

Step 7 (first pop up): I use Magnetic Boot as boot volume

Step 8 (Launch Pop Up): Continue without key

Once your instance is launched, you simply install OBIEE and the DB as you would any other environment.

Thanks

Gianni Ceresa

As said earlier you can also do the same on a linux instance (as far as I remember linux instances are cheaper than Windows).

AWS or not the install process is exactly the same, nothing change, so you can follow the official documentation or any "real" install tutorial you find online.

The AWS difference is only that your server is not physically there, but the OS is just a OS (linux or Windows).