Hi,
We could import the metadata through Plugin as well as through Orchestrate schema definitions but not through ODBC. .
My odbc.ini file for one Oracle user(user1) looks like this
[ODBC]
IANAAppCodePage=4
InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc
Trace=1
TraceDll=/home/dsadm/Ascential/DataStage/branded_odbc/lib/odbctrac.sl
TraceFile=/home/dsadm/Ascential/DataStage/branded_odbc/odbctrace.out
UseCursorLib=0
[TEST]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMora20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=UXJEDB05
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=user1
Password=user1
PortNumber=1521
ProcedureRetResults=0
SID=test1
UseCurrentSchema=1
The corresponding uvodbc.config file entry is as follows
#
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<TEST>
DBMSTYPE = ODBC.
When i try to import the metadata through the ODBC I am able to get the ODBC.ini in the DSN name but when i enter the username and password for the corresponding DSN it returns me the following Error
ERROR - ODBC License file (IVVM.LIC or DDVM.LIC) not found in branded_odbc Directory .
According to the error messgae i went into the branded_odbc directory and saw the file I could find the IVVM.LIC file in it.
Anything i am missing.Kindly provide me some inputs to proceed further.
Regards,
Bala.
Could not import metadata through ODBC
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration