Menu
Welcome, Guest
Username: Password: Remember me

TOPIC: Hi there how to open the data-integration report

Hi there how to open the data-integration report 1 week 4 days ago #91438

  • lakeZhang
  • lakeZhang's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
:(
Hi ,i have no problem of running and install the script , but how to use the data-integration and see the outcome report ?thx,best regards
The administrator has disabled public write access.

Hi there how to open the data-integration report 1 week 4 days ago #91439

  • ivyis
  • ivyis's Avatar
  • Offline
  • Moderator
  • Posts: 26
  • Thank you received: 6
  • Karma: 0
There are two projects. One is SuiteCRM Data Integration. This is the ETL solution that pulls data from SuiteCRM and places it into the Data Warehouse. The other project called SuiteCRM Analytics is the reporting suite where you can run reports and dashboards.

You can download the reporting project here.

docs.suitecrm.com/admin/suitecrm-analytics/scrm-analytics/
The administrator has disabled public write access.
The following user(s) said Thank You: lakeZhang

Hi there how to open the data-integration report 1 week 4 days ago #91443

  • lakeZhang
  • lakeZhang's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Thx for reply ,yes ,i have download and successfully run the two script. I can see my database is filled by the data-integration steps. but i couldn't find any tutorial about how to see the report via web-analytics(or Pentaho User Console) using the data which successfully run by the data-integration(or called it kettle)?
Thx for you attention ,Best regards
The administrator has disabled public write access.

Hi there how to open the data-integration report 1 week 3 days ago #91484

  • lakeZhang
  • lakeZhang's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Hi there ,any reply>?ivyis wrote:
There are two projects. One is SuiteCRM Data Integration. This is the ETL solution that pulls data from SuiteCRM and places it into the Data Warehouse. The other project called SuiteCRM Analytics is the reporting suite where you can run reports and dashboards.

You can download the reporting project here.

docs.suitecrm.com/admin/suitecrm-analytics/scrm-analytics/
The administrator has disabled public write access.

Hi there how to open the data-integration report 1 week 3 days ago #91540

  • ivyis
  • ivyis's Avatar
  • Offline
  • Moderator
  • Posts: 26
  • Thank you received: 6
  • Karma: 0
Did you download both SuiteCRM Data Integration AND SuiteCRM Web Analytics? You have to download both zips and run the setup scripts in both projects. It sounds like you gave the Data Integration working but not the Web Anaytics. Make sure you download the file i mentioned above and read the installation / run instructions
The administrator has disabled public write access.
The following user(s) said Thank You: lakeZhang

Hi there how to open the data-integration report 1 week 2 days ago #91571

  • lakeZhang
  • lakeZhang's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Actually,i have download both and both working ,the SuiteCRM Data Integration and SuiteCRM Web Analytics,so after running Data Integration ,i get a database,but the thing is ,the web analytics couldn't see the outcome of the suitecrm_dwh(for me is suitecrm_dwh2,i find the setting which in Web analytics install not work ,have to use local mysql and name as suitecrm_dwh,) ?

And what's more ,so i don't see the report ,fine ,maybe need myself to use the sample one to run it or use report designer ,at least i can a report , But here come the more difficult thing: i need to use UTF-8 ,but the outcome is definitely not and must be ASCII ,
although i try to change settings in
suitecrm.kjb ,
where i add
<attribute>
<code>EXTRA_OPTION_MYSQL.characterEncoding</code>
<attribute>utf8</attribute>
</attribute>
<attribute>
<code>SQL_CONNECT</code>
<attribute>set names utf8;</attribute>
</attribute>
but failed to work ,OK ,i try another way , i edit the
spoon.sh with
OPT="$OPT $PENTAHO_DI_JAVA_OPTIONS -Dfile.encoding=utf8
and also failed ,
then i don't know what to do.Could you help me ,i really appreciated!
If you still confused ,you can see the image and pls contact me ,thx for reply!
Attachments:
Last Edit: 1 week 2 days ago by lakeZhang.
The administrator has disabled public write access.

Hi there how to open the data-integration report 1 week 13 hours ago #91617

  • lakeZhang
  • lakeZhang's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Any progress?
The administrator has disabled public write access.

Hi there how to open the data-integration report 6 days 21 hours ago #91673

  • ivyis
  • ivyis's Avatar
  • Offline
  • Moderator
  • Posts: 26
  • Thank you received: 6
  • Karma: 0
That first screenshot of the SuiteCRM Analytics Server, you are looking at the contents of the admin user folder. Did you look at the contents of the public/suitecrm analyics/ reports folder?

If you want tp change any of the JDBC connection properties manually for the ETL to extract the data out of SuiteCRM to SuiteCRM Data Warehouse then you can edit the suitecrm-data-integration-server/configuration/simple-jndi/jdbc.properties file

Here you will see the JDBC connection string to both suitecrm and suitecrm dwh. You can add additional arguments to this JDBC connection string

Hope that helps a little
The administrator has disabled public write access.
Moderators: ivyis
Time to create page: 0.065 seconds
Powered by Kunena Forum