How can I use the Flxemonster control to connect to a MS SQL database from an angular app

I am trying to embed the Flexmonster control in an angular 6.1 app. I was able to follow the steps provided in library article for “Integration with Angular” successfully to connect to an OLAP cube on my Microsoft Analysis Server. Now I want to use a SQL database as a source for the same but I cannot figure out how to. In the library article “Connecting to DB with .NET” the following code snippet is provided. I am not sure what I should be using for filename. Can someone please help?

var pivot = new Flexmonster({
	container: "pivotContainer",
	toolbar: true,
	report: {
		dataSource: {
			dataSourceType: "ocsv",
			/* URL to the Data Compressor .NET */
			filename: "http://localhost:55772/api/flexmonster/get"
		}
	},
	licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
});

Another question is do I need the Accelerator service to connect to a SQL DB or is it only for connecting to an Analysis Server (OLAP cube)?
 
Thanks.

1 answer

Public
Iryna Kulchytska Flexmonster December 6, 2018

Hi Nilesh,
 
Thank you for posting your question on our forum.
 
We are glad that the article “Integration with Angular” was helpful with embedding Flexmonster in your angular 6.1 app.
 
Regarding your questions, the Accelerator service is only to connect to an Analysis Server (OLAP cube). To connect to an SQL DB you can use Flexmonster Data Compressor. Here is the article that explains what Flexmonster Data Compressor is https://www.flexmonster.com/doc/connecting-to-relational-database/. Flexmonster Data Compressor is available for .NET, Java, PHP, and Node.js. The article “Connecting to DB with .NET” https://www.flexmonster.com/doc/connecting-to-relational-database-with-net/ describes how to use the Data Compressor in the .NET back-end to connect to an SQL DB and how to provide this connection to the front-end Flexmonster control. Answering your direct question, for filename from the code snippet you need to use the URL to your back-end script that uses the Data Compressor to connect to an SQL DB and returns a streaming response.
 
Please let me know if you have any questions.
 
Kind regards,
Iryna

Please login or Register to Submit Answer