AWS Lambda和SQL Server集成 [英] AWS Lambda and SQL Server Integration

问题描述

我的应用程序使用MS Sql Server.现在，在了解了AWS Lambda之后，我想将我的应用程序转移到AWS Lambda以具有无服务器架构.

My application uses MS Sql Server. Now after knowing about AWS Lambda, I want to shift my application to AWS Lambda to have server-less architecture.

但是正如我提到的，应用程序使用Sql Server.因此，我不确定AWS Lambda是否支持与Sql Server的连接.

But as I mentioned, application uses Sql Server. So I am not sure if AWS Lambda supports connection with Sql Server.

任何评论/链接都会有所帮助.

Any comments/ links will be helpful.

推荐答案

下面是一些示例示例，其中带有注释以从Lambda连接到MS SQL Server数据库(假设使用NodeJS作为您的语言).

Here is some example boilerplate with comments to connect to an MS SQL Server database from Lambda (Assuming using NodeJS as your language).

const sql = require('mssql');

exports.handler = async (event, context, callback) => {

    let lookupValue = event.lookupValue;

    // Take DB Config from environment variables set in Lambda config
    const config = {
        user: process.env.DB_USERNAME,
        password: process.env.DB_PASSWORD,
        server: process.env.DB_SERVER,
        database: process.env.DB_DATABASE,
        options: {
            encrypt: true // Use this if you're on Windows Azure
        }
    }

    try {
        // Open DB Connection
        let pool = await sql.connect(config)

        // Query Database
        let result = await pool.request()
            .input('lookupValue', sql.Int, lookupValue)
            .query('select * from exampleTable where id = @lookupValue');

        // Close DB Connection
        pool.close();

        // The results of our query
        console.log("Results:", result.recordset);

        // Use callback if you need to return values from your lambda function.
        // Callback takes (error, response?) as params.
        callback(null, result.recordset);
    } catch (err) {
        // Error running our SQL Query
        console.error("ERROR: Exception thrown running SQL", err);
    }

    sql.on('error', err => console.error(err, "ERROR: Error raised in MSSQL utility"));
}

注意:您需要将运行mssql所需的node_modules上传到函数中.我发现最简单的方法是将整个文件夹(您的主要[通常为index.js]函数文件以及package.json和您的node_modules文件夹)压缩在一起，然后使用aws-cli上传:

Note: You will need to upload to your function the node_modules required to run mssql. The easiest way I've found to do this is to zip up the whole folder (your main [usually index.js] function file, along with package.json and your node_modules folder), and then upload it using the aws-cli:

aws lambda update-function-code --function-name your-function-name-here --zip-file your-zipped-project-directory.zip 

最后，确保您的数据库能够接受来自AWS Lambda函数的连接.最好的方法是结合使用AWS的VPC，NAT和Elastic IP设置-此示例在此博客文章中有所描述:

Finally, make sure that your database is able to accept connections from the AWS Lambda function. The best way to do this is to use a combination of AWS's VPC, NAT, and Elastic IP settings - and example of which is described in this blog post: https://medium.com/@matthewleak/aws-lambda-functions-with-a-static-ip-89a3ada0b471

这篇关于AWS Lambda和SQL Server集成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！