Category Archives: Command Line

Copy binary as text via clipboard to a remote desktop

Sometimes you are not allowed to transfer files between machines but you can transfer text via clipboard. A little hack how to transfer a file using a standard Windows utility certutil. 

Create a text file encoding the file

certutil -encode file.zip file.txt

Open and copy text

Create a new file on the remote desktop and paste the text

Decode the file into zip

certutil -decode file.txt file.zip

 

Backup scheduled reports

recurring.txt

action = exportXML
exportBiarLocation = recurring.biar
userName = Administrator
password = 
authentication = secEnterprise
CMS = localhost
exportDependencies = false
includeSecurity = false
exportQueriesTotal = 1
exportQuery1 = select * from CI_INFOOBJECTS where SI_RECURRING=1

recurring.bat

SET BO=C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0
"%BO%\win32_x86\jre8\bin\java.exe" -jar "%BO%\java\lib\biarengine.jar" recurring.txt

Creating ODBC system DNS with command line 

%WINDIR%\System32\odbcconf.exe CONFIGSYSDSN "SQL Server" "DSN=macoprod|Description=macoprod|SERVER=10.2.151.18|Trusted_Connection=No|Database=macoprod"
%WINDIR%\SysWOW64\odbcconf.exe CONFIGSYSDSN "SQL Server" "DSN=macoprod|Description=macoprod|SERVER=10.2.151.18|Trusted_Connection=No|Database=macoprod"