You are here: Getting Started > Connecting to a data store

Connecting to a Data Store

To connect to a new Data Store in order to process a set of data:

Right-click on Data Stores within your project in the Project Browser, and select New Data Store:

Select the category of data store that you want to connect to - Database, Text file, XML file, MS Office file, or Other (if you want to specify connection details using JDBC or ODBC)
Select where the data will be accessed from - the server or the client (See Client-side Data Stores)
Select the type of data store that you want to connect to (for example, for databases, select the type of database, for example, Oracle, SQL Server, MS Access etc.)
Specify the connection details to the data. For example:

For a client-side Access database, browse to the .mdb file on the local file system.
For a client-side Text file, browse to the directory that contains the text file on the local file system. For fixed-width text files, you must also define the fields that are present in the file.
For a server-side file (Access, Text, Excel or XML), enter the name of the file as it exists (or will exist) in the server landing area, including the file suffix. It is possible to use a project-specific landing area to enforce isolation between data in different projects. Administrators will need to setup a landing area for the projects which require the use of this functionality. Again, for fixed-width text files, you must also define the fields that are present in the file.

For a Database, specify the Database host, Port number (if not using the default port number), Database Name, User Name,Password, and Schema (if different from the default Schema for the User).
For a database accessed via a JNDI connection, specify the JNDI name.
For any other type of data that can be accessed via an ODBC bridge connector, specify the ODBC DSN, JDBC URL, User name and Password.
For any Other type of data that can be accessed via JDBC, specify the Driver Class Name, JDBC URL, User name and Password.

Note: Connecting non-native types of data source requires some knowledge of JDBC connectivity.

If you want to check the connection to the new data store, use the Test button. Note that it is possible to specify connection details to a file that is not yet present (such as a file to be created by an export task in OEDQ).
Give the data store a Name, and click Finish

The new data stories now configured and visible in the Project Browser.

Alternatively, if the data store is going to be shared across projects, you can create it at the System level (outside of any specific project) in the same way as above.

The next step is to Add a snapshot of data from your data store.