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

[former_member512864]

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

[teuku_faruq]

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.

[eralper_yilmaz]

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.

[former_member512864]

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.