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)
SAP Data Services
SAP HANA | SAP HANA studio
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Teuku Faruq Answered 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
▼ Viewable by all users
ERALPER YILMAZ
Dec 19, 2017 at 06:04 AM

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
Dec 19, 2017 at 04:17 PM

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
Comment