Skip to Content
avatar image
Former Member

SMART DATA ACCESS - HANA MSSQL

Hello,

I hope you can help me, I have to link my server MSSQL to my server HANA, so configure SMART DATA ACCESS on my server HANA, followed all the instructions of all tutorials and guides that I found, I worked after several tries, but only I can see the base of my MSSQL master data.

I hope you can help me.

Hola,

Espero me puedan ayudar, tengo que vincular mi servidor MSSQL a mi servidor HANA, por lo que configure SMART DATA ACCESS en mi servidor HANA, segui todas las intrucciones de todos los tutoriales y guias que encontre, me funciono despues de varios intentos, pero solo puedo visualizar la base de datos master de mi MSSQL.

Espero me puedan ayudar.

ODBC.png (6.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 18, 2015 at 04:49 PM

    I found my mistake, odbc.ini file creation should further Agragar a line that indicates which database engine SQL I wanted to connect.

    ***** ****** ODBC.INI

    Driver = [Route Driver]

    Server = [MSSQL IP Address]

    Port = 1433

    Database = [my database]

    Thank you for your help

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2015 at 02:46 PM

    What else do you expect to see?

    Does the user account that you used for SDA have the required permission on MS SQL Server-side to see the data you are looking for?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Lars,

      thanks for answering.

      I expected to see all databases SQL engine.

      If the user has the required permissions to view and run SQL queries.