yes i looked. it only has 3 drivers, none of which are for azure dw
where in the dremio installation dir is the included sql server driver and metadata file? I want to play around with it to see if i can get it working.
the jdbc driver is the same for normal sql server and azure dw, my experience in other tools is its only a slight difference in the connection string
Even when this was working there was no separate connector but you need to add as a SQL server source. There was a new stored procedure included in SQL server that was not in Azure DW and it was failing to load the datasets, you will get an error like this
2019-01-24 13:54:15,579 [metadata-refresh-sqldw] ERROR c.d.e.s.j.d.a.ArpDialect$ArpSchemaFetcher - Error listing datasets for ‘sqldw’
com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure ‘sp_msforeachdb’.
at
The sp_msforeachdb sp is an undocumented/unofficial/internal use only stored proc. You shouldn’t be using unsupported/undocumented features in a production product. And I’m not surprised it doesn’t exist in the MPP version – it doesn’t make sense there…
Numerate over the ansi sql information_schema.tables dataset instead?
if you point me to the uncompiled version of the arp file for sql server i’ll give it a shot