Installation Using Exasol Cloud Deployment Wizard

Configure and deploy an Exasol cluster or single node system using Exasol's Cloud Deployment Wizard for public clouds. The wizard guides you through the sizing, configuration, and deployment process (internally it uses and parameterizes Exasol's standard Deployment Manager templates).

After configuring your cluster you can either download the pre-configured template or directly open it with the Google Cloud Shell interface to proceed with the deployment process. In the Google Cloud Shell interface, you can further review and customize all settings.

Here is a video that gives you an overview of how the Cloud Deployment Tool works.

Prerequisite

• You must have your account set up on Google Cloud Marketplace.
• Enable the deployment manager API in the project where you want to deploy Exasol.
• Ensure that you have sufficient quota for compute instances and storage (SSD persistent disk) is required in the project.

Basic Mode

Do the following to use the wizard in Basic mode:

1. Open Exasol Cloud Deployment Wizard in your web browser.
2. Select your cloud platform.
3. Select your region from the drop-down and click Continue.

   

4. Select your raw data size from Raw Data Size.
5. Select one of the following recommendations from System Recommendations:
   • Basic Configuration: Shows a minimum specification for you data size.
   • Balanced Configuration: Shows an average specification for you data size for good performance.
   • High Performance Configuration: Shows the best possible specification for you data size for high performance.

   The above options are shown depending on your selection in Raw Data Size.

   

6. Click Continue.

   

   7. Click Continue.

      

      The Summary pages shows all the details about the GCP instance.

   8. Do one of the following on the summary page:
      • Select Create New VPC or Use Existing VPC: Use this option to create a virtual network or use an existing virtual network.
      • Open in Google Cloud Shell: Use this option to open your GCP instance in a new browser window and continue with the Exasol deployment in the Google Cloud Shell.

        Log in to you account and fill in the required information on the page to continue.

        For more information on the Stack parameters an to proceed further, see Template Parameters.

      • Deployment Manager Templates: You can download the Deployment Manager Templates on your system and upload them later to GCP through Google Cloud Shell.
   9. Do the following in the Google Cloud Shell:
      1. Log in to your Google Cloud account.
      2. Select Trust and click Proceed to continue.

         

      3. Enter the following information on the next screen:
         • EXAoperation password: Create the password for EXAoperation admin user.
         • Exasol database user password: Create the password for Exasol database user sys.
         • Assign Public IP: Select yes if you want to assign a public IP address.
         • Number of Nodes: Enter the number of nodes for Exasol instance.
         • Start Deployment: Enter yes to start the deployment.
         • Name of Deployment: Enter a name for the Exasol deployment.

         

         The deployment will initiate.

      4. Once the deployment is complete, following screen is shown.

         

Advanced Mode

Do the following to use the wizard in Advanced mode:

1. Open Exasol Cloud Deployment Wizard in your web browser.
2. Select your cloud platform.
3. Select your region from the drop-down and click Continue.

   

4. Click Advanced Configuration button on the Configuration page.
5. Configure the instance based on your requirements.

   

6. Click Continue.

   

   The Summary pages shows all the details about the GCP instance.

7. Do one of the following on the summary page:
   • Select Create New VPC or Use Existing VPC: Use this option to create a virtual network or use an existing virtual network.
   • Open in Google Cloud Shell: Use this option to open your GCP instance in a new browser window and continue with the Exasol deployment in the Google Cloud Shell.

     Log in to you account and fill in the required information on the page to continue.

     For more information on the Stack parameters an to proceed further, see Template Parameters.

   • Deployment Manager Templates: You can download the Deployment Manager Templates on your system and upload them later to GCP through Google Cloud Shell.
8. Do the following in the Google Cloud Shell:
   1. Log in to your Google Cloud account.
   2. Select Trust and click Proceed to continue.

      

   3. Enter the following information on the next screen:
      • EXAoperation password: Create the password for EXAoperation admin user.
      • Exasol database user password: Create the password for Exasol database user sys.
      • Assign Public IP: Select yes if you want to assign a public IP address.
      • Number of Nodes: Enter the number of nodes for Exasol instance.
      • Start Deployment: Enter yes to start the deployment.
      • Name of Deployment: Enter a name for the Exasol deployment.

      

      The deployment will initiate.

   4. Once the deployment is complete, following screen is shown.

      

Launch Instance

Once the instance is in running state, you can connect to it using the IP address or the DNS name displayed in the console. To launch the instance, follow these steps:

1. Copy and paste the IP address or the DNS name of the instance in a browser.
2. You will receive a digital certificate to confirm. Once you have confirmed this, the installation is initialized, and the following screen is displayed.



3. Once installation is complete, you will be redirected to the EXAoperation screen.

   It may take up to 45 minutes for the EXAoperation to be online after deployment.

Next Steps

Connect to Exasol

After installing Exasol on GCP, you can do the following:

• Install drivers required to connect to other tools.
• Connect SQL clients to Exasol.
• Connect Business Intelligence tools (BI tools) to Exasol.
• Connect Data Integration - ETL tool to Exasol.
• Connect Data Warehouse Automation tools to Exasol.

Load Data

After you have connected your choice of tool to Exasol, you can load your data into Exasol and process further. To know more about loading data into Exasol, see Loading Data.

Administration

For the maintenance tasks related to Exasol on GCP, see Administration - Google Cloud Platform.