DSXchange

Hi, I am trying to get data from GoogleAnalytics with DS 8.7. Does anyone has experiences in that? My first idea was to go throw a web service with webservice transform stage. But GA seems not to provide the data on a webservice. Next possibility would be to go with odbc stage directly to the MySQL ...

right, the problem is a column of xmltype like described here http://www-01.ibm.com/support/docview.w ... wg1JR43526
the column is created binary and the jdbc driver does not support it.
changing to clob helps

the directory is /opt/IBM/InformationServer/Server/DSODB
We use oracle connector stage for read/write on oracle database.
but I think DSODB works with the operations console and the metadata database (the oracle 11.2.0.2 I mentioned before)

dsodbconfig, dsodbconnect and dsodbtuning are the same on both systems

we use oracle 11.2 and I thought, datastage would connect to this via the oracle client installed on the server and does not use odbc connection.
in odbc.ini is no connection to this database specified.

hi, on our testsystem under DSODB/log are every a mass of handler logs created, e.g. handler-2013008....log These files are mostly empty and are created every few seconds. On our production system this does not happen. Has anyone an idea, what the reason can be and how it can be stopped? thanks, Mario

with DS 7.5.3 it does not appear

ok, but if I map top to document collection, then nothing else can be mapped.
For all other fields appear the message:
CDIUI2820E The mapping is not applicable due to an invalid type conversion or difference in the source and target list dimensions.

Hi, I am trying to generate in DS 8.7 with XML Stage a xml file. within the composer step of the Assembly is the mapping fine and a valide XML is generated. Problem is, that for each line of data one XML-file is generated. But I want to have all data in only one file. How can I do this?? Thanks, Mario

running the oracle connector in sequential mode helps, now the problem is solved.

Hi, we are migrating from 7.5.3 to 8.7. While loading data to oracle 11g via oracle connector some jobs produce deadlocks on the database, when loading over 100000 rows, when loading less it works. The OCI function OCIStmtExecute returned status 1. Error code: 60, Error message: ORA-00060: deadlock ...

thank you ray.
after contacting ibm support once more, we decided to install a new db instance with the utf16 characterset

Hi, we will install datastage 8.7, till now we use 7.5.3. The metadata repository needs the following characterset (oracle 11g r2 rac): NLS_CHARACTERSET = AL32UTF8 NLS_NCHAR_CHARACTERSET = AL16UTF16 Now we have the problem, that all our databases use nchar character set = utf8 so we would like to in...

it is solved. we made the upgrade with user root, who doesn't has the $DSHOME in our production environment.
After exporting $DSHOME it worked.

os is hp-ux itanium 11.23