This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow that uses a batch macro to dynamically set the DB connection string on a Data Output node as in the image below. I set up a "dummy" DB connection (which is a valid one), then pipe in the real one I want to use (environment specific) via the macro's Control Parameter at runtime. Everything works great locally, but when I publish to Alteryx Server I get an Unable to translate alias message also shown below.
By seeing this post of yours (link) I am guessing this issue is solved.
The issue here is I can see you are using saved data connection alias which was configured on your desktop. Now when you move the workflow to gallery and try to run it Gallery doesn't have the saved data connection alias hence you are getting the below issue. The workaround is to use actual connection string or you can ask the gallery adim to configure this saved data connection alias
Thanks for your reply. Not sure how I implied the issue was fixed . . . it isn't.
I did ask my server admin to create a saved db connection, but unfortunately because of the sensitivity of the environment (bio-pharma) I am not allowed to share the DB password for production with him.
I'm going to shift to using an (.indbc) connection and see if that works.
can you share the config of your action tool? It should be repalceable. There may be a second parameter in the same input data that you need to change as well though. Quotes can be fairly specific on string replace as well - especially with DSN...
Thanks for taking a look at this, however I've decided to go with in-DB connections and (.indbc) connection files instead of this approach. I'm still having challenges though, as described in this new post.