Creating a Oracle Data Source Connection

http://scn.sap.com/community/developer-center/mobility-platform/blog/2012/07/08/creating-a-oracle-data-source-connection

发表人 satya murthy 位置 SAP Mobile Platform Developer Center 打开 2012-7-8 20:42:25                       

Hi everybody the main intention presenting this blog is to guide the SUP basic learners as how to create the Data Source using Oracle. The Steps that Explained below have been tested in SDK 2.1.3.

Apart from the default Database that comes by installing SDK, the EXTERNAL Database Oracle 11g has been installed in my laptop. While installing Oracle Database I have assigned Database id as MOB. Once after installing you need to check if Database is mounted or not.

My system Environment is 

Operating System – Windows – 7 64bit 

SDK 2.1.3

Oracle 11g 64bit

Once you open the Workspace, you need t right click on the Database Connection in the Enterprise Explorer, then select the New Icon in the Connection
Profile Types wizard

1.png

you need to select Oracle from the list of defined Operations. Select Connection Profile Type as Oracle and assign the Driver Name

2.png3.png

Next you need to select New Driver Definition icon. You may also have an option to select Oracle Thin Driver & System Version.

4.png

Next select JAR list tab and add oracle OJDBC14.jar.  Now you need to search .jar file In the Oracle Installation Directory. Now you need to delete the default .jar file.

5.png6.png

 

(Remove the ojdbc14.jar)

7.png

Next important thing click on Properties tab and add the Correct
Properties

Connection URL, Database name, Driver class, Password, User id

8.png

You may check the Database Details as below

E:\app\satyam\product\11.2.0\dbhome_1\NETWORK\ADMIN\ listener.1.ora

Next you need to click on ‘ok’ then Test Connection now you
will get a message as Ping Success.

9.png10.png

Once you get a Success Message, you have to create Mobile
Workflow Application.

While creating MBO, you have to  open diagram editor. Now Drag and Drop
ZEMPLOYEE table to the Diagram Editor. Once you have done that, a warning
message will be displayed, you need to click ok.

By default Generated Operation called Create will open.

11.png12.png

Finally we will get an Error Message.

13.png

There is a reason
behind this Error. You need to Configure the JAR file that is been defined in
the Database Connection needs to be pasted in two locations you may refer the Screenshot
below.

C:\Sybase\UnwiredPlatform\MobileSDK213\Unwired_WorkSpace\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.oracle_2.1.3.201205181305\lib

C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\lib\3rdparty

14.png

Once again try to create MBO.

15.png16.png

17.png

I hope this somehow useful to have an idea to how to crteate datasources.

 

数据驱动型组织是指利用数据分析、数据驱动决策和数据驱动运营来实现组织的目标和战略的机构。要创建一个数据驱动型组织,需要以下几个关键步骤和要点。 首先,明确目标和战略。一个数据驱动型组织需要明确组织的目标,并将其与数据分析和决策相结合。这需要组织领导层对目标的清晰认识,并将数据集成到决策和战略制定中。 其次,建立数据文化。一个数据驱动型组织需要建立一种数据驱动的文化,使所有员工都意识到数据的重要性,并愿意使用数据来支持决策和行动。这需要组织内部进行数据培训和教育,提高员工的数据素养和数据分析能力。 第三,投资数据基础设施和工具。为了创建一个数据驱动型组织,需要投资建立稳定可靠的数据基础设施和使用先进的数据分析工具。这包括数据的收集、整理、存储和分析能力的建设,以及使用大数据、人工智能和机器学习等技术来挖掘数据的潜力。 最后,推动数据驱动决策。一个数据驱动型组织需要将数据分析融入到决策过程中,从而提高决策的准确性和效果。这需要建立一个数据驱动的决策制度,确保数据的准确性和可靠性,并将数据分析的结果纳入到决策的讨论和决策的过程中。 总之,创建一个数据驱动型组织需要明确目标和战略、建立数据文化、投资数据基础设施和工具,并推动数据驱动决策。通过这些步骤和要点的实施,组织可以更好地利用数据来支持决策和行动,从而提高组织的绩效和竞争力。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值