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. OneDB AMI includes the latest versions of: OneDB Products Installation directory OneDB Server /opt/hcl/onedb/server OneDB Mongo(WireListener) /opt/hcl/onedb/apis/mongo OneDB REST /opt/hcl/onedb/apis/rest OneDB Explore /opt/hcl/onedb/explore OneDB CSDK /opt/hcl/onedb/csdk OneDB JDBC /opt/hcl/onedb/jdbc Note: HCL OneDB server, CSDK, JDBC, WireListener, REST and 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 OneDB on-premises deployments without the complexity and risk of managing your own infrastructure. AWS provides an infrastructure to run 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 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-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 OneDB commands, such as onstat, onmode, and oninit. The machine is configured with the OneDB server running and listening to the following client types on the respective ports:
Protocol
Without TLS
With TLS
Installation directory
OneDB Server (SQLI)
9088
9089
/opt/hcl/onedb/server
OneDB Mongo(WireListener)
27001
27002
/opt/hcl/onedb/apis/mongo
OneDB REST
26001
26001
/opt/hcl/onedb/apis/rest
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 OneDB database server you can set a password on the desired OS account or create a database user via the CREATE USER STATEMENT.
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 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 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
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 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
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 "onedbexpu".
- From inside your provisioned instance, open a browser and connect to Explore at https://127.0.0.1:28002
- If you prefer to access 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 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: 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 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-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 OneDB commands, such as onstat, onmode, and oninit. The machine is configured with the OneDB server running and listening to the following client types on the respective ports:
|
Protocol |
Without TLS |
With TLS |
Installation directory |
|
OneDB Server (SQLI) |
9088 |
9089 |
/opt/hcl/onedb/server |
|
OneDB Mongo(WireListener) |
27001 |
27002 |
/opt/hcl/onedb/apis/mongo |
|
OneDB REST |
26001 |
26001 |
/opt/hcl/onedb/apis/rest |
|
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 OneDB database server you can set a password on the desired OS account or create a database user via the CREATE USER STATEMENT.
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 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 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
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 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
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 "onedbexpu".
- From inside your provisioned instance, open a browser and connect to Explore at https://127.0.0.1:28002
- If you prefer to access 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 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: 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 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 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 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 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 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.
