FORGOT YOUR DETAILS?

DATA ENVIRONMENT

With the help of MyReport data, user can connect to mentioned databases directly and to all other databases having ODBC (Open database connectivity) drivers. User can connect to all databases either locally or remotely & accordingly user would need his login credentials.

For successful Connection to any database, the credentials needed to pass depend on the kind of database you wish to connect to (eg. MSSQL, MYSQL, Oracle, Firebird, Interbase, Informix, PostGreSQL, AS400 etc). Nature of Credentials vary (Hostname, Database Name, OS authentication, User name & Password). Once the user successfully connects to the database, they can retrieve all the tables from original data source and perform numerous operations on it.

data environment (2)

Lets see how MyReport can connect to any database in seconds

For eg, To connect to MSSQL locally, mandatory credentials are Host Name, Database Name & OS authentication

en1

To connect to MSSQL Remote machine, mandatory credentials are Host Name, Database Name & OS authentication

Host Name is - host_Namesql_Instance_Name, port

en2

To connect to ORACLE local machine, mandatory credentials are Host Name, User Name and Password

en3

To connect to ORACLE remote machine, mandatory credentials are Host Name, User Name and Password

Host Name Syntax- Host Name or Ip: Oracle Port: System Id

en4

User can limit the number of tables to be fetched, from original database, by unchecking “retrieve all the tables” option.

Process

  1. Uncheck the “retrieve all the tables” option,
  2. Fetch only required tables – go to search (+) option – enter table name in MyReport data.
  3. Select OK – now your table is ready to use

en5

TOP