Support center for flex.bi version 3.2
SQL data source
- Otto Šteinbaums (Deactivated)
- Dace Kvalberga
To use SQL as a data source you have to do the following steps:
Create a new source application in the flex.bi source application tab.
Make sure you select SQL as your data source when creating a new source application
If you have created already another similar SQL data source then you can export its definition and paste it in Import definition to create new SQL source application with the same parameters.
SQL source parameters
For the following fields provide the information required:
Database type
Select the database type from the list of available options.
Host
Write the host IP of your selected database type.
Port
Write the port number your database uses, if you are using the default port for your selected database then you can leave this blank.
Database
Write your database name.
Username
Write the username of the user you wish to use to connect to the database.
Password
Write the password of the user you are using to connect to the database.
SQL SELECT statement
Write an SQL statement that will be used to retrieve data from the database. The SELECT part of the SQL statement determines the columns you will have to map in the next step.
Source column mapping
Once you have finished setting your parameters you will have to conduct the Source column mapping.
Mapping the data to columns is similar to importing a .csv/.xls file. The differences here are that you need to name your own cube and dimensions, because they need to be created if your data does not fit any of the already existing cubes.
When you are finished mapping your data press the Start Import button.
If your import finishes successfully you can see the results in the Analyze tab in the cube you imported your data to.