There are various options for database access for your research and class needs:
- MySQL - We offer MySQL database access for SoIC students, faculty, and staff for class and research use as well as for production school-wide projects. To request a database, please contact us and include the following information in your request:
- Expected maximum size of your database
- Expected project duration
- Course number or sponsoring faculty member. If this isn't for a SoIC course and isn't work for which you have a faculty sponsor, please just briefly explain the nature of your project.
Preferred database name (we will create the database and the mysql account using this same name). If this is for a class project, we have a standard naming convention based on the course number and semester so you do not need to provide a database name. Please note that the database name must not exceed 16 alphanumeric characters.
We will create the database and send you the access information, including an initial password that you should change. You will also have access to your databases using PhpMyAdmin via the URL http://phpmyadmin.soic.indiana.edu/soic-phpmyadmin/ where you will need to log in using your mysql account username and password, NOT your IU username and passphrase. Please also note that access to phpMyAdmin is limited to hosts in the indiana.edu and iu.edu domains. If you need to connect from outside of IU, we recommend that you use the IU VPN to get an IU IP address.
Please note that UITS also offers MySQL database access via the Research Database Complex (RDC).
Please be aware that UITS blocks the mysql port (3306) at the border routers so you will not be able to reach the SoIC mysql server from a non-IU IP address. If you need remote access, you will need to use the VPN to get an IU IP address.
Furthermore, UITS also blocks the mysql port (3306) for students using the IU Secure wireless network. If you are using IU Secure and need to make mysql connections, please see At IUB and IUPUI, how can students have direct network access to databases and/or remote desktop?
- Oracle - We do not support Oracle but UITS does provide access to Oracle database via the Research Database Complex (RDC) for instructional purposes. See the associated KB article for details on getting accounts for instructional use. If this does not meet your needs, then contact us if you would like assistance with installing Oracle on a local system that you will manage.
- MS SQL - We do not support Microsoft SQL but UITS does provide access to MS SQL Server for instructional purposes. See Microsoft SQL Server (and IIS) Accounts for Classes at IU for details. If this does not meet your needs, then contact us if you would like assistance with installing MS SQL Server on a local system that you will manage.
- PostgreSQL - ILS maintains two PostgreSQL installations.
- db.ils.indiana.edu is for general coursework and student projects Accounts for (db.ils.indiana.edu) can be requested by faculty, staff, or grad students in SOIC.
- Recall.ils.indiana.edu is for research projects that consist of larger datasets and which require an environment with less competition for CPU and memory resources. Accounts for (recall.ils.indiana.edu) can be requested by SOIC faculty. Request for recall accounts will require consultation with IT staff to ensure that various projects that might be active can coexist. After consultation, various parameters may be re-tuned by IT staff to maximize performance for (a) particular project(s).
- Requests should include all the information described in the MySQL section above. In addition, the IP address of the workstation(s) or server(s) that need access should be provided. The ILS PostgreSQL servers accept connections only from a known list of IP addresses and on port 5433 using ssl/tls.
- Course work via the psql command line can be used via iris.ils.indiana.edu or any other IU workstation with the postrgresql client package installed.
- Other tools like AquaDataStudio can also be used to access postgresql.