I install the EDI software and apply patches. The DBA sets up the database after I give him the specs from IBM/Sterling. There will be an empty database with a name and a user with the specified rights and no objects. The network and windows admins set up the new VM's and prepare the operating environments to their requirements and those I've provided. That blank slate is what I start with and I go and put all the java on the app server and clients as required before I start the install. After the install I extract the perimeter server package and install and configure those on the servers in the DMZ. I have the use of an admin level logon to the servers that I use for these occasions. They do their stuff and I do mine. At my company the EDI function is an IT position and I manage that function. My EDI Coordinator does not install software or manage servers, nor does he want to, but I have had him sit next to me so he knows the sort of thing that I am doing. If he had the interest or aptitude he could grow from his position into mine.
I don't know the names of the tables that I have not had occasion to query before. I would go to the DBA for that and treat it as a favor he's done me when it was provided. Should I do something horrible with that information and wreck my system, that would be 100% my own mess too. I process nearly a half billion USD per year in orders through our EDI system (plus all the other traffic to support that business) so I would do all my playing in my duplicate test environment and still be very, very careful. I know they can only kill me once and probably won't eat me but I like my job and I want to keep it. On Jan 8, 2013, at 12:35 PM, L wrote: > > > It might seem "elementary" but when you're a novice with a completely new > system, very little training, and documentation that is lacking at best, > nothing is elementary. > > We are using DB2, however I do not have direct access to the database. SI > provides a SQL Manager where I can run queries, but I don't know the table > names and what fields they contain. I was hoping there was a utility within > SI that would provide this information. I guess I have to put in a request > with our DBA team to look this up for me and maybe they can give me a > spreadsheet or something. > > I was looking for a way to look up table names and fields myself, without > having to bug the DBAs. > > I'm curious - do most of you have direct access to your EDI database tables? > I'm assuming that the majority of us are EDI developers, analysts, engineers, > mappers, etc., and not DBAs, Technical Services, or infrastructure-type > folks. What I mean is, I did not install the software, set up the database, > or create the file system. I analyze trading partner requirements, write > maps, set up trading partner relationships and communications, set up > reports, monitor errors, etc. Maybe it's the nature of my organization. We > are a large enterprise with a full-service IT staff comprised of separate > teams for different functions. > > Thanks, > Lori Folta > Lead EDI Engineer > UniGroup > > --- In [email protected], Mike Rawlins wrote: > > > > Well, this seems kind of elementary unless I'm missing something. SI > > uses a database like Oracle or SQL Server, right? Just track down the > > username and password you used to for the installation to access the > > database, start up SQLPlus or SQL Server enterprise manager (or whatever > > your version calls it) and go poke around. > > > > Mike > > > > ----------------------------------------- > > Michael C. Rawlins, Senior Software Engineer, GXS > > Sent from personal account > > > > > > On 1/7/2013 12:26 PM, L wrote: > > > > > > This begs a general question regarding SI 5.2. How does one find a > > > list of table names and the fields contained therein? > > > > > > Thank you, > > > Lori Folta > > > Lead EDI Engineer > > > UniGroup > > > > > > --- In [email protected] , riaz > > > mohammed wrote: > > > > > > > > YFS_USER > > > > > > > > > > > > > > > > ________________________________ > > > > From: Vijay Chandra > > > > To: "[email protected] " > > > > Sent: Wednesday, January 2, 2013 11:17 PM > > > > Subject: [EDI-L] Generate report on User information(IBM Sterling > > > Integrator 5.2) > > > > > > > > Â > > > > Hi All, > > > > > > > > Can anyone please share the Database table names that store all User > > > names and their corresponding details like permissions of that User. I > > > need to generate a report on user permissions and found out that there > > > is no pre-defined report configuration for fetching User information. > > > The only way is to extract the values from Database. > > > > > > > > I am using IBM Sterling Integrator 5.2. > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
