Show TOC

Object documentationInSQLPCo Connector Locate this document in the navigation structure

 

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.