Using External call
External call returns a credential security file for a project, as shown in Figure 6-7. The credential file allows you to run a project remotely, from a command prompt, or a batch file. Typically projects contain load and transformation instructions. You can control what instructions are executed from Data and Transform options in Projects management.
Figure 6-7  
The credential file contains encrypted information about the current date and time, the project name, and security information associated with the system where the product is installed. This information includes security keys that the BIRT Loader installer generates and saves in this folder:
C:\Program Files\Actuate11SP4\BIRTAnalytics\dubnium\qloader
Public-key encryption uses two different mathematically related keys, known as a key pair, to encrypt and decrypt data. Information encrypted using one key can only be decrypted by using the other member of the key pair. The names of the keys are:
*
Public key, associated with the system where the product is installed
*
Private key, used to decrypt the information encrypted with the public key
These files are only valid on the server where they are created. If these files are deleted, you can regenerate them by reloading the BIRT Loader web application to the Tomcat web server. Every time you reinstall the product, you must regenerate the load processes again.
The following activities are available:
*
A drop-down list of the projects the user accesses.
*
Generates a credential token for the selected project. This token is used to launch load processes remotely, or from batch files. By default, the project file name is callProject.tkn. You can change the name by choosing a name specific for a loading project.
Running projects using qLauncher
qLauncher is a Java-based utility, designed to run projects from batch files or a command prompt. The utility launches a load process remotely. The file, qLauncher.jar, is in the Tools folder of the installation files. qLauncher.jar is built using Java 1.7, and requires Java 1.7 in order to run.
The qLauncher command syntax is:
java -jar qlauncher.jar --url=[BIRT Loader Web Service URL] --file=[Credential project file name] --out=[log file name]
Parameters
--url
The BIRT Loader web service URL. This is a required parameter.
--file
The name of the project credential file. This is a required parameter.
--out
The name of the file to save the execution log. This is an optional parameter.
Example:
java -jar qlauncher.jar --url="http://localhost:8080/qloader/run" --file="callProject.tkn" --out="output.txt"
The qLauncher.jar file must be placed in the same folder as the project credential file. To obtain help for the command syntax, open a command prompt, and type the following:
java -jar qlauncher.jar
When you run a project, the utility changes the public key with the private key to log in to the BIRT Loader engine. To automate the data loading, include the command in a batch file.
How to run a project using qLauncher
This procedure runs a project remotely.
1  
1  
2  
3  
Figure 6-8  
In Opening callProject.tkn, choose OK. Depending on the web browser, the file is saved in the configured download folder.
2  
C:\Load\qLauncher
3  
4  
5  
6  
cd C:\Load\qLauncher
7  
java -jar qLauncher.jar
The help for the command syntax appears, as shown in Figure 6-9. This step is optional.
8  
java -jar qlauncher.jar --url="http://dctest:8080/qloader/run" --file="callProject.tkn" --out="output.txt"
The project run finishes and the prompt appears, as shown in Figure 6-9.
Figure 6-9  
9  
qLauncher saves the log file, output.txt, in the current folder. Listing 6-1 shows the log outputs for the executed transactions.
Listing 6-1  
- Loading process started at Fri Apr 26 14:12:30 PDT 2013
04/26/2013 14:12:31 - Starting project [MyFirstProject] at Fri Apr 26 14:12:31 PDT 2013
04/26/2013 14:12:31 - *INFO - Table: [SalesData].[Customers]
04/26/2013 14:12:34 - *INFO - Table: [SalesData].[Customers] - 122
04/26/2013 14:12:34 - *INFO - Table: [SalesData].[CarInventory]
04/26/2013 14:12:35 - *INFO - Table: [SalesData].[CarInventory] - 110
04/26/2013 14:12:35 - *INFO - Table: [SalesData].[DailyPurchases]
04/26/2013 14:12:36 - *INFO - Table: [SalesData].[DailyPurchases] - 35
04/26/2013 14:12:36 - *INFO - Table: [SalesData].[MonthlySales]
04/26/2013 14:12:36 - *INFO - Table: [SalesData].[MonthlySales] - 109
04/26/2013 14:12:36 - *INFO - Table: [SalesData].[SaleOrders]
04/26/2013 14:12:38 - *INFO - Table: [SalesData].[SaleOrders] - 326
04/26/2013 14:12:46 - *INFO - Table: [SalesData].[Employees]
04/26/2013 14:12:47 - *INFO - Table: [SalesData].[Employees] - 14
04/26/2013 14:12:48 - *INFO - Table: [SalesData].[Clients]
04/26/2013 14:12:49 - *INFO - Table: [SalesData].[Clients] - 122
04/26/2013 14:12:49 - Loaded tables: Customers,CarInventory,DailyPurchases,MonthlySales,SaleOrders,
Employees,Clients
04/26/2013 14:12:49 - Project [MyFirstProject] finished at Fri Apr 26 14:12:49 PDT 2013

Additional Links:

Copyright Actuate Corporation 2013 BIRT Analytics 4.2