Skip to Content
0

I can't find my imported table from sql server to my target system ( SAP HANA)

Dec 18, 2017 at 05:01 PM

49

avatar image
Former Member

Hello guys,

I want to load tables from SQL Server to SAP HANA through SAP DATA SERVICES.

I've created a job in SAP data services which complete successfly. However I can't find the replicated table under "SYSTEM schema" in my target database in (SAP HANA Studio)

bods-job.png

hana-tables.png

Need your help and thanks in advance

bods-job.png (113.4 kB)
hana-tables.png (86.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Teuku Faruq Dec 19, 2017 at 05:52 AM
0

Hello Ahmed,

Have you check your HANA user authorization? Template table by right will be created once your run the job in BODS successfully.

Thank you.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

It seems 10k rows inserted. Probably the user executing the job is different than the user Ahmed is using in HANA Studio to view the contents of the table.

1
Former Member

Thanks for your help, the problem was because I use a multiple containers (System database) to connect to sap hana ;

When I choose a single container I was able to find all my template tables.

1