Skip to main content
Rockwell AutomationCustomer feedback

Community members recommend Rockwell Automation's FactoryTalk Transaction Manager and FactoryTalk Optix for querying SQL databases from ControlLogix PLCs.

Source: Autobound Signal API · 149 signals tracked for Rockwell Automation · updated

Get Rockwell Automation's live signals in Claude or ChatGPT, or by API

AskWhat changed at Rockwell Automation this week? Use Autobound signals for rockwellautomation.com.

What happened

Post: "SQL query directly from a Rockwell PLC"

Source

RedditNov 13, 2026By u/turmeric_for_color_

r/PLC

SQL query directly from a Rockwell PLC

upvotes
16
comments
45

Post

Has anyone ever done this? I want to basically query if a number is in a SQL column or not. I know there are hardware solutions like the Softing tManager module, but I would rather not use that if I don't have to. I see some youtube vidoes of a company called Arc Automaton Consulting showing some SQL libraries they sell or sold at one point.

Extracted from these lines

  • [comment u/Fat_cat_syndicate] Rockwell's native solution for this is Factory Talk Transaction Manager (formerly known as RSSql).

  • [comment u/Psychological-End940] Try the new FT Optix software. You can run it on PC, or a HW (Compute module, HMI etc). PLC to SQL is built in feature

reddit.com/r/PLC/comments/1xvhpj9/sql_query_directly_from_a_rockwell_plcRead the full source

Comments on the post

5 of 45 comments
  • “You could also use your SCADA to transact with SQL. We do this with AVEVA Intouch.”

    u/greenflyingdragon23 points · Nov 13, 2026View

  • “Rockwell's native solution for this is Factory Talk Transaction Manager (formerly known as RSSql). You can trigger a transaction from a tag, use that transaction to perform a database function, then return the value.”

    u/Fat_cat_syndicate21 points · Nov 13, 2026View

  • “I used Node Red to do this and it worked well”

    u/Derby_Sanchez11 points · Nov 13, 2026View

  • “Try the new FT Optix software. You can run it on PC, or a HW (Compute module, HMI etc). PLC to SQL is built in feature, but you have oppurtunity write own C# based code, i'm forward data FROM SQL to PLC with this”

    u/Psychological-End94011 points · Nov 13, 2026View

  • “Implementing any SQL protocol on a PLC would be a non-trivial exercise. implementing a custom "here is a number, respond with a 1 or 0 indicating its presence or absence in an SQL column" protocol would be simpler. It could be implemented in Python in maybe a couple dozen lines, more to cover edge cases gracefully (return 2 for failures). It could be implemented as a Modbus client on the Rockw”

    u/drbitboy5 points · Nov 13, 2026View

Extracted by Autobound

From the Signal API record
Signal
Customer feedback

What this signalsUser posts often show product pain before it reaches reviews or churn.

Subreddit
r/PLC
Event date
Nov 2026

Companies

  • SoftingAlso named

The full record

From the Signal API record

Numbers

Mentions
4

Details

Timing
Ongoing state
Category
Features
Virality
High
Post kind
Text
Prominence
Aside
Company's role
Vendor

Topics and mentions

Topics

  • plc
  • sql
  • scada
  • iiot

Flair

  • PLC Question

Products named

  • FactoryTalk Transaction Manager
  • FactoryTalk Optix
  • RSSql

Extraction

Sentiment
Positive
Detected
Nov 13, 2026
signal_type
reddit-company
signal_subtype
customerFeedback

Use this data

Get every Reddit signal for Rockwell Automation and the companies you sell to, in the tools you already use.

  1. Ask Claude about it

    Connect Autobound to Claude, Claude Code or Cursor with MCP. Then ask: “What changed at Rockwell Automation this week?”

  2. Send it to your own tools

    The Signal API returns Reddit signals for any list of companies as JSON, for your CRM, warehouse or app.

  3. Try it free

    Sign up and spend your free credits on the companies you sell to.

    Start Free1,000 free credits

The API returns more than this page shows

This page shows a preview. The full reddit-company record in the Signal API and MCP can also have these 8 fields. Some fields are empty for some signals.

Company

  • linkedin_urlValue in the API
  • industriesValue in the API
  • employee_count_lowValue in the API
  • employee_count_highValue in the API
  • revenueValue in the API
  • descriptionValue in the API

Signal

  • signal_nameValue in the API
  • associationValue in the API
Show the full JSONThe record on this page and the API request

GET /v1/signals/5c9eb57c-fe72-54d6-a07e-c04c0dde6961 returns this record as JSON. POST /v1/companies/enrich returns every signal for rockwellautomation.com.

