Data Warehouse Management

In HENGSHI 3.0, data warehouse management has been added, allowing customers to reuse HENGSHI's data integration capabilities by opening up the internal data warehouse functions of the HENGSHI system.

The system administrator can open Settings -> Data Warehouse Management to access the data warehouse management page. This page will return system information about the data warehouse in use, including the host address, database, port, username, and password.

Enable Data Warehouse

After turning on Enable Warehouse and clicking Save, users can use the HENGSHI data warehouse in external systems and also create data connections using the HENGSHI data warehouse in HENGSHI SENSE, treating it as a regular database for read and write operations. When creating a connection, the connection type can be selected as either PostgreSQL or Greenplum.

Modify Data Warehouse Password

On the data warehouse management page, you can enter a new password in the Password text box to modify the data warehouse password, which is for easier management of the data warehouse within HENGSHI.

Disable Data Warehouse

After turning off Enable Data Warehouse and clicking Save, even if a data connection has been created using the HENGSHI data warehouse, upon opening it, a message will appear stating "Unable to Connect," and no data will be visible.

Data Warehouse Connection Notes

The host address returned by Data Warehouse Management is controlled by the HS_ENGINE_HOST parameter. For parameter configuration, please refer to Acceleration Engine Configuration. Users must correctly configure this parameter to use the host address returned by the system to connect to the data warehouse after opening it.

If you are unable to connect to the data warehouse using the information returned by the data warehouse at the data connection point, please log in to the host where HENGSHI SENSE is installed and execute the following command to check where the issue lies, replacing <ip> and <port> with the host address and port returned by the data warehouse:

timeout 1 bash -c "cat < /dev/null > /dev/tcp/<ip>/<port>" &> /dev/null; echo $?

If 0 is returned, it indicates that the local connection port is not problematic. Then, execute the following command to check if the local machine can connect to the engine database:

/opt/hengshi/lib/pgsql/bin/psql -Udwguest -h<ip> -p<port> <database>

If connecting to the data warehouse from an external system, you need to check if the port is open:

telnet <ip> <port>