Home Forums Programming CLR Integration and Programming. SQL 2008 R2 - Need to create a CLR assembly that calls a Java function and implement as a UDF RE: SQL 2008 R2 - Need to create a CLR assembly that calls a Java function and implement as a UDF

  • The source code for the function is proprietary, and thus, unavailable. The number of rows it would apply to would be relatively small. As the only non-ETL alternative would be to decrypt a significantly larger quantity of rows, there's really no viable alternative ... especially from a performance perspective, where the alternative is known to be a serious performance problem waiting to happen.

    I also need detailed step by step so that I can learn the process as well as understand it. I can read the VB code needed as I've been writing VBA and VBScript for more years than most folks have been working with computers, but I don't have any exposure to the details behind how a .NET assembly is compiled / created / deployed, or, once those things are done, referenced by a SQL Server UDF.

    sturner (2/26/2014)


    You'll need to create a .NET assembly that ultimately calls out to the Java routine. There will be a lot of overhead in this so consider how it will be used - the performance may be unacceptable.

    If it were me, I would implement the functionality in straight .NET.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)