From the Servers page, you need to connect to the server that stores the required database. You must select the required server and enter the connection details, like display name, port, username, and password.
Connect to a Server
To connect to a server, choose the required server from the Data Source Type dropdown list. The required details depend on the server type selected, but include:
- General: Enter the basic details, including the Data Source Type and the Display Name.
- Connection: Enter the general connection details, including the server's name or IP address and port.
- Security: Enter the Authentication Details (Username and password). Note: Some data sources support Windows authentication.
- Optional: Some server types support optional parameters.
- Click here for a list of data sources and how to connect to them.
Once you've entered the connection and security details, you can click Test Server to test the connection.
Related Capabilities
Some servers support additional capabilities: these capabilities will appear beside the selected server and can be enabled or disabled.
Write Capable
Certain types of data sources are write-capable. This means that Pyramid can actually use them as a DESTINATION for data that has been processed and cleansed in the Data Modeling tool. By checking this box, you allow users with Write access to create new databases on the targeted machine using that data stack application / service.
Note: Users need to be given explicit write access to a server beyond making the data server write-able.
Security and Metadata Overlay
Security and Metadata overlays in Pyramid are NOT automatically extended to MS SSAS (OLAP / Tabular) and SAP Hana. To extend this functionality, the overlay function must be enabled in the server setup page. This will provide overlaid controls for server, database, and model security, as well as hierarchy and measure security and metadata.
Note: Pyramid member level security is not provided for these engines - since these tools provide their own engines for member or row level security.
Pulse Remote Data Access
If Pulse Servers have been deployed, a remote data source can be set to use Pulse server for remote connectivity.
- Click here for more information