How do I set up the SQL Query Node to pull data from a local SQL server?
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>