InSQLPCo Connector

The connector that allows SAP Manufacturing Integration and Intelligence (SAP MII) to connect to the Wonderware® IndustrialSQL Server™ (InSQL) data source.

InSQLPCo connector is similar to InSQL connector except that InSQLPCo connectoer is of type PCo. It can be used in PCo and Plant Information Catalog query as a source data server.

When you configure InSQLPCo, 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 InSQLPCo 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)

You use the SAP MII Workbench to create your queries.