Skip to Content

SiePortal

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

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

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

how to fetch data from database(SQL Server 2005)

Created by: RAJKIRAN at: 2/7/2012 8:08 AM (8 Replies)

Rating (0)

Thanks 5

9 Entries

2/7/2012 8:08 AM	Rate (0)
RAJKIRAN Silver Member Joined: 8/18/2009 Last visit: 3/8/2025 Posts: 554 Rating: (33)	Dear Expert, I want to take data from database SQL sever 2005 & take into DB of PLC. How we can take this data,Please suggest any command & Document regarding this.
	Rajkiran Patil
Suggestion To thank Quote Answer

2/7/2012 8:29 AM	Rate (0)
Darius Platinum Member Joined: 9/28/2005 Last visit: 3/15/2025 Posts: 2957 Rating: (243)	Hi, Well it depends on what tools you want to use. One possibility is WinCC or WinCC Flexible. Then you can read data from SQL via script and copy it to some tag of PLC DB. Other possibility is to write your own program lets say in C# or C++, read data from SQL with it and then use OPC functions to write that data to PLC. There are lots of examples in Simatic.NET CD on how to use OPC with C++. But first you need to decide how you want to do it and the we can talk about more information.
	Best regards, Darius
Suggestion To thank Quote Answer

2/7/2012 9:33 AM	Rate (0)
fritz Diamond Expert Joined: 10/7/2005 Last visit: 3/26/2025 Posts: 3042 Rating: (1061)	Hello RAJKIRAN if you have an S7-300 and are game enough to try somehting new and (potentially) cool, you can also use a CP343-1 ERPC and get a direct link fom the CPU to a Databasethat way. Sales and delivery release for CP 343-1 ERPC Linking the CP 343-1 ERPC to a MES/ERP database I hope this helps
	Cheers fritz The advice and opinion given in this thread is that of the author and does not necessarily reflect the views of I S Systems Pty Limited. To find out how I S Systems can help you with your automation needs please visit www.issystems.com.au.
Suggestion To thank Quote Answer
This contribution was helpful to 3 thankful Users Darius Jazz_M stivanov

11/14/2017 7:10 AM	Rate (0)
stivanov Bronze Member Joined: 10/30/2012 Last visit: 6/24/2024 Posts: 73 Rating: (1)	Hello, Is there similar solution for S7-1500?

Suggestion To thank Quote Answer

11/14/2017 7:22 AM	Rate (0)
Duris_I Diamond Expert Joined: 4/28/2015 Last visit: 2/24/2025 Posts: 10832 Rating: (836)	Hello, maybe one solution is S7-1500 SQL
	With best regards... Ivan Duris Flight: OMICO
Suggestion To thank Quote Answer

11/14/2017 7:38 AM	Rate (0)
stivanov Bronze Member Joined: 10/30/2012 Last visit: 6/24/2024 Posts: 73 Rating: (1)	Hi, I saw it, but wondered if there is hardware option.

Suggestion To thank Quote Answer

11/14/2017 8:54 AM	Rate (0)
DJ_1 Gold Member Joined: 2/27/2014 Last visit: 2/18/2025 Posts: 689 Rating: (201)	Hello, Its soft controller based solution but which needs to be installed on specific SIMATIC IPC. Might be following solution can work for you by using industrial data bridge. https://support.industry.siemens.com/cs/ww/en/view/109483465 WinCC/IndustrialDataBridge: Writing data from SIMATIC WinCC or from SIMATIC controllers in MS Office files https://support.industry.siemens.com/cs/ww/en/view/104117374 How do you exchange data between the SIMATIC WinCC Industrial Data Bridge (IDB) and a SIMATIC S7 controller? https://support.industry.siemens.com/cs/ww/en/view/109745926 SIMATIC WinCC/IndustrialDataBridge V7.4 SP1
	With Best Regards, DJ TIA Portal - Your Gateway to automation in the Digital enterprise If you feel this post is useful then don't forget to rate it
Suggestion To thank Quote Answer
This contribution was helpful to 2 thankful Users stivanov Duris_I

11/15/2017 12:22 PM	Rate (0)
Murof Platinum Member Joined: 8/3/2009 Last visit: 3/25/2025 Posts: 15062 Rating: (1872)	Hello Additional Information: -> you could also Use the industrial Databridge without using WinCC Look here are also information: Bye Murof
	Last edited by: Jen_Moderator at: 11/15/2017 2:47:52 PM Inserted video. If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

12/30/2019 7:32 AM	Rate (0)
5136105 Posts: 2 Rating: (0)	Murof Hello Additional Information: -> you could also Use the industrial Databridge without using WinCC Look here are also information: Bye Murof Hello Murof, Can you share more detail please?
5136105 Posts: 2 Rating: (0)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on