2022.2

Oracle
1. Entertheappropriateinformationtoconnecttothedatabase:
l
Server:EntertheserveraddressfortheOracledatabase.
l
Port:EntertheporttocommunicatewiththeOracleserver.
l
Database name:Entertheexactnameofthedatabasefromwherethedatashouldbe
extracted.
l
User name:EnterausernamethathasaccesstotheOracleserverandspecifieddata-
base.TheuseronlyrequiresReadaccesstothedatabase.
l
Password:Enterthepasswordthatmatchestheusername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 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.
Page 303