Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


One System to Rule Them All


One System to Rule Them All

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36176 Visits: 18751
Comments posted to this topic are about the item One System to Rule Them All

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8366 Visits: 6161
I am an advocate for the "specific system for a specific function" school of thought as opposed to "we will buy in a very expensive ERP system and customize our whole company around it". The latter tends to force a company to change its business processes to be closer in line with what the ERP can handle rather than find a system that is a close match to requirements. Also they both end up in an imperfect situation.

What I really prefer is customisable COTS systems that are best of breed and have an open API to the data because it is assumed that the data is the purchasing business' (as opposed to the supplier's or their system's). This leads to a system that is easily replaceable because it is isolatable but not necessarily worth replacing because it does, or at least it should do, a reasonable job. This also allows for bespoke development of systems to integrate with an enterprises' business systems ecosystem where there is no COTS software applicable.

I guess this boils down to "although I love coding, I must only code what I have to". Reuse, support, maintainability, etc. are the cornerstones of my opinion.

This follows on from how I develop systems; I reuse off the shelf components as I wouldn't dream of implementing a RDBMS, for example.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Yet Another DBA
Yet Another DBA
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 1207
Gary Varga (8/13/2014)
..... opposed to "we will buy in a very expensive ERP system and customize our whole company around it". The latter tends to force a company to change its business processes.....


Yep, come across those situations before. Seen it in large multinationals and also in a smaller sub 1000 person company.

I tend to be wary of "solutions" that become too difficult to move away from. If they offer proper exports and proper interfaces then it tends to be be because they are sure of what they do and have a good product.
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8366 Visits: 6161
Yet Another DBA (8/13/2014)
...I tend to be wary of "solutions" that become too difficult to move away from. If they offer proper exports and proper interfaces then it tends to be be because they are sure of what they do and have a good product.


Totally agree. Also you mention size of company. That matters a lot too.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
eric.notheisen
eric.notheisen
SSC-Enthusiastic
SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)

Group: General Forum Members
Points: 101 Visits: 258
Having participated in the design and development of enterprise level integrations at several large organizations, I need to say the development team frequently has little to no input on decisions made to purchase large ERP applications. Someone gets to the CIO or CTO and sells the features of the ERP, whether it is Solomon, Great Plains or JD Edwards. Development teams then have to design the integration so existing systems will interact with it.

Since we will never change the behavior of CTOs or CIOs, it behooves us to get to know the intricacies of a Software Architecture Blueprint. See http://it.toolbox.com/blogs/enterprise-solutions/system-blueprint-template-ndash-part-1-introduction-39619.

Using documentation as described in the link above allows you to see the big picture of the integration and brings into focus what is needed to succeed in the integration process.
Ed Wagner
Ed Wagner
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10309 Visits: 9594
I don't care for the "very expensive ERP" option either. I got to work with one for a period of several years and found it tedious and difficult. Let's face it...it didn't want to be customized at all. It was slow and inefficient and completely incapable of ALTERing anything. Every change involved a complete rebuild of the table, so it didn't keep any indexes we created on anything. The foreign keys were maintained by the application and not the database, which helped bloat the application. I'm thankful I don't have to work with it any more.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
chrisn-585491
chrisn-585491
SSC Eights!
SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)

Group: General Forum Members
Points: 962 Visits: 2321
Steve wrote in the editorial:

"On one hand I think that's a better way to build large systems, mainly from the standpoint of size, scale, complexity, and likelihood of completion. However I also realize this means that all companies need to account for some level of software development, either in-house or on a contract basis."

I'm that in-house programmer for my division. I write utilities that save us and our clients time. I also build custom ETL programs that make client "data" work. Yeah! Even though we are slowly switching to SSIS for some of the complex jobs, many times a small script in PowerShell or Python is the answer for the job.
Ed Wagner
Ed Wagner
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10309 Visits: 9594
chrisn-585491 (8/13/2014)
I'm that in-house programmer for my division. I write utilities that save us and our clients time. I also build custom ETL programs that make client "data" work. Yeah! Even though we are slowly switching to SSIS for some of the complex jobs, many times a small script in PowerShell or Python is the answer for the job.

I think that's called picking the right tool for the job, which is something I'm a big proponent of as a whole.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8366 Visits: 6161
Ed Wagner (8/13/2014)
chrisn-585491 (8/13/2014)
I'm that in-house programmer for my division. I write utilities that save us and our clients time. I also build custom ETL programs that make client "data" work. Yeah! Even though we are slowly switching to SSIS for some of the complex jobs, many times a small script in PowerShell or Python is the answer for the job.

I think that's called picking the right tool for the job, which is something I'm a big proponent of as a whole.


I think you will find much support for that thinking.

As an aside, I initially scan read your response and thought (totally incorrectly) that you you were being a tad aggressive. If you cannot see it then you are a far purer soul than I am. If you can then you might chuckle Whistling

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Andrew..Peterson
Andrew..Peterson
Old Hand
Old Hand (342 reputation)Old Hand (342 reputation)Old Hand (342 reputation)Old Hand (342 reputation)Old Hand (342 reputation)Old Hand (342 reputation)Old Hand (342 reputation)Old Hand (342 reputation)

Group: General Forum Members
Points: 342 Visits: 683
I guess it all depends on who is making the decision. And what they fear.
More technology focused companies see technology as a competitive advantage, and seek out the best solution. Others see technology just as another expensive administrative bit of overhead. Until, of course a competitor gets ahead. And some exec's like the idea of having a single company to call when it breaks. Personally, I think technology focused companies will succeed.

The more you are prepared, the less you need it.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search