Identify the BIRST Spaces that use the SQL query

Christian Maldonado · 2025-03-12T20:03:18+00:00

There was an error rendering this rich post.

Is there a way to identify the BIRST spaces that are using SQL queries, or SQL credentials?
We need to replace the SQL credential in the spaces, and the BIRST account we are using is tied with hundreds of BIRST spaces.

For example, find the BIRST spaces that have extraction SQL query below:

SELECT address_id, addressname, city
FROM address

Find more posts tagged with

Accepted answers

All comments

Diane McElhiney

There is no central managing UI in Birst to display what you are asking. If you are comfortable writing code using web services, you can review our REST API (https://customerportal.infor.com/csmcore?id=kb_article_view&sysparm_article=KB2174156 for Space Level Connections). The output will at least confirm which Spaces have connections. Then you'll have to manually review the connection for a Query Based object containing the SQL statement.

Christian Maldonado

Hi Diane, Thank you I will try this.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of