on 03-25-2013 12:43 PM
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:
I would prefer first approach. What do u suggest?
Guys information appreciated.
Regards,
Ajinkya
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.