Database Connection : Not Connecting

[jmclarnon3]

Input Data (281) Unable to translate alias Clarity Connection

This is the error I keep getting, does anyone know how to resolve?

I cannot run this workflow - I have downloaded the driver and still no resolution

Many thanks

[fmvizcaino]

Hi @jmclarnon3 ,

The workflow you are trying to run uses a Gallery Data Connection, which is created by your server admin and shared with all users.

It is basically a way for admins to guarantee the connections will always work on the server. Here is more information about it if you are interested. https://knowledge.alteryx.com/index/s/article/Gallery-Data-Connections-FAQ-1583461562803

Your issue is that you don`t have access to the connection, so if you try running on the Gallery or in your Designer, you will get that message. So you have to ask your admin to share the connection with you.

https://knowledge.alteryx.com/index/s/article/Troubleshooting-Unable-to-translate-Alias-with-Gallery...

Best,

Fernando Vizcaino

[jmclarnon3]

Thanks for the reply - we are not using a gallery data connection

We are using a SQL database

[fmvizcaino]

Hi @jmclarnon3 ,

A SQL database could be configured as a Gallery Data Connection. I believe another option is that a user created an alias for his connection and shared the workflow later with you. In that case, you would need to recreate the connection by yourself.

Both cases would look like this.

Did anyone share the workflow file with you, or did you download it from the Gallery? 

Best,

Fernando Vizcaino

[jmclarnon3]

Hello,

Yes, it was shared with me.

I will try to re-create the connection and hopefully that works.

Many thanks