Bulk Load Database column & Table Aliases

Hi everyone,

I'd like to bulk load table and column aliases using the connect SDK tools, but I am not quite sure how to go about it. Manually updating the aliases and bulk loading from the admin console w/ excel files are pretty straight forward, but given the volume of entries we need to edit, I'd like to automate this. I haven't been finding much in the way of documentation for custom loads (specifically for Attributes). Has anyone attempted to do something like this?

I can see that the synonyms/aliases are stored in Attribute table in the CLOB_VALUE field where the ATTR_KEY is 'entrySynonym', but I am not quite sure how to land data there with the SDK tools.

Any help or direction is greatly appreciated.

Thanks,

Greg

Common Use Cases

Accepted answers

PetrH

Hi Greg,

I suggest to use Connect API released in version 2020.3

you can access it in

( your_connect_url/swagger-ui.html )

To identify fields, I would use ADVANCED SEARCH

in your case I think you need to use "entrySynonym" which is named in connect - Alternate names

This can give you quick hint on available field.

I am listing fields for table…

Please be aware that you should use the the fields, which you can update in connect manually. If you update the loaded field it would not propably retained after subsequent loads. I suggest to test on one entry, and try to execute the loader again (or at least run sync job) in oder to confirm that updated field is not removed again. Alternate name is designed for manual use, so it should be OK to use it.

Hope its make sence to you.

Best regards,

Petr

All comments

joshuaburkhow

@DanH - Something you might be able to provide insight on?

PetrH

Hi Greg,

I suggest to use Connect API released in version 2020.3

you can access it in

( your_connect_url/swagger-ui.html )

To identify fields, I would use ADVANCED SEARCH

in your case I think you need to use "entrySynonym" which is named in connect - Alternate names

This can give you quick hint on available field.

I am listing fields for table…

Hope its make sence to you.

Best regards,

Petr

Greg_Murray

@joshuaburkhow thanks for the bump.

@PetrH, Thanks for the quick response. We are a few versions behind, but we should be upgrading in the next week or two. Looking forward to checking out the updated API.

Thanks for the help identifying the field that needs to be updated. The part I am having trouble with now is how to push the updated aliases there. I am sure I am missing something super similar, but any help is greatly appreciated.

Here is a sample I'd like to load where the entry_xid is points at a column entry.

here is my workflow:

here are the settings for the output:

Greg_Murray

@PetrH,

We upgraded to 2020.4 last week and I can confirm that updating the field via the API works through the Swagger UI. I'll work through the Alteryx piece when I can find some time.

Thanks,

Greg

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703