Skip to Content
avatar image
Former Member

Creating a connection to SQL Server

Hi all,

I am new to BOE, so maybe my question will be phrased no so accurately.

I have an SQL Server database, which i want to use with Web Intelligence / Xcelsius.

How to i add this database to the universe? to the connection list?

i tired also to find some documentation in the SDN but could not.

please assist.

-Doron

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 20, 2009 at 10:28 AM

    Hi Doron,

    The first thing you need to do is create a connection to the database. This is done in the Designer tool. When you click new in Designer it will display a wizard and you can set it up as part of this, or alternatively you can use the tools connections. For SQL Server the connection can be created using ODBC drivers or direct to SQL Server. If ODBC then you will need to have configured the DataSource.

    Having created the connection, you can use it by setting it in the universe parameters.

    To see a list of tables available simply right click the data view panel (main panel on the right)

    Regards

    Alan

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 07, 2015 at 08:25 PM

    Hi,

    In BOE 4.1 SP6 is possible connect Web Intelligence direct on database with feature Free-Hand SQL. Following this link with steps:

    http://scn.sap.com/docs/DOC-64504

    For other versions, you need build connection with tool client Information Design Tool. Following this link:

    http://scn.sap.com/docs/DOC-22019

    For connection remote database you need configuring ODBC driver and add ip adress ou named instance.

    Business Object local ODBC connections and server ODBC connections

    Verify if you machine have access and port open.

    Regard, Jean

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 03, 2009 at 11:46 AM

    Issue is solved

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I am having an issue with SIA and Sql Server db communication.  I have created a copy of the SQL server database on a test server and installed SAP 4.1 on the same server.  I provided the DSN connection pointing to the database located on the test server.  After installation it's saying I can't connect to he CMS.  The error says "Account Information not recognized: Could not reach CMS........(FWM 20031)".  I created another node and still not working.  I checked via CCM and SIA is running. 

      I think the problem seems to be, the communication between SQL server and SIA.  But I need an expert advice.

      The ports are open and the firewall and the antivirus were suspended during installation.

      Any help is appreciated.

      Regards.

      Aaron.