2022.2

Microsoft SQL Server
1. Entertheappropriateinformationtoconnecttothedatabase:
l
Server:EntertheserveraddressfortheMicrosoftSQLServerdatabase.
l
Port:EntertheporttocommunicatewiththeSQLServer.Thedefaultportis1433.
l
Database name:Entertheexactnameofthedatabasefromwherethedatashouldbe
extracted.
l
User name:EnterausernamethathasaccesstotheSQLServerandspecifieddatabase.
TheuseronlyrequiresReadaccesstothedatabase.
l
Password:Enterthepasswordthatmatchestheusernameabove.
2. ClickNextandentertheinformationforthesourcetable.
l
Connection string:Displaysthefullpathtothedatabase.
l
Table:Usethedrop-downtoselecttheappropriatetableorstoredquerytoretrievethe
appropriatedataset.
l
Encoding:Usethedrop-downtoselecttheencodingwithwhichtoreadthedatainthe
table.
l
Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending
(Z-A)order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnum-
bers,itwillbesortedasatext.
3. ClickFinishtoopenthedatabase.
Microsoft Access
1. Entertheappropriateinformationtoconnecttothedatabase:
l
File name:BrowsetoyourMicrosoftAccessdatabasefile(.mdb,.accddb).
l
Password:Enterapasswordifoneisrequired.
2. ClickNextandentertheinformationforthesourcetable.
l
Connection string:Displaysthefullpathtothedatabase.
l
Table:Usethedrop-downtoselecttheappropriatetableorstoredquerytoretrievethe
appropriatedataset.
l
Encoding:Usethedrop-downtoselecttheencodingwithwhichtoreadthedatainthe
table.
l
Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending
(Z-A)order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhas
Page 718