Getting Started with AWS AMI
You can use the OmniSci AWS AMI (Amazon Web Services Amazon Machine Image) to try OmniSciDB and OmniSci Immerse in the cloud. Perform visual analytics with the included New York Taxi database, or import and explore your own data.
Many options are available when deploying an AWS AMI. These instructions skip to the specific tasks you must perform to deploy a sample environment.
- Prerequisite
- Launching Your Instance
- Using OmniSci Immerse on Your AWS Instance
- Importing Your Own Data
- Accessing Your OmniSci Instance Using SSH
Prerequisite
You need a security key pair when you launch your OmniSci instance. If you do not have one, create one before you continue.
- Go to the EC2 Dashboard.
- Select Key Pairs under Network & Security.
- Click Create Key Pair.
- Enter a name for your key pair. For example,
MyKey
. - Click Create. The key pair PEM file downloads to your local machine. For example, you would find
MyKey.pem
in yourDownloads
directory.
Launching Your Instance
- Go to the AWS Marketplace page for OmniSci Enterprise Edition , or to to OmniSci Enterprise Edition (BYOL) if you have an OmniSci license. You can get overview information about the product, see pricing, and get usage and support information.
- Click Continue to Subscribe to subscribe.
- Read the Terms and Conditions, and then click Continue to Configuration.
- Select the Fulfillment Option, Software Version, and Region.
- Click Continue to Launch.
- On the Launch this software page, select Launch through EC2, and then click Launch.
- From the Choose and Instance Type page, select an available EC2 instance type, and click Review and Launch.
- Review the instance launch details, and click Launch.
- Select a key pair, or click Create a key pair to create a new key pair and download it, and then click Launch Instances.
- On the Launch Status page, click the instance name to see it on your EC2 Dashboard Instances page.
Using OmniSci Immerse on Your AWS Instance
To connect to OmniSci Immerse, you need your Public IP address and Instance ID for the instance you created. You can find these values on the Description tab for your instance.
To connect to OmniSci Immerse:
- Point your Internet browser to the public IP address for your instance, on port 6273. For example, for public IP
54.83.211.182
, you would use the URLhttps://54.83.211.182:6273
. - If you receive an error message stating that the connection is not private, follow the prompts onscreen to click through to the unsecured website. To secure your site, see Tips for Securing Your EC2 Instance.
- Enter the USERNAME (mapd), PASSWORD ( {Instance ID} ), and DATABASE (mapd). If you are using the BYOL version, enter you license key in the key field and click Apply.
- Click Connect.
- On the Dashboards page, click NYC Taxi Rides. Explore and filter the chart information on the NYC Taxis Dashboard.
For more information on OmniSci Immerse features, see Introduction to OmniSci Immerse.
Importing Your Own Data
Working with your own familiar dataset makes it easier to see the advantages of OmniSci processing speed and data visualization.
To import your own data to OmniSci Immerse:
- Export your data from your current datastore as a comma-separated value (CSV) or tab-separated value (TSV) file. OmniSci supports Latin-1 ASCII format and UTF-8. If you want to load data with another encoding (for example, UTF-16), convert the data to UTF-8 before loading it to OmniSci.
- Point your Internet browser to the public IP address for your instance, on port 6273. For example, for public IP
54.83.211.182
, you would use the URLhttps://54.83.211.182:6273
. - Enter the USERNAME (mapd) and PASSWORD ( {instance ID} ). If you are using the BYOL version, enter you license key in the key field and click Apply.
- Click Connect.
- Click Data Manager, and then click Import Data.
- Drag your data file onto the table importer page, or use the directory selector.
- Click Import Files.
- Verify the column names and datatypes. Edit them if needed.
- Enter a Name for your table.
- Click Save Table.
- Click Connect to Table.
- On the New Dashboard page, click Add Chart.
- Choose a chart type.
- Add dimensions and measures as required.
- Click Apply.
- Enter a Name for your dashboard.
- Click Save.
For more information, see Loading Data.
Accessing Your OmniSci Instance Using SSH
Follow these instructions to connect to your instance using SSH from MacOS or Linux. For information on connecting from Windows, see Connecting to Your Linux Instance from Windows Using PuTTY.
Open a terminal window.
Locate your private key file (for example, MyKey.pem). The wizard automatically detects the key you used to launch the instance.
Your key must not be publicly viewable for SSH to work. Use this command to change permissions, if needed:
chmod 400 MyKey.pem
-
Connect to your instance using its Public DNS. The default user name is
centos
orubuntu
, depending on the version you are using. For example:ssh -i MyKey.pem centos@ec2-12-345-678-901.us-west-2.compute.amazonaws.com
-
Use the following command to run the
omnisql
SQL command-line utility on OmniSciDB. The default user ismapd
and the default password isHyperInteractive
:$OMNISCI_PATH/bin/omnisql
For more information, see omnisql.