Connect to SAP ECC from Web or Workstation (2024)

Learn how to connect to SAP ECC via the Data Source dialog and handle your connection.

Upon successful connection, you can begin importing data.

How to Authenticate

The SAP ECC connector does not support live connect mode.

  1. In MicroStrategy Web, click the Create button > Add External Data.

    In MicroStrategy Workstation, click Create a new dataset Connect to SAPECC from Web or Workstation (1) and choose a project.

  1. Select the SAP ECC connector.

  2. Next to Data Sources, clickNew Data Source<![CDATA[ ]]>Connect to SAPECC from Web or Workstation (2) to add a new connection.

    Connect to SAPECC from Web or Workstation (3)

    The Data Source dialog appears when there are no new database roles or connections.

  3. Enter your connection credentials in the Data Source dialog.

    Connect to SAPECC from Web or Workstation (4)

    • Data Source Name: A unique connection name is required.

      If you enter an existing name, the following error is returned: The database connection name already exists.

    • SAP Gateway URL: The Service URL for the ODATAservice.

      For details on URL formats supported by the connector, see URL Handling.

    • Username: The username of a valid user account in SAP ECC.
    • Password: The password of a valid user account in SAPECC.

  4. Click Save.

Data Source Handling

Administrators can delete database connections created via MicroStrategy Web by going to Developer Administration > Configuration Managers > Database instances.

  1. Under Data Sources, hover over your connection and click the more icon Connect to SAPECC from Web or Workstation (5).

    Connect to SAPECC from Web or Workstation (6)

  2. Select one of the following options:

    • Edit: Modify the fields in the Data Source dialog.
    • Delete: Remove your connection from Data Sources.
    • Rename: Rename your connection.
    • Share: Share your connection and grant controlled access to other users.

      Connect to SAPECC from Web or Workstation (7)

    • Duplicate: Create a duplicate connection.

      By default, the duplicated connection's name begins with Copy of , followed by the original connection name. You can rename the duplicated connection.

      For security reasons, the duplicated connection is populated with the hardcdded string, PWDHIDDEN123!@#. Clicking on the connection, without changing the password, returns the following error message: Your credentials and/or authentication mode are incorrect.

      Administrators can delete the database connections created via Web by going to Developer > Administration > Configuration Managers > Database Instances.

  3. Click on the newly created connection and select from any of the displayed tables.

Once a connection is established, you can get started with the data importing process.

Connect to SAP ECC from Web or Workstation (2024)

FAQs

How to connect to SAP ECC database? ›

Connect to SAP ECC from Web or Workstation
  1. Select the SAP ECC connector.
  2. Next to Data Sources, click New Data Source to add a new connection. The Data Source dialog appears when there are no new database roles or connections.
  3. Enter your connection credentials in the Data Source dialog. ...
  4. Click Save.

How are we integrating SAP ECC to Portal? ›

Answers (4)
  • Create RFC Destinations in J2EE Engines in EP 6.0.
  • Create TCP/IP connection RFC Destinations for SAP EP 6.0 in SAP ECC.
  • Maintain Portal Server Settings for SAP EP 6.0 in SAP ECC.
  • Maintain Single Sign-On in SAP ECC.
  • Export the ECC Certificate from SAP ECC.
  • Import the ECC Certificate into SAP EP 6.0.

How to connect bods to SAP ecc? ›

Steps required to connect BODS 4.2 to SAP ECC to use Extractors to extract data from ECC
  1. Install OpenDataProvider API on ECC system. ...
  2. Create a RFC connection/user in ECC (tcode: sm59) - under the TCP/IP Connections.
  3. Then create a datastore in BODS and use the RFC connection details from Step2.
Jan 18, 2017

What is the difference between SAP ERP and SAP ECC? ›

ECC is an ERP solution provided by SAP. ECC stands for ERP Central Component and ECC is a term confined to SAP only. ECC is a component of SAP's ERP software package. The ERP suite provides the overall management and control of the functions.

What database does SAP ECC use? ›

Database: ECC supports databases from other providers such as Db2, Oracle, or Informix, however, S/4HANA only runs on SAP HANA.

How to connect SAP with website? ›

Add connection in SAP Cloud Platform co*ckpit
  1. Click Connectivity -> Destinations -> New Destination.
  2. Add system I73 with additional properties PS: Here I use odata_abap,dev_abap,ui5_execute_abap as the WebIDEUsage.
  3. Check connection:
Apr 10, 2017

Can SAP ECC run on Cloud? ›

Migrating SAP ECC or HANA environment from On-Premise to Cloud is a complex process that requires careful planning and execution. The process involves several critical steps, including optimizing the cloud environment, to ensure that the SAP system performs optimally in the new environment.

How do I connect to SAP server remotely? ›

Procedure
  1. From the menu bar, choose File Manage SAP Remote Connection. ...
  2. Configure an S-User with the following authorizations: ...
  3. To enable or disable services and to capture customer system information required by these services, such as IP address, choose Remote Connection Configuration Wizard (RCCW).

How to get data from SAP ECC? ›

Enter the Extractor Checker S-API (RSA3) transaction to open the extractor. The following window opens: In the DataSource field, select a data source from the list of available data sources. Select the relevant data source and choose OK.

Is SAP ECC outdated? ›

By 2027, SAP will no longer maintain SAP ECC, so companies will need to migrate to SAP S/4HANA. In this article, we'll explore the key differences you need to be aware of before you make the move.

Is SAP ECC web based? ›

At its core, R/3 uses a client-server model to store, retrieve, analyze, and process data while SAP ECC runs on a web-based application server.

Who uses SAP ECC? ›

SAP ERP Central Component (ECC) Customers by Geography

The top three geographies of SAP ERP Central Component (ECC) for enterprise-resource-planning-erp are the United States with 2,156(42.95%), India with 789(15.72%), United Kingdom with 350(6.97%) customers respectively.

How do I log into SAP database? ›

Procedure
  1. In the context menu of the database, choose Login.
  2. Enter user name and password of the user with which you want to log on. Authentication Information. Property. Description. User Name. Users fall into two groups: DBM operators: These users can perform administrative tasks.

How to connect SAP to external database? ›

To establish a connection from SAP to an external database, users can leverage two primary methods: using the 'DBAco*ckPIT' transaction code or the 'DBCO' transaction code. DBAco*ckPIT: Navigate to the DBAco*ckPIT transaction code to initiate the process of creating a database connection.

How do I view table data in SAP ECC? ›

SM30--views of the table(search with * table name*) you will get the view for table. you can maintain entries thru sm30 for the tables T****. You must be a registered user to add a comment.

Top Articles
Latest Posts
Article information

Author: Geoffrey Lueilwitz

Last Updated:

Views: 6074

Rating: 5 / 5 (80 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Geoffrey Lueilwitz

Birthday: 1997-03-23

Address: 74183 Thomas Course, Port Micheal, OK 55446-1529

Phone: +13408645881558

Job: Global Representative

Hobby: Sailing, Vehicle restoration, Rowing, Ghost hunting, Scrapbooking, Rugby, Board sports

Introduction: My name is Geoffrey Lueilwitz, I am a zealous, encouraging, sparkling, enchanting, graceful, faithful, nice person who loves writing and wants to share my knowledge and understanding with you.