RE: Replication between as/400 and Sql Server 2000

["Lopez, Eduardo (Tijuana)" <lopeze@xxxxxxxxxxxxxxxxx>]

No Ben, the tool when working with the "real-time" mode it reads only the
journals entries... and when working in "mirror" mode it reads the data from
the logical files (only the primary keys) in order to get the tables data...
the problem that I have is that our BPCS database does not have the primary
keys, but it does have indexes... so the thing is that I can't use this tool
because it'll only read primary keys... you might ask yourself... so why
don't you define the primary key?... well I might do it... but I didn't want
to change anything on the BPCS database... mmm.. that's crazy if you think
about it... that's why I sent this email... I thought maybe someone knew
"another way"

Regards,
Eduardo

>-----Original Message-----
>From: Whitaker, Ben [mailto:WhitakB@xxxxxxxxxxxxxxx] 
>Sent: Thursday, July 10, 2003 5:38 AM
>To: SSA's BPCS ERP System
>Subject: RE: Replication between as/400 and Sql Server 2000
>
>
>I read your problem with interest; not because it is something 
>we are doing, but it's something we might do in the future.
>
>Will the DB2Motion tool read the data through logical files?  
>We took on an archiving project that uses logical files to get 
>to the keys on the tables. We also found that, in almost every 
>case, the logical file we needed was already included in the 
>BPCS libraries.
>
>Maybe this can solve your problem.
>
>Ben Whitaker
>Project Leader
>Mohawk Paper Mills, Inc.
>465 Saratoga St
>Cohoes, NY 12047
>518.233.6210
>whitakb@xxxxxxxxxxxxxxx 
>
>
>-----Original Message-----
>From: Lopez, Eduardo (Tijuana) [mailto:lopeze@xxxxxxxxxxxxxxxxx]
>Sent: Wednesday, July 09, 2003 9:54 PM
>To: 'bpcs-l@xxxxxxxxxxxx'
>Subject: Replication between as/400 and Sql Server 2000
>
>
>Hi to all,
>
>I have a big "dilemma"... hope somebody can help... this is my 
>situation
>
>We want to built a custom data warehouse with SQL Server for 
>the QMS, API and CAP modules... why use SQL Server?...
>
>   * We already have the license for SQL Server 2000 
>Enterprise this means that we can use Analysis Services for 
>free... the product/solutions from IBM and also from Cognos 
>are very expensive!!
>   * We'll be very integrated with Microsoft Office... using 
>for example Pivot Tables, the Office Web Components, etc... 
>and for free because we already have the licenses for Microsoft Office
>   * The time to implement it is very short... three months!!
>   * We already have all the tools from the Windows side
>   * I'm very skilled in SQL Server
>
>
>Please follow..
>I'm evaluating a replication tool... the tool name is 
>DB2Motion from Hit Software... this tool operates in two modes 
>refresh and mirroring... the first one uses the DB2 Journal 
>feature which is very cool because we can have in some parts 
>of the data warehouse "real-time" data!! and the other mode is 
>using primary keys on the tables to get the last records (not 
>real-time data)... and now my "dilemma"
>
>   * I can't use the DB2 Journal feature because it'll impact 
>to much the
>as/400... so this means that I can't use "real-   time" 
>data... that's fine
>for now...
>   * I can't use primary keys because the BPCS tables doesn't 
>have primary keys!!... Ohh my god why?
>
>the only "good" option that I can think is using the ODBC 
>driver from Hit Software or the one from IBM's Client/Access 
>with the Data Transformation Services (DTS) feature from SQL Server
>
>Can somebody guide me on any more options... there has to be 
>another way...
>
>Thank you,
>
>Eduardo Lopez
>Software Developer
>Tyco Adhesives
>
>US Phone (San Diego, CA)
>+1  (619) 424-4244
>Mexican Phone (Tijuana, MX)
>+52 (664) 647-4359
>
>"Man finds God behind every door that science manages to open" 
>"El hombre encuentra a Dios detrás de cada puerta que la 
>ciencia logra abrir" Albert Einstein
>
>_______________________________________________
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.
>_______________________________________________
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.
>