|
|
| Line 1: |
Line 1: |
| − | = Connecting to the e-Ecology database via Access or other relational database programs=
| + | Disregard: I created this page by mistake and now cannot delete - Stacy Feb 2018 |
| − | Stacy Shinneman, Updated: February 2018; Judy Shamoun-Baranes / Bart Heupers, Updated: July 28, 2014
| |
| − | | |
| − | =General Information=
| |
| − | | |
| − | The e-Ecology database is a spatial postgreSQL ([http://www.postgresql.org/-http://www.postgresql.org/]). Before 2018, it was also referred to as the FlySafe database.
| |
| − | | |
| − | PgAdmin III or IV can be used to browse and query data. If you use pgAdmin you do not need to set up an ODBC connection.
| |
| − | | |
| − | The database can also be called from other programs by installing an ODBC driver for postgreSQL and establishing a "User Data Source" [http://www.postgresql.org/ftp/odbc/versions/msi/-http://www.postgresql.org/ftp/odbc/versions/msi/].
| |
| − | | |
| − | In order to access the database, you should send your IP address to uva-bits@uva.nl who will provide a user name and password. For organizations an IP range can also be given.
| |
| − | | |
| − | The e-Ecology server which is accessible to the UvA-BiTS community is at:
| |
| − | | |
| − | Server: pubserv.e-ecology.nl
| |
| − | Port: 5432
| |
| − | SSL: required
| |
| − | | |
| − | To set up a new connection to the e-Ecology database via '''pgAdmin III''', go to create New Server Registration and fill in the information below. To set up a connection in '''PgAdmin version 4''', click Add New Server and then enter the information on the General, Connection and SSL tabs.
| |
| − | | |
| − | '''Under the Properties tab'''
| |
| − | Name: e-Ecology
| |
| − | Host: pubserv.e-ecology.nl
| |
| − | Port: 5432
| |
| − | Maintenance DB: eecology
| |
| − | Username: <your user name>
| |
| − | Password: <your password>
| |
| − |
| |
| − | '''Under the SSL tab'''
| |
| − | SSL: required
| |
| − |
| |
| − | Restricted e-Ecology server information:
| |
| − | | |
| − | Server : db.e-ecology.sara.nl
| |
| − | Port : 5432
| |
| − | SSL: required
| |
| − | | |
| − | The tracking data can be found in the schema '''gps'''. However, these instructions can be used to access any of the data included in the e-Ecology database.
| |
| − | | |
| − | =Setting up an ODBC connection=
| |
| − | | |
| − | ODBC (Open Database connectivity) is a standard method of sharing data between databases and other programs. ODBC drivers use SQL to gain access to data from sources outside the program. Therefore, in order to connect between your database and other programs you must set up an ODBC connection.
| |
| − | Step 1: Download and install an ODBC driver for postgreSQL.
| |
| − | [http://www.postgresql.org/ftp/odbc/versions/msi/-http://www.postgresql.org/ftp/odbc/versions/msi/]
| |
| − | Step 2: Set up ODBC connection
| |
| − | | |
| − | | |
| − | Do the following:
| |
| − | # go to '''start | Control panel | Administrative tools | Data sources (ODBC)'''
| |
| − | # go to '''User DSN''' (first tab in Data sources)
| |
| − | # click '''ADD'''
| |
| − | # in window '''create''' '''new data source''' select '''PostgreSQL ANSI''' click '''FINISH'''
| |
| − | # The '''ODBC Driver setup''' window opens. '''Data source name''': give your data source a name (eg GPS). Keep it simple, easily identifiable, this is the name you will use to identify your database from other applications, this will be the '''ODBC driver name'''.
| |
| − | # In the same window fill in the following information: '''database''' ''eecology'', '''Server''' ''public.e-ecology.sara.nl'', '''User Name''' your user name, '''SSL Mode''' ''require'', '''Port''' ''5432'', '''Password''' your password. When the window is completed click '''SAVE'''
| |
| − | # Back in the '''User DSN''' window you should now see your ODBC driver you just named, click '''OK'''
| |
| − | After completing these steps many other programs will now recognize your database and be able to communicate with it
| |
| − | | |
| − | =Connecting to Access=
| |
| − | You can now connect to the database via access. You have two options. One is to import the data, once this is done your database is not automatically updated but does not require a link to the database.
| |
| − | | |
| − | The second option (described below) is to create a dynamic link to the database (you must be connected to the network) in this case you are always viewing data that is in the actual SARA database.
| |
| − | | |
| − | # Open a new database in Access
| |
| − | # go to '''file | Get external data | Link tables'''
| |
| − | # in '''files of type''' select '''ODBC databases'''
| |
| − | # in '''select data source''' click on tab '''Machine Data Source'''
| |
| − | # select the data source name you created when setting up the ODBC connection (eg GPS) click '''OK'''
| |
| − | # Select the tables you want to import click OK
| |
| − | | |
| − | You now have access to your selected tables in the database. Have fun.
| |
| − | | |
| − | | |
| − | Original document [[ Media:Connect_flysafe.doc ]]
| |
