Software 101 – Database Part 1
Getting Started
Welcome to the Database, also known as SQL/Azure Data Studio. This is where all client data is housed. Access to client data is restricted. Clients and Partners do not have access to this platform. Only PI engineers and the User Operations team have access to this information.
Azure Data Studio should already be downloaded onto your computer. If you do not have it contact IT to have it installed before moving on.
Connect to a SQL Server
1. Start Azure Data Studio
2. The first time you run Azure Data Studio the Welcome page should open. If you don’t see the Welcome page, select Help > Welcome. Select New Connection to open the Connection pane:
3. Fill in the fields as follows:
- Server Name: accesspi-prd-server.database.windows.net
- Authentication Type: SQL Login
- User name: email without @predictiveindex.com
- Password: PI email password
- Database Name: AccessPi-Prd
- Server Group: <Default>
- Name: AccessPi-Prd