Connecting to Simcorp Dimension

[Spike]

Does anyone know how one connects to a Simcorp Dimension Database v3.7
Any advices would be very gratefully received

Many thanks
--
with kind regards

Spike

[John.Greenan]

I've seen this done. What's the prefered technology - what are you trying to
achieve?


--
www.alignment-systems.com


"Spike" wrote:

> Does anyone know how one connects to a Simcorp Dimension Database v3.7
> Any advices would be very gratefully received
>
> Many thanks
> --
> with kind regards
>
> Spike

[Spike]

I would like to extract data to an excel spreadsheet as in using ADO for
Access etc.
--
with kind regards

Spike


"John.Greenan" wrote:

> I've seen this done. What's the prefered technology - what are you trying to
> achieve?
>
>
> --
> www.alignment-systems.com
>
>
> "Spike" wrote:
>
> > Does anyone know how one connects to a Simcorp Dimension Database v3.7
> > Any advices would be very gratefully received
> >
> > Many thanks
> > --
> > with kind regards
> >
> > Spike

[John.Greenan]

Ok, so you want to use ADO - you are running Dimension on an Oracle database?
You therefore need the oracle client installed on your client PC and you
need to know the connection details for the database server - the server
name, database name and the port number that oracle is listening on. Set
that up in a .udl file and then use that to connect from Excel to Dimension.

Or, you can use the data access API and go via the application server.

This is not a trivial exercise - depending on your implementation, it might
be the case that the database admins are not allowing direct connections to
the database.


--
www.alignment-systems.com


"Spike" wrote:

> I would like to extract data to an excel spreadsheet as in using ADO for
> Access etc.
> --
> with kind regards
>
> Spike
>
>
> "John.Greenan" wrote:
>
> > I've seen this done. What's the prefered technology - what are you trying to
> > achieve?
> >
> >
> > --
> > www.alignment-systems.com
> >
> >
> > "Spike" wrote:
> >
> > > Does anyone know how one connects to a Simcorp Dimension Database v3.7
> > > Any advices would be very gratefully received
> > >
> > > Many thanks
> > > --
> > > with kind regards
> > >
> > > Spike

[Spike]

Thank you very much for that i thought it would not be easy i think it will
be best for me to get on to the guys running it. I am grateful.
--
with kind regards

Spike


"John.Greenan" wrote:

> Ok, so you want to use ADO - you are running Dimension on an Oracle database?
> You therefore need the oracle client installed on your client PC and you
> need to know the connection details for the database server - the server
> name, database name and the port number that oracle is listening on. Set
> that up in a .udl file and then use that to connect from Excel to Dimension.
>
> Or, you can use the data access API and go via the application server.
>
> This is not a trivial exercise - depending on your implementation, it might
> be the case that the database admins are not allowing direct connections to
> the database.
>
>
> --
> www.alignment-systems.com
>
>
> "Spike" wrote:
>
> > I would like to extract data to an excel spreadsheet as in using ADO for
> > Access etc.
> > --
> > with kind regards
> >
> > Spike
> >
> >
> > "John.Greenan" wrote:
> >
> > > I've seen this done. What's the prefered technology - what are you trying to
> > > achieve?
> > >
> > >
> > > --
> > > www.alignment-systems.com
> > >
> > >
> > > "Spike" wrote:
> > >
> > > > Does anyone know how one connects to a Simcorp Dimension Database v3.7
> > > > Any advices would be very gratefully received
> > > >
> > > > Many thanks
> > > > --
> > > > with kind regards
> > > >
> > > > Spike