hi
Which stage do we use to access MYSQL database in datastage parallel edition(7.5)?.
Also are there any restrictions in using MYSQL database in datastage?Thanks in advance.
Regards,
Pavan
Mysql in parallel edition
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Sun Mar 19, 2006 5:46 am
- Location: vja
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ODBC Enterprise stage. The only restrictions are the usual ones - you have to use the correct ODBC quote character (which the stage can retrieve for you at design time) and you must conform to ODBC standards, for example limits on table and column name lengths. The latter can be resolved with aliases if necessary.
Obviously another "restriction" is that the ODBC data source name (DSN) must have been set up and configured.
(From version 8 prefer the ODBC Connector.)
Obviously another "restriction" is that the ODBC data source name (DSN) must have been set up and configured.
(From version 8 prefer the ODBC Connector.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 17
- Joined: Sun Mar 19, 2006 5:46 am
- Location: vja
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is a button in the server ODBC stage on the Stage properties tab, captioned "Get SQL quote character" or something similar. Clicking this button is all you need to do to load the quote character in the server ODBC stage.
Make a note of that character and populate the Quote Character property, or use that quote character in derivations or user-defined SQL, in the ODBC Enterprise stage or ODBC Connector in parallel jobs.
Make a note of that character and populate the Quote Character property, or use that quote character in derivations or user-defined SQL, in the ODBC Enterprise stage or ODBC Connector in parallel jobs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 17
- Joined: Sun Mar 19, 2006 5:46 am
- Location: vja