Harold,
I inquired recently of the IBM U2AskUs Group as to the ability of reading
and writing from/to an SQL database by Universe using EDA.
It sounds like you want to do the same thing, and it sounds like IBM is not
planning to offer the EDA capability with an SQL database at this time.
Here is the response I received:
Dave,
You can convert UniVerse files to UniVerse tables today and enable access to
UniVerse tables from SQL.
The online manuals have a number of manuals that dicuss this; I would start
with SQL Administration from DBAs.
This enables a lot of features such as RDBMS-like functionality such as
security constraints, referential integrity and triggers on UniVerse tables.
What External Database Access (EDA) does is allow you to map and migrate
your data out of UniVerse and into another database such as DB2, Oracle or
Microsoft SQL Server. This is different because, above, your data is still
in UniVerse. You can choose file by file and, within a file, you can choose
field by field what to migrate. Your existing Basic programs and queries
should be able to work as before for the most part, however now, some or all
of your data is in another data server.
At present we provide a driver that allows you to move your data into DB2;
we have, for UniData, prototyped a driver to Microsoft SQL Server, but are
not currently planning to offer that as a product. However, we may be able
to offer it via U2 Lab Services.
Hope this helps.
Regards,
IBM U2 Marketing Team
www.ibm.com/software/u2
***********************************
Dave Taylor
Sysmark Information Systems, Inc.
Authorized IBM Business Partner
49 Aspen Way
Rolling Hills Estates, CA 90274
(O) 800-SYSMARK (800-797-6275)
(F) 310-377-3550
(C) 310-561-5200
www.sysmarkinfo.com
----- Original Message -----
From: "Oaks, Harold" <[EMAIL PROTECTED]>
To: <u2-users@listserver.u2ug.org>
Sent: Monday, April 14, 2008 4:43 PM
Subject: [U2] Reading data from an SQL Server Database from Universe
I am simply trying to read data from a SQL Server database into
Universe.
It's all supposed to be explained in the document "BASIC SQL Client
Interface Guide", but am missing one key point, it seems...
One defines the ODBC data source in the uvodbc.config file. According
to the documentation the only information one puts into this parameter
file are data source name and dbms type. For example:
<mysqldb>
DBMSTYPE = ODBC
are two lines in this file. This says the data source name is 'mysqldb'
and it's an ODBC type of database. OKfine.
That's it! For sources which are Universe databases, one also enters a
service type and host. That makes sense.
Well - the SQL Server database I am interested in reading is on another
server. WHERE do I specify the name of the server and the database name?
Is it even possible in Universe to connect to a SQL Server database on
another server?
Thanks for any help on this.
Harold D. Oaks
Sr. Analyst/Programmer
Office of the Budget and Information Systems
Clark County, Washington
ph: (360) 397-6121 x4132
fax: (360) 397-2342
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
