Data Junction

[Tony Griffiths]

Hi,
Is there anyone who has experience of a product called Data Junction (V7)
used in an NT environment with SQL Server 7 - Have you found it
reliable..... or realy buggy.... any views or experiences welcome.

[Andrew]

I've used in conjunction with converting various types of databases/text
files in to foxpro databases, and found that for the most part it works
very well.

Andrew
DBA
Lguide.com

"Tony Griffiths" <TonyGr...@st-martins.co.uk> wrote in message
news:8oejbn$g0v$1...@news.lu-visp.net...

[Neil Pike]

Tony,

Haven't used it in anger for a while, but when I did it was the best of it's kind.

> Is there anyone who has experience of a product called Data Junction (V7)
> used in an NT environment with SQL Server 7 - Have you found it
> reliable..... or realy buggy.... any views or experiences welcome.
>

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7 - SQL Public)
or http://www.ntfaq.com/Section.cfm?sectionID=34
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

[Phil]

Data Junction? We bought the "Enterprise Suite" for $5K. Still have
yet to find it work when I needed.

Tried executing Oracle "CREATE TABLE AS SELECT" statements - it failed
with the native driver. ODBC wasn't an option for my application.

Tried importing SAS - only supports 2-3 year-old formats (v6.11 or
later).

Then, there is the "high quality" Visual Basic front-end - on an
expensive commercial product. Sheesh!

[PJ]

We've used it extensively within our company and it's hard to beat it's bang
for the buck.

I can't believe this guy is calling it expensive. Compared to the other
products out there...Gentran, Mercator, Paperfree, it's about 10% of the
cost. Granted, it does not have the all the rich set of features for the
product, but it's flexibility with external code, and the SDK that allows
you to completely customize your solution made it the choice for us. If it
bogs for any reason it will return the error and allows you to put custom
code on various events within the conversions, including errors.

It's a data mapping/translation application. I'm sorry this guy had trouble
creating tables, but I don't know what he was using for that for. Someone
needs to introduce him to Erwin or Embarcadero Studio.

And it NOT a VB front end. The end user event coding is a vb script variant
(that allows you to instatiate COM or call .dll functions programmed in any
language during the conversion), the application is programmed in a
hub&spoke type design totally in assembly,c, and c++.

However, it does have some annoying quirks during the design phase of the
conversion. Once the conversion is set up, however, it runs remarkable
fast. Last but not least...the customer support at Datajunction is
remarkable, especially considering the fact that they are a relatively small
company.

"Phil" <jsn...@aol.com> wrote in message
news:39ad743a...@news.mindspring.com...

[Phil]

I'd like nothing more than to be convinced that our $5K was not
wasted. If I ever stumble over anything that Microsoft SQL Server's
DTS can't handle, I'll definately give it another try. Since DTS
handles all of the file formats we use except SAS (Microsoft +
Oracle), and DJ can't handle any SAS versions written in recent years,
I've not had a need to try DJ again.

Glad to hear the front-end isn't classic Visual Basic.