cancel
Showing results for 
Search instead for 
Did you mean: 
SOLVED

CtrlX SQL Database Integration

Taktt
New Poster

CtrlX SQL Database Integration

I've got a customer who wants to tie their CtrlX system into a SQL database to read/write data.  I've seen that there are some SQL libraries for sale on the codesys store.  Does anyone know whether these are compatible with ctrlX?  They say Codesys v3.5 is the requirement, so I'm assuming this should be compatible.

If anyone has another way they've solved this, I'm open to that as well.

https://store.codesys.com/en/mysql-library-sl.html 

2 REPLIES 2
CodeShepherd
Community Moderator

Re: CtrlX SQL Database Integration

There are several possibilities depending which SQL database you like to use:

  1. MySQL:
  2. Microsoft SQL
bclapperton
Established Member

Re: CtrlX SQL Database Integration

@CodeShepherd Please clarify,

I can see that Node Red can enable CtrlX to both read from and write to an SQL databases. 

However, can Telegraf and Device Bridge read and write? Most of the information/flow diagrams I can see shows data going from a PLC to a database. Not the other way round. 

Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist