Bold & Format John Lee
In defining a database source or target, the information entered in the different fields (driver, database, login, etc.) is used to construct a connection string that Jitterbit uses when it needs to connect to the database during an operation. However, you also have the option to specify this connection string manually.
- To do this, Check the Construct Connection String Manually checkbox, which will disable most of the fields on the tab. Here is what to do with the fields that remain enabled.
- Enter the connection string in the Connection String text field.
- Enter what database driver to use when connecting.
- In the Timeout field, you must still Enter a connection time out value, because it is handled separately from the connection string.
- Since the manual connection string will be visible in clear text in the source/target page, you may not want to include the password there. In that case, leave the password parameter and value out of the connection string, and instead define the password as you would when creating database sources and targets using the automatically created string. To do this, Click the Password button and Enter the password. The password will be appended to the connection string when needed, and it will never be visible on the screen.
- If you are using a JDBC driver, you can also leave out the user name from the connection string, and use the dedicated Login field instead.