Hello, I would like to perform the insert/update on my DB table out of the DB Connect. The corresponding db_outputs.conf looks as follow: [Z_USERS]
connection = HANA_S4_FRUN_FH1
customized_mappings = id:id:16,name:name:32,username:username:32,email:email:32 ,address.street:address_street:32, address.suite:address_suite:32, address.city:address_city:32, address.zipcode:address_zipcode:32 , address.geo.lat:address_geo_lat:32, address.geo.lng:address_geo_lng:32, phone:phone:32, website:website:32 , company.name:company_name:32, company.catchphrase:company_catchphrase:64, company.bs:company_bs:64
disabled = 0
is_saved_search = 0
scheduled = 0
table_name = Z_USERS
ui_query_catalog = SAPHANADB
ui_query_schema = FRX_READ_USER
ui_query_table = Z_USERS
using_upsert = 1
unique_key = id,name,username
#interval = 40 * * * * So my DB primary key is a combination of the id+name+username. Unfortunately it wont work. When I define the above unique_key to be only one field and of course create the underlying DB table correspondingly, it will be fine, so the issue is not laying anywhere else, it has to do definitely with the composite primary key. How would I overcome this? Is it possible? I mean one of the ideas would be to concatenate the fields of the key into an additional key, but this means changing the DB structure (additional column) and this is not always possible. So ideally the solution should be that the DB Connect is able to handle this, especially that this is not so uncommon case to have compound keys I think. Kind Regards, Kamil
... View more