CData Python Connector for SAP BusinessObjects BI

Build 21.0.8011

Connecting

Connecting with a Dialect URL

A specific URL format is used to establish a connection using SQLAlchemy. For this connector, either of the following URL formats are acceptable when creating the engine:

Format 1


from sqlalchemy import create_engine
engine = create_engine("sapbusinessobjectsbi:///?User=MyUser;Password=MyPassword;Url=http://myserver:6405/biprws;")

Format 2


from sqlalchemy import create_engine
engine = create_engine("sapbusinessobjectsbi://User:Password@/?URL=http://{Server-Name}:6405/biprws;")

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.8011