Hive vs. OpenAir PSA

Hive is a powerful tool for data analysis and management that is well-suited for a wide range of scenarios. Here are some specific examples of scenarios where Hive might be particularly well-suited: Data warehousing: Hive is often used as a data warehousing platform, allowing users to store and analyze large amounts of structured and semi-structured data. It is especially good at handling data that is too large to be stored and analyzed on a single machine, and supports a wide variety of data formats. Batch processing: Hive is designed for batch processing of large datasets, making it well-suited for tasks such as data ETL (extract, transform, load), data cleansing, and data aggregation.Simple queries on large datasets: Hive is optimized for simple queries on large datasets, making it a good choice for tasks such as data exploration and summary statistics. Data transformation: Hive allows users to perform data transformations and manipulations using custom scripts written in Java, Python, or other programming languages. This can be useful for tasks such as data cleansing, data aggregation, and data transformation. On the other hand, here are some specific examples of scenarios where Hive might be less appropriate: Real-time queries: Hive is a batch-oriented system, which means that it is designed to process large amounts of data in a batch mode rather than in real-time. While it is possible to use Hive for real-time queries, it may not be the most efficient choice for this type of workload. Complex queries: Hive is optimized for simple queries on large datasets, but may struggle with more complex queries or queries that require multiple joins or subqueries.Very large datasets: While Hive is designed to scale horizontally and can handle large amounts of data, it may not scale as well as some other tools for very large datasets or complex workloads.

Incentivized

This product is well suited for an organization that is focused on client services, project delivery, time tracking, expense reporting, and revenue recognition. From a pure project management perspective, this product is not as feature rich as say Microsoft Project Server. For organizations that are looking for detailed complex project plan and resource management (along with resource leveling, etc.), this is probably not the best suited product

Incentivized

• Simplicity, it offers a clean environment without risking the outcome. An example of this are the timesheets that allow a fast way to keep track of progress
• Interaction, the different options make it faster and easier to interact and collaborate in the development of a product. An example of this would be Hive Notes for meetings
• The different visualisations it offers allow to explore the best ways to affront your projects. I really like the Gantt mappings view to understand who can be contacted at each point

Incentivized

• Netsuite OpenAir PSA is highly configurable and has a large ecosystem of assets to work with.
• Tasks are easily designed to automate processes in your business workflow.
• OpenAir is designed in such a way that it can communicate and receive information from external systems without having to re-engineer your systems to make them work if you are following standard business practice.

Incentivized

• Organizing tasks by assignees could be better. It's a little cumbersome to check off each person you want. Can you group these?
• I don't really use any view besides task view. Is there something better I could be using?
• It would be nice if attachments showed up in a nicer format, maybe with a preview?

Incentivized

• Compared to QuickArrow, setting up reports to reflect the data accurately seemed to require a bit more consultant time and collaboration. Getting the numbers correct is essential, so budget extra time for this iniative. We also learned that certain calculations can not be displayed in the executive dashboards. Ask these questions upfront to ensure your dashboards are complete for your needs (again, working backwards in the preparation stages).
• Compared to QuickArrow, NetSuite OpenAir PSA falls short in the resource management capabilities. UI, flexibility, and scheduling options all could be improved. This is on their roadmap, timeline yet to be defined. Scheduling is vitally important to our company and this is THE area where we feel is the applications weakest. However, the application does provide everything critical to scheduling and provided the elements we needed in order to be successful. We altered our scheduling process accordingly.
• During our System Administration 3 day online training, when a question was asked about detailed functionality, sometimes the trainer would share..."Yes, OpenAir has a configuration for that. Just inquire with your consultant and they can flip that flag in your instance." The responsibility for obtaining these special application configurations was placed on the System Admin [in training] to ask and to take notes. If your company needs the application to work a certain way, speak up and ask your OA consultant. There seems to be MANY flags that can be flipped in the background to allow for the system to meet your needs. My complaint is that these are not published, rather made available if one inquires.
• OpenAir is able to generate invoices directly and we strongly encourage using this feature to keep everything housed under one application. However, this did not work for our organization and we leveraged a financial integration. A bit of a pioneer integrating with Softrax -- the integration works well, however is quite fragile. We do receive appropriate support when needed, but would prefer the integration to be a bit more stable. We recommend integrating with their stated supported financial systems, as staying the course will likely net a more stable integration.

It all depends. We are still looking at moving our consultants to Oracle PAC, in order to get our financial systems in line (we use Oracle Financials currently). We are feeling a lot of pain with integration and segmented systems.

Ultimately,it depends on how much pain is felt there. OpenAir has given us a path to follow on from QuickArrow. I foresee either moving onto Oracle PAC by end of calendar, or staying on OpenAir.

OpenAir to Oracle integration is not easy. From a reporting and process perspective, there’s been pain from being in different systems

Its a easy tool, the best way to organize the workflow but has room for more improvements.

In this day and age I should not have to read a manual to understand a product. It should be intuitive to administrate and perform basic tasks. It feels like a ton of intelligence was poured into making OpenAir feature rich but no where near as much attention was given to the user experience.

Incentivized

The system up time was reliable and that was never anything we ever had any concerns/issues with.

The performance was acceptable. If you had a very large data set you were working with it might take a little longer, but within reason.

Our CSR is easily accessible and they have support built into the app itself. They also have a pretty robust support site. We also took advantage of the free trial and learned so much by putting Hive through the paces and figuring out the best way to mold it to our needs.

Incentivized

As an admin, I've had more contact with OA support than most. I've found their response to tickets typically timely and helpful, however many of the responses to tickets are "we will file an enhancement request" and then I never hear about it again. So not terrible, but not a very fulfilling experience.

Incentivized

Very knowledgeable and able to articulate how other customers configured the solution to meet their needs as well as the best practices they recommended.

We did a 3 day online remote course back in April. NetSuite prefers training to occur before migration. We went over the functionality of tool and three months later we migrated. Personally, I didn’t find it that beneficial. Certain parts of it were beneficial as they applied to me – talked a lot about invoicing capabilities that didn’t apply to me. They also have knowledge base / e-learning assets, but I haven’t referred to them

It went fine. Everything came over the way we wanted. In addition to migrating the current projects we wanted to migrate historical data – did that seamlessly. The finished product looked pretty good – just needed to tweak – and they helped us with that

Hive is a bit different than Jira and Monday, which I used mostly. Overall does a great job managing project and helps with team communication. Removes dependency of asking team members for updates by going to conference rooms. With Hive, the team updates the status, and we can easily track it.

Incentivized

OpenAir accurately reflects changes in real-time as well as lends itself to see where a draw is at, when payment is expected and what percentage of the contract has been billed or approved to date. This helps with project billing and tracking as well as cash flow. Quickbooks lacks the ability to show progress draws, approved changes, and pending changes on a given project where OpenAir excels.

Incentivized

Once the system is setup, it's easy to manage and maintain.

• Workflow Management will help you better move your projects along which saves time and money.
• Time tracking will allow you to better manage the hours and keep your contractors accountable.
• Overall visibility of projects allow you to keep your margins down and combat "bleeding" and hidden costs or surprises.

Incentivized

• It covers our requirements for time tracking and project/resource management better than the previous solution we used.
• Project managers are happier having this tool for their job and also because it is running on the cloud as opposed to running on-prem.
• It doesn't help in any way improving the "chasing" of the people that don't submit their time-sheets in time. This one stayed the same as before.

Incentivized