Datamart is a single-tenant database that is provisioned for your organization to power advanced reporting and integrations with Data Warehouse and custom BI solutions, refreshed with your latest data on a nightly basis. This feature is an optional add-on to our Enterprise subscription plan. Please contact your account manager to inquire about pricing and availability for your organization.

Example Use Cases

1. Integration with a BI reporting tool that enables advanced reporting and visualizations on your organization’s data and trends.
2. Customize data output into BI tools and SQL flexibility to create formulas within the datamart tool itself (examples: counts, lags etc).
3. Collate Winmore data with information from disparate systems to create an executive insights and visualizations.

Configuration and System Requirements

Further information for connecting to your Datamart will be provided at the time of implementation. This includes your host, port, username, password, and database URL specification.

Note: Make sure that the supplied PORT is not blocked on your network.

You may test the connection to the Datamart database using this command from your terminal. You can find the two entries in your personalized Datamart handoff documentation.

telnet your_database_url your_database_port

Successful connection should return “Connected to..” as in:

My Computer:~ user$ telnet your_database_url your_database_port

Trying 34.225.25.97...

Connected to telnet your_database_url your_database_port.

Unsuccessful connection will not return the “Connected to..” as in:

My Computer:~ user$ telnet your_database_url your_database_port

Trying 34.225.25.97...


telnet: connect to address 34.225.25.97: Operation timed out

telnet: Unable to connect to remote host

Note: You may need to update your root certificate to ensure Winmore is a “trusted” provider. The AWS root certificate which Winmore uses is available here:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html

Helpful BI Links:

• Microsoft PowerBI Postgres Data Sources: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-sources/
• Qlik’s Postgres Connection Guide: http://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/1.0/PostgresSQL/Create-PostgresSQL-connection-with-Add-data.htm
• Tableau PostgreSQL Connection Guide: https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_postgresql.html

You can also directly connect to your Datamart via a PostgreSQL client application from your computer. Here are a few PostgreSQL client application options for consideration:

• DataGrip: https://www.jetbrains.com/datagrip/
• Postico: https://eggerapps.at/postico/
• PGAdmin: https://www.pgadmin.org/