Installation and Setup to the FISDATAMART for SQL Server ...

INSTALLATION AND SETUP TO THE FISDATAMART FOR SQL SERVER AUTHENTICATION

The first time you access the FISDataMart, you'll need to follow these steps: 1. Open MS Access, select a blank database, give File Name and Click on Create

2. Go to External Data, select New Data Source, Select From other sources and select ODBC Database

3. In Get External Data ? ODBC Database screen, Select Link to the data source by creating a linked table.

~

~

Table Tools

szk_420. Database \\Nasf1ss 101\users\szk420\My Documents\sz

File

Home Create

Q Database Tools Help Fields Table

Tell me what you want to do

l':"':',1. Saved Im Get Externa l Data - ODBC Dat abase

X

N ew Data Source?

Impo rt & Link

All Access ... 0

Search...

T ables

l!J Table l

Select the source and destination of the data

Spe cify how and where you wa nt to st ore the data in the current database.

0 !mport the source data into a new table in the current database.

If the specified object does not exist. Access will create it. lf the specified object a lready e xists, Acce ss will append a number to the name of the imported object. Cha nges ma de to source obje cts (including data in tab les} will not b e reflected in the current database.

@ !1,_ink_to _the da_ta ,urc:e: 1:,y c:reat_in51_ a l_in k_ed _table .! Access wilt create a table tha t wilt maintain a link to the source da ta.

OK

Cancel

4. In the next pop window which is Select Data Source screen, select Machine Data Source and select New

~

;

Table Tools

szk_420: Database- \\Nasf1s

File

Home Create

Q Database Tools Help Fields Table

Tell me what you want to

~

Select Data Source

X

New Data Source?

File Data Source Machine Data Source

IAIIAo

Search...

Tables

EEi TablE

Data Source Name dBASE Files Excel Files FIS fisdatamart FISDataMartl fisdatamart_production FISDataMart_SZKODBC

<

Type User User User User User User User

Description

GURU Corporate Controller Data Warehouse Corporate Controller Data Warehouse "

>

A Machine Data Source is specific to this machine. and cannot be shared. "User" data sources are specific to a user on this machine. "System" data sources can be used by all users on this machine. or by a system-wide service.

OK

Cancel

Help

II

5. In Create New Data Source screen, Make sure User Data Source is selected and click select Next

~

;

File

Home Create

~

New Oat Create N ew Data Source Source?

All A

Search. .. Tables [:) Ta

Table Tools

szk_420: Database- W

Q Database Tools Help Fields Table

Tell me what you

X

Select a type of data source: @User Data Source (Applies to this machine only)

0 System Data Source (Applies to this machine only)

Selecting User Data Source creates a data source which is specific to this machine. and visible only to you.

R,..

Next>

Cancel

6. In Create New Data Source screen, Select SQL Server Native Client 10.0 (Note: Alternative option would be SQL Server if, you do not have SQL Server Native Client 10.0) Click Next

~

;

File

Home Create

q

New Dat Create New Dat a Source Sou r ce ?

All A

search...

Tables

EIE Ta

Table Tools

szk_420 : Database- \ \Nasf iss-101

Database Tools Help Fields Table Q Tell me what you want to do

X

Select a driver for which you want to set up a data source

Name Microsoft Paradox Driver ('.db) Microsoft Paradox-Treiber ('.db) Microsoft Text Driver ('.bct ?.csv) Microsoft Text-Treiber (' .bct ?.csv) 0 DBC Driver 11 for SOL Server SOL Server SOL Server Nabve Chen! 10 0 SOL Server Native Client 11.0

<

Versie I\

1000 1000 1000 10.00. 2014.1 10.00 2009.1 2011.1 V

>

7. Verify that User Data Source Driver: SQL Server, Select Finish

i;;i

?

File Home Create

re

New Oat Create New Data Source Source -

All A

search. ..

Tables

!m Ta

Table Tools

szk_420. Database- \\Nasfiss-101

Database Tools Help Fields Table Q Tell me what you want to do

X

W hen you click Finish. you will create the data source which you have just configured. The driver may prompt you for more information

User Data Source Driver: SOL Server Native Cli ent 10.0

V

<

>

8. In Create a New Data Source to SQL Server screen i. Name: FISDataMart ii. Description: Corporate Controller Data Warehouse iii. Server: 128.118.75.84 **Note: Select Next.

i;;i

?

Table Tools

szk_420: Database-\\Nasfiss-101

File Home Create

Database Tools Help Fields Table Q Tell me what you want to do

...,

- rr Create a New Data Source t: Ql: e r -

lI New Data

X

Sourc~

[All Ac<

'

This wizard will help you create a n ODBC data source that you can use to connect to SOL Server.

What name d o you wantto use to refer to the data source ?

~ rch...

Name: IFISDaiaMart_szk_42o/

Tables

l:i:1J Table

How do youwant to describe lhe data source? Description: !Corporate Controller Dala W arehouse

Which SOL S erver do y ou wantto connectto? Servec 1128.118.75.84

F inish

Next >

~ ancel

L Help

II

9. At the `How should SQL server verify the authenticity of the login ID?' ? Select : 'With SQL Server authentication using a login ID and password entered'. (Note: second option)

Enter LoginID and Password that we have been received from email by FIS Personal, Select Next

~

;

Table Tools

szk_420 : Database- \\Nasfiss-101\u

File

~

Home

-

Create

Database Tools

~ Creat e a N ew Data Source to SQL Server

N ew Data

Help Fields

0

Table

Source -

> I

How should SQL Server verify the authenticity of the login ID?

All Ace !;QtServer20:l!R2

Q W ith Integrated W indows authentication.

Q Tell me what you want to do

X

Search...

SPN (Optional)

Tables

~ Table

@ With SQL Server authentication using a login ID and password entered

by the user.

I Login ID: szk_420

I

Password: I??????????I

I

G2] Connect to SQL Server to obtain default settings for the additional

configuration options.

I II I I I I I

Cancel

Help

i). At the next dialog box, Make sure to change the default database to checked and FISDataMart is populated in the drop down.

**Select Next

C reat e a N ew Oat.a Source t o SQ L Server

SQLServer 2Ca1 R2

!;d Change the default database to :

liikt?fflfflMT\1

Mirror server:

SPN for mirror server (Optional):

D Attach database filename:

X

~1

121 Use A NSI quoted identifiers . 121 Use A NSI nulls . paddings and warnings.

7 ._!__ < Back

N_ex_t >_ _.

J L Help

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download