SQL view in BAQ

Kinetic ERP
1

I created a View in SQL in our Kinetic database, can I use this view in a BAQ.

Thanks!

2

Hi - don’t do this.

Custom objects in the Kinetic database can mess up your ‘regenerate data model’ process.

Create a new database on the sql server instance and reference that through an external baq.

If your in th cloud, then I don’t think this is an option.

Cheers,

Andrew.

5 Likes
3

We have created a “Utility” database and all views and stored procedures go in there, and it’s all referenced by External Database connection. It is limiting, but in the new BAQ editor, we might be able to combine regular BAQs with External ones - otherwise you’ll need to build the whole query in the external DB and call it singularly.

4 Likes