LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

I need to perform a query against a SQL Server database, but do not see a node for SQL Server. Is there a way for me to query data from SQL Server into BRAIN.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: skim

You will need to use JDBC Query node (if using "core" lib) or jquerydump (if using "basic" lib).

You will need to download JDBC driver for MS SQL server from Microsoft and put the jar files in your CLASSPATH in order to do so. The JDBC driver documentation that comes with the driver should have this information, but basically, you will need the following:
[ul]
[li]JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver[/li]
[li]JDBC URL: jdbc:microsoft: sqlserver://host: port[/li]
[/ul]
The only trouble I had with JDBC to MS SQL Server is that it did not support all of the metadata feature, so I had to specify all of the names in the table in my query (as opposed to "SELECT * FROM a_table").

Good luck!

Post edited by: skim, at: 2007/03/12 07:15

Post edited by: skim, at: 2007/03/12 07:15

Post edited by: skim, at: 2007/03/12 07:20<br><br>Post edited by: skim, at: 2007/03/12 07:25