Overall Satisfaction with PostgreSQL
PostGre SQL is the relational data source for our Tableau Data. It holds data ETL-ed from MQ Listener via SSIS. This application houses all the patient and long term care facility details in a normalized relation data model. Tableau connects to Postgres and joins/massages the data to produce business consumable reports.
- Edit data after View
- Instantaneous access and update for Tableau extracts hooked to this data source
- Simple syntax for DDL
- The Data layer for Tableau is being met and reports can be produced quickly at a summarized level
Oracle: Ideally suited for a large enterprise. Expensive product.
MS Access: Scalable for medium to small businesses
DB2: Needs expertise to implement in an organization
MS Access: Scalable for medium to small businesses
DB2: Needs expertise to implement in an organization
Using PostgreSQL
30 - DDL/DML
Joins on Tableau VizQL for Data Visualization
Joins on Tableau VizQL for Data Visualization
3 - Build And Integration team takes care of the Data Server
- Data Layer for Analytics
- Expand the Data Repository to other Verticals within the company
Evaluating PostgreSQL and Competitors
- Price
- Product Usability
- Third-party Reviews
- Product usability in the space of an Open Source-based Enterprise DB
- The price point for an Open-Source product is minimal, where the cost incurred is for developers working with the tool
We would want to continue using PostgreSQL for the sheer completeness of the product as to how it meets project and enterprise needs.
PostgreSQL Implementation
- Implemented in-house
Change management was minimal - Since our organization is a privately owned product company in EHR long term health care, we started out with defined goals and milestones. We had a vision of leveraging open-source products from the get go. PostgreSQL was a natural choice to house analytics data in this DB.
- There was some in-house learning curve that had to be met and
- in-house training of debelopers
PostgreSQL Training
- Online training
- Self-taught
Yes, I would strongly recommend to teams looking for an open-source EDB solution. Yes, this product is easy to learn for folks who have basic idea of PL/SQL. Yes, this product can be learned by non-technical folks with the help of product documentation and online help artifacts. With examples and code snippets, the online documentation is a great starting point.
PostgreSQL Support
Pros | Cons |
---|---|
Quick Resolution Good followup Knowledgeable team Problems get solved Kept well informed No escalation required Immediate help available Support understands my problem Support cares about my success Quick Initial Response | None |
No - It is an in-house trained team that supports softwares
Using PostgreSQL
Pros | Cons |
---|---|
Like to use Relatively simple Easy to use Well integrated Consistent Quick to learn Convenient Feel confident using Familiar | None |
- Group DDL Functions on the Schema
- Snowflake Schema