Database Browser

Top  Next

PTSS Company Logo

 

Database Browser

 

Database Browser(1) is a feature available in all our spatial products. It is found in the Data tab(2):

 

DATABA~1_img2

 

It allows you to connect to any database and present a selection of its tables as layers. Clicking on it brings up the following dialogue. Click the Connect button(1) to access the connection menu(2):

 

DATABA~1_img3

 

DATABA~1_img4

 

By Database type click on the dropdown and choose the database type you will be connecting to(1):

 

DATABA~1_img5

 

Below you are asked to put in your credentials(1). If you are using Integrated Security(2) you won’t need to do this you can then just specify the Server(3) and choose the Database(4). You can then test the connection to the database by clicking Test Connection(5), if all good it will let you know(6)(Note: this is how the connection dialogue is for a SQL Server database, for other databases it may vary):

 

DATABA~1_img6

 

DATABA~1_img7

 

Now you can go ahead and click Connect(1):

 

DATABA~1_img8

 

You can now view the data tables and their components. Click on the plus sign(1) to expand a table and view its components(2):

 

DATABA~1_img9

 

DATABA~1_img10

 

By right clicking on a data table you can choose to View Data(1) which will allow you to see the data of that table(2):

 

DATABA~1_img11

 

DATABA~1_img12

 

You can also choose to Add as layer(1), you will then be prompted to choose the projection(2) and your table will be added as a layer in your spatial pane(3):

 

DATABA~1_img13

 

DATABA~1_img14

 

DATABA~1_img15

 

You can also just click and drag any of these tables straight onto the scene or layer control to add it as a layer, as noted at the bottom of the dialogue(1):

 

DATABA~1_img16

 

You can choose as well to Add as data(1) which will add just the data of the table as a non-display layer(2):

 

DATABA~1_img17

 

DATABA~1_img18

 

Once you have added a data table as a layer in your spatial pane you can then create whatever queries you want from the data table in the Data tab of the Layer Properties box of the layer(1)(2):

 

DATABA~1_img19

 

You can manually type the queries(1) in or you can build a query using the Query Builder button(2) which brings up a dialogue box where you can tick on and off which columns you would like from your table(3), these columns are then entered in the grid below(4)(make sure to have the * row(5) ticked off so as not to bring in everything) and the query is built for you(6):

 

DATABA~1_img20

 

DATABA~1_img21

 

When done click Execute(1) to execute the query and see what it brings in, which will be shown in the Query Results box(2). If you are happy then you can exit the results box and then click OK(3):

 

DATABA~1_img22

 

DATABA~1_img23

 

DATABA~1_img24

 

Then you will see your query that has been built for you in the Layer Properties box(4) , click OK(5) and now you can see by viewing the layer data grid that only the columns that you queried are in your layer(6):

 

DATABA~1_img25

 

DATABA~1_img26