I'm not, but one installation of AIE with multiple service instances can host multiple data exchanges. Each data exchange can be configured to use a different database connector, so I see no reason why I could not have four service instances running four data exchanges (1 per) that draw from SQL Server, Oracle, a flat file, and a DB2 database, with all of the data exchanges pushing something to the same AR Server. Based on what I have seen performance-wise, I would try to separate the data exchanges from one another by time slices; I wouldn't want to have all four running simultaneously.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, June 19, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Having never used AIE my question would be ... Is anyone using it to access multiple database manufacturers at the same time (i.e. MS SQL and Oracle at the same time), or are people using just one manufacturer at a time (i.e.accessing multiple Oracle databases, or accessing multiple MS SQL databases, or accessing multiple Sybase databases)? Fred _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 10:02 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** That is my thought as well or is it looking at what the arserver is talking to. Thanks for the info, Howard On 6/19/08, strauss <[EMAIL PROTECTED]> wrote: ** You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 8:50 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
