SMART DATA ACCESS - HANA MSSQL

[Former Member]

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.

[Former Member · Accepted solution]

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

[former_member643375 · Accepted solution]

Hi,

I modified odbc.ini file by adding database details but still I am able to view only Master.

Any other step required to be performed?

[lbreddemann]

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?

[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.