PlanetPress® Connect User Guide
  • Table of ContentsTable of Contents
  • IndexIndex
  • GlossaryGlossary
 

Adding data from a Database Data Source

It is possible to add data directly from a Database Data Source and display a record set in PlanetPress Connect Designer without the use of a Data Mapping Configuration.

To add data from a Database Data Source:

  • In the Menus, go to File, Add Data, From Database Data Source....
  • Select the Database type you want to use.
  • Follow the below directions for the chosen database type:

MySQL:

  • Enter the appropriate information to connect to the database:
    • Server: Enter the server address for the MySQL database.
    • Port: Enter the port to communicate with the MySQL server. The default port is 3306.
    • Database name: Enter the exact name of the database from where the data should be extracted.
    • User Name: Enter a username that has access to the MySQL server and specified database. The user only requires Read access to the database.
    • Password: Enter the password that matches the username above.
  • Click Next and enter the information for the source table.
    • Connection string: Displays the full path to the database.
    • Table: Use the drop-down to select the appropriate table or stored query to retrieve the appropriate data set.
    • Encoding: Use the drop-down to select the encoding with which to read the data in the table.
  • Click Finish to save the configuration.

Microsoft Access:

  • Enter the appropriate information to connect to the database:
    • Filename: Browse to your Microsoft Access database file (.mdb)
    • Password: Enter a password if one is required.
  • Click Next and enter the information for the source table.
    • Connection string: Displays the full path to the database.
    • Table: Use the drop-down to select the appropriate table or stored query to retrieve the appropriate data set.
    • Encoding: Use the drop-down to select the encoding with which to read the data in the table.
  • Click Finish to save the configuration.

SQL Server:

  • Enter the appropriate information to connect to the database:
    • Server: Enter the server address for the SQLServer database.
    • Port: Enter the port to communicate with the SQLServer. The default port is 1433.
    • Database name: Enter the exact name of the database from where the data should be extracted.
    • User: Enter a username that has access to the SQLServer and specified database. The user only requires Read access to the database.
    • Password: Enter the password that matches the username above.
  • Click Next and enter the information for the source table.
    • Connection string: Displays the full path to the database.
    • Table: Use the drop-down to select the appropriate table or stored query to retrieve the appropriate data set.
    • Encoding: Use the drop-down to select the encoding with which to read the data in the table.
  • Click Finish to save the configuration.

ODBC DataSource:

  • Select the ODBC system data source. NOTE: Only 32-bit data sources are currently shown in this dialog, even if your system is 64-bits.
  • Click Next and enter the information for the source table.
    • Connection string: Displays the full path to the database.
    • Table: Use the drop-down to select the appropriate table or stored query to retrieve the appropriate data set.
    • Encoding: Use the drop-down to select the encoding with which to read the data in the table.
  • Click Finish to save the configuration.

JDBC:

  • Enter the appropriate information to connect to the database:
    • JDBC Driver: Use the drop-down to select which JDBC Driver to use for the database connection.
    • JAR file path: Enter a path to the JAR file that contains the appropriate driver for the database below.
    • Server: Enter the server address for the database server.
    • Port: Enter the port to communicate with the server.
    • Database name: Enter the exact name of the database from where the data should be extracted.
    • User: Enter a username that has access to the server and specified database. The user only requires Read access to the database.
    • Password: Enter the password that matches the username above.
    • Advanced mode: check to enable the Connection String to manually enter the database connection string.
      • Connection string: Type or copy in your connection string.
  • Click Next and enter the information for the source table.
    • Connection string: Displays the full path to the database.
    • Table: Use the drop-down to select the appropriate table or stored query to retrieve the appropriate data set.
    • Encoding: Use the drop-down to select the encoding with which to read the data in the table.
  • Click Finish to save the configuration.

Oracle:

  • Enter the appropriate information to connect to the database:
    • Server: Enter the server address for the Oracle database.
    • Port: Enter the port to communicate with the Oracle server.
    • Database name: Enter the exact name of the database from where the data should be extracted.
    • User: Enter a username that has access to the Oracle server and specified database. The user only requires Read access to the database.
    • Password: Enter the password that matches the username above.
  • Click Next and enter the information for the source table.
    • Connection string: Displays the full path to the database.
    • Table: Use the drop-down to select the appropriate table or stored query to retrieve the appropriate data set.
    • Encoding: Use the drop-down to select the encoding with which to read the data in the table.
  • Click Finish to save the configuration.
 
 
 
 
 

Table of Contents

Index

Glossary

-Search-

Back