SQL Server Connection window

From DataSelf Knowledge Base
Jump to navigation Jump to search

There is one data warehouse database per ETL project. The SQL Server Connection window manages the connection to the current project's data warehouse database.

SQL Server Connection window. Configures the connection between the ETL's current project and it's data warehouse database.


DataSelf Standard Names for Data Warehouse Connections and Data Bases

Source System ETL's Data Source Name of Data Warehouse SQL Server Database Name of Data Warehouse
MS Dynamics GP DSDWDYNGP DwDynamicsGP
Sage Accpac DSDWACCPAC DwSageAccpac
SageCRM DSDWCRM DwSageCRM
Sage MAS 90 DSDWMAS90200 DwMas90200
Sage MAS 200 DSDWMAS90200 DwMas90200
Sage MAS 500 DSDWMAS500 DwMas500
Sage PRO DSDWSAGEPRO DwSagePro
Sage PFW DSDWSAGEPFW DwSagePfw
Sage SalesLogix DSDWSALESLGX DwSlsLgx
SAP Business One DSDWBIZONE DwSapBiz1