2022.2

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.
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.
Page 717