Can we connect our orchestrator to our Microsoft SQL Server Management Studio

Help Orchestrator
,
1

Is there any possibility to give connection between our orchestrator and database?

2

Hey!

What exactly are we trying? I mean what kind of data we’re trying to deal with?

We can store the credentials in database and we can fetch the credentials from databases to orchestrator directly.

Are you looking for the same?

Regards,
NaNi

3

As same as fetching the credentials from database to orchestrator, do we have any chance to get how many records in the database from last month and how many types of records?

4 
	 
--Count all records in your uipath database:

SELECT
SUM(sPTN.Rows) AS 'Total number of records in Uipath Orchestrator'  
FROM
     sys.objects AS sOBJ
     INNER JOIN sys.partitions AS sPTN
           ON sOBJ.object_id = sPTN.object_id
WHERE
    sOBJ.type = 'U'
     AND sOBJ.is_ms_shipped = 0x0
     AND index_id < 2 -- 0:Heap, 1:Clustered

Example:

image
image723×663 14.5 KB

If you need to check by each table individually:

SELECT
     QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName]
     , SUM(sPTN.Rows) AS [RowCount]
FROM
     sys.objects AS sOBJ
     INNER JOIN sys.partitions AS sPTN
           ON sOBJ.object_id = sPTN.object_id
WHERE
    sOBJ.type = 'U'
     AND sOBJ.is_ms_shipped = 0x0
     AND index_id < 2 -- 0:Heap, 1:Clustered
GROUP BY
     sOBJ.schema_id
     , sOBJ.name
ORDER BY [RowCount] DESC

Example:

image

5

Can you please let me know about orchestrator database.

6

Your question/requirement is not clear. What do you want to achieve?

7

My client wants me to to connect orchestrator to Microsoft SQL server management database…

Is it possible to connect?

Correct me if i am wrong.

8

Example:

image

9

The above Login and Password are the credentials of our orchestrator Database right?

10

I provided in the above screenshot what this should look like.

Who installed the customer’s Orchestrator or the customer’s Orchestrator admin should know the details for the connection.