| |
To avoid computer connectivity problems, please use the System DNS host name
when configuring computers.
The host name of the server is: 128.118.75.73
Installation and Setup to the FISDataMart
The first time you access the FISDataMart, you’ll need to follow
these steps:
- Open MS Access, select a blank database.
Click on OK.
- Name the database. Click on Create.
- Go to file pull down, Get External Data, select Link
Tables…
- Change Files of Type to ODBC Databases().
- In the ODBC Data Source Administrator change tab to System DSN , select the Add... button.
- At the Create New Data Source, select SQL Server driver,
click on Finish.
- At the Create New Data Source to SQL Server, fill in the following for:
Name: FISDataMart
Description: Corporate Controller Data Warehouse
Server:
128.118.75.73
Select
Next.
- At the ‘How should SQL
server verify the authenticity of the login ID?' -- leave it at the default selection: ' With Windows NT authentication using the network login ID'.
Select Next.
- At the next dialog box, the default selections are
fine.
- Change the default databases to: verify it is 'FISDataMart'
- Attach database file name - Unchecked
- Create temporary stored procedures - Checked
- Use ANSI quoted identifiers - Checked
- Use ANSI nulls… - Checked
- Use the fail over SQL server … - Unchecked
Click on Next.
- At the next dialog box, the default selections are
fine.
- Change the language of SQL Server system message to. - Unchecked
- Perform translation for character data - Checked
- Use regional settings when outputting currency, numbers, dates and
times - Unchecked
- Save long running queries to the log file - Unchecked
- Log ODBC driver statistics to the log file –
Unchecked
Click on Finish. (You can test
connectivity to the data source by clicking on the Test Data Source
button.)
- At the next dialog box, select OK.
- At the ODBC Data Source Administrator dialog box, select
FISDataMart.
- At the next dialog box, select the desired tables from the database.
|
|
