Date: Thu, 28 Mar 2024 08:26:12 -0600 (MDT) Message-ID: <1778375681.2467.1711635972278@confluence-external-wiki> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2466_2136107575.1711635972278" ------=_Part_2466_2136107575.1711635972278 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Follow the instructions below to connect Yellowfin to a Microsoft = Azure database.
Click on the yellow Create button and then on Data Source.&nbs=
p;
Click on the Database icon.
When the New Connection popup appears, provide a name and desc= ription for your database.
From the Database Type drop down list, select Microsof=
t Azure. New configuration fields will appear on doing so.
Select the Include Schema in SQL checkbox to =
add the schema name when addressing database tables in SQL queries.
Enter the name of the server hosting the database.
<= /li>Yellowfin offers multiple drivers for this database connection=
. Select the one you require.
=
p>
Next, specify if you want to create a default instance or a named in= stance of Azure. If an instance of Microsoft Azure is not already installed= then a default one will be created, unless a named instance has been speci= fied.
To specify a named instance, first select the Use =
Named Instance checkbox, and then enter the name of the insta=
nce in the new field.
The required TCP/IP port number required will already be displ= ayed.
Specify the name of the database containing the data that you = require.
Select a method for database authentication. To authenticate W=
indows user accounts, select the Windows Authentication option, and then provide the name of the domain in the new field=
.
Or select the SQL Authentication= option to authentication user accounts on an SQL Server.
From the SSL drop down list, choose whether o=
r not the Secure Sockets Layer should be enabled to encrypt data.
Select the Use Custom Fetch Size checkbox if=
you want a specific number of data rows to be retrieved from the database =
after a query is executed, instead of fetching its entire result. Specify t=
he number of rows. Doing so will allow Yellowfin to process data faster.&nb=
sp;
Yellowfin will select the preferred JDBC driver to talk to you= r Azure database, based on your selection in step 7.
Enter the username and password of your database account.
Once you have completed your connection information, you will =
have several options:
Advanced Connection Editor: This will take you to the Data Source page in= the Admin Console and allow you to edit all the advanced options available= for your database.
Test Connection: This will validate the conne= ction parameters you provided to ensure it can connect to your database. If= the connection was successful, a message will appear.
Create View: This will save your connection a= nd get you started on creating a view based on it.
Save & Close: This will allow you to save= your connection and close the New Connection popup, returning you to the p= age you were on previously.
Cancel: This closes the New Connection popup = without saving your connection, returning you to the page you were on previ= ously.
We recommend testing the connection, and then saving it by usi= ng the Save & Close button.