Local copy database schema

Kinetic ERP
1

Hello,
is there any way we can get a sql script for the kinetic database schema because we want to create a local copy for the reporting purpose.

thanks,

Eddy

2

I don’t follow the question? You want to create an empty copy of the database structure of Epicor?

3

Hey Eddy,

I know you don’t want to hear this but I highly recommend @hkeric.wci’s advice. Learn the tools. This is a path that will lead to heartbreak eventually.

If you choose that path, @hkeric.wci has also done the work for you.

[ Download ] Epicor 10.2 & Kinetic .CHM Schema - ERP 10 - Epicor User Help Forum (epiusers.help)

1 Like
4

yes, just schema of the database will be fine and then i can use rest api to get the data and feed to the local database.

regards,

Eddy

5

What you really want is the OpenAPI/Swagger definitions of the business objects for the API definitions.

If you go to:

https://[KineticServer]/[KineticInstance]/apps/resthelp/

You will find what you need. The help on ZendDesk is pretty good.

6

I take it you are cloud?

What is the business case for doing this?

There may be better options available.

1 Like
7

So… the REST API does some work on the data it returns. It’s not a one-to-one map of the database itself. Single REST methods do aggregation from multiple tables.

If you have the time and resources and stubborness to build a database around the REST structure and modify the database to match REST API changes over Epicor product updates, well, that’s the scope. Keep in mind that differential updates won’t work everywhere - records will change without updating a filterable sequence reference, which will apply an early and hard scaling limit where updating your reporting database will effectively DDOS your ERP.

Your best bet will likely be to request database backups from Epicor support. Not sure what the odds of success of getting that on a schedule is, but I’d be really surprised if they can’t provide backups. Lots of businesses need a point-in-time copy of data for various reasons.

8

thanks so much. it is clear for me. i will ask a database backup from epicor support.
I thought that way too.
another workaround is to create tables with core fields I need and use rest api to populate the data.

Regards,

Eddy

9

I’d still like to know why?

10

to ask a backup of database may need fee i think. nothing is free.

11

No, I mean why do you need this ?

My question above? What is the business use case?

Trying to help see if there are better options.

1 Like
12

Heed @Mark_Wonsil advice above and let @klincecum, etc help you find a better alternative.

13

Hello Klincecum,
it is for the reporting purpose. we can use the local copy to create a lot of reports.

regards,

Eddy

14

But why? What I’m trying to say is there are probably better options.

Are you struggling with anything? Etc.

15

Ngapa GIF