Motivation:
This is a short example to demonstrate how to access Data Virtuality via an ODBC connection in F#. Please keep in mind that this is not an F#/.NET code and the sample just shows a basic approach for the ODBC connection.
Requirements:
The system which shall access Data Virtuality Server needs to have at least the ODBC drivers installed. A DSN connection is also possible but requires the ODBC drivers as well. They can be obtained from the web server which is implemented in Data Virtuality (see https://datavirtuality.zendesk.com/hc/en-us/articles/115002027906-Components-downloadable-from-DV-site)
Simple code sample:
The following sample creates a connection string based on a DSN. It is then used for a new ODBC connection and the program executes the query “SELECT * FROM dwh.foo” on this connection.
Afterwards, the name of the first column of the result set is retrieved and all values for this column are printed.
open System
open System.Data.Odbc
[<EntryPoint>]
let main argv =
let connectionString = “DSN=DataVirtuality_32_A;username=admin;pw=admin;”
let dvConn = new OdbcConnection(connectionString)
let qComm = new OdbcCommand(“SELECT * FROM dwh.foo”,dvConn)
qComm.Connection.Open()
let result = qComm.ExecuteReader()
let firstColumn = result.GetName(0)
printfn “%A” firstColumn
while result.Read() do printfn “%A” (result.GetValue(0))
result.Close()
dvConn.Close()
System.Console.ReadKey()
0 // return an integer exit code
The point thing is the connection string which can be build based on a DSN or an ODBC driver
Connect via DSN
let connectionString = "DSN=DataVirtuality_32_A;username=admin;pw=admin;"
Connect via Driver and other information
let connectionString = "driver={DataVirtuality ANSI}; server=dv; port=35432; database=datavirtuality; uid=admin;pwd=admin";