S7-1200 to SQL

mk42 · May 13, 2020

Thomas_v2 said:
Today Siemens released an application example of how to connect to a MS SQL server with a S7-1500.
I haven't tested it, but from what I've seen I think it may also run on a S7-1200 with minor modifications:

https://support.industry.siemens.com/cs/document/109779336

Good find, sir! note on 1200 usage, from the documentation:

Under the following conditions, this module is also functional with an S7 1200 from firmware V4.4 or higher:

•Do not use the archive functionality

•Comment out program line 386 of the "LSql_Microsoft" block. To do this, open the block and click on "Edit type". Now find program line 386 with the "WriteToArrayDB" instruction and comment it out.

mass89 · May 13, 2020

Thomas_v2 said:
Today Siemens released an application example of how to connect to a MS SQL server with a S7-1500.
I haven't tested it, but from what I've seen I think it may also run on a S7-1200 with minor modifications:

https://support.industry.siemens.com/cs/document/109779336

Wow thanks I read that it will work with the 1200 also, I think I owe you a beer or two if it works

rQx · May 13, 2020

I will also thank you for this link. I've been up to trying to get s7-1200 message MQTT to AWS IoT and then Lambda function to MySQL RDS. Now maybe I can try with s7-1200 straight to the AWS RDS

mk42 · May 14, 2020

rQx said:
I will also thank you for this link. I've been up to trying to get s7-1200 message MQTT to AWS IoT and then Lambda function to MySQL RDS. Now maybe I can try with s7-1200 straight to the AWS RDS

It looks like the Siemens app note is specifically for MS SQL. It is implementing a more or less proprietary protocol; I haven't been able to find any other DB systems that support it (except Sybase, which MSSQL is based on).

rQx · May 14, 2020

mk42 said:
It looks like the Siemens app note is specifically for MS SQL. It is implementing a more or less proprietary protocol; I haven't been able to find any other DB systems that support it (except Sybase, which MSSQL is based on).

On AWS RDB I can create a public ms SQL database running on the cloud, I was hoping I could access is with this block over internet, but I'm probably wrong

mk42 · May 15, 2020

rQx said:
On AWS RDB I can create a public ms SQL database running on the cloud, I was hoping I could access is with this block over internet, but I'm probably wrong

Oh, you said MySQL in the first mesage, which was what I was addressing.

In Theory, I don't know why you wouldn't be able to reach a DB in the cloud, but in Practice I've heard that getting the certificates set up correctly to do it in a secure way (TLS) can be challenging.

rQx · May 15, 2020

mk42 said:
Oh, you said MySQL in the first mesage, which was what I was addressing.

In Theory, I don't know why you wouldn't be able to reach a DB in the cloud, but in Practice I've heard that getting the certificates set up correctly to do it in a secure way (TLS) can be challenging.

I was not clear in my post

I dont think you need certificates to the AWS RDS. I have set up s7-1200 to the AWS IoT core module and there you have to have certificates, but after many hours I got it working.

So now on to the RDS

rQx · May 20, 2020

I have setup a project that is working with the function block in the application with a s7-1200 writing to MsSQL in Amazon webservices.

Only thing is that I had to comment out the whole TRCV block in the FB, that is not stated to do so in the manual. Don't know what purpose the TRCV block serves though.

Hopefully this will help someone not spending several hours figuring this out...

/Tim

S7-1200 to SQL

mk42

Lifetime Supporting Member

mass89

Member

rQx

Lifetime Supporting Member

mk42

Lifetime Supporting Member

rQx

Lifetime Supporting Member

mk42

Lifetime Supporting Member

rQx

Lifetime Supporting Member

rQx

Lifetime Supporting Member

Similar Topics