Thanks Charlie, Doug From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Charlie Lotridge Sent: Wednesday, March 25, 2015 12:10 PM To: [email protected] Subject: Re: Refresh my Memory Please
** Doug, You should not need any middleware to do this. It's not clear if this is what you're trying, but I'd recommend creating a MS SQL view that pulls the data from the remote DB. One advantage is that if you can successfully query the SQL view in (say) SQL Server Management Studio query window (using the Remedy account), then the ARS server will have no problem querying it either and should be blissfully unaware that the data is coming from a remote source. I.e., if there are any problems with the connection, they'll show up when you try to directly SELECT from the SQL view. Another advantage is that it isolates ARS from any changes you may make to this data source. E.g., should you decided to pull the remote data into a local table, you'd just need to reconfigure the SQL view to "point to" the local data, and you would not need to change the Remedy view at all. Hope this helps. -charlie On Wed, Mar 25, 2015 at 8:58 AM, Tanner, Doug <[email protected]<mailto:[email protected]>> wrote: ** Dear List, I am going from Memory here, so I need some assistance (Senior Moment) Configuration: ARS 8.1.2 MS SQL 2012 Our DBA has setup a couple of Linked Server on our dedicated MS SQL 2012 Server. (1st Linked Server) – Points to an external MS SQL database and works just fine (Have successfully created a View Form and Workflow – been in production for years) (2nd Linked Server) – Points to an external DB2 database. When attempting to create the View form I get a ARERR 552. Backend Database: DB2 LUW Version 10.5.5 Using MS SQL Connector: Microsoft OLEDB provider for DB2 V4.1 If I login to SQL Manager using the Remedy account, I can see and query everything just fine on this Linked Server, so permissions, etc. appear to be fine. I recall that going “cross databases” (Remedy-MS SQL, Linked Server #2 – DB2) requires an additional add on (“Middleware”). Do I recall this correctly? Can someone enlighten me? (I recall James Croom authoring something years ago ☺) Thanks in Advance, Doug |Doug Tanner | Enterprise Workflow Applications | |Compass Group | 2400 Yorkmont Rd, Charlotte, NC 28217 | | (w) +1.704.328.3178<tel:%2B1.704.328.3178> | (m) +1.980.230.8563<tel:%2B1.980.230.8563> | | www.cgnad.com<http://www.cgnad.com/> |why Compass?<http://www.worldofcompass.com/video/> | This email is subject to certain disclaimers, which may be reviewed via the following link. http://compass-usa.com/Pages/Disclaimer.aspx. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ This email is subject to certain disclaimers, which may be reviewed via the following link. http://compass-usa.com/Pages/Disclaimer.aspx. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
