How to set up a Bulk Loader Connection in Gallery

[gtorres8]

How to set up a Bulk Loader Connection in Gallery

Want to take advantage of the Bulk Loader and share it on your gallery, but not sure how to configure the connection? This article will guide you on how to complete this task so you can enjoy the option to house a Bulk Loader connection in your organization's gallery.
 

Prerequisites
 

• Alteryx Server
  • All versions
• SQL Server
  • 2008 R2 +
• SQL Server ODBC Drivers
  • Native Client 11
  • ODBC 13
  • ODBC 17
• Snowflake
• Snowflake ODBC Drivers
  • 2.21.7+
  • Simba 1.3.0+

Procedure

1. Go to gallery URL -> Admin page.

idea Skyscrapers

2. Click on Data Connections -> Add New Data Connection.

idea Skyscrapers

3. For the connection drop-down, select Other.

idea Skyscrapers

4. Give the desired connection name.

5. Enter the DSN or DSN-less connection string for the database platform in question as follows:

 

SQL Server (DSN-less)

ssvb:DRIVER={SQL Server XX Driver};Database=XXXX;Server=hostname\InstanceName;UID=XXXX;pwd=XXXX

Example for SQL Server Authentication/ODBC/Bulk Loader:

ssvb:DRIVER={ODBC Driver 17 for SQL Server};DATABASE=MYDB;SERVER=MYLOCALHOST\INSTANCE;UID=SQLAUTHUSER1;pwd=mypassword

Example for Windows Authentication/ODBC/Bulk Loader:

ssvb:DRIVER={ODBC Driver 17 for SQL Server};DATABASE=MYDB;SERVER=MYLOCALHOST\INSTANCE;Trusted_Connection=yes

Note 1

Once the connection is saved, the password will be encrypted with the value __EncPwd1__ in the connection string.
 

Note 2

For more information on different attributes to include in the connection string, see the Microsoft connection string documentation for SQL Server.

 

Snowflake (DSN)

snowbl:DSN=xxxx;UID=xxxx;PWD=xxxx;Staging=local;Method=user

Example for Snowflake Authentication/ODBC/Bulk Loader/Local Staging Option:

snowbl:DSN=SnowflakeDSN;UID=SnowflakeAuthUser1;PWD=mypassword;Staging=local;Method=user

Example for Snowflake Authentication/ODBC/Bulk Loader/Amazon S3 Staging Option:

snowbl:DSN=SnowflakeDSN;UID=SnowflakeAuthUser1;PWD=mypassword;Bucket=DataBucket1;Access=xxABC123xx;Secret=xxQRS987xx;URL=s3.amazonaws.com;Region=us-east-1

Note 1

The Amazon S3 URL and Region may be different based on your organization's configuration.
 

Note 2

From Alteryx Designer version 2021.4+ onwards we support Snowflake DSN-less for Bulk connections using Data Connection Manager (DCM). 

image.png

Prior to Alteryx Designer version 2021.4 Snowflake DSN-less was not supported for Bulk connections. A DSN must be used to avoid errors.


6. Don't forget to grant the appropriate user(s)/Studio(s) to the new Data Connection.

7. The data connection is ready to be used in future workflows to users that have been granted for it.

 

Additional Resources

• Microsoft Connection String Documentation
• Alteryx Data Connections Help

 

[ettoreaquino]

@GT ,

Is it possible to set up a "DSN-less" Bulk Loader for Snowflake? I've tried different strings without luck, for example:

snowbl:DRIVER={SnowflakeDSIIDriver};SERVER={myserver.snowflakecomputing.com};UID={user};DATABASE={domain_database};AUTHENTICATOR={snowflake};PWD={user_pass};Staging=local;Method=user;

I've noticed that you've only shown an example where a DSN must be provided to set up the connection. But having a lot of users and diferent business domains to proxy our connections, creating endless DSNs does will not scale.

Cheers,