Hello all,

Not sure if this can be done but I need to contect to an instance of Oracle that is not part of Remedy (for updates to the external instance). Is this possible and if so how could it be done?

Cris

Buck,

Yes it can be done. We do it.

1. Create a database link between the 2 instances.

2. Create synonyms for the tables to access on the other system.

3. Use Direct SQL to write to the other system. Be sure to surround the
Remedy Variables with ' single parentheses.

Good Luck,

Tom Shurmur
University of Michigan

Buck Lucifer wrote:

>Hello all,
>
>Not sure if this can be done but I need to contect to an instance of Oracle that is not part of Remedy (for updates to the external instance). Is this possible and if so how could it be done?
>
>Cris
>
>
>
>
>
>

Buck,
<br />
<br />On Fri, 7 Nov 2003, Tom Shurmur wrote:
<br />
<br />> Buck,
<br />>
<br />> Yes it can be done. We do it.
<br />>
<br />> 1. Create a database link between the 2 instances.
<br />>
<br />> 2. Create synonyms for the tables to access on the other system.
<br />>
<br />> 3. Use Direct SQL to write to the other system. Be sure to surround the
<br />> Remedy Variables with ' single parentheses.
<br />
<br />Once, you setup the database link, you can also use view forms. You don't
<br />say what version of Remedy you are using, but you will need 5+ to use view
<br />forms. With a view form, you can read and update information just like a
<br />regular form. There are ome limitations though; for instance, a view
<br />form cannot be used in a join form.
<br />
<br />> Good Luck,
<br />>
<br />> Tom Shurmur
<br />> University of Michigan
<br />>
<br />> Buck Lucifer wrote:
<br />>
<br />> >Hello all,
<br />> >
<br />> >Not sure if this can be done but I need to contect to an instance of Oracle that is not part of Remedy (for updates to the external instance). Is this possible and if so how could it be done?
<br />> >
<br />> >Cris
<br />> >
<br />
<br />--
<br />Dan Clawson
<br />Software Developer - Remedy Project
<br />University of Utah - Network & Communication Services
<br />
<br />(e) dan.clawson@utah.edu
<br />
<br />
<br />
<br />

Tom,

Thanks for the help. Are there any examples on the net that will show me what I need to do this?

We're using ARS 5.01

Thanks

Cris




Yes it can be done. We do it.

1. Create a database link between the 2 instances.

2. Create synonyms for the tables to access on the other system.

3. Use Direct SQL to write to the other system. Be sure to surround the Remedy Variables with ' single parentheses.

Good Luck,

Tom Shurmur
University of Michigan

Buck Lucifer wrote:

>Hello all,
>
>Not sure if this can be done but I need to contect to an instance of Oracle that is not part of Remedy (for updates to the external instance). Is this possible and if so how could it be done?
>
>Cris
>
>
> UNSUBSCRIBE or access ARSList Archives at
>http://www.ARSLIST.org (Support: mailto:support@arslist.org ) ARSList
>is hosted by QMX SUPPORT SERVICES at www.QMXS.com
>
>
>

Hello,

I got the database link on the two instances done. However, can this link
be private? The DBA doesn't want to set these as public. Also, the
synonyms for the two tables are made. But I can't access these tables in
the view form in the Remedy admin client. Any help would be greatly
appreciated.

Cris

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Dan Clawson
Sent: Saturday, November 08, 2003 08:16 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Connecting to Another Oracle Instance

Buck,

On Fri, 7 Nov 2003, Tom Shurmur wrote:

> Buck,
>
> Yes it can be done. We do it.
>
> 1. Create a database link between the 2 instances.
>
> 2. Create synonyms for the tables to access on the other system.
>
> 3. Use Direct SQL to write to the other system. Be sure to surround
> the Remedy Variables with ' single parentheses.

Once, you setup the database link, you can also use view forms. You don't
say what version of Remedy you are using, but you will need 5+ to use view
forms. With a view form, you can read and update information just like a
regular form. There are ome limitations though; for instance, a view form
cannot be used in a join form.

> Good Luck,
>
> Tom Shurmur
> University of Michigan
>
> Buck Lucifer wrote:
>
> >Hello all,
> >
> >Not sure if this can be done but I need to contect to an instance of
Oracle that is not part of Remedy (for updates to the external instance).
Is this possible and if so how could it be done?
> >
> >Cris
> >

--
Dan Clawson
Software Developer - Remedy Project
University of Utah - Network & Communication Services
(o) 801-581-6745
(e) dan.clawson@utah.edu



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

**
Yes it can be private. We use a private DB Link and it works fine.

