提供: Bright Pattern Documentation
• English
データアダプターの作成
データアダプターにより、Jaspersoft StudioはSQLクエリを使ってレポートデータベースからデータを取得できます。次の手順に基づいて、クライアントがデータベースにアクセスする方法を定義するプログラミング言語Java用のJava Database Connectivity（JDBC）APIを使用するデータアダプターを作成します。 JDBCは、データベース内のデータを照会および更新する方法を提供します。
Note that creating a data adapter is not required unless you have direct database access; direct database access is a licensed fee.
Procedure
To create a data adapter, navigate to the Repository Explorer tab in the left-hand corner of the screen, and proceed through the following steps.
Step 1: Create a data adapter
- In Repository Explorer, select and right-click Data Adapters.
- Then select Create Data Adapter.
Step 2: Choose your connection
- In the window that pops up, select Database JDBC Connection and click Next.
Step 3: Specify JDBC properties
You will be defining the properties (i.e., driver, database server host, authentication) for the Java Database connection.
In the window that pops up, specify the following:
- Name: Name of the data adapter; note that "New Data Adapter" is the default name but it may be renamed
- JDBC Driver: org.mariadb.jdbc.Driver (Note: copy and paste this driver name into the field, or use the pull-down menu to select this driver.)
- JDBC Url: jdbc:mariadb://<your database server host name>:3306/< your reporting database name>
- Username: Username for access to your Reporting Database
- Password: Password for access to your Reporting Database
Then click Finish.
Notes
- For database server host name, database name, and username, open the Contact Center Administrator application and navigate to Reporting Settings.
- In the JDBC Url field, do not include "<" or ">" symbols. Replace "<your database server host name>" and "<your reporting database name>" with your respective host and database names.
< 前へ