Import From ODBC

[prussell]

I'm evaluating the trial version and am trying to import from an ODBC source.  The import seems to be successful, however it's only importing the stored procedures and functions. No tables or views. I have the include user views checked but do not see any setting for tables. I'm assuming they are imported automatically.

Am I missing something?

Thanks
Patrick

[prussell]

Ok I've figured out the problem. I was using the wrong Schema/Owner. But why did the Stored Procedures and Functions import? They have the same Owner?.

BTW: Importing from SQL Server 2000

Thanks
Patrick

[«Midnight»]

Hi Patrick,

Good to hear you have things sorted out.

Something to do with system table access rights I think. We see this pattern from time to time, but the details are obscure. It usually indicates that access privileges are incorrect (but close), or sometimes that the client-side drivers are not completely compatible with the way EA does things. [The latter problem seems to be more common with Oracle, but both might apply.]

From the point of view of us users the real issue is how do we solve the problem, not what's causing it (that's Sparx' concern). The main thing here is that you are over the hump...

David

By the way, which settings did you have to tweak. That is, what access settings needed changing, and where did you change the schema?

[Timea]

I'm experiencing a similar problem with EA and mysql. When I try to import db schema from odbc source, I get this message from EA :

unable to obtain table information.


This my  configuration:

• EA 7.1
• Mysql  5.0.67-community-nt
• myodbc  5.0.1

I performed this on mysql:

• I created a database and user with all privileges on the database.
• Created a table and populated it with a couple of records.
• Added and configured a DSN.

Any clue?

Thanks a lot for any help.
Rachid

[«Midnight»]

When you created the database user, did you use your fully-qualified (i.e. with domain or machine name) name or just the username you use to log to Windows? I have seen access problems (when using EA and some other problems) in the latter case.

[Timea]

Thanks for your reply Midnight. Mysql database server and EA are installed and run on the same machine (localhost). I used the same database username as the windows login.  The machine is in a workgroup, no LDAP or Active Directory authentication, local only.

Regards

[«Midnight»]

Well, it might have worked.

The same set of problems can affect MS SQL Server 2008, and I think 2005 as well. These can lock you out even in a single-machine scenario without a domain. [I know this from a recent unhappy experience in just that configuration.] Whether this might apply to MySQL I cannot say. But it bears looking into.

In the MS SQL scenario what I had to do was create a new username for the database, giving it the fully-qualified <machine>\<username> syntax. I then assigned the necessary database roles to that username. Once I did that I was OK.

[muppetry]

I'm getting the same message "Unable to obtain Table Information".
I'm using EA 6.5.800 and attempting to import from Oracle 10g (driver 10.2.0.1).

I suspect this might be because my connecting user doesn't have satisfactory permissions to select from the SYS tables, however in our organisation our dev database users aren't given free reign so I can't just assign rights to myself.

What permissions do I need to ask my DBAs to grant me in order for EA to succeed in getting the table info?  (Ps, the user i'm connecting as is the owner of the tables i'm interested in.)

Thanks!