InSQL Connector 
The connector that allows SAP Manufacturing Integration and Intelligence (SAP MII) to connect to the Wonderware® IndustrialSQL Server (InSQL) data source.
When you configure InSQL, configure Microsoft® SQL Server to listen on TCP/IP for better security configuration and data access in distributed networks.
Structure
The following table describes the server parameters required to configure InSQL to use the default TCP/IP protocol or OLEDB.
Parameter |
Data Type |
Description |
URL |
String |
Driver-specific string that defines how to access the database. Default: jdbc:inetdae:hammer9:1434?database=Runtime&sql7=true OLEDB: jdbc:inetdae:hammer9:1433?database=Runtime&sql7=true |
User Name |
String |
Database-specific user ID. Default: wwUser OLEDB: user account with permission to query the Runtime database |
Password |
String |
Database-specific password. Default: wwUser OLEDB: password corresponding to the User Name setting |
UseOLEDB |
Boolean |
Determines what mode is used to query the InSQL data. Default: false (default for InSQL version 7.x and earlier) OLEDB: true (default for InSQL version 8.x and later) |
The following connector modes are supported:
GroupList
TagList
History
HistoryEvent
Statistics
Current
The connector provides current values for discrete and analog tags with all versions of InSQL. If the InSQL version is 7.1 or newer, the connector also provides live values for string tags.
You do not need special modes to access the StringHistory, summary, and event tables of InSQL; you can use the IDBC connector to access these. You do not need to license and configure the IDBC connector; you can create a server in the IDBC connector, which is identical to the server in the InSQL connector, and use the SAP MII Workbench to create your queries.