SQL Relay 2016

SQLRelay

So if you’re not attending the Exasol breakfast on Friday, and data is your thing, how about SQL Relay?

Admittedly I’m a bit late on the bandwagon here. This years’ SQL Relay is already halfway through, with the Birmingham, Cardiff and Reading events already done.

Tomorrow, 5th October, is Nottingham, with the Relay wrapping up in Leeds on Friday 6th October.

I’m heading to Relay in Leeds. There’s 3 main tracks of talks, with the added bonus of a workshop track. Best of all it’s free!

My itinerary is as follows:

9.30-12.30 – Workshop on Azure Machine Learning with Amy Nicholson and Andrew Fryer from Microsoft

12.30-2.30 – Lunch / Networking (come find me!)

2.30-3.30 – DatOps Journey at Sky Betting with Andy Burgin

3.45-4.40 – Simon Whiteley discusses Diving into Data Lakes

If you know of anymore conferences free or otherwise that you think could be interesting,  get in touch and let me know.

HOW TO: Connecting to SQL Server from EXASOL

Here’s how to connect EXASOL to SQL Server.

To do this I created a connection. The following connection from EXASOL connects to the default instance of SQL Server.

CREATE CONNECTION SQLDB_CONNECTION
TO 'jdbc:sqlserver://192.168.0.2;databaseName=My_SQLDB'
USER 'sa'
IDENTIFIED BY '********';

If you are not connecting on the default port, stipulate the port with a colon as follows.

CREATE CONNECTION SQLDB_CONNECTION
TO 'jdbc:sqlserver://192.168.0.2:1435;databaseName=My_SQLDB'
USER 'sa'
IDENTIFIED BY '********';

Finally, use the connection as follows.

IMPORT INTO MYSCHEMA.MYTABLE
FROM JDBC DRIVER='MSSQL'
AT SQLDB_CONNECTION TABLE SQLSERVERTABLE;