RedshiftConnection

BI# not only supports classical relational database systems, but also Amazon's data warehouse service Redshift.

See .

This process shows how you can use Amazon Redshift by using BI#:

#define EngineVersion 2.0
#define RuntimeVersion 2.0

void RedshiftDemo()
@Description: "Demonstrates how to connect to access an Amazon Redshift database.";
@Category: "Demo";
{
    RedshiftConnection connection = RedshiftCreateConnection("Server=test.redshift.amazonaws.com;Port=5439;Database=test;Uid=client;Pwd=;");
    SQLData result = RedshiftExecuteQuery(connection, "select distinct public.analysis.product from public.analysis");
    foreach (SQLDataRow row in result)
    {
        string product = SQLDataRowGetString(row, "product");
        WriteLine("Found product: " + product);
    } 
    RedshiftDisconnect(connection);
}