Skip to Content
author's profile photo Former Member
Former Member

MS-Access and HANA Views

I want to connect to HANA via ODBC from MS-Access. By doing this I can see TABLEs and write Access Queries to get data. But what I really would want is to connect to VIEWS (instead of Tables) - but Views do not show up in my ODBC list of "tables" to connect to. Is there any way to do this? (I have searched everywhere and my onw IT has no answers.)

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2012 at 05:44 PM

    Here is another idea. Suppose I could send the output of a Calculated or Analytical View to a user table within HANA, then I could read that new table from MS-Access. Is there any way to redirect a View to write to a HANA-User created table?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2012 at 10:14 AM

    Hi Ira,


    I can only imagine this is because HANA as of now haven't officially certified MS-Access to be used as a client and hence would not provide access to column views via the ODBC interface. Have a look at note 1577128.

    I had a similar issue while connecting Cognos to HANA as part of a proof of concept exercise wherein only tables could be selected but no column views. As a work around we ended up creating database views under the schema (not column views) and that worked. However, as expected performance was poor as they wouldn't use the super fast olap, join and calculation engines of HANA.

    Thanks,

    Anooj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Henrique Pinto

      Well, I had already tried the Regedit method without much success. Although I can get over 500K cells, it still crashes with the amount of data I am after - as well as much slower than my Access Queries against HANA Tables. I will be fine with the Tables - just kept hoping that I would be able to use Views via ODBC.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2012 at 05:54 PM

    Is there any way to submit a request to SAP to have them make Views accessible via ODBC?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.