abilian / olapy

OlaPy, an experimental OLAP engine based on Pandas
GNU Lesser General Public License v2.1
106 stars 21 forks source link

Connection with Oracle. #17

Open JyGius opened 4 years ago

JyGius commented 4 years ago

Hi all.

olapy runserver -st=db -dbc=C:\Users\x\olapy-data\olapy-config.yml -cbf=C:\Users\x\olapy-data\cubes\cubes-config.yml -sa=oracle+cx_oracle://x:y@ip:port -tf=OLAPTABLE

DB config file is C:\Users\x\olapy-data\olapy-config.yml: connection_string : oracle+cx_oracle://olapx:olapx@ip:port

C:\Users\x\olapy-data\cubes\cubes-config.yml starts with:

cube name -> db name

name : olapcube source : oracle xmla_authentication : False ..................... ...............

The documentation says -tf File path or DB table name but it still looks for csv in the directory:

File "pandas_libs\parsers.pyx", line 387, in pandas._libs.parsers.TextReader.cinit File "pandas_libs\parsers.pyx", line 705, in pandas._libs.parsers.TextReader._setup_parser_source FileNotFoundError: [Errno 2] File b'OLAPCONSUMER' does not exist: b'OLAPTABLE'

How can I connect to my db?

Many thanks.

Bye.

mouadhkaabachi commented 4 years ago

Hi JyGius Which oracle version are you using? so that I can reproduce your error

marioscialpi commented 3 years ago

@JyGius did you solve your configuration issue? I have similar problem.

Many thanks

Mario