Re: ADP PICK database connect to SQL

drogers@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (drogers) wrote in
news:FbOdnRgR9er9ULreRVn_vA@xxxxxxxxxxxx:

> Hi. I am looking for information on how to connect to an ADP/PICK
> database with SQL. I am a webdeveloper recently hired by an auto
> dealer. I am quite new to the pick world, and for that matter,
almost
> all database programming outside of using PHP with mysql.
>
> All of the dealerships data is stored in a pick database. I am
charged
> with making a website that is able to display that data online.
>
> One possible route has been exporting the pick data to csv files and
> putting them on the linux side and then grabbing them from there and
> importing them into sql. this seems to be overly complicated,
> however. ideally, i could like to connect to the database via sql
and
> interact with it directly.
>
> could someone help me get a good start on doing this? is it even
> possible? i played around with software like pixieware, but it
seemed
> like it wasn't up to the task. i tried several different connection
> configuration files, but they all errored out.
>
> any ideas? any help is very much appreciated.

You basically have two choices:

a) Hook into their system via their web service and extract data in
real time from their system. You and/or the client will have to speak
directly with ADP support for details on how to call their web service
and request specific data sets such as repair order data, invoice
data, etc.

b) Study the documentation for the file relationships (you'll have to
know how/where to obtain data from different files to compile a
complete data set), then write a series of data extract programs that
create XML or flat files at the UNIX level, then ftp the files to your
server and parse them there.

Regards,
Joe
.

Relevant Pages

  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)