ER/Studio vs. Projector PSA

Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms

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 think Projector PSA is a great tool to track and manage people in a professional service environment like management consulting. This system is easy to set up, easy to understand and should easily suit the needs of smaller and medium sized firms. It may be less appropriate for firms that rely very heavily on project management through another system (like MS Project) or firms that rely very heavily on a sales pipeline tracking system. While still very much possible to use, you would (I believe) have to do some re-keying between systems

• ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type.
• ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names.
• My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models.

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

• Projector is a very well designed tool for project management. It has allowed us to eliminate a number of auxiliary tools for project timelines and WBS for the vast majority of our projects.
• Time and expense entry is intuitive and quick for our staff.
• Our forecasting and resource management capability has improved greatly with Projector and allows us to grow our team efficiently with minimal additional administrative burden.
• Reporting is extremely robust. It does require some time to really get a handle on the full functionality of the reporting tool, but once you do, you can get almost any kind of report you want out of the system!

• ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running.
• The repository can be slow when the model count gets larger. By large I mean 20 to 30 models.
• A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two.

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

• Release management process needs to be improved. Currently no facility is provided to test the impact of new releases in a sand-box. This introduces business risk if there are interfaces into Projector PSA as part of it's use in the business.

We have been using this tool for a year now and find our use of it continually evolves and broadens. We are also very excited about the overhaul that's under way and feel many of the improvements being put in place will help make us that much more effective and efficient. The Projector team is also very responsive and collaborative in terms of user feedback and improvement suggestions, which helps us know they will work hard to help us get what we need out of the tool.

Desktop interface feels complex to new users.

In 5 years of use we have never experienced an unscheduled outage.

I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.

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

ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.

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 did pursue Quick Arrow another tool that was similar. We found that be in inflexible in use. Projector allows a lot of flexibility in setup. Our organization has very specific business processes and we were able to set up Projector to work with those processes. Several other systems we tried were not as flexible in allowing set up to our needs.

• ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase.

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

• Even in the small time that I stayed to see Projector PSA reporting I saw ROI projections become more realistic. There was real data to analyze that proved we were spending way too much and charging way too less on some projects.
• Although employees were not used at entering their hours, this single reporting improved operations management and validated employees concerns that more people were needed to manage workload
• Project proposals were more realistic because they were driven by real data.
• Decision making overall for the department became more efficient and effective

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