Data From Database

Import from Database function is used to get data from database.

SheetKraft contains the Data From Database option which can be accessed by the Import From Button present in the SheetKraft Toolbar ( See figure) Ribbon

The data can be imported from a particular table of the database. Or a Stored Procedure or Manual Query can be used to retrieve data from database.

Case 1: Basic Example

The following guidelines describe how data can be imported from a particular table using Data From Database.

Step 1

Click on the Import From Button and select the Database option to open this dialogue box. Data

Step 2

Click on the browse button next to Connection, to configure the database connection. If the Configuration File is already setup as explained in Desktop & Server Configurations, then this step can be skipped. Data

A window for configuring connection appears. Configure the connection as shown in Step 4 of Export to Database.

Step 3

After entering the connection settings, select Table option. Data

Select the table name by clicking on the browse button next to the Table Name. Data

The database tables are listed in the format <Schema_Name>.<Table_Name>. Data

Step 4

After selecting the database table, the data in the database table will be loaded. Data

Select the required columns in the output by checking on the checkbox corresponding to each column. The columns can be reordered by dragging the headers.

Step 5

The number of data rows retrieved from the database can be limited bt checking Max rows and entering the required number in the corresponding field. Data

Step 6

To get filtered/sorted data, click Filter/Sort and follow the steps given in Filter/Sort. Click Next to get the data without filtering or sorting. Data

You will be asked where to save the result. To save the data in the Existing WorkSheet, you can input the index of the starting cell where you want to copy the data. Or you can save the data in a New Worksheet. Data

Step 7

After entering your choice, click Finish. Data

Case 2: Using Stored Procedure

Repeat the steps 1 and 2 in Case 1.

Step 3

After entering the connection settings, select Procedure option. Data

Select the procedure by clicking on the browse button next to Procedure. Data

The following window appears where the stored procedures are listed in the format <Schema_Name>.<Procedure_Name>. Data

Step 4

After selecting the stored procedure, parameters in the procedure, if any, will be loaded. Data

Enter the parameter values in the field corresponding to each parameter.

Step 5

Click on Show Preview to display the data that will be retrived. This can also be used to check if there is any error in the parameter values. Data

Data

Step 6

Continue steps 5-7 in Case 1. The result is shown in figure below: Data

Case 3: Using Manual Query

Repeat the steps 1 and 2 in Case 1.

Step 3

After entering the connection settings, select ManualQuery option. Data

Step 4

Enter the query to retrieve data from the database in the field to Query. Data

After entering the query, if the query doesnot have any error , the data to be imported will be loaded. Data

Step 5

Continue steps 6-7 in Case 1. The result is shown in figure below: Data