Community Manager
Community Manager

Background

In some use cases, you may want to enable internet access for your community edition so that you can load publicly accessible data sets, for example. This article will show you how to do this using VMWare. A similar article exists already for Virtualbox.

Prerequisites

First, download the Exasol Community Edition by filling out this form and choosing the .OVA file to download.

If not already done, import the Exasol OVA file into VMWare by clicking on "Open a Virtual Machine" and choosing the OVA file you downloaded. 

Annotation 2020-08-25 104145.png

 Accept the "End User License Agreement" and the "Privacy Statement" and wait until the image has been successfully loaded.

You will know when Exasol has been completely installed when you see a page that looks like this:

Annotation 2020-08-25 104412.png

 

 

 

How to Enable Internet Access

Step 1: Open Virtual Machine Settings

Open up the Virtual Machine settings by clicking Player -> Manage -> Virtual Machine Settings. It should look like this:

Annotation 2020-08-25 104625.png

 

Annotation 2020-08-25 104700.png

 

 

Step 2: Change Network Adapter

In the Virtual Machine Settings, change the Network Adapter to type "NAT". 

NOTE: You could also choose a Bridged Adapter, however this can be more complicated because you must ensure that the correct adapters have internet access and are set for bridged mode. For this example, we will continue with NAT.

Click the NAT radio buttonClick the NAT radio button

 

Then click "OK".

Step 3: Reboot the Virtual Machine

You can go to Maintenance -> Reboot to restart the Virtual Machine so that the network settings are applied. 

Step 4: Add NTP and DNS Servers

Once the machine has been rebooted, please open EXAoperation by visiting the link that is displayed on the machine. In the picture below, I can access EXAoperation by visiting https://192.168.47.129. You will need to accept the security risk. 

Annotation 2020-08-25 105658.png

 In EXAOperation, click on the Network Button. On this page, we will add NTP and DNS servers.

Annotation 2020-08-25 105953.png

Click on Edit and add your DNS and NTP servers. You can use the google DNS Servers 8.8.8.8 or 8.8.4.4 and the NTP servers *.de.pool.ntp.org. Of course, you can also use any other DNS or NTP server that you would like.  The end result will look like this:

Annotation 2020-08-26 113953.png

 

 

Step 5: Synchronize Time

Click on the Monitoring Tab in EXAoperation and synchronize the time. 

Synchronize Time in EXAoperation.PNG

 

Now you should be able to connect to the internet. You can test this by running an IMPORT on a publicly-available data set or by creating a UDF which connects to the internet. 

Additional Notes

Network settings on virtual machines can be very tricky. Even after performing these steps, the internet connection might work. In most cases, this is due to your company's network settings or firewall settings. If you are still having trouble, you can contact your company's IT team to help troubleshoot the network problems. 

Additional References

Comments
Moderator
Moderator

Here's a similar guide how to enable Network Access for CE from VirtualBox

https://community.exasol.com/t5/training-forum/enable-network-access-from-community-edition-in-virtu...