The HFSQL (HyperFileSQL) server

The CLOUD for PC SOFT applications allows you to benefit from the HFSQL server to share databases anywhere in the world, from any application (iOS, Android, Site, Desktop, ...)


Note: From version 19, HFSQL is the new name for HyperFileSQL.


Regarding the update of the HFSQL server, see the guide Updating the HFSQL server.


In this guide, let's see how to manage the databases deployed on the platform.

2 possibilities: 

- use the HFSQL Control Center,

- use the remote HFSQL administrator 



Using the HFSQL Control Center


You must have:

- the identifier 

- and the password of the PCSCloud account.

The identifier and password have been supplied in the confirmation email when creating the PCSCloud account. 


Connect yourself to the CLOUD dashboard, at the following address: https://pcscloud.net/.


Enable the remote HFSQL access, if not already done.

Then, click the "Management information" link.




Write:

- the address of your platform (at the top, in the "Access your platform" section)

- the user name and password of the HFSQL server (at the bottom, in the "Management of HFSQL server" section). 


These parameters allow you to connect to the HFSQL server of the platform from the HFSQL Control Center.

All you have to do is enter the address of the platform, the user name and the password.




Using the remote HFSQL administrator


You must have:

- the identifier 

- and the password of the PCSCloud account.

The identifier and password have been supplied in the confirmation email when creating the PCSCloud account. 


Connect yourself to the CLOUD dashboard, at the following address: https://pcscloud.net/.


In the list of platforms at the top, click the platform (for PC SOFT applications) that must be managed.


Further down, in the "Management" section, click "HFSQL administrator".





- You can now access the settings and the management of the databases deployed on the platform.

From the remote HFSQL administrator, you can:

- list, create and delete databases,

- configure the users, the groups and the rights,

- access the server configuration,

- manage the backups,

- manage the scheduled tasks, ...


For more details about the remote HFSQL administrator, click here to access its online documentation.