Software 101 – Database Part 2

1. Open up SQLQuery

2. Run ‘User_Info_ByEmail’ query:

• exec [Support].[GlobalBASearch_ByEmail] ‘test@predictiveindex.com’

3. Locate the UserID in the results

4. Open Salesforce

5. Navigate to user’s company

6. Select ‘API Requests’ located in the Quick Links box

7. Select the most recent API Request for that user

8. Locate the APIUserID – copy it

9. Using the APIUserID execute the following stored procedure in SQL

• exec [Support].[Update_APIUserID] ‘UserID’, ‘APIUserID’