Invalid SSLMODE postgres bulk insert connection

[Joshman108]

I am trying to Delete Data and Append via the PostgreSQL Bulk Loader (pgbl:) via a system dsn datasource.

It fails with 

 

I have tried configuring the dsn with every available ssl option (disable, allow, prefer, require, verify-ca, verify-full) the first four of which all produce the same error, the same two producing a different error.

Using and ODBC connection succeeds, but is unusable because it's too slow.

Does anyone know what I need to do here?

Thanks

[BrandonB]

The SSL option should be the same one that you use in the SSL Options of your ODBC connection if you go to your ODBC connection manager and click configure. 

[Joshman108]

You make it sound like there's an ssl option within alteryx that should be set to match my odbc ssl option,

But I don't see anything in alteryx that I should set?

[BrandonB · Accepted solution]

Ah I see the issue - I can tell that you changed from PostgreSQL ODBC to PostgresQL Bulk in the dropdown. Can you instead go to the data sources page and pick Bulk?

[Joshman108]

Perfect, thanks!

[NicolasFabre81]

I am migrating from Alteryx 2019.3 to Alteryx v2021.4, and getting the same issue while trying the new postgreSQL bulk INSERT.

I connect with a connect string like this :

Driver={PostgreSQL UNICODE};Server=PFADC2PXXX;Port=54XX;Database=sab_pfdc_xxxx;Uid=usrxxxx;Pwd=__EncPwd1__;|||mytable

I added sslmode=disable at the end as documented here : https://www.connectionstrings.com/postgresql-odbc-driver-psqlodbc/

Driver={PostgreSQL UNICODE};Server=PFADC2PXXX;Port=54XX;Database=sab_pfdc_xxxx;Uid=usrxxxx;Pwd=__EncPwd1__;sslmode=disable|||mytable

But still getting the same error message

It works if I change my ODBC connection and use a DSN connection. Is it a connect string issue ?