Procedure
To configure SQL for ADX, complete the following steps:
- From the Destination Database list, select the appropriate database name.
- In the Datasource Name field, enter a name.
- In the Username field, enter your user name.
- In the Password field, enter your password.
- In the Server IP field, enter the SQL instance server IP.
- In the DB Polling field, enter the polling time the framework checks with the Generic SQL database from new device or points added after initial discovery.
- In the Event Start Date, select the current date.
- Uncheck the Get Events check box for Enterprise Manager.
- To read timeseries data select the Get Timeseries check box.
- Select the Post Entries check box to enable USG to post entries to the cloud.
- In the Device Points section, in the Point Polling Time, select the time interval the present value for selected points is pulled in.
- In the Metadata Query tab, enter the query to read the metadata from the connected system and output column is to be the same as the parameter list.
- In the Time Series Sample Query tab, enter the query to read the timeseries from the connected system and output column to be the same as the parameter list.
- In the Events Query tab, enter the query to read the events from the connected system and output column is to be the same as the parameter list.