...
- Add a new Datasource to your model and Select the driver class to match your database and check all three checkboxes on the details tab
- Click on Datasource Instances and add a new instance providing the connection string, username and password as shown below. (For SQL Server, the connection string specifies the Server, SQL Server Instance and Database)
- Save and close the Datasource.
- Hover over the Datasource and select Add a new database collector
- Check both the checkboxes on the details tab and save.
- Add a SELECT query to the query string tab and test by clicking the Run query button. You should see results from the table in your query
- Save and close the database collector.
- Hover over the database collector and select Create a new stream using the attributes returned by the query
- View the attribute expressions to confirm that each column in the query has been configured
- Run analysis on the stream and view the results
Sample Model for reading from a Database
Connection String for Local Instance of SQL Server
Attributes configured automatically from the SELECT Query
| Info |
|---|
Related articles
...