Connect to MS SQL

[Former Member]

Hi,

Can anybody tell me the detailed procedure to connect MS SQL server from VC.

Which system I have to create in EP and what are parameters to that system.

Thanks in Advance.

Srinivas Sandaka

[Former Member]

Hi,

I did whatever you sugest, but the same error remains.

But I created a direct JDBC system, it is working fine and successfully tested.

It does't work with BIUDI JDBC system.

I found new parameters in BIUDI system:

<b>Fixed Catalog</b> and <b>Fixed Schema</b>

Do we need to specify anything into them.

[Former Member]

Go back to your original connection settings. In the system, check and make sure the User Management property is set to admin,user.

Make sure you have defined an System Alias.

Make sure you have inputted User Mapping for that Alias. If you do not have user mapping set it will not work. I also set the Distributed Query Engine UserID and Password to the Database UserID and Password.

Regards,

Peter

[Former Member]

Hi Peter

But the problem is that if you make the connection only based on JDBC you won’t have access from VC BI or SQL editor in the VC.

Regards,

Werner

[Former Member]

I had the same problem. I solved it by configuring JDBC Connector in the Admin Console.

Check the configuration and checking the BI Java Connectors ( see Post Installation Activities in SAP Business Warehouse 3.5, which can be accessed from SAP Service Marketplace at

service.sap.com/instguides -> SAP NetWeaver -> Release 04 )

You have to configure jdbc drivers and JDBC Connector to use these drivers.

Follow the guide...

Bye, Roberto

[Former Member]

Werner,

Yes, you are correct. You will not have access to the VC BI Wizard or SQL Editor. If this is what is desired, go back and create another system (with the same properties) but instead of using the standard JDBC system, create it this way:

System from Par -> com.sap.portal.systems.BIUDI -> SAP_BI_JDBC.

Then in the VC you should be able to run some SQL against that system and use the SQL Editor also. I suggest using the BI Query Wizard when you get into VC.

Regards,

Peter

[Former Member]

Hi.

Did you solve this problem ?

I got same problem in EP 6.0 SP 11.

If you solve this problem, let me know.

Thanks in advance.

Regards, Arnold.

[Former Member]

Dear Peter

Exactliy this ist the problem. When i definie a system with SAP_BI_JDBC I can't define "Distributed Qeuery Engine" and without that I can't connect. I guess that there is somewhere an access problem.

Regards

Werner

[Former Member]

Werner,

We are not using DQE, I was mistaken. You only need to set that property if you have DQE set up and are running queries against multiple systems and combining the data.

If you only want to create a system to a SQL DB and then run SQL against it, instead of just using stored procedures, then follow the steps in my previous post, setting your user mapping as the a DB user with full control.

Regards,

Peter

[Former Member]

Dear Peter

I had setup up first a sql System using the jdbc system. Without defining the DQE user a can not test or use the connection. The defined user has administration rights on the DB. When I define additional the DQE user the SQL connection works and I can use the system in the portal. Via VC a can access the stored procedures.

When I define now a similar (same definition) connection using the BI IDBC I can’t test the connection. When I access the connection via VC I receive the error “Error 21003: Cannot retrieve catalogs and shemas. Failed to connect to backend system. ……”

There is an other hint with the configuration in the backend system according to SP BW. I tried to make this configuration as descript in the BW installation guide. But there a have another problem finding the right class. Is this mandatory for using BI JDBC?

Regards

Werner