Notes for direct connection to R/3 databases by Bo

Although universe can directly connect to the ECC database, it does not mean that all problems have been solved. There may also be some minor problems, so record them to avoid detours.

1. Permission issues

If Oracle client is installed on the BoE server, creating a universe connection directly on the server may encounter permission issues .:

No matter whether you edit the connection or create a connection, or even open the software in the Oracle client, I thought that the 64-bit server system can only install the 64-bit client. I checked that the 32-bit client can be installed. finally, I found that my BOE server has insufficient user permissions. If you use administrator, it will be okay.

2. Restart sia

It is okay to refresh the created report in rich client. Why is an error reported when the report is published to BOE? :

I can't understand why I found a post in SDN saying that I want to restart SIA. I remember I didn't need it before. this may be the case for the new version. after restarting, you can use both rich client and infoview. solution. other databases should be the same.