Open topic with navigation
Supported Database Types
Delimiters are special characters that are used to separate the fields in a data file.
Microsoft Excel is a spreadsheet application. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Access is a database management system that combines the Microsoft Jet Database Engine with a user interface and software development tools.
Note that you must have the appropriate drivers installed to run Excel or Access. These drivers are installed with Microsoft Office. If you do not have Office, you will need to go to the Microsoft website and download the drivers.
If you have a 64-bit computer and a 64-bit operating system, you can download 64-bit drivers from the Microsoft website. However, if you have a 32-bit computer, or a 64-bit computer and a 32-bit operating system, you must download a 32-bit driver.
Microsoft SQL Server is a relational database management system. As a database server, SQL Server has the primary function of storing and retrieving data as requested by other software applications. If you have SQL Server already set up on your computer or network, you can connect to it from the Database Setup Wizard.
Oracle is an object-relational database management system. An Oracle database system comprises at least one instance of the application along with data storage. You connect to your Oracle database by using the Database Setup Wizard. When you connect, you can select your authentication method: either Windows Authentication or Database Authentication.
MySQL is an open-source relational database management system. MySQL's primary function is to store and retrieve data as requested by other software applications. It is most often used in small-to-medium scale single-server deployments, either as a component in a LAMP-based web application or as a standalone database server. You connect to MySQL from the Database Setup Wizard. When you connect, the wizard enables you to choose to use your current credentials (Windows Authentication) or to specify the user name and password that were created with the database (Database Authentication).
An Intermediate Document (IDoc) is a transactional message, in the form of a text file, sent from an SAP-connected program to other programs. Most of an IDoc message consists of fields of data that are grouped into segments. The segments themselves have a hierarchical relation to each other. For more information, refer to Using SAP IDoc Files.
Database (DB)2 is a group of relational database products that are offered by IBM. DB2 provides an open database environment that runs on a wide variety of computing platforms. Using Structured Query Language (SQL), users can obtain data simultaneously from DB2 and other databases.
IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) types. The Informix server supports the object-relational model, which enables IBM to offer extensions that support data types that are not SQL standard.
PostgreSQL is an open-source, object-relational database system. PostgreSQL's primary function is to store and retrieve data as requested by other software applications. You connect to PostgreSQL from the Database Setup Wizard. When you connect, the wizard enables you to choose to use your current credentials (Windows Authentication) or to specify the user name and password that were created with the database (Database Authentication).
Firebird is an open-source, relational database management system. Its primary function is to store and retrieve data as requested by other software applications. You connect to Firebird from the Database Setup Wizard. When you connect, the wizard enables you to choose to use your current credentials (Windows Authentication) or to specify the user name and password that were created with the database (Database Authentication).
A number of OLE DB providers are installed with Windows, and others can be obtained from database manufacturers.
To see what OLE DB data sources are available on your computer, create a plain text file and give it the file name extension ".udl". Double-click the file to open the Windows Data Link Properties dialog. Click the Providers tab to see the list of providers.
ODBC stands for Open Data Base Connectivity. An ODBC data source is a set of configuration information that specifies at least the following:
An ODBC driver that is designed to read from a particular database format
Depending on the database format, the name of either a directory or file that contains one or more tables
A name for this set of information
ODBC is a technology that enables programs to read information from different data sources without having to understand specific details of the particular database format. This is done through the use of ODBC drivers.
ODBC drivers exist for all major database management systems, for many other data sources such as address book systems and Excel, and even for text or CSV files. To add, modify, or remove ODBC data sources, use the ODBC Data Source Administrator dialog.