Hi all,
My friend luke.marsonhas been encouraging me for years (and I'm not using the word figuratively) to post some blogs related to the Nakisa applications. So far, I've managed to avoid doing so, but, now that I work with him, there's really no avoiding it. So, I'm starting with a little one. :smile:
Just a quick warning: I've never really blogged, for any purpose. So, it might not always be concise, and there's almost always going to be a lot of notes and parentheses. (I like going on tangents.) Nevertheless, I hope you enjoy, and take something worthwhile home with you, by the time I'm done.
In this series of posts I'm covering the XML configuration files (AppResources). It's primarily geared towards consultants who already have a cursory understanding of how the VSN applications work, but I'll start another series which covers the topic from the ground up (I promise).
Speaking of which, this is actually the bottom-up view of AppResources. So, also look forward to the top-down view of the subject in the near future. Which is actually essential to understand when you want to make manual modifications and customizations to existing configurations.
Without further ado:
The contents in this post (and related posts) are specifically focused on the technical XML configurations for VSN (SOVN) OrgChart 3.0 SP3, and are catered to the latest available version at the time of publishing (3.0.3.255). Although, configurations will usually apply to earlier versions as well, and I will do my best to highlight any special *new* configurations which have only become available in the latest release.
Also, most configurations also apply to other applications in the VSN (SOVN and STVN) product suite. So, I'll try to put a list of products which support the configuration at the bottom of the post. In the case that I don't cover a very important configuration for a specific application (because it's not supported by OrgChart), I'll have to post another blog on the subject.
So, let's get started!
<connectiontype>
SAP
Oracle
SQLServer
DB2
ActiveDirectory
DLL
<connectionstring>
SAP: ASHOST=[Server name or IP] SYSNR=[System number] CLIENT=[Client number] USER=[Optional] PASSWD=[Optional]
Oracle: Data Source=[TNS name];User Id=[User for appropriate schema];Password=[User password];
SQLServer: Data source=[Server name/IP];Initial Catalog=[DB instance];user id=[SQL Server auth user];password=[User password]
ActiveDirectory: LDAP://[server],[port],[etc.]
(If I got any of the above wrong, or just plain ignored it, I'm sure you can find many examples of properly formulated connection strings for each system on the internet.)
Note: currently, in most applications other than OrgChart the Data Center can be found under the Application-wide Settings menu
Another note: You'll notice that all existing connection strings are encrypted, regardless if your ManagerResources enryptions are on or off (that's another subject). This is a new, and very beneficial, feature of VSN 3.0 (all support levels). This ensures your system passwords cannot be read by anyone who has access to the application server's filesystem. So, if you do create a new data connection manually, the next time you load it and save it in AdminConsole the system will encrypt your string for you. (Except in your .delta folder)
That's to say:
Pretty much all versions of all applications too. DataConnectionConfiguration, being the most basic of all XML files, hasn't needed to change in years. At least, I remember it being exactly the same all the way back to version 1.3x when AppResources was stored in one big XML file instead of neatly compartmentalized into different file folders like it is now (but my memory can fail me sometimes :smile: ).
Purpose: Connect VSN to the data system
Location: AppResources\dataconnectionconfiguration
Parameters: <connectiontype>, <connectionstring>
Used by: DataElementConfiguration
Uses: None
AdminConsole: Data Center -> Data Connections
Apps: All
Did I miss something? Don't like the order I put things in? Layout? Let me know.
Cheers,
Matthew
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |