Database Reference
In-Depth Information
1.
In SQL Azure database, create a table with the following
columns and name the table 'EmployeeBudgetInfo,' as shown
in Table
A-1
and Figure
A-3
.
Table A-1.
SQL Azure database design
Column
Data Type
ID
Int
Employee Name
Nvarchar (100)
Year
Int
Budget
Money
Spent
Money
Email Address
Nvarchar (250)
Profile
Nvarchar (250)
Figure A-3.
SQL Azure database table columns
2.
Open the SharePoint Online Admin site and click on Secure
Store link, as shown in Figure
A-4
. Enter Target Application
Settings, Application ID, Display Name, Contact Email, and
Target Application Type. Leave the credential fields to default
and enter the target application administrator.