How do I setup a SQL Server/OLEDB account in IntelliFront BI?

In order to use SQL Server / OLEDB, you will need to set up SQL Server/OLEDB account.

Accounts - SQL Server/OLEDB

In order to use SQL Server / OLEDB, you will need to set up SQL Server/OLEDB account.

  • Go to Library and select Accounts. In Accounts, select SQL Server/OLEDB.
KPI's and Dashboards: SQL Server/OLEDB Accounts in IntelliFront BI.
  • Or select SQL Server/OLEDB Accounts from the card on the home screen.
KPI's and Dashboards: SQL Server/OLEDB Accounts in IntelliFront BI.

KPI's and Dashboards: SQL Server/OLEDB Accounts in IntelliFront BI.
  • Click New OLEDB Account.
KPI's and Dashboards: SQL Server/OLEDB Accounts in IntelliFront BI.
  • In the Server Name field, enter the name of the server the OLEDB uses.
  • In the Database Name, enter the name of the database the OLEDB points to.
  • In the User Name and Password fields, enter the relevant OLEDB credentials.
If you wish to use the credentials of the user currently logged into the machine, click the box next to Use Integrated Authentication instead of entering credentials.
  • Click Verify.
KPI's and Dashboards: SQL Server/OLEDB Accounts in IntelliFront BI.
  • If the verification is successful, click Save. Once successfully saved the SQL Server/OLEDB will appear in the list of SQL Server Accounts.
KPI's and Dashboards: SQL Server/OLEDB Accounts in IntelliFront BI.