Run SQL from local server?

unknown

 How do I set up the SQL Query Node to pull data from a local SQL server?

0712131256598360.doc

john-miller

Microsoft or Oracle SQL?  I'll assume Microsoft. On your default system configuration (Usually main) Go to the JDBC tab and enter the following:

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Database URL: jdbc:sqlserver://<IPAddress>:<PortNumber>;databaseName=<DatabaseSchemaName>

User: <User>

Password: <Password for user>