Click on Connect to data source, to see the Data Connectivity window:

In order to connect to data from the PostgreSQL database, proceed as follows.

Select the data source as Postgres:

Enter the connection string for the PostgreSQL database, and the PostgreSQL user/password.

In the Advanced section, remove the limit of the number of records in the Space:

Press Next and the Persons table will display:

Click on each item to see the relevant instructions.

1. Connect to the Database	Next : 2. Deploy GigaSpaces	3. View the Services
4. View the Spaces	5. View the Object Types	6. Perform SQL Operations on the Object Data

Click on Deploy, then choose the Automatic deployment method:

A screen will display indicating that the deployment process is underway:

When the deployment is successful, the following message will appear:

On the side menu, click on the Services tab:

This will display the services that were created as a result of the deployment:

Click on the Spaces tab:

to see the Spaces created by the deployment:

Click on the demo Space to see details of the Space object:

5. View the Object Types

Scroll down the page to see the list of Object types in the space. In this example, there is one Object, the Persons Object. This Object corresponds to the Persons table that we created in PostgreSQL, and appears as follows:

Click on the Persons object:

and detailed information about the Persons object will display:

Click on the SQL Editor tab to see the default the SQL command:

To make it more interesting, modify the command as follows:

SELECT * FROM "com.mycompany.app.model.Persons" order by personId LIMIT 5000
 

 

Click on Run Query to see the query results: