Solved: Creating a connection to SQL Server

Former Member · ‎2009 May 20

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

jean_machado · ‎2015 Aug 07

Hi,

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

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

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

Verify if you machine have access and port open.

Regard, Jean

Creating a connection to SQL Server