We are trying to import TableDefintions from the
Manager -ImportTableDefinitions -ODBC TableDefinitions.
If we are trying to import the TableDefinitions from the default Database defined for the ODBC connection(DSN), it works fine.
If we try to import the TableDefinitions from the different Database using the same ODBC connection(DSN), it does not work.
We tried to import using Plug-in MetaDefinitions, but the defintions are not matching with definitions on SQL Server.
Is there a way we can define a generic ODBC connection for different Databases on the same server,
so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?
Thanks in Advance
Import Table Definitions
Moderators: chulett, rschirm, roy
Re: Import Table Definitions
No that I'm aware of.poorna_76 wrote:Is there a way we can define a generic ODBC connection for different Databases on the same server, so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Hi Poorna,
Is there a way we can define a generic ODBC connection for different Databases on the same server,
so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?
I don't think that is ever possible unless all databases have same drivers. The reason we create different ODBC connections for different databases is because of the unique drivers for each database.
Thanks,
Naveen.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi All,naveendronavalli wrote:Hi Poorna,
Is there a way we can define a generic ODBC connection for different Databases on the same server,
so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?
I don't think that is ever possible unless all databases have same drivers. The reason we create different ODBC connections for different databases is because of the unique drivers for each database.
Thanks,
Naveen.
Thanks for all the suggestions.
I mean different databases(DB1,DB2...) on
one RDBMS ( SQL Server in my case).
I don't mean different Databases as Oracle,SQL Server,DB2 etc.
Currently we have ODBC connection(DSN) defined at Server with no default database selected.
All my DataStage jobs works fine, even though they read data from different databases(DB1,DB2..) using same ODBC connection, if we prefix the table name with Database name.
Only issue we are facing is while importing the TableDefinitions.
Thanks in Advance.