Need a special offer?Find out if your project fits.
+

Accelerator CONNECTION_STRING only works if DATABASE specified

Resolved
Craig Button asked on June 13, 2022

Hello,
We are connecting to our analysis services through accelerator but we have to specify the Database in the config instead of using the catalogue option in the datasource 
"CONNECTION_STRING=Data Source=<server>;DATABASE=<database>" - in config
"type: "microsoft analysis services",
proxyUrl: <url>,
catalogue:<database>,
cube:<model>,
withCredentials:true,
binary: true" - datasource
We were expecting to be able to change the database using the catalogue attribute but without the database specified in the config flexmonster uses the incorrect database (ignoring the one specified in the catalogue attribute), the only other databases we have are the ones created when a user logs into the analysis services (e.g. <database>_cbutton_48689ebf-6b43-4382-a8db-cd145a4bd435). 
Are we doing something wrong?
Kind regards,
Craig Button

5 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster June 14, 2022

Hello, Craig!

Thank you for writing to us.

Could you please provide us with the information of what SSAS model you are using?(multidimensional/tabular) Knowing this information will give us additional context and help to understand the described issue.

Looking forward to hearing from you.

Best Regards,
Maksym

Public
Craig Button June 14, 2022

Hi Maksym,
Its Tabular.
Kind regards,
Craig Button

Public
Maksym Diachenko Maksym Diachenko Flexmonster June 16, 2022

Hi, Craig!

Thank you for giving us more information.

Indeed, the Database property is not passed into the connection string for tabular modules. Instead, Flexmonster provides the catalog property, which corresponds to the Catalog property of the connection string.
Our team will take a closer look at the Database property usage and return to you with results, ETA 28th Jun.

In the meantime, please let us know in case any questions arise.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster June 28, 2022

Hello, Craig!

We are glad to inform you that it is now possible to set the DATABASE connection string property through the report.dataSource.catalog when connecting to the tabular model via the Accelerator.

This is included in the 2.9.28 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-28/

You are welcome to update the component. Check out our updating tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/

A kind reminder is to update Flexmonster Accelerator also: https://www.flexmonster.com/doc/updating-to-the-latest-version/#!accelerator

Please tell us if the feature works.

Best regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster July 5, 2022

Hello, Craig!

We would like to know whether our feature with DATABASE connection property works for your project. 
Looking forward to hearing your feedback.

Best Regards,
Maksym

Please login or Register to Submit Answer