Alteryx Macro - Unencrypted Version

Question

Hi All,

I wanted to build a Alteryx Macro - Encrypted version where I can use it like other tools from the palette.

Currently we have a dynamic macro which is built in 32bit version which is not working  in Alteryx 2023.

(We have static macro which is working fine with 2023 version, in this we can't change the below mentioned values, so it will be single input.)

Could someone assist how to unencrypt the macro so that we can change the settings and use it, due to this we have 30+ workflows which is not working and it will impact the business users.

Main our requirement is we need to pass the below values as dynamically

System Environment,

User Name,

Password,

SQL Query,

Record Limit

We have to extract the data from IBM iSeries Database using the above details which will be dynamically passed in between the workflow using the ODBC connection ( We have server name, database, schema everything).

Since I'm in beginner level to Alteryx, couldn't able to figure it out how to build it. Could someone assist me to resolve the issue.

apathetichell · Answer

here are your options:

1). find/restore their laptop/backup. look for unencrypted version.

2). rebuilt the macro from scratch.

3). Ask Alteryx if they have a skeleton key - knowing that if they say yes they are effectively compromising every encrypted macro. (I don't believe this is likely).

I'd probably go for 2) - but 1) Is probably most corporate preferable.

dineshbabu2811 · Answer

@apathetichell  the partner who built the macro is not with organization now

apathetichell · Answer

Talk to whoever built it for you/encrypted it. https://www.theinformationlab.co.uk/community/blog/encrypting-your-alteryx-workflows-macros-apps/ - basically encryption is encryption - if the encryption is useful you can't negate it by sheer will power.