DSXchange

Hi:

I am using the Oracle enterprise stage tp read the daya from Oracle database.I am wondering where can give the server name in the stage.
In the properties tab there is DB Options and DB Options mode.
I am using the Userdefined SQL option.
In DB Option there is User and password only to enter.

Where can specify the database servername in the stage.Please give me advice.

Thanks in advance
Cnu

On the "Properties" tab, click on the "Connection" folder icon. In the lower right of the dialog is the "Available properties to add" section. Click on the "Remote Server" property to add that to the connection options. The value you enter in the top right of the dialog is the database name you are trying to connect to.

Hi Thanks !!
Added the Server and specify the user name and passowrd also as user=user,password=password.It fail to connect when i click on View Data button.
But i am able to connect to the database by using same.
Is that way of passing user and password is correct.Please advice me.

Thanks
cnu

Hi cnu

In this case you must type the full that appear in the tnsnames.ora, for example

my.database.ora.com
{
etc
etc
}

when you define the property: Remote Server = my.database.ora.com

I hope this help

It fail to connect when i click on View Data button

what is the error?

Hi:
the error is select privileges.
I will work with DBA on that.

Thanks
cnu

Hi:
the error is select privileges.
I will work with DBA on that.

Thanks
cnu