Hello, my client will move to epicor kinetic cloud very soon. my question is if it is possible to set up a linked server in the sql server to connect the cloud database. our salesforce has this feature to setup a linked server and connect to the cloud database. I want to know if Epicor can do tha…

Epicor provides a robust REST interface.

thanks, i know i can call the rest api. now, since you raise the rest api topic, my root of the problem is how to query the cloud epicor database properly. give you an example, i have a stored procedure. it is list for each part, how many on hand qty, how many open quotes, how many open orders, h…

Sounds like you could create a BAQ and get its output via REST

So many options. You can query the business objects via odata, or via custom methods. For more advanced stuff (simple stuff too), you could design a BAQ. If you want fine grained control on the “shape” of your data, use an Epicor Function.

Look at us tackling the move to cloud one post at a time! Yes, OP, @eqiu , sounds like a BAQ is in order for you.

And since I just referenced this today, this might be of interest to you. ODBC ODATA: [image] Issues with REST BAQ Experts' Corner BTW All I thought I’d go ahead and give that CData Odata ODBC Driver a try with our rest services v2 - works great and I’d think it should b…

[image] klincecum: ODBC ODATA: Hello, thanks. that’s the topic I saw too. CDATA ODBC driver. i think it is the solution i can try it. thanks, Eddy

Man you had to dig for that one, you joined in 2021…

[image] utaylor: you joined in 2021 Or did I ? :smiling_imp:

That’s why I am trying to understand how you are so plugged in and I haven’t connected with you before. Am I just losing my memory or my mind? I apologize if we have connected, and I just don’t remember. But I read a ton of your posts and learn a ton, I feel like I would have connected with you a l…

Kinetic - SQL Server Linked Server

Kinetic ERP

klincecum (Kevin Lincecum) February 16, 2023, 10:32pm 11

And since I just referenced this today, this might be of interest to you.

ODBC ODATA:

Topic		Replies	Views
SSMS Solution Kinetic ERP sql , reports , ssms , dumpster-fire	23	1921	October 18, 2023
Kinetic cloud replicated database Kinetic ERP kinetic , database	4	1059	March 8, 2024
Epicor ERP Cloud Production Environment Copy for Read-Only Data Access Kinetic ERP	6	3623	May 26, 2023
SQL-Visual Studio Views to SSRS? Kinetic ERP	2	856	January 25, 2023
External BAQ can i access a Kinetic database Kinetic ERP	5	1739	January 25, 2023

Kinetic - SQL Server Linked Server

Related topics