cancel
Showing results for 
Search instead for 
Did you mean: 

Integrating SAP MII with Wonderware Industrial SQL database : need help

Former Member
0 Kudos

hi guys,

I have requirement in which SCADA has been integrated with wonderware InSQL server.

SAP MII is suppoed to connect to wonderware InSQL server and fetch data. I have below questions:

  • As per my information SAP MII has standard InSQL connector for this.? how do we set this up in SAP MII dataserver? i.e. what is connector, connector type, server URL and all to be enterd?
  • Can PCO also be used for same?

I would prefer first approach. What do u suggest?

Guys information appreciated.

Regards,
Ajinkya

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ajinkya,

I am not sure, which version of MII are you using. As per 12.2 version, InSQL connector allows SAP MII to connect to the Wonderware IndustrialSQL Server (InSQL) data source.

When we configure InSQL, configure Microsoft SQL Server to listen on TCP/IP for better security configuration and data access in distributed networks.

Below table will give you more information.

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)

Hope the above information helps.

Thanks

S.Rajesh

Former Member
0 Kudos

thank you Rajesh.

I have SAP MII 12.2 SP 4.

I need accurate details like if you have summary screenshot of an InSQL connector configured in SAP MII, then that would be of great help.

e.g. I am attaching screenshot for simple SQL connector. can you send me similar screenshot for InSQL conector? or

From InSQL connector perspective what would be the values of fields marked in red rectangles

Connector, ConnectorType, JDBC driver, Server URL, Server package?

Former Member
0 Kudos

Hi Ajinkya,

Kindly ensure you were using correct JDBC drivers for MII 12.2 version. Below link helps you to find JDBC driver http://msdn.microsoft.com/en-us/library/bb545450.aspx

As per screenshot,Connector & Conntector Type details are fine.

JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Server Package : com.sap.xmii.Illuminator.connectors.IDBC

Server URL  : jdbc:sqlserver://servername:portnumber;databaseName=name

You can ensure SQL connection is working fine, by testing it with SQL Server management studio or some other SQL database tools.

In server URL, you can replace servername with IP address and check.

In any case, check NWE logs files for appropriate errors, which helps us to narrow down quickly.

Thanks

S.Rajesh

Former Member
0 Kudos

Ok Thank you.

If my understanding is not wrong th InSQL connector would be same as normal SQL connector right?

Answers (0)