acewolf 发表于 2008-10-5 22:18:21

求教:BI7.0(Oracle数据库)怎样连接MY SQL数据源

求教:BI7.0(Oracle数据库)怎样连接MY SQL数据源

BW的版本是7.0,底层数据库是ORACLE,现在想从MYSQL 数据库中抽取数据,怎样建立BW和MYSQL数据库之间的连接。

zhuq_axy 发表于 2008-10-22 15:13:35

通过UDC链接

你先找到MYSQL的JDBC DRIVER,然后让BASIS在VA里加入MYSQL JDBC DRIVER.BI里配置一个UDC即可。BASIS没做过?那你就只能自己找HELP做了

acewolf 发表于 2008-10-24 12:59:34

好的,已经解决,谢谢!

weiuse 发表于 2009-6-2 22:31:55

UDC不稳定

UDC不稳定
偶尔报错,如下:
--------------------------------------------------------------------------------------

Error message from the source system

Diagnosis
An error occurred in the source system.

System Response
Caller 09 contains an error message.

Further analysis:
The error occurred in Extractor .
Refer to the error message.

Procedure
How you remove the error depends on the error message.

Note
If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.
--------------------------------------------------------------------------------------
Errors in source system
Message no. RSM340
--------------------------------------------------------------------------------------
S:RSSDK:300 Table: Table_Name not found
Message no. RSSDK300
--------------------------------------------------------------------------------------

清各位协助看一下,
这个抱错大体是什么原因?
如何来处理这个问题呢?

多谢!
页: [1]
查看完整版本: 求教:BI7.0(Oracle数据库)怎样连接MY SQL数据源