-
How to move the Pyramid repository location
The following explains how to move the Pyramid repository location to another server if needed. You first need to stop the services to change your Pyramid repository location.…
-
How to add a CData custom connector as a data source
A step-by-step guide on how to add a CData custom connector as a data source. Download the Java JDBC driver for the data source you want to connect to. (Click here for a complete list of the…
-
How to backup and restore a PostgreSQL database via DBeaver
This article discusses how to back up and restore your PostgreSQL database via DBeaver. There is another way to do it via the windows command line, as described in this article:…
-
Creating a test environment from a production repository
The following article will cover PostgresSQL, SQL, And Oracle databases. Postgres When using Postgres as the Pyramid repository, to create a copy of an existing environment,…
-
Retrieving XMLA to analyze cube structure
Below are instructions on how to get the cube structure (dimensions, hierarchies, measures…) It can help the Pyramid development team debug cases where the query fails to get the cube metadata.…
-
Routine Content Backup Recommendations
The following are items we Recommend backing up periodically. (Preferably Daily but it's up to you) The database repository. If you don't know where it is, browse to HTTP:…
-
How to hide Microsoft SQL databases that a user does not have access to
By default even if a user does not have access to an Microsoft SQL database they can still view it when logging into SQL Management studio. Therefore the same behavior will be seen in Pyramid when…
-
How to backup and restore a PostgreSQL database
Before upgrading Pyramid, it is strongly recommended to back up the Pyramid repository database. This article explains how to back up and restore a PostgreSQL repository database using the command…
Pyramid Internal Databases (The Application Repository)