Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Tags:
Former Member
Former Member replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question