SQL query to pull data directly from SSRS - Kinetic Pilot SaaS

Kinetic ERP
1

Hello,
Has anyone been able to pull data using SQL query directly form SSRS in the Kinetic Pilot SaaS environment?

2

That is not a supported Epicor configuration.

Could you hack at it and make it work? Probably.
But you would be on your own for support.

1 Like
3

I may be misunderstanding, but you cannot pull data from SSRS. SSRS gets its data from somewhere else. If it is a normal Kinetic Report, it will get it’s data from tables that have copied data from Kinetic using Report Data Definitions (RDDs). If you know what tables the data comes from, that would be the best location.
If it is a custom SSRS report, then you will have to query that report’s data source.

Also, Epicor does offer a readonly database for SaaS (extra $$$).

2 Likes
4

@Jason_Woods , you are incorrect. It is $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
:laughing: :rofl:

5

And it’s what, a day old?

6

You can.

7

Could you show or describe how you pull data from an SSRS Report?

8

Me?

9

Please. I’ve only know SSRS to be the final result, not a datasource in itself.

10
11

Isn’t that pulling data INTO SSRS, not pulling data FROM SSRS?

1 Like
12

Depends on how you read it.

I’m pretty sure he meant using SSRS to pull from a database.

13

Hence me need to clarify.

1 Like
14

SaaS Read-Only DB is a SQL replicated DB so the data is refreshed in near real time.

1 Like
15

Sweet, good to know!

16

I am sure it is not supported but it works in hosted environment.
Using the RDD I can only add the PartLot table once. I need to create a PartLot-to-PartTran relationship and then PartTran-to-PartLot01 in order to determine the issued material expiration dates.
Another question, is it possible to add SQL views to RDD as datasources?

17

Why don’t you do this as a BAQ Report?

18

I ended up with creating a BAQ report. It would have been easier for the users to just print the packing slip and the C of C reports would print automatically. now they have to print the C of C’s separately.

19

Take a look at the linked tables in the RDD. Often Epicor include the relevant linked tables, and you can then select which fields to include. If you can get some of the data this way, it leaves you free to create a link to the same PartLot table manually.

Also within the Calculated fields for an RDD, often you’ve find things such as Customer_Name, Customer_EmailAddress where you’re getting things you likely want, but “for free” because you’re not having to create a table yourself.

20

Thanks, I had tried all that without any luck.