SmartViews - Steps to Configure SQL Connection
Launch the SmartView’s Analyze application. The main interface will be displayed.
2. Access the Connection Settings:
Click on the File menu.
Navigate to Views > Create New View.
This will allow access to the data connection settings.
3. Open the Designer Tab:
Navigate to the Designer tab.
Click on the Add button to add a new data connection.
A dropdown will appear with multiple data source options.
4. Select SQL Server as Data Source:
Under the Microsoft section, choose SQL Server.
This will open the Connection Properties window.
5. Configure Connection Properties:
Connection Name: Enter a desired name for the connection (e.g., Test).
Data Source: Ensure it is set to Microsoft SQL Server (SqlClient).
Server Name: Enter the SQL Server instance (e.g., ERPL033\B1SQLEXPRESS).
6. Choose Authentication Method:
Select either:
Windows Authentication (if using domain authentication), or
SQL Server Authentication (if using SQL credentials).
If using SQL Server Authentication:
Enter the Username (e.g., sa).
Enter the Password.
7. Connect to a Database:
Select a database from the dropdown list (e.g., DEMO10).
Optionally, a database file can be attached by clicking Browse.
8. Test the Connection:
Click Test Connection.
A pop-up will appear indicating whether the connection was successful.
If successful, click OK to save the configuration.
Related Articles
Sql Server LocalDB Installation for New SmartViews
Installation Instructions As of version 462.1000, SmartViews uses LocalDB 2017 in place of the previous local cache. As such, LocalDB 2017 or later needs to be installed on the machine, and an important patch needs to be applied. LOCALDB 2019 ...Smartviews Data Connection
How to Add a data connection? Step 1 : Login to SmartViews and select Designer tab and Click on "Add" a data connection Currently, Smartviews support the following data connection: Microsoft SQL server MS Access MS Excel Oracle ODBC Lillyworks ...SmartViews Scheduler User Guide
PREREQUISITES Supported Visual version are 7.0 – 10.x Database Platform: SQL Server & Oracle Microsoft .Net Framework 4.8 ADMINISTRATION INSTALLING Use the following link to download the setup file. Once downloaded follow these steps to install. Run ...SmartViews - Release Notes
v480.1000 (Pending) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to v23.2Change to framework 4.8 v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic syncing ...SmartViews Network Requirements
In addition to connecting to other databases to view their data, SmartViews also needs to be able to connect to a designated SmartViews database in order to run. This SmartViews database stores the data in SmartViews, such as user accounts, Views, ...