{"id":14745,"date":"2020-09-29T11:30:53","date_gmt":"2020-09-29T09:30:53","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/"},"modified":"2020-09-29T11:30:53","modified_gmt":"2020-09-29T09:30:53","slug":"getting-started-with-exasol-setting-up-an-environment","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/","title":{"rendered":"Getting started with Exasol &#8211; Setting up an environment"},"content":{"rendered":"<p><a href=\"https:\/\/www.exasol.com\" target=\"_blank\" rel=\"noopener noreferrer\">Exasol<\/a> is an in memory database with parallel processing, or shorter <a href=\"https:\/\/en.wikipedia.org\/wiki\/Massive_parallel_processing\" target=\"_blank\" rel=\"noopener noreferrer\">MPP<\/a>(Massively Parallel Processing) database. I got in touch with some people from Exasol at the <a href=\"https:\/\/2020.doag.org\/index.php?id=1449\" target=\"_blank\" rel=\"noopener noreferrer\">DOAG 2019 in Nuremberg<\/a> but never had the time to take a closer look since then. Over the past few weeks however I finally had the chance to get in touch with the system and thought it might be a good idea to share what I learned by writing a couple of blog posts. This is the first one in this series and I&#8217;ll start with the basics: Getting a test system up and running, and once it is there how to connect to it, with either a graphical user interface or by using the command line. In the coming post we&#8217;ll look at how Exasol handles transactions, how you can connect Exasol to PostgreSQL and how you can import and export data, and few other topics that differentiate Exasol from other database systems.<\/p>\n<p><!--more--><\/p>\n<p>For getting a test system up and running you basically have <a href=\"https:\/\/www.exasol.com\/en\/product-overview\/ways-to-trial\/\" target=\"_blank\" rel=\"noopener noreferrer\">three choices<\/a>:<\/p>\n<ul>\n<li>Deployment in a private cloud<\/li>\n<li>Deployment in a public cloud (AWS, Azure, Google)<\/li>\n<li>Use the community edition (limited to 200GB of data but with all the features), either as an <a href=\"https:\/\/en.wikipedia.org\/wiki\/Open_Virtualization_Format\" target=\"_blank\" rel=\"noopener noreferrer\">OVA file<\/a> or as an ISO for installation<\/li>\n<\/ul>\n<p>I went with the community edition and you can request a download <a href=\"https:\/\/www.exasol.com\/en\/product-overview\/community-edition-download\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg\" alt=\"\" width=\"597\" height=\"510\" class=\"aligncenter size-full wp-image-43730\" \/><\/a><\/p>\n<p>Once you either have installed from the ISO or imported the OVA you should see a screen like this which gives you the basic information you need to connect the system:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-16-14.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-16-14.png\" alt=\"\" width=\"743\" height=\"437\" class=\"aligncenter size-full wp-image-43734\" \/><\/a><\/p>\n<p>One graphical tool you can use to connect to Exasol is <a href=\"https:\/\/dbeaver.io\/\" target=\"_blank\" rel=\"noopener noreferrer\">dbeaver<\/a>. Setting up a connection to Exasol in dbeaver is just a matter of a few clicks:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-23-47.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-23-47.jpg\" alt=\"\" width=\"618\" height=\"671\" class=\"aligncenter size-full wp-image-43735\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-24-09.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-24-09.jpg\" alt=\"\" width=\"624\" height=\"677\" class=\"aligncenter size-full wp-image-43736\" \/><\/a><\/p>\n<p>Another option you have is the command line. The client is called EXAPlus and can be downloaded from the Exasol&#8217;s <a href=\"https:\/\/www.exasol.com\/portal\/display\/DOWNLOAD\/7.0\" target=\"_blank\" rel=\"noopener noreferrer\">download page<\/a>. The client is written in Java and should run on any operating system.<\/p>\n<p>When start that up and connect the Exasol system you&#8217;ll notice that it pretty much feels like SQL*Plus from Oracle:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [95,98,101]\">\ndwe@dwe:~\/EXAplus-7.0.0$ .\/exaplus -c 192.168.22.117:8563 -u sys -p exasol\nEXAplus 7.0.0 (c) EXASOL AG\n\nMonday, September 28, 2020 at 4:30:32 PM Central European Summer Time\nConnected to database EXAone as user sys.\nEXASolution 7.0.2 (c) EXASOL AG\n\nSQL_EXA&gt; select * from exa_parameters;\nEXA: select * from exa_parameters;\n\nPARAMETER_NAME                \n------------------------------\nSESSION_VALUE                                                                                                                                                                                           \n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nSYSTEM_VALUE                                                                                                                                                                                            \n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nNLS_DATE_FORMAT               \nYYYY-MM-DD                                                                                                                                                                                              \nYYYY-MM-DD                                                                                                                                                                                              \nNLS_FIRST_DAY_OF_WEEK         \n7                                                                                                                                                                                                       \n7                                                                                                                                                                                                       \nNLS_TIMESTAMP_FORMAT          \nYYYY-MM-DD HH24:MI:SS.FF6                                                                                                                                                                               \nYYYY-MM-DD HH24:MI:SS.FF6                                                                                                                                                                               \nNLS_NUMERIC_CHARACTERS        \n.,                                                                                                                                                                                                      \n.,                                                                                                                                                                                                      \nNLS_DATE_LANGUAGE             \nENG                                                                                                                                                                                                     \nENG                                                                                                                                                                                                     \nQUERY_TIMEOUT                 \n0                                                                                                                                                                                                       \n0                                                                                                                                                                                                       \nCONSTRAINT_STATE_DEFAULT      \nENABLE                                                                                                                                                                                                  \nENABLE                                                                                                                                                                                                  \nPROFILE                       \nOFF                                                                                                                                                                                                     \nOFF                                                                                                                                                                                                     \nTIME_ZONE                     \nUTC                                                                                                                                                                                                     \nUTC                                                                                                                                                                                                     \nTIME_ZONE_BEHAVIOR            \nINVALID SHIFT AMBIGUOUS ST                                                                                                                                                                              \nINVALID SHIFT AMBIGUOUS ST                                                                                                                                                                              \nDEFAULT_CONSUMER_GROUP        \nMEDIUM                                                                                                                                                                                                  \nMEDIUM                                                                                                                                                                                                  \nNICE                          \nOFF                                                                                                                                                                                                     \nOFF                                                                                                                                                                                                     \nSQL_PREPROCESSOR_SCRIPT       \n                                                                                                                                                                                                        \n                                                                                                                                                                                                        \nQUERY_CACHE                   \nON                                                                                                                                                                                                      \nON                                                                                                                                                                                                      \nDEFAULT_LIKE_ESCAPE_CHARACTER \n\\                                                                                                                                                                                                       \n\\                                                                                                                                                                                                       \nTIMESTAMP_ARITHMETIC_BEHAVIOR \nINTERVAL                                                                                                                                                                                                \nINTERVAL                                                                                                                                                                                                \nSCRIPT_LANGUAGES              \nPYTHON=builtin_python R=builtin_r JAVA=builtin_java PYTHON3=builtin_python3                                                                                                                             \nPYTHON=builtin_python R=builtin_r JAVA=builtin_java PYTHON3=builtin_python3                                                                                                                             \nSCRIPT_OUTPUT_ADDRESS         \n                                                                                                                                                                                                        \n                                                                                                                                                                                                        \nPASSWORD_EXPIRY_POLICY        \nOFF                                                                                                                                                                                                     \nOFF                                                                                                                                                                                                     \nPASSWORD_SECURITY_POLICY      \nOFF                                                                                                                                                                                                     \nOFF                                                                                                                                                                                                     \nHASHTYPE_FORMAT               \nHEX                                                                                                                                                                                                     \nHEX                                                                                                                                                                                                     \nTEMP_DB_RAM_LIMIT             \nOFF                                                                                                                                                                                                     \nOFF                                                                                                                                                                                                     \nUSER_TEMP_DB_RAM_LIMIT        \nOFF                                                                                                                                                                                                     \nOFF                                                                                                                                                                                                     \nSESSION_TEMP_DB_RAM_LIMIT     \nOFF                                                                                                                                                                                                     \nOFF                                                                                                                                                                                                     \nST_MAX_DECIMAL_DIGITS         \n16                                                                                                                                                                                                      \n16                                                                                                                                                                                                      \n\n25 rows in resultset.\n\nSQL_EXA&gt; col session_value for a80;\nCOLUMN   session_value ON\nFORMAT   a80\nSQL_EXA&gt; col system_value for a80;\nCOLUMN   system_value ON\nFORMAT   a80\nSQL_EXA&gt; select * from exa_parameters;\nEXA: select * from exa_parameters;\n\nPARAMETER_NAME                 SESSION_VALUE                                                                    SYSTEM_VALUE                                                                    \n------------------------------ -------------------------------------------------------------------------------- --------------------------------------------------------------------------------\nNLS_DATE_FORMAT                YYYY-MM-DD                                                                       YYYY-MM-DD                                                                      \nNLS_FIRST_DAY_OF_WEEK          7                                                                                7                                                                               \nNLS_TIMESTAMP_FORMAT           YYYY-MM-DD HH24:MI:SS.FF6                                                        YYYY-MM-DD HH24:MI:SS.FF6                                                       \nNLS_NUMERIC_CHARACTERS         .,                                                                               .,                                                                              \nNLS_DATE_LANGUAGE              ENG                                                                              ENG                                                                             \nQUERY_TIMEOUT                  0                                                                                0                                                                               \nCONSTRAINT_STATE_DEFAULT       ENABLE                                                                           ENABLE                                                                          \nPROFILE                        OFF                                                                              OFF                                                                             \nTIME_ZONE                      UTC                                                                              UTC                                                                             \nTIME_ZONE_BEHAVIOR             INVALID SHIFT AMBIGUOUS ST                                                       INVALID SHIFT AMBIGUOUS ST                                                      \nDEFAULT_CONSUMER_GROUP         MEDIUM                                                                           MEDIUM                                                                          \nNICE                           OFF                                                                              OFF                                                                             \nSQL_PREPROCESSOR_SCRIPT                                                                                                                                                                         \nQUERY_CACHE                    ON                                                                               ON                                                                              \nDEFAULT_LIKE_ESCAPE_CHARACTER  \\                                                                                \\                                                                               \nTIMESTAMP_ARITHMETIC_BEHAVIOR  INTERVAL                                                                         INTERVAL                                                                        \nSCRIPT_LANGUAGES               PYTHON=builtin_python R=builtin_r JAVA=builtin_java PYTHON3=builtin_python3      PYTHON=builtin_python R=builtin_r JAVA=builtin_java PYTHON3=builtin_python3     \nSCRIPT_OUTPUT_ADDRESS                                                                                                                                                                           \nPASSWORD_EXPIRY_POLICY         OFF                                                                              OFF                                                                             \nPASSWORD_SECURITY_POLICY       OFF                                                                              OFF                                                                             \nHASHTYPE_FORMAT                HEX                                                                              HEX                                                                             \nTEMP_DB_RAM_LIMIT              OFF                                                                              OFF                                                                             \nUSER_TEMP_DB_RAM_LIMIT         OFF                                                                              OFF                                                                             \nSESSION_TEMP_DB_RAM_LIMIT      OFF                                                                              OFF                                                                             \nST_MAX_DECIMAL_DIGITS          16                                                                               16                                                                              \n\n25 rows in resultset.\n\nSQL_EXA&gt; \n<\/pre>\n<p>Even some of the parameters like the various &#8220;NLS_*&#8221; settings are the same than in Oracle. If I understood correctly, Exasol, in the beginning, was an accelerator on top of Oracle and that would explain why some aspects of the system are very close to it.<\/p>\n<p>An Exasol database always contains two schemas, SYS and EXA_STATISTICS but you won&#8217;t see them in the corresponding system catalog view:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; select * from EXA_DBA_SCHEMAS;\nEXA: select * from EXA_DBA_SCHEMAS;\n\nSCHEMA_NAME     SCHEMA_OWNER    SCHEMA_OBJECT_ID      SCHEM SCHEMA_COMMENT                \n--------------- --------------- --------------------- ----- ------------------------------\n\n0 rows in resultset.\n<\/pre>\n<p>Again, it pretty much feels like Oracle in the beginning. All the catalog views start with EXA_DBA_\/EXA_USER_ or EXA_ALL_ (and yes, tab-completion works in EXAPlus):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; select * from EXA_\nDisplay all 143 possibilities? (y or n) \nEXA_ALL_COLUMNS                           EXA_ALL_VIRTUAL_TABLES                    EXA_DBA_RESTRICTED_OBJ_PRIVS              EXA_MONITOR_DAILY                         EXA_STATISTICS                            EXA_USER_OBJ_PRIVS_MADE\nEXA_ALL_COLUMN_SIZES                      EXA_CACHE_CONTENT                         EXA_DBA_ROLES                             EXA_MONITOR_HOURLY                        EXA_STATISTICS_OBJECT_SIZES               EXA_USER_OBJ_PRIVS_RECD\nEXA_ALL_CONNECTIONS                       EXA_CLUSTERS                              EXA_DBA_ROLE_PRIVS                        EXA_MONITOR_LAST_DAY                      EXA_SYSCAT                                EXA_USER_PROFILE_LAST_DAY\nEXA_ALL_CONSTRAINTS                       EXA_CONSUMER_GROUPS                       EXA_DBA_SCHEMAS                           EXA_MONITOR_MONTHLY                       EXA_SYSTEM_EVENTS                         EXA_USER_PROFILE_RUNNING\nEXA_ALL_CONSTRAINT_COLUMNS                EXA_DBA_AUDIT_IMPERSONATION               EXA_DBA_SCHEMA_OBJECTS                    EXA_OBJECTSTORAGE_USAGE                   EXA_SYS_COLUMNS                           EXA_USER_RESTRICTED_OBJ_PRIVS\nEXA_ALL_DEPENDENCIES                      EXA_DBA_AUDIT_SESSIONS                    EXA_DBA_SCRIPTS                           EXA_PARAMETERS                            EXA_SYS_SCRIPTS                           EXA_USER_ROLE_PRIVS\nEXA_ALL_FUNCTIONS                         EXA_DBA_AUDIT_SQL                         EXA_DBA_SESSIONS                          EXA_ROLE_CONNECTION_PRIVS                 EXA_TIME_ZONES                            EXA_USER_SCHEMAS\nEXA_ALL_INDICES                           EXA_DBA_COLUMNS                           EXA_DBA_SESSIONS_LAST_DAY                 EXA_ROLE_OBJ_PRIVS                        EXA_USAGE_DAILY                           EXA_USER_SCHEMA_OBJECTS\nEXA_ALL_OBJECTS                           EXA_DBA_COLUMN_SIZES                      EXA_DBA_SESSION_RESOURCES                 EXA_ROLE_RESTRICTED_OBJ_PRIVS             EXA_USAGE_HOURLY                          EXA_USER_SCRIPTS\nEXA_ALL_OBJECT_SIZES                      EXA_DBA_CONNECTIONS                       EXA_DBA_SYS_PRIVS                         EXA_ROLE_ROLE_PRIVS                       EXA_USAGE_LAST_DAY                        EXA_USER_SESSIONS\nEXA_ALL_OBJ_PRIVS                         EXA_DBA_CONNECTION_PRIVS                  EXA_DBA_TABLES                            EXA_ROLE_SYS_PRIVS                        EXA_USAGE_MONTHLY                         EXA_USER_SESSIONS_LAST_DAY\nEXA_ALL_OBJ_PRIVS_MADE                    EXA_DBA_CONSTRAINTS                       EXA_DBA_TRANSACTION_CONFLICTS             EXA_SCHEMAS                               EXA_USER_COLUMNS                          EXA_USER_SESSION_RESOURCES\nEXA_ALL_OBJ_PRIVS_RECD                    EXA_DBA_CONSTRAINT_COLUMNS                EXA_DBA_USERS                             EXA_SCHEMA_OBJECTS                        EXA_USER_COLUMN_SIZES                     EXA_USER_SYS_PRIVS\nEXA_ALL_ROLES                             EXA_DBA_DEPENDENCIES                      EXA_DBA_VIEWS                             EXA_SESSION_CONNECTIONS                   EXA_USER_CONNECTION_PRIVS                 EXA_USER_TABLES\nEXA_ALL_SCHEMAS                           EXA_DBA_DEPENDENCIES_RECURSIVE            EXA_DBA_VIRTUAL_COLUMNS                   EXA_SESSION_PRIVS                         EXA_USER_CONSTRAINTS                      EXA_USER_TRANSACTION_CONFLICTS_LAST_DAY\nEXA_ALL_SCHEMA_OBJECTS                    EXA_DBA_FUNCTIONS                         EXA_DBA_VIRTUAL_SCHEMAS                   EXA_SESSION_ROLES                         EXA_USER_CONSTRAINT_COLUMNS               EXA_USER_USERS\nEXA_ALL_SCRIPTS                           EXA_DBA_IMPERSONATION_LAST_DAY            EXA_DBA_VIRTUAL_SCHEMA_PROPERTIES         EXA_SNAPSHOT_BACKUP                       EXA_USER_DEPENDENCIES                     EXA_USER_VIEWS\nEXA_ALL_SESSIONS                          EXA_DBA_IMPERSONATION_PRIVS               EXA_DBA_VIRTUAL_TABLES                    EXA_SPATIAL_REF_SYS                       EXA_USER_FUNCTIONS                        EXA_USER_VIRTUAL_COLUMNS\nEXA_ALL_TABLES                            EXA_DBA_INDICES                           EXA_DB_SIZE_DAILY                         EXA_SQL_DAILY                             EXA_USER_IMPERSONATION_LAST_DAY           EXA_USER_VIRTUAL_SCHEMAS\nEXA_ALL_USERS                             EXA_DBA_OBJECTS                           EXA_DB_SIZE_HOURLY                        EXA_SQL_HOURLY                            EXA_USER_IMPERSONATION_PRIVS              EXA_USER_VIRTUAL_SCHEMA_PROPERTIES\nEXA_ALL_VIEWS                             EXA_DBA_OBJECT_SIZES                      EXA_DB_SIZE_LAST_DAY                      EXA_SQL_KEYWORDS                          EXA_USER_INDICES                          EXA_USER_VIRTUAL_TABLES\nEXA_ALL_VIRTUAL_COLUMNS                   EXA_DBA_OBJ_PRIVS                         EXA_DB_SIZE_MONTHLY                       EXA_SQL_LAST_DAY                          EXA_USER_OBJECTS                          EXA_VIRTUAL_SCHEMAS\nEXA_ALL_VIRTUAL_SCHEMAS                   EXA_DBA_PROFILE_LAST_DAY                  EXA_LOADAVG                               EXA_SQL_MONTHLY                           EXA_USER_OBJECT_SIZES                     EXA_VOLUME_USAGE\nEXA_ALL_VIRTUAL_SCHEMA_PROPERTIES         EXA_DBA_PROFILE_RUNNING                   EXA_METADATA                              EXA_SQL_TYPES                             EXA_USER_OBJ_PRIVS\n<\/pre>\n<p>The &#8220;SYS&#8221; schema contains all meta data definitions while the the EXA_STATISTICS schema contains monitoring and use statistics of the system, like EXA_MONITOR_HOURLY:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; col cluster_name for a15;\nCOLUMN   cluster_name ON\nFORMAT   a15\nSQL_EXA&gt; select INTERVAL_START,CLUSTER_NAME,LOAD_AVG,LOAD_MAX,CPU_AVG,CPU_MAX from EXA_MONITOR_HOURLY;\nEXA: select INTERVAL_START,CLUSTER_NAME,LOAD_AVG,LOAD_MAX,CPU_AVG,CPU_MAX f...\n\nINTERVAL_START             CLUSTER_NAME    LOAD_A LOAD_M CPU_AV CPU_MA\n-------------------------- --------------- ------ ------ ------ ------\n2020-09-28 08:00:00.000000 MASTER             0.4    2.3    2.1    4.7\n2020-09-28 09:00:00.000000 MASTER             0.1    0.4    2.8   12.0\n2020-09-28 10:00:00.000000 MASTER             0.0    0.3    1.9    6.8\n2020-09-28 11:00:00.000000 MASTER             0.1    0.6    2.6    6.8\n2020-09-28 12:00:00.000000 MASTER             0.0    0.3    2.5    7.2\n2020-09-28 13:00:00.000000 MASTER             0.1    0.6    2.7   12.9\n2020-09-28 14:00:00.000000 MASTER             0.0    0.2    2.1    6.3\n2020-09-28 15:00:00.000000 MASTER             0.0    0.2    1.8    6.1\n2020-09-28 16:00:00.000000 MASTER             0.0    0.2    2.1    6.3\n\n9 rows in resultset.\n<\/pre>\n<p>When it comes to users and schemas Exasol compares more to PostgreSQL or SQL Server. A user can create multiple schemas and schemas can be owned by a user, e.g.:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; create schema s1;\nEXA: create schema s1;\n\nRows affected: 0\n\nSQL_EXA&gt; create schema s2;\nEXA: create schema s2;\n\nRows affected: 0\n\nSQL_EXA&gt; create user u1 identified by \"u1\";\nEXA: create user u1 identified by \"u1\";\n\nRows affected: 0\n\nSQL_EXA&gt; alter schema s1 change owner u1;\nEXA: alter schema s1 change owner u1;\n\nRows affected: 0\n\nSQL_EXA&gt; \n<\/pre>\n<p>Now that we know how to setup a simple test system, how to connect and how the catalog is organized we can go into the details. But that will be the topic of the next post.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019 in Nuremberg but never had the time to take a closer look since then. Over the past few weeks however I finally had the chance to get [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":14746,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[2127,2128],"type_dbi":[],"class_list":["post-14745","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-exasol","tag-mpp"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Getting started with Exasol - Setting up an environment - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting started with Exasol - Setting up an environment\" \/>\n<meta property=\"og:description\" content=\"Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019 in Nuremberg but never had the time to take a closer look since then. Over the past few weeks however I finally had the chance to get [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-29T09:30:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"597\" \/>\n\t<meta property=\"og:image:height\" content=\"510\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Getting started with Exasol &#8211; Setting up an environment\",\"datePublished\":\"2020-09-29T09:30:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\"},\"wordCount\":543,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg\",\"keywords\":[\"Exasol\",\"MPP\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\",\"name\":\"Getting started with Exasol - Setting up an environment - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg\",\"datePublished\":\"2020-09-29T09:30:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg\",\"width\":597,\"height\":510},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting started with Exasol &#8211; Setting up an environment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Getting started with Exasol - Setting up an environment - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/","og_locale":"en_US","og_type":"article","og_title":"Getting started with Exasol - Setting up an environment","og_description":"Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019 in Nuremberg but never had the time to take a closer look since then. Over the past few weeks however I finally had the chance to get [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/","og_site_name":"dbi Blog","article_published_time":"2020-09-29T09:30:53+00:00","og_image":[{"width":597,"height":510,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg","type":"image\/jpeg"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Getting started with Exasol &#8211; Setting up an environment","datePublished":"2020-09-29T09:30:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/"},"wordCount":543,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg","keywords":["Exasol","MPP"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/","url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/","name":"Getting started with Exasol - Setting up an environment - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg","datePublished":"2020-09-29T09:30:53+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-13-45.jpg","width":597,"height":510},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Getting started with Exasol &#8211; Setting up an environment"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14745"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14745\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14746"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14745"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}