Hello @guyhn,
knowing who did the installation sounds like a good idea. Although, I have some remarks to make here.
While probably your training was about the usage of VA (functional usage) I can guess you got no training about administration of SAS, and even less of SAS VA. A SAS solution such as Visual Analytics requires to have assigned a role of a SAS Administrator. This administrator will require both functional and technical skills, to be able to translate your requirements (security, integration with ODS, etc) into technical implementations. But also to be able to coordinate all those actions and the involved teams (SAS Technical Support, users, developers, IT, etc) and even raise questions to the proper teams or SAS. Also, if it is true that there is a mis-installation there, the SAS Administrator will detect the issue inmediately.
And I believe you miss this role very much. If you get a colleague this role and the proper training and experience, you should not have those issues. Instead, you would have projects that will implement every requirement.
For now, i would strongly suggest to contact your SAS account manager or SAS Consulting services to evaluate the best way to move forward and get to know who you need to contact to.
That being said, let me answer some of your questions:
1. Control security is not that hard if you know what to do. Also, if you get the appropiate tools (such as Metacoda) it won't be only easier, also quicker. Feel free to contact @MichelleHomes or @PaulHomes, I am sure they will be happy to help you there).
2 & 3. When you speak about ODS, I understat you don;t mean the SAS ODS procedure, but a name of one of your systems as you well explained. If that is the case, what we will need to know is the format of the data generated by ODS, and also if it is capable of generate the data in other formats. Examples: leave the data on a database such as DB2, Oracle or MySQL, or as Excel or CVS - comma-delimited file). If this is possible, and I would be surprised if not, then load this data into VA is pretty much possible with a Data Query Builder query or just dropping the data into AutoLoad.
4. I don't understand about that it is not secure to generate data in those formats, but this is not SAS related, but IT related. We can probably help you a bit on it. What is the security question here? Maybe encryption of data would help! There are many options
Please let us know what you think and I hope this helps a bit.
Kind regards,
Juan
... View more