Anybody familiar w/ SSRS, SSIS or similar sqlserver products?: /home/Support/LabKey Support Forum

Anybody familiar w/ SSRS, SSIS or similar sqlserver products?

LabKey Support Forum (Inactive)

View Message

Anybody familiar w/ SSRS, SSIS or similar sqlserver products?

Ben Bimber

2013-03-21 08:35

Status: Closed

Does anyone at LabKey have experience w/ SQL Server's reporting/business intelligence tools like SSRS or SSIS? Maybe some of the former MS employees?

I ask b/c we're exploring the feasibility of using LabKey as a data source for these tools, and I think we would want to pull in data from LK over the HTTP APIs, rather than interact directly against the DB. The purpose of that is for security, seeing UserSchemas, etc. The most promising avenue I can see is consuming data using the same API as excel web query, which basically provides a tab-delimited table. I've seen some posts suggesting consuming web-based tab-delimited data is possible, but no actual how-tos, yet. I'd be curious if anyone has suggestions or comments. Thanks.

marki responded:	2013-03-21 10:54
We are doing some work with SSIS. We are working with other folks who use SSRS but are not using it ourselves & don't have opinions. SSIS has a lot of options and I can't claim to know them all. I would consider these options 1) Use a script component in SSIS to access the data as you said (as here: http://www.sqlservercentral.com/Forums/Topic384287-148-1.aspx ) 2) Write a script component to use the standard LabKey API. This will require some programming to wrap the LK API with .NET. Slightly bigger, extend SSIS with custom object type that can access LabKey via the API. 3) It would be great to have a Connection implementation that accesses the API. We've got an experimental JDBC driver that needs work. It could be wrapped with a bridge to link in to SSIS. Alternately a new one could be written.

Ben Bimber responded:	2013-03-21 10:55
are clients funding this? we should talk about the scope as a potential ONPRC dev item. i've available today or tomorrow if you think it makes sense to talk in person.