38
Whosetsitup?
Dataprovider
Infree-handSQL,youcancreate
yourownconnectiontothedatabase.
Onceyouhavecreatedtheconnec-
tion,youcanmakeitavailableto
otherusers.
Free-handSQL
Whenyouaccessdatainapersonal
datafileorXMLfile,youselectthe
fileandindoingso,you"connect"to
it.Thisisnotatechnicaltask,it'sjust
aquestionofselectingtherightfile
PersonaldatafilesandXMLfiles
AVBAprocedurerunsaVBAmacro
thatretrievesdataforyourDesktop
Intelligencereport.Thepersonwho
createsthemacrodefinestheconnec-
tiontothedatasourceinthemacro
code.
VBAprocedures
Restrictiveconnections
Ifyouareworkingwithauniversethatissetupwitharestrictiveconnection,
youneedtosupplythedatabaseusernameandpasswordtorunaquery.
Thisusername/passwordisnottheonethatyouusetologontoDesktop
Intelligence;itistheusername/passwordoftheunderlyingdatabase(for
exampleanSQLServerdatabase)thattheuniverseaccesses.Thisdatabase
normallyremainshidden,buttheuniversedesignercansetuparestrictive
connectiontoaddanextralayerofsecurity.Dependingonthetypeof
restrictiveconnection,youneedtosupplythedatabaseusernameand
passwordinsomeorallofthefollowingsituations:
• Whenyoufirstrunaquery(formoreinformationonrunningaquery,see
"BuildingaqueryintheQueryPanelandrunningthequery.".
30
DesktopIntelligenceAccessandAnalysisGuide
IntroductiontoAccessingDatawithDesktopIntelligence
2
Whatdatasourcesareavailable?