|
This section details the various connection settings available for performing queries on database servers other than MS SQL, MySQL or Oracle. Step 1 and 2 are common to all database queries and connection methods. They are documented in the Database Query Analysis section.
Step 3.1d - Setting Command line connection to Other database servers (ODBC only)
Connection settings for databases other than MS SQL, MySQL or Oracle is only supported through ODBC connection. You can set the connection parameters with the following panel:
Database Query Analysis Wizard — Other (ODBC only) connection settings Page
| • | Connection String: Enter the connection string that includes attributes such as the name of the driver, server, database and security information (user name and password).
In computing, a connection string is a string that specifies information about a data source and the means of connecting to it. It is passed in code to an underlying driver or provider in order to initiate the connection.The connection string may include attributes such as the name of the driver, server and database, as well as security information such as user name and password.Whilst commonly used for a database connection, the data source could also be a spreadsheet or text file. |
| • | Password: Passwords are sensible information that should not be displayed without being encrypted. When a password is included in the string you need to execute, you must use the %{PASSWORD} macro in the string and enter the corresponding password in the Password field (encrypted display). |
Example
String = Driver={MySQL ODBC 3.51 Driver};Server=myserver;Database=mydatabase;User=user;Password=%{SW_PASSWORD};Option=3;
Password = *********
|
 | Note that space characters are not supported for passwords in Windows, thus you need to enter a space-free password if you are working with this operating system. |
Click Next to open the query definition panel.
|
