Neuron ESB User Network

The Service Bus for the Connected Business

Anyone using SS 2008 as database backend for Neuron?

Views: 110

Reply to This

Replies to This Discussion

Good news / Bad news.

If your machine is already set up to converse with SQL Server 2008 then all appears to work, but have only scratched the surface.

If your machine has NOT been setup to interact with SQL Server 2008, then there appears to be missing SS2008 assemblies. Our clean machine could not query or create stored procedures via ESB Explorer.
Is there an advantage to using 2008 vs. 2005? I can't seem to find a use for the data in 2005 becase messages aren't queryable because they are sored in a binary format.
As far as I know, there is nothing "out of the box" as far as making message audits more queryable (I have already made that request).

But given that, I THINK SQL 2008 might provide a better embedded CLR experience. I have been thinking about trying to create a read-only view of the audit tables that would use CLR integration to break apart the message field into separate columns. I do not know if this is even possible (but it should be, if it isn't).

Taking this approach, should not cause any Neuron internal errors, and at the same time open the door for more useful (searchable) audit investigation.

Just my $0.02

I would be willing to collaborate.

RSS

Neuron ESB Product Support Forums and Communities

Latest Activity

Sayantini Basak posted a discussion

Maximum payload size(REST API) for requests interfacing to NeuronESB

I am new to Neuron ESB and in our current scenario,We need to process batch transactions comprising of ~1000 records and send them to Neuron ESB for further processing. I would like to understand what is the maximum size of payload that can be transferred using REST interface to Neuron ESB.See More
Jul 22
Profile IconRobert E Dunie and Sayantini Basak joined Neuron ESB User Network
Apr 28
Profile IconDayanand, Frederic C, Steffen Greve-Oksfeldt and 1 more joined Neuron ESB User Network
Mar 16
Profile IconCam Vong and Mitja Luznar joined Neuron ESB User Network
Jan 27
Profile IconWill Hitzges, Chad Parsons, michael larsen and 4 more joined Neuron ESB User Network
Jun 11, 2021
Anupama Nair posted a discussion

ODBC stored proc polling with temporary tables

We have set up an ODBC adapter to poll a stored proc.We found that if the stored proc has a temporary table defined the rows returned are always 0.Any idea why this would be and what we can do to get around it?See More
Dec 14, 2020
Prasanth Kharade is now a member of Neuron ESB User Network
Dec 30, 2019
Suman vadde is now a member of Neuron ESB User Network
Dec 16, 2019

Badge

Loading…

© 2022   Created by Neuron Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service