Binnen Transpas wordt voor verschillende functionaliteit gebruik gemaakt van OLE Automation Stored Procedures. Deze worden meegeleverd met SQL Server. Om gebruik te mogen maken van deze procedures moet een gebruiker de rol sysadmin hebben binnen SQL Server.
De voornaamste functionaliteit waar dit voor wordt gebruikt is interactie met het bestandssysteem, het lezen en schrijven van bestanden.
Voor, onder andere, de volgende functies worden de procedures gebruikt:
Als alternatief voor de sysadmin rechten kunnen de verschillende procedures ook worden toegekend aan andere rollen. Zie hiervoor het script hieronder. Let er hierbij op dat het met deze procedures onder andere mogelijk is om bestanden te lezen en schrijven vanuit de security context van de SQL Server. Dat wil zeggen met de rechten van het account waaronder de SQL Server service draait.
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OACreate] TO [public]
GO
GRANT EXECUTE ON [sys].[sp_OASetProperty] TO [public]
GO
GRANT EXECUTE ON [sys].[sp_OAGetProperty] TO [public]
GO
GRANT EXECUTE ON [sys].[sp_OAMethod] TO [public]
GO
GRANT EXECUTE ON [sys].[sp_OAGetErrorInfo] TO [public]
GO
GRANT EXECUTE ON [sys].[sp_OAStop] TO [public]
GO
GRANT EXECUTE ON [sys].[sp_OADestroy] TO [public]
GO
Hieronder een lijst met functies waarin deze procedures worden gebruikt (in versie 2.25 Release 6).
| Naam | Type |
|---|---|
| BytesToString | Scalar Valued Function |
| DetectEncoding | Table Valued Function |
| Dir | Table Valued Function |
| EvaluateBarcode | Table Valued Function |
| FileExists | Scalar Valued Function |
| FileToBin | Scalar Valued Function |
| FolderExists | Scalar Valued Function |
| GetEnvironmentVar | Scalar Valued Function |
| GetTempFolder | Scalar Valued Function |
| ReadFileContents | Scalar Valued Function |
| ReadFileContentsEx | Scalar Valued Function |
| RegexFind | Table Valued Function |
| RegexMatch | Scalar Valued Function |
| RegexReplace | Scalar Valued Function |
| RegexSplit | Table Valued Function |
| sp_AccountViewNetHandler | Stored Procedure |
| sp_AddFileToZipfile | Stored Procedure |
| sp_AFASSoap | Stored Procedure |
| sp_ASLAS_DeleteRecord | Stored Procedure |
| sp_ASLAS_GetDatasetInfo | Stored Procedure |
| sp_ASLAS_GetDataWithMetaData | Stored Procedure |
| sp_ASLAS_GetDataWithParameters | Stored Procedure |
| sp_ASLAS_InsertRecord | Stored Procedure |
| sp_ASLAS_Login | Stored Procedure |
| sp_ASLAS_Logout | Stored Procedure |
| sp_ASLAS_UpdateRecord | Stored Procedure |
| sp_AvalancheSOAP | Stored Procedure |
| sp_BinToFile | Stored Procedure |
| sp_BinToString | Stored Procedure |
| sp_BusinessCentralWebservice | Stored Procedure |
| sp_CheckVat | Stored Procedure |
| sp_CreateMonitoringEvent | Stored Procedure |
| sp_DeleteDocument | Stored Procedure |
| sp_EmailAccountOAuthHelper | Stored Procedure |
| sp_ExactOnlineSoap | Stored Procedure |
| sp_ExistsInAvalanche | Stored Procedure |
| sp_FileAction | Stored Procedure |
| sp_FinnlinesWebservice | Stored Procedure |
| sp_FormattedDataToXml | Stored Procedure |
| sp_ForSeaWebservice | Stored Procedure |
| sp_GeocodeAddresses | Stored Procedure |
| sp_GeocodeLocations | Stored Procedure |
| sp_GetCurrencyRateProviderRates | Stored Procedure |
| sp_GetFormatDefXml | Stored Procedure |
| sp_HandleHttpRequest | Stored Procedure |
| sp_HandleWebRequest | Stored Procedure |
| sp_HttpRequest | Stored Procedure |
| sp_HttpRequest2 | Stored Procedure |
| sp_iMuisKingWebservice | Stored Procedure |
| sp_LoketWebservice | Stored Procedure |
| sp_MC_ProcessAttachmentXml | Stored Procedure |
| sp_MC_QC_Subscribe | Stored Procedure |
| sp_MC_SendSMS | Stored Procedure |
| sp_MissionPlannerWebservice | Stored Procedure |
| sp_NavisionWebService | Stored Procedure |
| sp_NmbrsWebservice | Stored Procedure |
| sp_PO_ImportPurchaseInvoicesXml | Stored Procedure |
| sp_PO_TransferPurchaseInvoice | Stored Procedure |
| sp_POFerriesWebservice | Stored Procedure |
| sp_ReadFileContents | Stored Procedure |
| sp_ResendSysMailItem | Stored Procedure |
| sp_Ropo24Webservice | Stored Procedure |
| sp_RP_CalculateCombinationRoute | Stored Procedure |
| sp_RP_CalculateTripActivityETA | Stored Procedure |
| sp_RPT_CalculateCombinationRoute | Stored Procedure |
| sp_SI_TransferSalesInvoice | Stored Procedure |
| sp_SnelStartOnline | Stored Procedure |
| sp_SO_CalculateLegRoute | Stored Procedure |
| sp_SO_CalculateSubLegRoute | Stored Procedure |
| sp_SO_CalculateTemplateLegRoute | Stored Procedure |
| sp_SO_CopyDocument | Stored Procedure |
| sp_SO_ImportTemplateLegs | Stored Procedure |
| sp_SO_ImportTransportBookingsXml | Stored Procedure |
| sp_SpedionSOAP | Stored Procedure |
| sp_SproomWebservice | Stored Procedure |
| sp_StartService | Stored Procedure |
| sp_StopService | Stored Procedure |
| sp_StoreDocument | Stored Procedure |
| sp_StripNilledElementsFromXml | Stored Procedure |
| sp_T3Webservice | Stored Procedure |
| sp_TA_NormalizeRule | Stored Procedure |
| sp_TidyXml | Stored Procedure |
| sp_TrackunitWebservice | Stored Procedure |
| sp_TransformXml | Stored Procedure |
| sp_TransicsSOAP | Stored Procedure |
| sp_TransMissionWebService | Stored Procedure |
| sp_TTLineWebservice | Stored Procedure |
| sp_TwinfieldWebservice | Stored Procedure |
| sp_UnicontaWebservice | Stored Procedure |
| sp_Unit4Webservice | Stored Procedure |
| sp_UnzipFiles | Stored Procedure |
| sp_VehcoWebservice | Stored Procedure |
| sp_WM_ImportOrdersXml | Stored Procedure |
| sp_WriteLogToFile | Stored Procedure |
| sp_WriteStringToFile | Stored Procedure |
| StringToBytes | Scalar Valued Function |
| tvf_3P_WarehouseParseBarcode | Table Valued Function |
| tvf_FileToBin | Table Valued Function |
| ValidateEmailAddress | Scalar Valued Function |
| Win32_Service | Table Valued Function |
| WriteStringToFile | Scalar Valued Function |