Thank you sir. I think that route may be the better way. I am going to setup a test now.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, June 03, 2010 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: Configuring AR System 7.6 to support a View Form for a remote SQL Server database No. Remedy does not mess with objects in the database it is not working with. The reason I do it that way is my dev Remedy has to pull data from the dev provisioning system here (the same with test to test and production to production). When I migrate the Remedy forms and workflow nothing has to change. I can tell management my Remedy code is truly the same in all environments. 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 9:06 AM To: arslist@ARSLIST.ORG Subject: Re: Configuring AR System 7.6 to support a View Form for a remote SQL Server database So, you create a view in the local ARSystem database, is this dangerous? Would an upgrade of the ARSystem database overwrite this view? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, June 03, 2010 9:53 AM To: arslist@ARSLIST.ORG Subject: Re: Configuring AR System 7.6 to support a View Form for a remote SQL Server database 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature
