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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- installation and setup to the fisdatamart for sql server
- log server troubleshooting guide forcepoint
- mp2 system overview 6 0 sql enterprise edition
- cdata software inc salesforce to sql server integration
- manually creating the log database
- ppc s smart pracitice aids installation with the database
- planning and executing a successful sql server
- querying external data in azure blob data lake storage
Related searches
- sql server datetime to date
- sql server number to date
- sql server convert datetime to utc
- sql server utc to local
- sql server convert date to string
- sql server convert numeric to string
- sql server 2016 installation steps
- sql server 2016 installation file
- sql server varchar to date conversion
- sql server cast datetime to varchar
- sql server setup odbc connection
- sql server 2016 installation media