ODBC in Epicor 9.x

Yahoo Archive
1
Sorry I "replied" to the wrong post...

--- In vantage@yahoogroups.com, "howco22" <agortman@...> wrote:
>
> I've come back to this project again. I was able to get OTS (one time ship to addresses) to import, (OTS fields are in the OrderHed table), however, if the customer has more than one shipto address, worldship tells you ( in a warning) that multiple addresses were found, Worldship will uses the first address (default)... which is typically wrong.
>
> So I am thinking of two options,
>
> Option 1) copy the shipto address information to UD fields in the OrderHed table (via BPM?)
>
> Option 2) copy the orderhed & shipto tables to an access db & link Worldship to that db.
>
> I am not sure which option would be better, or easier as right now I am not sure how to do either option?
>
> Any thoughts, suggestions, or input would be appreciated
>
> Thaks
> Andy
>
>
> --- In vantage@yahoogroups.com, "howco22" <agortman@> wrote:
> >
> > interesting...
> >
> > We are not planning to upload from Worldship back into E9, Our shipper has Epicor client, they use the scanner attached to the PC, to scan the tracking number into the shipment screen as they ship orders.
> >
> > --- In vantage@yahoogroups.com, Bill Jackson <fujijapman@> wrote:
> > >
> > > I used ODBC / World Ship (Vantage 6.10.541) to 'upload' tracking numbers, etc. I had to use Access as a 'middle-man' , couldn't get the Merant ODBC
> > > to 'talk' directly to WorldShip.
> > >
> >
>
2
Is ODBC an available option for connecting to Epicor 9? Our CAM mentioned that it is no longer supported.

Thanks,

Brian
3
Yes. It's still in 9.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
B_Stinger
Sent: Wednesday, April 07, 2010 11:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC in Epicor 9.x





Is ODBC an available option for connecting to Epicor 9? Our CAM mentioned
that it is no longer supported.

Thanks,

Brian





[Non-text portions of this message have been removed]
4
I don't think it's ever been "supported". ;)


--- In vantage@yahoogroups.com, "B_Stinger" <bstenglein@...> wrote:
>
> Is ODBC an available option for connecting to Epicor 9? Our CAM mentioned that it is no longer supported.
>
> Thanks,
>
> Brian
>
5
It actually was supported years ago when we went live with Vantage. Support had instructions on how to set it up, the "ODBC Kit", and they'd take your call if you had a problem with it.

Over the years, they've been discouraging it's use more and more, but now I'm told its not available, not supported.

I understand Epicor's reasons for discouraging its use. If it's not properly set up, or properly secured its misuse can cause serious issues with the database. I feel we've taken the proper care to deal with those concerns and have used it in a lot of applications to do things with Vantage data in an Access DB.

We are at the early stages of planning an upgrade from 6.1 to 9 and if that tool is no longer available to us it will be a major problem.

Any other comments from those using ODBC in 9, would be welcome.

Brian

--- In vantage@yahoogroups.com, "saab_barracuda" <chris.clunn@...> wrote:
>
> I don't think it's ever been "supported". ;)
>
>
> --- In vantage@yahoogroups.com, "B_Stinger" <bstenglein@> wrote:
> >
> > Is ODBC an available option for connecting to Epicor 9? Our CAM mentioned that it is no longer supported.
> >
> > Thanks,
> >
> > Brian
> >
>
6
There is a ODBC toolkit available for 9.
I just got it from Epicor a few weeks ago.
I am using it to set up a ODBC (Read uncommitted) connection for a "keyed" import into UPS WorldShip, to pull in the shipto info so our shipping clerk does not need to re-type all the shipping info.

Ive Granted rights to the new user for the various tables, I can see data if I create an odbc connection for Crystal reports, however, I get an error when I try to connect into WorldShip. Ive got my UPS tech coming out next week to help get this solved.

--- In vantage@yahoogroups.com, "B_Stinger" <bstenglein@...> wrote:
>
> It actually was supported years ago when we went live with Vantage. Support had instructions on how to set it up, the "ODBC Kit", and they'd take your call if you had a problem with it.
>
> Over the years, they've been discouraging it's use more and more, but now I'm told its not available, not supported.
>
> I understand Epicor's reasons for discouraging its use. If it's not properly set up, or properly secured its misuse can cause serious issues with the database. I feel we've taken the proper care to deal with those concerns and have used it in a lot of applications to do things with Vantage data in an Access DB.
>
> We are at the early stages of planning an upgrade from 6.1 to 9 and if that tool is no longer available to us it will be a major problem.
>
> Any other comments from those using ODBC in 9, would be welcome.
>
> Brian
>
> --- In vantage@yahoogroups.com, "saab_barracuda" <chris.clunn@> wrote:
> >
> > I don't think it's ever been "supported". ;)
> >
> >
> > --- In vantage@yahoogroups.com, "B_Stinger" <bstenglein@> wrote:
> > >
> > > Is ODBC an available option for connecting to Epicor 9? Our CAM mentioned that it is no longer supported.
> > >
> > > Thanks,
> > >
> > > Brian
> > >
> >
>
7
I used ODBC / World Ship (Vantage 6.10.541) to 'upload' tracking numbers, etc. I had to use Access as a 'middle-man' , couldn't get the Merant ODBC
to 'talk' directly to WorldShip.
8
interesting...

We are not planning to upload from Worldship back into E9, Our shipper has Epicor client, they use the scanner attached to the PC, to scan the tracking number into the shipment screen as they ship orders.

--- In vantage@yahoogroups.com, Bill Jackson <fujijapman@...> wrote:
>
> I used ODBC / World Ship (Vantage 6.10.541) to 'upload' tracking numbers, etc. I had to use Access as a 'middle-man' , couldn't get the Merant ODBC
> to 'talk' directly to WorldShip.
>
9
I've come back to this project again. I was able to get OTS (one time ship to addresses) to import, (OTS fields are in the OrderHed table), however, if the customer has more than one shipto address, worldship tells you ( in a warning) that multiple addresses were found, Worldship will uses the first address (default)... which is typically wrong.

So I am thinking of two options,

Option 1) copy the shipto address information to UD fields in the OrderHed table (via BPM?)

Option 2) copy the orderhed & shipto tables to an access db & link Worldship to that db.

I am not sure which option would be better, or easier as right now I am not sure how to do either option?

Any thoughts, suggestions, or input would be appreciated

Thaks
Andy


--- In vantage@yahoogroups.com, "howco22" <agortman@...> wrote:
>
> interesting...
>
> We are not planning to upload from Worldship back into E9, Our shipper has Epicor client, they use the scanner attached to the PC, to scan the tracking number into the shipment screen as they ship orders.
>
> --- In vantage@yahoogroups.com, Bill Jackson <fujijapman@> wrote:
> >
> > I used ODBC / World Ship (Vantage 6.10.541) to 'upload' tracking numbers, etc. I had to use Access as a 'middle-man' , couldn't get the Merant ODBC
> > to 'talk' directly to WorldShip.
> >
>