Using a Central Database on Dataminer

Solved602 views
1
0 Comments

Good afternoon team,

You could support us by mentioning which tables should be created in a SQL server where the central Dataminer database is going to be deposited, this as a requirement so that the Dataminer agents can deposit the information in the repository (SQL Server)

Thanks in advance.

Regards

Javier Gordon Selected answer as best 22nd March 2021

2 Answers

3
15.99K 0 Comments

Hi Javier,

You can find this information in DataMiner Help - Setting up an offload database.
There are instructions for MySQL, MSSQL and Oracle DBs:

In MSSQL:

a.Open Microsoft SQL Server Management Studio, and connect to the SQL server with the user account you created earlier.

b.Right-click Databases and select New Database.

c.Fill in “SLDMSDB” as Database name, and click OK.

d.From the C:\Skyline DataMiner\Tools directory, run the following script to create the tables: CentralTableDefSQLServer.sql.

Javier Gordon Selected answer as best 22nd March 2021
2
8.65K 0 Comments

Hi Javier,

this is probably the information you are looking for: DataMiner Help

Ben Vandenberghe [SLC] [DevOps Enabler] Answered question 22nd March 2021