SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

S7-1200/1500 PLC to SQL

5/12/2020 8:15 PM	Rate (0)
Grantek-TCB Advanced Member Joined: 8/20/2018 Last visit: 4/4/2025 Posts: 10 Rating: (1)	Looking for the best Siemens solution to read/write from an S7-1200 PLC to an MSSQL2016 database. I will have an HMI in this project but am hoping to use a Basic/Comfort panel. Option to move to a WinCC Advanced PC Panel if that's the best option to connect SQL. Our application needs to constantly check a flag for database change and then download/update a list of barcodes (strings) to the PLC. It also needs to post regular status data (OEE data) from PLC to SQL at a regular interval. The options I've researched so far listed below. Let me know if there's anything else. From Siemens: Siemens Industrial Data Bridge VBA code using WinCC Advanced Simatic ODK 1500S SQL Driver and 3rd party options: SQL4Automation PLC2SQL PDSql Library (PLCSQLdirect)

Suggestion To thank Quote Answer

5/18/2020 3:27 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 4/25/2025 Posts: 15355 Rating: (1895)	Hello with a Basic or Comfort Panel you will not be able to connect to a SQL Server!!! only with a PC Based HMI like WInCC Advanced RT for example: https://support.industry.siemens.com/cs/ww/en/view/61883659 Check out also this Topic: LINK Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

5/19/2020 1:41 AM	Rate (0)
grrrrrroooo Platinum Member Joined: 3/16/2015 Last visit: 10/10/2021 Posts: 1250 Rating: (174)	I haven't tried this yet and intend to shortly. If you are inclined to connect to SQL with your s7-1200 it looks like it is now possible. Link Attachment sqlS7-1200.PNG (476 Downloads)
	Last edited by: Kal.A at: 06/17/2020 16:47:42
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Grantek-TCB

6/18/2020 8:04 AM	Rate (0)
Jen_Moderator Diamond Member Joined: 6/19/2017 Last visit: 9/6/2024 Posts: 8175 Rating: (174)	New question published by valerossi46 is split to a separate thread with the subject Error 8602. Best regards Jen_Moderator

Suggestion To thank Quote Answer

Share this page:

Share this page on...