On the 2nd page of the Wizard, there's a single item listed in the Connector Selection panel:
Name=ODBC Connector, Type=ODBCConnector, Variant=3.5, Hosted on=<my DS server name>. When I click this item and click Next, I get the following error:
Code: Select all
DataStage was unable to attach to this connector.
An exception occurred while trying to send the request to the handler: Missing a handler pool for
[5874305.178a891c.711635ee.1128cdd30e0.2914b5c5.15ab].
In the Import Meta Data (ODBC) window, I'm able to select the DSN I set up on the DS server. I put in the username and password and hit OK, and the window grows briefly and shows "(Retrieving)" and then collapses and shows nothing. The DB account I'm using has "db_datawriter" privileges.
I escalated the privileges to "db_owner", and now I see the tables in the DB. I select the TUTORIAL table I created from the supplied creation script, and get no errors. The definition went into <project name>\Table Definitions\ODBC\<DSN name>\<db>.<owner>.TUTORIAL
So, I got the data in -- but didn't get it the way the tutorial wanted. The tutorial indicates the icon of the table def would be different since it came in thru a connector -- but mine has the same plain "table" icon as the rest.
Does anyone have any idea of the cause of the hard error above, and what to do about it? Secondly, if I'm inmporting directly, what are the minimm privileges the account needs for DataStage to list the tables in the DB? I assumed "db_datawriter" would work, because that lets me list and update tables. I'd rather not use highly-privileged accounts where I can avoid it.
Thanks in advance!
Regards,
Val