Skip to Content
0

HCI DS - Same Datastore ETL and Lookup not provided

Dec 08, 2016 at 07:24 PM

189

avatar image

Hi Folks,

I created a file store to HCP DB tasks using HCI DS and vice versa it worked fine. Then tried File to File tasks which also worked fine. These were simple scenarios

I wanted some ETL functionality to test and was not able to achieve using HCI DS.

1. When Moving data from flat file to HCP DB. I was not able to perform lookups on any column in the flat file with a table in HCP DB. The data store for HCP did not even show up ! Only the flat files data store showed up. !!! How to solve this?

2. As a work around I thought of this solution - Store data in a temp table in HCP and then perform lookup and insert data into actual table. - This too dint work out ! - I was not able to select the HCP DB as both source and target. If I select in source the all data stores realted to HCP disappear in the target ! Same applies vice versa.

1. HCP DB connection data store and imported tables

2. choosing flat file as source:

3. Choosing HCP DB s target:

Till this it is fine.

4.Choosing HCP DB as the source

5. HCP DB once again cant be selected as target - Not shown from the data stores. So Same DB ETL not possible? Say moving from staging to prod / usage.

6. And lookup is not showing the HCP DB tables -

Does HCI DS not have these functionality or Am I missing something?

Please Help.

Thanks and Regards -- Vyas

1.png (72.2 kB)
2.png (44.6 kB)
3.png (53.8 kB)
4.png (54.5 kB)
5.png (39.6 kB)
6.png (69.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vyas Sarangapani Dec 21, 2016 at 05:45 AM
0

Hi Got resolved by SAP ticket :


Share
10 |10000 characters needed characters left characters exceeded