Make sure that the DBA give your Login (user) select and view permission to the Oracle forms you are trying to access.

The Synonyms need to be created on the Remedy Server pointing to the database link.

Once the synonyms are created you should be able do a DESC on the synonym name and get a listing of the table.

Good Luck

Tom Shurmur
University of Michigan

57a649 wrote:


Hello,

I got the database link on the two instances done. However, can this link
be private? The DBA doesn't want to set these as public. Also, the
synonyms for the two tables are made. But I can't access these tables in
the view form in the Remedy admin client. Any help would be greatly
appreciated.

Cris

-----Original Message-----

This posting was submitted via the Web interface
From: Action Request System discussion list(ARSList)

Hi Cris,

I think you need to create your view form from a view (or a table) rather than the synonym itself. Having a synonym should make it a little easier to create the view though.

Rod

-----Original Message-----
From: 57a649 [mailto:57a649@COX.NET]
Sent: Tuesday, 11 November 2003 2:14 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Connecting to Another Oracle Instance


Hello,

I got the database link on the two instances done. However, can this link
be private? The DBA doesn't want to set these as public. Also, the
synonyms for the two tables are made. But I can't access these tables in
the view form in the Remedy admin client. Any help would be greatly
appreciated.

Cris

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Dan Clawson
Sent: Saturday, November 08, 2003 08:16 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Connecting to Another Oracle Instance

Buck,

On Fri, 7 Nov 2003, Tom Shurmur wrote:

> Buck,
>
> Yes it can be done. We do it.
>
> 1. Create a database link between the 2 instances.
>
> 2. Create synonyms for the tables to access on the other system.
>
> 3. Use Direct SQL to write to the other system. Be sure to surround
> the Remedy Variables with ' single parentheses.

Once, you setup the database link, you can also use view forms. You don't
say what version of Remedy you are using, but you will need 5+ to use view
forms. With a view form, you can read and update information just like a
regular form. There are ome limitations though; for instance, a view form
cannot be used in a join form.

> Good Luck,
>
> Tom Shurmur
> University of Michigan
>
> Buck Lucifer wrote:
>
> >Hello all,
> >
> >Not sure if this can be done but I need to contect to an instance of
Oracle that is not part of Remedy (for updates to the external instance).
Is this possible and if so how could it be done?
> >
> >Cris
> >

--
Dan Clawson
Software Developer - Remedy Project
University of Utah - Network & Communication Services
(o) 801-581-6745
(e) dan.clawson@utah.edu



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

Rod,

Perhaps I'm not writing the correct syntax into the "Please provide a
Database Table or create View Form:" field.

Cris

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of ISD ARAdmin
Sent: Monday, November 10, 2003 08:35 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Connecting to Another Oracle Instance

Hi Cris,

I think you need to create your view form from a view (or a table) rather
than the synonym itself. Having a synonym should make it a little easier to
create the view though.

Rod

-----Original Message-----
From: 57a649 [mailto:57a649@COX.NET]
Sent: Tuesday, 11 November 2003 2:14 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Connecting to Another Oracle Instance


Hello,

I got the database link on the two instances done. However, can this link
be private? The DBA doesn't want to set these as public. Also, the
synonyms for the two tables are made. But I can't access these tables in
the view form in the Remedy admin client. Any help would be greatly
appreciated.

Cris

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Dan Clawson
Sent: Saturday, November 08, 2003 08:16 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Connecting to Another Oracle Instance

Buck,

On Fri, 7 Nov 2003, Tom Shurmur wrote:

> Buck,
>
> Yes it can be done. We do it.
>
> 1. Create a database link between the 2 instances.
>
> 2. Create synonyms for the tables to access on the other system.
>
> 3. Use Direct SQL to write to the other system. Be sure to surround
> the Remedy Variables with ' single parentheses.

Once, you setup the database link, you can also use view forms. You don't
say what version of Remedy you are using, but you will need 5+ to use view
forms. With a view form, you can read and update information just like a
regular form. There are ome limitations though; for instance, a view form
cannot be used in a join form.

> Good Luck,
>
> Tom Shurmur
> University of Michigan
>
> Buck Lucifer wrote:
>
> >Hello all,
> >
> >Not sure if this can be done but I need to contect to an instance of
Oracle that is not part of Remedy (for updates to the external instance).
Is this possible and if so how could it be done?
> >
> >Cris
> >

--
Dan Clawson
Software Developer - Remedy Project
University of Utah - Network & Communication Services
(o) 801-581-6745
(e) dan.clawson@utah.edu



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com