Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Connect Discoverer to MS SQL Server

Re: Connect Discoverer to MS SQL Server

From: <yakov.b_at_gmail.com>
Date: 5 Apr 2007 08:05:49 -0700
Message-ID: <1175785549.319737.310940@n59g2000hsh.googlegroups.com>


On Mar 27, 3:15 pm, "Marino Ljubic" <mlju..._at_globalnet.hr> wrote:
> <yako..._at_gmail.com> wrote in message
>
> news:1174981104.716947.318060_at_b75g2000hsg.googlegroups.com...
>
>
>
> > On Mar 26, 12:59 pm, "frank.van.bor..._at_gmail.com"
> > <frank.van.bor..._at_gmail.com> wrote:
> >> On 26 mrt, 11:59, yako..._at_gmail.com wrote:
>
> >> > Hi,
> >> > I'm trying to connect Discoverer 10g to MS SQL Server 2000.
> >> > I think I know what to in the username and password fields but I can't
> >> > figure out what to put in the "Connect" field.
> >> > I tried a DSN name, connection string, server name... nothing works!
> >> > Please help me out..
> >> > TIA,
> >> > jake
>
> >> It should be the TNS alias; it's the part defined in tnsnames.ora,
> >> before the first equal ("=") sign.
>
> >> I seriously doubt whether you can connect to SQL Server.
>
> > Thanks.
> > I guess now I have to figure out how to write the part after the equal
> > sign, eh?
> > jake
>
> You can connect to MSSQL only indirectly via heterogeneous services, which
> means you have to create database link in Oracle database using either
> Oracle Transparent Gateway or Generic Database Connectivity (ODBC, OLE DB).
>
> Before you query data in any data source, you must define it in Discoverer's
> End User Layer, which is metadata repository. The EUL must be stored in an
> Oracle database, unless you use some older version of Discoverer. It means
> you need at least one Oracle instance. You can find more details in
> Discoverer help, chapter "Discoverer support for non-Oracle databases and
> Oracle Rdb".
>
> If you want direct access to non-Oracle data sources, you can try Siebel or
> some other BI tool.
>
> Regards

Thanks. Received on Thu Apr 05 2007 - 10:05:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US