HCL OneDB Is Now Available on AWS Marketplace
Enable deeper analytics from the gateway edge to the cloud with high performance, reliability, ease of use, and low cost of ownership.
The Amazon Machine Image (AMI) for HCL OneDB provides all the information required to launch a virtual server instance in the AWS cloud. Simply select the AMI that meets your business needs and launch as many instances as required. HCL OneDB AMI includes the latest versions of: HCL OneDB Products Installation directory HCL OneDB Server /opt/hcl/onedb/server HCL OneDB Mongo(WireListener) /opt/hcl/onedb/apis/mongo HCL OneDB REST /opt/hcl/onedb/apis/rest HCL OneDB Explore /opt/hcl/onedb/explore HCL OneDB CSDK /opt/hcl/onedb/csdk HCL OneDB JDBC /opt/hcl/onedb/jdbc Note: HCL OneDB server, CSDK, JDBC, WireListener, REST and HCL OneDB Explore are installed and configured for OLTP environments. Please contact Lab Services using the “Contact Us” panel for guidance and support. HCL OneDB on AWS is an enterprise-class database offered on the Amazon Web Services (AWS) Cloud. It features a cloud-delivered, ready-to-run, fast, resilient, and scalable database management system that manages traditional relational, object-relational, and dimensional data types. HCL OneDB on AWS offers the complete features of HCL OneDB on-premises deployments without the complexity and risk of managing your own infrastructure. AWS provides an infrastructure to run HCL OneDB in a flexible, scalable, and cost-effective manner in the cloud
HCL OneDB is offered as an hourly Amazon Machine Image (AMI). An AMI is an image applied to compute and memory resources which Amazon calls “EC2”. To place an order in your AWS account, navigate to “Services”, and then “EC2”. Click the “Launch Instance” button.
- 1. Navigate to “AWS Marketplace.”
- 2. Search for “HCL OneDB” and select the latest available version. (Delivery Method is AMI - Amazon Machine Image).
- 3. Click on the Continue to Subscribe button and complete all selections.
- 4. Proceed through the remaining steps to provision a HCL OneDB EC2 instance (virtual machine) on AWS.
- 5. Connect to the virtual machine via a ssh program, using the private key for the keypair specified during your instance provisioning.
- SSH as the user “ubuntu”.
Here’s an example:
- $ ssh -i ~/.ssh/my_aws_private_key ubuntu@hostname-of-my-HCL onedb-ec2
- 6. After you are logged into the virtual machine, use the sudo command to become the user “Informix”.
- Example: $ sudo -u informix bash
As the user Informix, you will be able to run the various HCL OneDB commands, such as onstat, onmode, and oninit. The machine is configured with the HCL OneDB server running and listening to the following client types on the respective ports:
Protocol
Without TLS
With TLS
Installation directory
HCL OneDB Server (SQLI)
9088
9089
/opt/hcl/onedb/server
HCL OneDB Mongo(WireListener)
27001
27002
/opt/hcl/onedb/apis/mongo
HCL OneDB REST
26001
26001
/opt/hcl/onedb/apis/rest
HCL OneDB Explore Server
28001
28002
/opt/hcl/onedb/explore
To control the network traffic on the EC2 instance (to and from), it is preferable to use the Amazon “Security Group”, instead of an OS-based firewall configuration.
For security reasons, the OS (Operating Systems) accounts on the AMI do not have a password, and the only account initially configured for inbound SSH is “ubuntu”. To allow a remote client to connect to the HCL OneDB database server you can set a password on the desired OS account or create a database user via the CREATE USER STATEMENT.
HCL OneDB AMI can be ordered in all AWS regions and on all EC2 types. Since EC2 types have varying amounts of CPU and memory, several types and amounts of storage may be added to an EC2, tuning the HCL OneDB Server to meet your needs (E.g., altering the number of CPU VPs, increasing the size of the buffer-pool, adding dbspaces on the desired storage devices).
To connect a remote client to HCL OneDB, first ensure the AWS Security Group permits traffic on the appropriate ports. To encrypt communication between the client and server, configure the client for TLS by following these guidelines:
- Client TLS setup for a JDBC application: https://help.hcltechsw.com/onedb/2.0.0.0/jdbc/ids_jdbc_490.html
- Client TLS setup for a SQLI application: https://help.hcltechsw.com/onedb/2.0.0.0/sec/ids_ssl_003.html
- Client TLS setup for a WireListener(Mongo) application: https://docs.mongodb.com/manual/tutorial/configure-ssl/
- Client TLS setup for a REST application: https://help.hcltechsw.com/onedb/2.0.0.0/rest/rest.html
HCL OneDB certificate is located at /home/Informix/client_ssl/selfsigned_ssl.cert. For security reasons this certificate should be changed immediately to a certificate you control.
- Instructions to configure HCL OneDB:https://help.hcltechsw.com/onedb/2.0.0.0/sec/ids_ssl_002.html
- Instructions to configure the WireListener(Mongo):https://help.hcltechsw.com/onedb/2.0.0.0/json/ids_json_076.html
HCL OneDBExplore is a web-based monitoring and administration tool for DBAs and developers which by default will already be configured, up and running. The Explore Server and Agent processes run as the OS user "HCL onedbexpu".
- From inside your provisioned instance, open a browser and connect to Explore.
- If you prefer to access HCL OneDB Explore from a remote host, first ensure that the AWS Security Group permits the traffic, and then use a browser to connect to https:// (your EC2 instance IP address) :28002.
- Details about the initial credentials can be found in the /opt/hcl/onedb/explore/explore/informixhq-server.properties file. This is a text file and can be viewed using the UNIX “cat” command. Please refer to: Starting HCL OneDB Explore Server
- To change the password for the “Explore server admin”, log into Explore as user “admin” and then navigate to the “User Settings” area.
Please refer to: HCL OneDB Explore Server – User Settings
HCL OneDB is offered as an hourly Amazon Machine Image (AMI). An AMI is an image applied to compute and memory resources which Amazon calls “EC2”. To place an order in your AWS account, navigate to “Services”, and then “EC2”. Click the “Launch Instance” button.
- 1. Navigate to “AWS Marketplace.”
- 2. Search for “HCL OneDB” and select the latest available version. (Delivery Method is AMI - Amazon Machine Image).
- 3. Click on the Continue to Subscribe button and complete all selections.
- 4. Proceed through the remaining steps to provision a HCL OneDB EC2 instance (virtual machine) on AWS.
- 5. Connect to the virtual machine via a ssh program, using the private key for the keypair specified during your instance provisioning.
- SSH as the user “ubuntu”.
Here’s an example: - $ ssh -i ~/.ssh/my_aws_private_key ubuntu@hostname-of-my-HCL onedb-ec2
- 6. After you are logged into the virtual machine, use the sudo command to become the user “Informix”.
- Example: $ sudo -u informix bash
As the user Informix, you will be able to run the various HCL OneDB commands, such as onstat, onmode, and oninit. The machine is configured with the HCL OneDB server running and listening to the following client types on the respective ports:
|
Protocol |
Without TLS |
With TLS |
Installation directory |
|
HCL OneDB Server (SQLI) |
9088 |
9089 |
/opt/hcl/onedb/server |
|
HCL OneDB Mongo(WireListener) |
27001 |
27002 |
/opt/hcl/onedb/apis/mongo |
|
HCL OneDB REST |
26001 |
26001 |
/opt/hcl/onedb/apis/rest |
|
HCL OneDB Explore Server |
28001 |
28002 |
/opt/hcl/onedb/explore |
To control the network traffic on the EC2 instance (to and from), it is preferable to use the Amazon “Security Group”, instead of an OS-based firewall configuration.
For security reasons, the OS (Operating Systems) accounts on the AMI do not have a password, and the only account initially configured for inbound SSH is “ubuntu”. To allow a remote client to connect to the HCL OneDB database server you can set a password on the desired OS account or create a database user via the CREATE USER STATEMENT.
HCL OneDB AMI can be ordered in all AWS regions and on all EC2 types. Since EC2 types have varying amounts of CPU and memory, several types and amounts of storage may be added to an EC2, tuning the HCL OneDB Server to meet your needs (E.g., altering the number of CPU VPs, increasing the size of the buffer-pool, adding dbspaces on the desired storage devices).
To connect a remote client to HCL OneDB, first ensure the AWS Security Group permits traffic on the appropriate ports. To encrypt communication between the client and server, configure the client for TLS by following these guidelines:
- Client TLS setup for a JDBC application: https://help.hcltechsw.com/onedb/2.0.0.0/jdbc/ids_jdbc_490.html
- Client TLS setup for a SQLI application: https://help.hcltechsw.com/onedb/2.0.0.0/sec/ids_ssl_003.html
- Client TLS setup for a WireListener(Mongo) application: https://docs.mongodb.com/manual/tutorial/configure-ssl/
- Client TLS setup for a REST application: https://help.hcltechsw.com/onedb/2.0.0.0/rest/rest.html
HCL OneDB certificate is located at /home/Informix/client_ssl/selfsigned_ssl.cert. For security reasons this certificate should be changed immediately to a certificate you control.
- Instructions to configure HCL OneDB:https://help.hcltechsw.com/onedb/2.0.0.0/sec/ids_ssl_002.html
- Instructions to configure the WireListener(Mongo):https://help.hcltechsw.com/onedb/2.0.0.0/json/ids_json_076.html
HCL OneDBExplore is a web-based monitoring and administration tool for DBAs and developers which by default will already be configured, up and running. The Explore Server and Agent processes run as the OS user "HCL onedbexpu".
- From inside your provisioned instance, open a browser and connect to Explore.
- If you prefer to access HCL OneDB Explore from a remote host, first ensure that the AWS Security Group permits the traffic, and then use a browser to connect to https:// (your EC2 instance IP address) :28002.
- Details about the initial credentials can be found in the /opt/hcl/onedb/explore/explore/informixhq-server.properties file. This is a text file and can be viewed using the UNIX “cat” command. Please refer to: Starting HCL OneDB Explore Server
- To change the password for the “Explore server admin”, log into Explore as user “admin” and then navigate to the “User Settings” area.
Please refer to: HCL OneDB Explore Server – User Settings
HCL OneDB is initially configured to interact with clients using the SQLI, Mongo, and REST protocols and to run with a small buffer pool on a single CPU VP. If you have ordered a larger EC2 type and want to get more power from HCL OneDB please consider increasing the number of CPU VPs as well as the buffer pool.
Lab Services
PRIORITY SUPPORT SERVICES
Priority handling of *HCL OneDB support issues above and beyond the standard support process on a monthly subscription basis.
PREMIUM ADVISORY SERVICES
Premium Advisory Services provides onsite and online advisory services to customers and partners on time and material (T&M) basis to get optimal utilization and throughput from your HCL OneDB environment.
DEPLOYMENT ACCELERATION
Deployment Acceleration helps you deploy your solution quicker by providing assistance in training, up and running, configuration, design and implementation of your solution.
PARTNER ACCELERATION
Lab Services enables partner applications, compliments partner offerings, and provides priority support to promote growth and make our partners more successful. Joint asset programs and joint GTM programs provide incentives for solution providers to address specific use case scenarios with a holistic solution stack. This accelerates design, development, and deployment of industry solutions using HCL OneDB.
ENABLEMENT
HCL provides many enablement services that includes but is not limited to training, certification, boot camps, Proof of Concepts (PoC), and Proof of Technology (PoT) engagements for customers, ISV partners, business partners, and IoT partners alike. We also provide unique training and certification for partners registered with the HCL OneDB referral program.
HA DESIGN AND CLOUD BACKUP
HA design and cloud backup service includes the design, implementation, and setup of High Availability (HA) and disaster recovery solutions in the cloud or for on-premise HCL OneDB database instances. Service also includes the architectural design, implementation, and setup of the Amazon S3 storage environment, enabling cost effective backup solutions that leverage HCL OneDB’s ability to back-up directly to the cloud.
FAQs
Support
The HCL Support organization has expertise to provide you with quality responsive software support. We can help maximize the value of your software investment by providing comprehensive technical support and updates for software products. Find the latest information on products and servers, submitting tickets, and joining communities on our support portal.
