[Bulk] RE: PH - MS SQL Service access in Unix

[Bob Deskin]

There are many databases included in the data access layer that are not 
officially supported by PowerHouse and Axiant. We share some of the data 
access technology with the older BI products. MySQL is one of those 
databases that is listed via DataDirect ODBC. It is not officially 
supported by ADT nor do we test against it.

Bob



From:
"Ken Langendock" <ken.langendock at rogers.com>
To:

Cc:
<powerh-l at lists.sowder.com>
Date:
2009-08-14 12:19 PM
Subject:
RE: [Bulk] RE: PH - MS SQL Service access in Unix
Sent by:
powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com



So does this mean you work against MySQL also?

Ken


-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Bob Deskin
Sent: August 14, 2009 9:49 AM
To: 'Jeff Hoffman'
Cc: powerh-l at lists.sowder.com
Subject: [Bulk] RE: PH - MS SQL Service access in Unix

PowerHouse 4GL 8.43D1 (current version is 8.43F) and up use DataDirect 
ODBC to access SQL Server from UNIX/Linux to Windows. I can't say anything 

about performance because every network and situation is different.

As for "direct access", it depends what you mean. For all relational 
databases on UNIX/Linux, we have a data access layer that generalizes 
database calls. This data access layer hooks into the database 
gateway/client/ODBC driver which actually talks to the database.

The only way to know what your situation will be like is to test it. If 
you can get sample software and test the connection, that should be part 
of your evaluation. The nice thing is that PowerHouse makes the 
application end easy. Given a sample database, you can generate SQL as 
required and really all you need is the DATABASE statement in PDL to 
connect. Test QUICK response and also processing times in QUIZ or QTP with 

complex ACCESS statements. And note that in almost all cases, a DECLARE 
CURSOR plus a simple ACCESS <cursor> will be much more efficient than the 
corresponding complex ACCESS linkage.

Bob

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.