dbt vs. MasterControl Manufacturing Excellence

The prerequisite is that you have a supported database/data warehouse and have already found a way to ingest your raw data. Then dbt is very well suited to manage your transformation logic if the people using it are familiar with SQL. If you want to benefit from bringing engineering practices to data, dbt is a great fit. It can bring CI/CD practices, version control, automated testing, documentation generation, etc. It is not so well suited if the people managing the transformation logic do not like to code (in SQL) but prefer graphical user interfaces.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

MasterControl Manufacturing Excellence is excellent for creating batch records to track a specific regulated process. It helps us keep our data in line and make sure we are following our procedures. there are some difficulties with more customizable products. The more variable that are in the product the fewer features that MasterControl Manufacturing Excellence can apply to assist

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• dbt supports version control through GIT, this allows teams to collaborate and track the data transformation logic.
• dbt allows us to build data models which helps to break complex transformation logic into simple and smaller logic.
• dbt is completely based on SQL which allows data analyst and data engineers to build the transformation logic.
• dbt can be easily integrated with snowflake.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Coding is not needed to build production records
• All data input types are highly configurable from getting data collected from integrated systems all the way to simple text entries.
• Customer service is outstanding to keep our cases resolved in a timely manner.
• The updates continue to improve end user experiences and better functionality

• Field-level lineage (currently at table level)
• Documentation inheritance - if a field is documented the downstream field of the same name could inherit the doc info
• Adding python model support (in beta now)

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Collaboration within a document on MasterControl Manufacturing Excellence could be improved
• I would like to be able to put more than 1 prerequisite on a training task in MasterControl Manufacturing Excellence
• It would be nice if training aids from MasterControl Manufacturing Excellence were accessible within the application and not just their site.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

The quality service and the strong production versatility has helped us develop a great solution for our batch records. These improvements are much better than the legacy batch records and provide immediate access at multiple points across the organization. Would definitely purchase again.

dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

I receive positive feedback from manufacturing personnel about how easy it is to use when manufacturing and I also receive positive feedback from quality personnel for review batch records. We have had some deviations where operators are inputting data under other operators accounts which is really bad good documentation practices and is a compliance risk

During a few early templates, a configuration for product family had not been removed and it created an error. The subject matter expert and support desk was able to help me understand the error was builder generated and how to resolve it very quickly. This is now a non-existent occurrence.

I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT there's a FREE version for 1 dev seat with no read-only access for anyone else, so you can always start with that and then buy yourself a seat later.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

We choose Mx to try and get rid of the paper trail, assist with the improvement for GDP, ease of access and review of the production records to try and get better on releasing batches to meet demand. Having our documents, training and production records in one general area makes it easier for end user

• Simplified our BI layer for faster load times
• Increased the quality of data reaching our end users
• Makes complex transformations manageable

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• We have been able to reduce the amount of production records variability had based on product families.
• New user uptake is very high and they can learn the solution quickly.
• The ability to add formula parameters and production record linking has helped traceability.