{
  "signal_id": "5c9eb57c-fe72-54d6-a07e-c04c0dde6961",
  "signal_type": "reddit-company",
  "signal_subtype": "customerFeedback",
  "detected_at": "2026-11-13T19:46:41+00:00",
  "company": {
    "name": "Rockwell Automation",
    "domain": "rockwellautomation.com"
  },
  "data": {
    "nsfw": false,
    "stage": "none",
    "awards": 0,
    "timing": "ongoing_state",
    "topics": [
      "plc",
      "sql",
      "scada",
      "iiot"
    ],
    "post_id": "1xvhpj9",
    "summary": "Community members recommend Rockwell Automation's FactoryTalk Transaction Manager and FactoryTalk Optix for querying SQL databases from ControlLogix PLCs.",
    "category": "features",
    "comments": [
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19sl7rovji7ky/",
        "depth": 0,
        "score": 23,
        "author": "greenflyingdragon",
        "excerpt": "You could also use your SCADA to transact with SQL. We do this with AVEVA Intouch.",
        "posted_at": "2026-11-13T19:48:40.000Z",
        "author_url": "https://www.reddit.com/user/greenflyingdragon/"
      },
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19sl7zbycpn8g/",
        "depth": 0,
        "score": 21,
        "author": "Fat_cat_syndicate",
        "excerpt": "Rockwell's native solution for this is Factory Talk Transaction Manager (formerly known as RSSql). You can trigger a transaction from a tag, use that transaction to perform a database function, then return the value.",
        "posted_at": "2026-11-13T19:53:26.000Z",
        "author_url": "https://www.reddit.com/user/Fat_cat_syndicate/"
      },
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19sl7zhswwijm/",
        "depth": 0,
        "score": 11,
        "author": "Derby_Sanchez",
        "excerpt": "I used Node Red to do this and it worked well",
        "posted_at": "2026-11-13T19:53:32.000Z",
        "author_url": "https://www.reddit.com/user/Derby_Sanchez/"
      },
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19slacpxk2g2q/",
        "depth": 0,
        "score": 11,
        "author": "Psychological-End940",
        "excerpt": "Try the new FT Optix software. You can run it on PC, or a HW (Compute module, HMI etc). PLC to SQL is built in feature, but you have oppurtunity write own C# based code, i'm forward data FROM SQL to PLC with this",
        "posted_at": "2026-11-13T20:46:37.000Z",
        "author_url": "https://www.reddit.com/user/Psychological-End940/"
      },
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19sl8rch8lwwy/",
        "depth": 0,
        "score": 5,
        "author": "drbitboy",
        "excerpt": "Implementing any SQL protocol on a PLC would be a non-trivial exercise.\n\n implementing a custom \"here is a number, respond with a 1 or 0 indicating its presence or absence in an SQL column\" protocol would be simpler. It could be implemented in Python in maybe a couple dozen lines, more to cover edge cases gracefully (return 2 for failures).\n\n It could be implemented as a Modbus client on the Rockw",
        "posted_at": "2026-11-13T20:10:53.000Z",
        "author_url": "https://www.reddit.com/user/drbitboy/"
      },
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19sldt9ffihuq/",
        "depth": 0,
        "score": 4,
        "author": "MinisterOfSauces",
        "excerpt": "I wrote odbc bindings and a fully featured sql library for a former company's codesys based controller that ran Linux under the hood. It was done with binding to a matching c++ library. We had added functionally to allow customers to call C libraries, but without that it would have been impossible without internal dev tools.\n\n I can't imagine doing that on a normal plc, especially AB, directly to",
        "posted_at": "2026-11-13T22:04:10.000Z",
        "author_url": "https://www.reddit.com/user/MinisterOfSauces/"
      },
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19sl8o484zaw2/",
        "depth": 0,
        "score": 3,
        "author": "Key_Director_4450",
        "excerpt": "There is a free library for Siemens PLCs to do that.\n\n If you have Tia portal you can import it and read the code, it's all just plain ST.",
        "posted_at": "2026-11-13T20:08:52.000Z",
        "author_url": "https://www.reddit.com/user/Key_Director_4450/"
      },
      {
        "url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/comment/19sl7ztam3468/",
        "depth": 0,
        "score": 3,
        "author": "its_the_tribe",
        "excerpt": "Yeah I'm thinking some scada/hmi option or node red. Or you create a Lil python script on your dB that has an open socket your plc can send messages to. Then the python does the query and sends back a message. This Is how many wcs works.",
        "posted_at": "2026-11-13T19:53:44.000Z",
        "author_url": "https://www.reddit.com/user/its_the_tribe/"
      }
    ],
    "evidence": [
      "[comment u/Fat_cat_syndicate] Rockwell's native solution for this is Factory Talk Transaction Manager (formerly known as RSSql).",
      "[comment u/Psychological-End940] Try the new FT Optix software. You can run it on PC, or a HW (Compute module, HMI etc). PLC to SQL is built in feature"
    ],
    "virality": "high",
    "post_date": "2026-11-13T19:46:41.000Z",
    "post_kind": "text",
    "post_text": "Has anyone ever done this?\n\nI want to basically query if a number is in a SQL column or not.\n\nI know there are hardware solutions like the Softing tManager module, but I would rather not use that if I don't have to.\n\nI see some youtube vidoes of a company called Arc Automaton Consulting showing some SQL libraries they sell or sold at one point.",
    "sentiment": "positive",
    "subreddit": "PLC",
    "event_date": "2026-11",
    "post_flair": [
      "PLC Question"
    ],
    "post_title": "SQL query directly from a Rockwell PLC",
    "prominence": "aside",
    "source_url": "https://www.reddit.com/r/PLC/comments/1xvhpj9/sql_query_directly_from_a_rockwell_plc/",
    "entity_role": "vendor",
    "post_author": "turmeric_for_color_",
    "upvote_ratio": 0.8636363636363636,
    "mention_count": 4,
    "mention_surge": true,
    "subreddit_url": "https://www.reddit.com/r/PLC/",
    "total_upvotes": 16,
    "comments_total": 45,
    "total_comments": 45,
    "other_companies": [
      {
        "name": "Softing",
        "role": "alternative",
        "domain": "softing.com"
      }
    ],
    "post_author_url": "https://www.reddit.com/user/turmeric_for_color_/",
    "signal_category": "feedback",
    "comments_included": 16,
    "products_mentioned": [
      "FactoryTalk Transaction Manager",
      "FactoryTalk Optix",
      "RSSql"
    ]
  }
}

Long text fields are shortened on this page.

Looking up one signal by its id is free. Enrich costs 2 credits per signal returned; a call with no results is free.