User Tools

Site Tools


Menu

Company Website

Video Tutorials

Documentation for Streamline 4.x

User Guide

1. General Information

2. Starting Up

3. Connecting data

4. Demand and Sales Forecasting

5. Inventory Planning

6. Reference

database-connection

3.4. Databases

Database connection allows importing the entire spectrum of data types that Streamline can take in order to plan your demand, forecast revenue, and optimize your inventory. You can activate additional axes in Streamline such as Locations and Channels by providing the corresponding data types. The first one allows you to plan your demand and inventory by location or site. The other one, to forecast and plan your future sales by channel or customer.

Database connection uses the ODBC or MySQL driver to import data into Streamline. This connector works with 32-bit/64-bit ODBC data sources if the 32-bit/64-bit version of Streamline is installed accordingly.

Watch a video tutorial (8:32)

 

Along with the most commonly used cases as:

we will also explain what data types you need to provide and how to import them in the following special cases:

Besides importing capabilities, Database connection allows you to export the results and outcomes of Streamline's planning.

Below, we give an introduction to the Database connection dialog and discover the generic capabilities of this connector. You will learn how to establish a connection to a database and read the content of its tables.

To open the dialog, go to the menu File > New > Database connection.

The dialog differs only in database connection options whether the ODBC or MySQL driver is used. Below, we describe how to configure a connection to a database using the ODBC or MySQL option of the dialog.

ODBC

There are three ways to connect to an ODBC data source in Streamline:

  • Choose your connection configuration from the Data source name drop-down. In this case, your configuration should be created outside Streamline prior to selecting it in the dialog. Streamline automatically pulls out all available ODBC connection configurations from your system and shows them in the drop-down list of the Data source name control.
  • Create a connection string to your database by clicking the Build button.

After the driver has been selected, Streamline opens its native configuration dialog where you can set up the database (or data file) and enter login credentials. Finally, Streamline automatically inserts the resulting connection string into the Data source name field.

If Streamline can’t detect an interactive tool for building the connection string, it shows a “This driver cannot build connection string interactively.” message. In this case, refer to the driver documentation and build the connection string manually.
  • Enter the connection string into the Data source name field manually. The login information can be excluded from the string and entered in the Username and Password fields.

MySQL

Host is the IP address, domain name, or LAN name of the MySQL server.

Port is the port listened to by the MySQL server.

Database is the name of the database you are connecting to.

Using the MySQL option is much faster than connecting to MySQL database using ODBC driver.

After the driver settings are set, enter the database account credentials into the Username and Password fields of the dialog.

Reading the Database Tables

To read the tables of the database, click the Read button. The list of the tables will appear on the right side of the dialog.

To show the content of a table, double-click on the table name in the list. The content will appear in the table at the bottom of the dialog.


Next: Data types

Download PDF

database-connection.txt · Last modified: 2019/07/11 07:41 by admin