How to save workflows in alteryx server using .indbc file connection?

Question

Hi All,

I am trying to save workflow which uses .indbc file connection to connect database. can somebody please guide me step by step how to save workflow in gallery. I tried many times, include .indbc file as asset or uncheck .indbc file in asset options. nothing works. driver is also correct.

yisoo4097 · Answer

I'd suggest using and after run without errors event to run a bat file that renames the file workflow writes. You can generate the bat file in the process to get the name you need.

world of solitaire

dataguyW · Answer

A thing that kept me from using this was small, but painful.   The Connect InDB tool allows the user to screw up the connection here.   You can connect two ways either through an alias or by using the file.

To connect to an alias you just see the name of the connection.   When you connect using a file you MUST have FILE:  C:\whateverpath.     When I swapped to the UNC I completely overlooked this an changed the string to \Myserver\Mypath\Myfile which will not work.

FILE: \MyServer\Mypath\Myfile works great.  Make sure you didn't make the same mistake. and that you and the account running alteryx in the gallery have access to the share drive.

In my opinion on the interface it should ask you if you want an alias or file and then just ask for name or path and have the tool append that FILE: at run time.

preeti121288 · Answer

I did that but it didn't work for me.