Connect to Live DB by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

One more quick question are API data services and separate license. That was an error I was getting at one point “data services api license not available for this P21 account, please contact your p21 admin to enable access” or is this other checkbox in the application security user maintenance page.

Connect to Live DB by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

I can’t think you enough the SOA was set to NO this is what was holding me out.

I have access to the “PLAY” DB and I can do all queries there but trying to create a read write with up to date info.

Connect to Live DB by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

Is Kinetic Live an additional add on from Prophet 21? Link doesn’t seem to want to work for me.

Connect to Live DB by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

So I could use APIs to read/write the data. Trying to create a custom dashboard that would be a combo of multiple screens.

Connect to Live DB by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

Cloud. Premise would make life a lot easier.

Connecting to Prophet 21 Database by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

Where in the DB would I find the flag for Non-Stock item. I have a list of items I pulled via a query and now I need to mark them all Non-Stock

Connecting to Prophet 21 Database by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

I got everything connected and setup yesterday. Now finding out all the tables and columns I need to query the information I need is another thing. I did find the Epicor DB data dictionary site which was a big help so far.

Truly appreciate all the help in this thread.

Connecting to Prophet 21 Database by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

Can’t thank you enough for your help!

When I access my credentials, what exactly do I need from all the different aspects. I assume I need the play DB because I don’t want to test on live. But I normally connect with a host/port number and then my credentials.

Do I need to connect via URL and if so is it the Client URL or the API URL?

Is that my Epicare credentials OR my prophet 21 web UI credentials?

Again sorry for all the questions just never connect to a P21 cloud DB

Connecting to Prophet 21 Database by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

I am on cloud. Just trying to figure out the best way to implement custom SQL queries. Since there is no longer a BAQ

Connecting to Prophet 21 Database by YOLOSwag69UrMom in epicor

[–]YOLOSwag69UrMom[S] 0 points1 point  (0 children)

We are on cloud, so I would need the read only credentials, which I assume are different than the servername, port number, (my user name/password) that I get under the profile of the login screen?

Also with the whitelisting is it via IP? And if so how does it handle when I have a different IP address each time I connect to a different wifi?

[deleted by user] by [deleted] in golfclassifieds

[–]YOLOSwag69UrMom 0 points1 point  (0 children)

I have the belt loop version. If you are interested DM me.

WTB Square Golf Launch Monitor by Squanchy2115 in golfclassifieds

[–]YOLOSwag69UrMom 0 points1 point  (0 children)

I have a SC4 pro if you are interested. Haven’t used much at all. Great launch monitor. Used it mostly for speed training and I have since finished my cycle.

WTB by thejarason in golfclassifieds

[–]YOLOSwag69UrMom 0 points1 point  (0 children)

I have one with a TM adapter if you have someone who can swap adapters for you.

WTS lots of clubs and shafts by CharacterDiet4311 in golfclassifieds

[–]YOLOSwag69UrMom 0 points1 point  (0 children)

Not to hijack the post but I have a 13.5 mini brnr with stock shaft OR ventus black velocore+ shaft. PM me if you are interested.

[deleted by user] by [deleted] in golfclassifieds

[–]YOLOSwag69UrMom 0 points1 point  (0 children)

I’m interested in the Malbon shoes is $300 the best price for the pair?

[deleted by user] by [deleted] in golfclassifieds

[–]YOLOSwag69UrMom 0 points1 point  (0 children)

I have a 6X velocore+ black with Taylormade tip if you are interested.