2022.2

l
MariaDB
l
MySQL
l
Oracle
l
MicrosoftSQLServer
l
MicrosoftAccessDatabase(.mdb,.accddb)
l
ODBCDataSource
l
JDBC
2. Reviewtheoptionspresented.Theoptionsavailabledependonthetypeofdatabasedata
source;seebelow.
MariaDB \ MySQL
1. Entertheappropriateinformationtoconnecttothedatabase:
l
Server:EntertheserveraddressfortheMariaDBorMySQLdatabase.
l
Port:EntertheporttocommunicatewiththeMariaDBorMySQLserver.Thedefaultportis
330.
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MariaDBorMySQLserverandspe-
cifieddatabase.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 302