You have to have the Remedy database be able to read data from the external (remote) database. In MS SQL Server this is called a link (in Oracle it is a dbLink). In SQL Management you set up a link so the Remedy database can connect to the external (remote) database. Think of pure a SQL select statement. How would you do a select of data in an external (remote) database while connected to the local Remedy databse?
Personally I do it a bit differently. I set up the link and a database View of the data in the external (remote) database in the local Remedy database and then create my Remedy view form against that local database view. This way I can adjust for dev/test/production environments at the database level and Remedy is the same for each. Say the Remedy database is called LocalRemedy and the external (remote) database is CompanyDatabase. In LocalRemedy you set up a link to CompanyDatabase called Companylink. You can then create a Remedy view form against CompanyLink.CompanyDatabase.dbo.People. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bilinski, John CTR WHS/ITMD/ASD Sent: Thursday, June 03, 2010 7:46 AM To: arslist@ARSLIST.ORG Subject: Configuring AR System 7.6 to support a View Form for a remote SQL Server database Question, I am reading page 177 of the AR Server Integration guide v7.5 on how to configure a VIEW FORM to connect to an external database. My system runs on SQL Server 2005 64-bit, both OS are Windows Server 2003. I am a bit confused by this line in the integrations guide: "Create a link to the remote database and either give ARAdmin an account on the remote database or use the proper login credentials." What do they mean by link? Do they mean an ODBC datasource connection on the database server? Or is this something that needs to be setup in SQL Management Studio? Also, a couple lines down from this setup task the guide says: "The format for the table name is:LINKNAME.DATABASENAME.OWNER.TABLENAME" Do I have to create this table in my ARSystem Database? I think they are leaving out some important information about how to handle this in SQL Server. Need help. Thanks. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
