OIT: How to Connect to Secure Databases Hosted by FileMaker
Several databases hosted by FileMaker contain secure data. This data must be treated as highly confidential and requires additional security precautions. Due to this you may be required to establish a secure connection before being able to access these systems.
METHOD 1: VPN
- Open BIG-IP Edge Client by searching for it in the start menu:
- Click the F5 icon in the bottom right taskbar:
- Click Connect
- Enter login details when requested. You will need to authenticate using DUO mobile. If login window doesn’t show up click the F5 icon again and click “Main Console...”
- Once your session is connected the F5 icon in the taskbar will turn red and stop flashing
- Open FileMaker Pro and select your database (you may need to follow the One-time FileMaker Pro setup instructions that follow if you don’t see your database)
METHOD 2: FileMaker Restricted
Some databases do not permit connections even over VPN and require that you connect to a remote terminal server. Only follow these steps if the VPN method does not work or you are instructed to use this method as standard practice.
If you have recently refreshed your RemoteApp feed you can skip to step 5
- Right click the RemoteApp and Desktop Connections icon in the taskbar:
- Click Open RemoteApp and Desktop Connections
- Next to Most Recent Update, click View Details
- Click Update Now and wait for the update to complete
- Search using the Start Menu for FileMaker Secure (Brown RemoteApps)
- Click Connect if prompted
- If the log-in is successful you will see the DUO authentication window appear:
- Authenticate as you wish and wait until your remote terminal desktop loads
- You can access the secure version of FileMaker Pro Advanced 17 by double clicking the item on your desktop
- You may need to reconfigure this version of FileMaker with your desired server by using the One-time FileMaker Pro Advanced 17 setup instructions that follow
TIPS:
You can use the blue bar at the top of the screen to minimize your remote session and return to your regular desktop
When finished with your remote terminal session log out by using the start menu as you normally would on your own computer (this will also disconnect your session)
Only use the remote terminal server for FileMaker access. Do all other work on your regular desktop to free up resources for other connections and minimize security risks on the remote terminal.
Set up FileMaker Pro (One time)
- Open FileMaker Pro
- Click Add App under My Apps and select “From Hosts…”
- Click the small + icon in the top left
- Enter the relevant URL (see below) for the Host’s Internet Address and click OK
- The databases you are authorized to use will display automatically (if you are prompted to log-in enter your AD credentials)
Database Name | Database Description | URL |
CIS-ServiceRepair | Service & Repair transaction system | FileMakerB.ad.brown.edu |
iClicker_2_0 | IT Service Center iClicker transaction database | |
CIS_HelpDeskWaivers | IT Service Center advanced tech support waiver forms | |
CIS-Inventory | Internal CIS inventory tracking system | |
CIS_Loaner_Equipment_Database | IT Service Center Loaner Equipment transaction system | FileMakerF.ad.brown.edu |