October 18, 2021 at 12:00 am
Comments posted to this topic are about the item Connect to PostgreSQL as an External Data Source using PolyBase
October 18, 2021 at 7:01 pm
It should be noted that Postgres releases their own native ODBC driver to connect, you don't have to use CData's driver.
It can be found on their official release page here:
https://www.postgresql.org/ftp/odbc/versions/msi/
One of the trickiest and most time-consuming things about using PolyBase with Eternal Tables that use ODBC is data types and creating the External Table schema.
I discovered an easy trick to have SQL give you baseline data types without you having to code it by hand.
CREATE EXTERNAL TABLE [YourSchema].[YourTable_dummy] ( [dummy] INT ) WITH ( LOCATION = 'your_external_schema.your_external_table', DATA_SOURCE = your_data_source ); -- generate detected fields list
It will then give you the schema in the Messages tab which you can use to copy/paste the columns and data types.
October 19, 2021 at 3:35 am
It is also important to note there is a 32-bit and 64-bit installer, you can use either of them. If it is the 64-bit version, the connection options must be 'Driver={PostgreSQL ANSI(x64)};'
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy