I currently have SAP HANA connection and tables in IDT. The owner of the tables is ‘EDL’
The fields in the table has double quotes around them. For example, LOCATION_CV.“Banner”.
I want to switch all the tables now to use AWS environment. The tables names there are not the same and schema is different as well
I have so far done this:
Right click on the HANA table in the .dfx layer and changed the owner to ‘aws’
Changed the connection to AWS.
Double click on the table and renamed it to the aws table. So old table was LOCATION_CV and the new table will become ‘aws_location’
When I do this, the field names for each objects go from double quotes to single quotes so the new field will become aws_location.‘Banner’. When I try to validate the field it fails.
If I manually add the double quotes, for example, aws_location.“Banner”. It verifies fine.
Questions that I have are as follows:
Is it even recommended to changed the table name the way I did.
Can I update all the field from single quotes to use double quotes all at once.