Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to Simcorp Dimension
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to Simcorp Dimension
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to Simcorp Dimension
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to Simcorp Dimension
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to Simcorp Dimension
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two dimension look up table | Excel Worksheet Functions | |||
Matrix Dimension | Excel Worksheet Functions | |||
2 dimension lookup | Excel Programming | |||
Array transfer - 1 dimension v. 2 dimension | Excel Programming | |||
Dimension problem | Excel Programming |